[jira] [Created] (IGNITE-19268) Wrong error TraceId

["Alexander Belyak (Jira)" <ji...@apache.org>]

Alexander Belyak created IGNITE-19268:
-----------------------------------------

             Summary: Wrong error TraceId
                 Key: IGNITE-19268
                 URL: https://issues.apache.org/jira/browse/IGNITE-19268
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 3.0
            Reporter: Alexander Belyak


Example of broken query:

drop table if exists t;
CREATE TABLE t (id varchar default gen_random_uuid primary key, val int);
insert into t(id, val) values('40e6215d-b5c6-4896-987c-f30f3678f608', 'val1');

Sql output (throw JDBC):

[Code: 0, SQL State: 50000]  Exception while executing query [query=insert into t(id, val) values('40e6215d-b5c6-4896-987c-f30f3678f608', 'val1')]. Error message:IGN-CMN-65535 TraceId:ede42a06-41da-4373-8174-d70029b18901 Remote query execution

 

but in server log there is no such trace id, but there are the following exception:
{code:java}
2023-04-10 18:01:05:443 +0300 [DEBUG][%node0%sql-execution-pool-3][QueryTaskExecutorImpl] Uncaught exception
org.apache.ignite.lang.IgniteInternalException: IGN-CMN-1 TraceId:3199170b-b51b-4061-9892-21026df58cf6 Unexpected exception
        at org.apache.ignite.internal.sql.engine.exec.ExecutionContext.lambda$execute$0(ExecutionContext.java:320)
        at org.apache.ignite.internal.sql.engine.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:80)
        at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: java.lang.NumberFormatException: For input string: "val1"
        at java.base/java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
        at java.base/java.lang.Integer.parseInt(Integer.java:652)
        at java.base/java.lang.Integer.parseInt(Integer.java:770)
        at org.apache.calcite.runtime.SqlFunctions.toInt(SqlFunctions.java:2293)
        at SC.execute(Unknown Source)
        at org.apache.ignite.internal.sql.engine.exec.exp.ExpressionFactoryImpl$ProjectImpl.apply(ExpressionFactoryImpl.java:654)
        at org.apache.ignite.internal.sql.engine.exec.rel.ProjectNode.push(ProjectNode.java:69)
        at org.apache.ignite.internal.sql.engine.exec.rel.ScanNode.push(ScanNode.java:111)
        at org.apache.ignite.internal.sql.engine.exec.ExecutionContext.lambda$execute$0(ExecutionContext.java:315)
        ... 4 more
 {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)