[jira] [Commented] (FLINK-34155) Recurring SqlExecutionException
[ https://issues.apache.org/jira/browse/FLINK-34155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17810238#comment-17810238 ] Matthias Pohl commented on FLINK-34155: --- How big is the mvn.log? I'm wondering whether it would be possible to share the entire log for investigation purposes. > Recurring SqlExecutionException > --- > > Key: FLINK-34155 > URL: https://issues.apache.org/jira/browse/FLINK-34155 > Project: Flink > Issue Type: Bug > Components: Tests >Affects Versions: 1.19.0 >Reporter: Jeyhun Karimov >Priority: Major > Labels: test-stability > Attachments: disk-full.log > > > When analyzing very big maven log file in our CI system, I found out that > there is a recurring {{{}SqlException (subset of the log file is > attached){}}}: > > {{org.apache.flink.table.gateway.service.utils.SqlExecutionException: Only > 'INSERT/CREATE TABLE AS' statement is allowed in Statement Set or use 'END' > statement to submit Statement Set.}} > > > which leads to: > > {{06:31:41,155 [flink-rest-server-netty-worker-thread-22] ERROR > org.apache.flink.table.gateway.rest.handler.statement.FetchResultsHandler [] > - Unhandled exception.}} > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (FLINK-34155) Recurring SqlExecutionException
[ https://issues.apache.org/jira/browse/FLINK-34155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17809713#comment-17809713 ] Shengkai Fang commented on FLINK-34155: --- Hi [~jeyhunkarimov]. The exception mentioned in the text are due to the addition of exception cases in our testing. The same exceptions occurring in multiple places: 1. During the process of submitting SQL, an illegal query is detected. The SQL gateway currently logs this exception; 2. When users directly fetch the results of the exceptional SQL, the logging system will also record the same exception. I see that there is some redundancy in the exception information here, but I believe it does not affect the stability of the tests, at most it may affect future troubleshooting. This test hasn't been modified for a long time, if there were any issues, the CI tests would have become unstable a while ago. > Recurring SqlExecutionException > --- > > Key: FLINK-34155 > URL: https://issues.apache.org/jira/browse/FLINK-34155 > Project: Flink > Issue Type: Bug > Components: Tests >Affects Versions: 1.19.0 >Reporter: Jeyhun Karimov >Priority: Blocker > Labels: test > Attachments: disk-full.log > > > When analyzing very big maven log file in our CI system, I found out that > there is a recurring {{{}SqlException (subset of the log file is > attached){}}}: > > {{org.apache.flink.table.gateway.service.utils.SqlExecutionException: Only > 'INSERT/CREATE TABLE AS' statement is allowed in Statement Set or use 'END' > statement to submit Statement Set.}} > > > which leads to: > > {{06:31:41,155 [flink-rest-server-netty-worker-thread-22] ERROR > org.apache.flink.table.gateway.rest.handler.statement.FetchResultsHandler [] > - Unhandled exception.}} > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (FLINK-34155) Recurring SqlExecutionException
[ https://issues.apache.org/jira/browse/FLINK-34155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17808539#comment-17808539 ] Jeyhun Karimov commented on FLINK-34155: Hi [~lincoln.86xy] for example {{org.apache.flink.table.gateway.AbstractSqlGatewayStatementITCase is the one failing.}} > Recurring SqlExecutionException > --- > > Key: FLINK-34155 > URL: https://issues.apache.org/jira/browse/FLINK-34155 > Project: Flink > Issue Type: Bug > Components: Tests >Affects Versions: 1.8.0 >Reporter: Jeyhun Karimov >Priority: Blocker > Labels: test > Attachments: disk-full.log > > > When analyzing very big maven log file in our CI system, I found out that > there is a recurring {{{}SqlException (subset of the log file is > attached){}}}: > > {{org.apache.flink.table.gateway.service.utils.SqlExecutionException: Only > 'INSERT/CREATE TABLE AS' statement is allowed in Statement Set or use 'END' > statement to submit Statement Set.}} > > > which leads to: > > {{06:31:41,155 [flink-rest-server-netty-worker-thread-22] ERROR > org.apache.flink.table.gateway.rest.handler.statement.FetchResultsHandler [] > - Unhandled exception.}} > -- This message was sent by Atlassian Jira (v8.20.10#820010)
[jira] [Commented] (FLINK-34155) Recurring SqlExecutionException
[ https://issues.apache.org/jira/browse/FLINK-34155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17808419#comment-17808419 ] lincoln lee commented on FLINK-34155: - [~jeyhunkarimov] thanks for the investigation! Could you offer more information of the test cases related to above exceptions? I saw there were several cases expected these error msg, e.g., statement_set.q and begin_statement_set.q > Recurring SqlExecutionException > --- > > Key: FLINK-34155 > URL: https://issues.apache.org/jira/browse/FLINK-34155 > Project: Flink > Issue Type: Bug > Components: Tests >Affects Versions: 1.8.0 >Reporter: Jeyhun Karimov >Priority: Blocker > Labels: test > Attachments: disk-full.log > > > When analyzing very big maven log file in our CI system, I found out that > there is a recurring {{{}SqlException (subset of the log file is > attached){}}}: > > {{org.apache.flink.table.gateway.service.utils.SqlExecutionException: Only > 'INSERT/CREATE TABLE AS' statement is allowed in Statement Set or use 'END' > statement to submit Statement Set.}} > > > which leads to: > > {{06:31:41,155 [flink-rest-server-netty-worker-thread-22] ERROR > org.apache.flink.table.gateway.rest.handler.statement.FetchResultsHandler [] > - Unhandled exception.}} > -- This message was sent by Atlassian Jira (v8.20.10#820010)