apache / shardingsphere

Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Apache License 2.0
19.86k stars 6.72k forks source link

DBeaver exec sql print error #24330

Open wangjianme opened 1 year ago

wangjianme commented 1 year ago

Bug Detail:

[INFO ] 2023-02-24 09:00:48.689 [Connection-14-ThreadExecutor] ShardingSphere-SQL - Logic SQL: SELECT from stud LIMIT 0, 200 [INFO ] 2023-02-24 09:00:48.689 [Connection-14-ThreadExecutor] ShardingSphere-SQL - Actual SQL: ds_0 ::: SELECT from stud LIMIT 0, 200 [ERROR] 2023-02-24 09:00:48.721 [Connection-13-ThreadExecutor] o.a.s.p.f.c.CommandExecutorTask - Exception occur: java.lang.IndexOutOfBoundsException: Index 20 out of bounds for length 20 at java.base/jdk.internal.util.Preconditions.outOfBounds(Preconditions.java:64) at java.base/jdk.internal.util.Preconditions.outOfBoundsCheckIndex(Preconditions.java:70) at java.base/jdk.internal.util.Preconditions.checkIndex(Preconditions.java:266) at java.base/java.util.Objects.checkIndex(Objects.java:359) at java.base/java.util.ArrayList.get(ArrayList.java:427) at org.apache.shardingsphere.sqlfederation.advanced.resultset.SQLFederationResultSetMetaData.getColumnName(SQLFederationResultSetMetaData.java:111) at org.apache.shardingsphere.infra.executor.sql.execute.result.query.impl.driver.jdbc.metadata.JDBCQueryResultMetaData.getColumnName(JDBCQueryResultMetaData.java:47) at org.apache.shardingsphere.proxy.backend.response.header.query.QueryHeaderBuilderEngine.build(QueryHeaderBuilderEngine.java:51) at org.apache.shardingsphere.proxy.backend.communication.DatabaseCommunicationEngine.processExecuteFederation(DatabaseCommunicationEngine.java:226) at org.apache.shardingsphere.proxy.backend.communication.DatabaseCommunicationEngine.execute(DatabaseCommunicationEngine.java:168) at org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:92) at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:110) at org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.run(CommandExecutorTask.java:77) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:833)

UI Tool: image

Bug Png: image

tuichenchuxin commented 1 year ago

We need more information to judge this issue. Such as configuration, version, reproduction steps, etc.

xize0 commented 1 year ago

I have the same problem. Have you solved it yet? @wangjianme
Version : sharding-proxy5.3.0

crcjwice123 commented 1 year ago
image

when use DBeaver to connect to shardingProxy and select from logical table, the sharding is successfully, but seeing IndexOutOfBoundsException shardingSphere 5.3.2