Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Question]: It occurs an error with elasticsearch after updating the ragflow version to v0.17.2 #6046

Open
4 tasks done
lxf44944 opened this issue Mar 13, 2025 · 1 comment
Labels
question Further information is requested

Comments

@lxf44944
Copy link

Self Checks

  • I have searched for existing issues search for existing issues, including closed ones.
  • I confirm that I am using English to submit this report (Language Policy).
  • Non-english title submitions will be closed directly ( 非英文标题的提交将会被直接关闭 ) (Language Policy).
  • Please do not modify this template :) and fill in all the required fields.

Describe your problem

025-03-13 11:51:52,480 INFO 20691 HTTP Request: POST http://localhost:11434/api/chat "HTTP/1.1 200 OK"
2025-03-13 11:51:52,494 INFO 20691 POST http://localhost:1200/_sql?format=json [status:400 duration:0.008s]
2025-03-13 11:51:52,494 ERROR 20691 ESConnection.sql got exception
Traceback (most recent call last):
File "/home/oppoer/ragflow/rag/utils/es_conn.py", line 540, in sql
res = self.es.sql.query(body={"query": sql, "fetch_size": fetch_size}, format=format,
File "/home/oppoer/ragflow/.venv/lib/python3.10/site-packages/elasticsearch/_sync/client/utils.py", line 446, in wrapped
return api(*args, **kwargs)
File "/home/oppoer/ragflow/.venv/lib/python3.10/site-packages/elasticsearch/_sync/client/sql.py", line 330, in query
return self.perform_request( # type: ignore[return-value]
File "/home/oppoer/ragflow/.venv/lib/python3.10/site-packages/elasticsearch/_sync/client/_base.py", line 389, in perform_request
return self._client.perform_request(
File "/home/oppoer/ragflow/.venv/lib/python3.10/site-packages/elasticsearch/_sync/client/_base.py", line 320, in perform_request
raise HTTP_EXCEPTIONS.get(meta.status, ApiError)(
elasticsearch.BadRequestError: BadRequestError(400, 'parsing_exception', 'line 1:271: identifiers must not start with a digit; please use double quotes')

@lxf44944 lxf44944 added the question Further information is requested label Mar 13, 2025
@KevinHuSh
Copy link
Collaborator

KevinHuSh commented Mar 14, 2025

The SQL is generated by LLM.
The SQL might be not genereated correctly.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants