Ivan Bessonov created IGNITE-27590:
--------------------------------------
Summary: "IGN-SQL-3 Failed to parse query" error in server logs
Key: IGNITE-27590
URL: https://issues.apache.org/jira/browse/IGNITE-27590
Project: Ignite
Issue Type: Bug
Components: sql ai3
Reporter: Ivan Bessonov
{code:java}
2026-01-14 14:41:15:202 +0000
[INFO][%cac-dpd-cde-gg-aks-dev-0%sql-execution-pool-3][JdbcQueryEventHandlerImpl]
Exception while executing query.
org.apache.ignite.sql.SqlException: IGN-SQL-3 Failed to parse query: Lexical
error at line 1, column 1. Encountered: "\ufeff" (65279), after : ""
TraceId:6ac8eb40
at
org.apache.ignite.internal.sql.engine.sql.IgniteSqlParser.convertException(IgniteSqlParser.java:178)
at
org.apache.ignite.internal.sql.engine.sql.IgniteSqlParser.parse(IgniteSqlParser.java:133)
at
org.apache.ignite.internal.sql.engine.sql.IgniteSqlParser.parse(IgniteSqlParser.java:90)
at
org.apache.ignite.internal.sql.engine.sql.ParserServiceImpl.parseScript(ParserServiceImpl.java:55)
at
org.apache.ignite.internal.sql.engine.exec.fsm.QueryExecutor.parseScript(QueryExecutor.java:532)
at
org.apache.ignite.internal.sql.engine.exec.fsm.ParsingPhaseHandler.lambda$handle$0(ParsingPhaseHandler.java:40)
at
org.apache.ignite.internal.sql.engine.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:93)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown
Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: org.apache.calcite.sql.parser.SqlParseException: Lexical error at
line 1, column 1. Encountered: "\ufeff" (65279), after : ""
at
org.apache.ignite.internal.generated.query.calcite.sql.IgniteSqlParserImpl.convertException(IgniteSqlParserImpl.java:484)
at
org.apache.ignite.internal.generated.query.calcite.sql.IgniteSqlParserImpl.normalizeException(IgniteSqlParserImpl.java:230)
at
org.apache.calcite.sql.parser.SqlParser.handleException(SqlParser.java:159)
at
org.apache.calcite.sql.parser.SqlParser.parseStmtList(SqlParser.java:214)
at
org.apache.ignite.internal.sql.engine.sql.IgniteSqlParser.parse(IgniteSqlParser.java:109)
... 8 more
Caused by:
org.apache.ignite.internal.generated.query.calcite.sql.TokenMgrError: Lexical
error at line 1, column 1. Encountered: "\ufeff" (65279), after : ""
at
org.apache.ignite.internal.generated.query.calcite.sql.IgniteSqlParserImplTokenManager.getNextToken(IgniteSqlParserImplTokenManager.java:27281)
at
org.apache.ignite.internal.generated.query.calcite.sql.IgniteSqlParserImpl.jj_ntk(IgniteSqlParserImpl.java)
at
org.apache.ignite.internal.generated.query.calcite.sql.IgniteSqlParserImpl.SqlStmtList(IgniteSqlParserImpl.java:3963)
at
org.apache.ignite.internal.generated.query.calcite.sql.IgniteSqlParserImpl.parseSqlStmtList(IgniteSqlParserImpl.java:282)
at
org.apache.ignite.internal.sql.engine.sql.IgniteSqlParser$InternalIgniteSqlParser.parseSqlStmtList(IgniteSqlParser.java:315)
at
org.apache.calcite.sql.parser.SqlParser.parseStmtList(SqlParser.java:212)
... 9 more
{code}
Parsing errors are completely normal, and should not lead to a stacktrace in
server logs. In my view, they're not even worthy of INFO log messages. The text
of error should belong to the client that executes the query, not the server.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
