dobet commented on issue #32289:
URL:
https://github.com/apache/shardingsphere/issues/32289#issuecomment-2253134715
the stack is:
```
[INFO ] 2024-07-27 00:51:27.190 [ShardingSphere-Command-0]
ShardingSphere-SQL - Logic SQL: /* ApplicationName=DBeaver 24.0.0 - SQLEditor
<Script-1.sql> */ create table sbtest1 (id int)
[INFO ] 2024-07-27 00:51:27.190 [ShardingSphere-Command-0]
ShardingSphere-SQL - Actual SQL: ds_1 ::: /* ApplicationName=DBeaver 24.0.0 -
SQLEditor <Script-1.sql> */ create table sbtest1_1 (id int)
[INFO ] 2024-07-27 00:51:27.190 [ShardingSphere-Command-0]
ShardingSphere-SQL - Actual SQL: ds_0 ::: /* ApplicationName=DBeaver 24.0.0 -
SQLEditor <Script-1.sql> */ create table sbtest1_0 (id int)
[INFO ] 2024-07-27 00:51:31.888 [ShardingSphere-Command-0]
ShardingSphere-SQL - Logic SQL: /* ApplicationName=DBeaver 24.0.0 - SQLEditor
<Script-1.sql> */ lock tables sbtest1 write
[INFO ] 2024-07-27 00:51:31.888 [ShardingSphere-Command-0]
ShardingSphere-SQL - Actual SQL: ds_1 ::: /* ApplicationName=DBeaver 24.0.0 -
SQLEditor <Script-1.sql> */ lock tables sbtest1 write
[INFO ] 2024-07-27 00:51:31.888 [ShardingSphere-Command-0]
ShardingSphere-SQL - Actual SQL: ds_0 ::: /* ApplicationName=DBeaver 24.0.0 -
SQLEditor <Script-1.sql> */ lock tables sbtest1 write
[ERROR] 2024-07-27 00:51:31.898 [ShardingSphere-Command-0]
o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.sql.SQLSyntaxErrorException: Table 'sbtest_1.sbtest1' doesn't exist
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at
com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:770)
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:787)
at
com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:102)
at
com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
at
org.apache.shardingsphere.proxy.backend.connector.jdbc.executor.callback.impl.ProxyStatementExecutorCallback.execute(ProxyStatementExecutorCallback.java:44)
at
org.apache.shardingsphere.proxy.backend.connector.jdbc.executor.callback.ProxyJDBCExecutorCallback.executeSQL(ProxyJDBCExecutorCallback.java:69)
at
org.apache.shardingsphere.proxy.backend.connector.jdbc.executor.callback.ProxyJDBCExecutorCallback.executeSQL(ProxyJDBCExecutorCallback.java:46)
at
org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutorCallback.execute(JDBCExecutorCallback.java:85)
at
org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutorCallback.execute(JDBCExecutorCallback.java:64)
at
org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.syncExecute(ExecutorEngine.java:99)
at
org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.parallelExecute(ExecutorEngine.java:95)
at
org.apache.shardingsphere.infra.executor.kernel.ExecutorEngine.execute(ExecutorEngine.java:78)
at
org.apache.shardingsphere.infra.executor.sql.execute.engine.driver.jdbc.JDBCExecutor.execute(JDBCExecutor.java:66)
at
org.apache.shardingsphere.proxy.backend.connector.jdbc.executor.ProxyJDBCExecutor.execute(ProxyJDBCExecutor.java:73)
at
org.apache.shardingsphere.proxy.backend.connector.ProxySQLExecutor.useDriverToExecute(ProxySQLExecutor.java:217)
at
org.apache.shardingsphere.proxy.backend.connector.ProxySQLExecutor.execute(ProxySQLExecutor.java:176)
at
org.apache.shardingsphere.proxy.backend.connector.DatabaseConnector.doExecute(DatabaseConnector.java:220)
at
org.apache.shardingsphere.proxy.backend.connector.DatabaseConnector.execute(DatabaseConnector.java:173)
at
org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:86)
at
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.doExecuteCommand(CommandExecutorTask.java:126)
at
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:121)
at
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:78)
at com.alibaba.ttl.TtlRunnable.run(TtlRunnable.java:60)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630)
at java.base/java.lang.Thread.run(Thread.java:831)
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
