bluerfish opened a new issue, #23547:
URL: https://github.com/apache/shardingsphere/issues/23547
version : shardingproxy 5.3 (include 5.0)
question : we use dts to access shardingproxy, it will send "select
schema_name from information_schema.SCHEMATA"
here is mysql config:
databaseName: information_schema
dataSources:
ds_0:
url:
jdbc:mysql://ip_address/information_schema?useUnicode=true&characterEncoding=utf8&useSSL=false
username: root
password: ...
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
minPoolSize: 1
when execute select SCHEMA_NAME from information_schema.SCHEMATA or select
* from information_schema.SCHEMATA it will return correct result . but when
excute select schema_name from information_schema.SCHEMATA it will failed,
output is
ERROR: java.lang.ArrayIndexOutOfBoundsException: Index 2 out of bounds for
length 1 。
here is logs:
---------------------------------------------------------------------------------------------------------------------------------------
[INFO ] 2023-01-13 18:02:11.966 [epollEventLoopGroup-3-1]
o.a.s.p.b.h.a.e.AbstractDatabaseMetadataExecutor$DefaultDatabaseMetadataExecutor
- Actual SQL: ds_0 ::: selec
t SCHEMA_NAME from information_schema.SCHEMATA
[INFO ] 2023-01-13 18:02:11.969 [epollEventLoopGroup-3-1]
o.a.s.p.b.h.a.e.AbstractDatabaseMetadataExecutor$DefaultDatabaseMetadataExecutor
- Actual SQL: ds_0 ::: selec
t SCHEMA_NAME from information_schema.SCHEMATA
[INFO ] 2023-01-13 18:02:36.145 [epollEventLoopGroup-3-1]
o.a.s.p.b.h.a.e.AbstractDatabaseMetadataExecutor$DefaultDatabaseMetadataExecutor
- Actual SQL: ds_0 ::: selec
t * from information_schema.SCHEMATA
[ERROR] 2023-01-13 18:02:36.148 [epollEventLoopGroup-3-1]
o.a.s.p.f.c.CommandExecutorTask - Exception occur:
java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: Index 7 out
of bounds for length 1
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
at
com.mysql.cj.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:437)
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1020)
at
com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at
com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at
org.apache.shardingsphere.proxy.backend.handler.admin.executor.AbstractDatabaseMetadataExecutor$DefaultDatabaseMetadataExecutor.getSourceData(AbstractDataba
seMetadataExecutor.java:216)
at
org.apache.shardingsphere.proxy.backend.handler.admin.executor.AbstractDatabaseMetadataExecutor.execute(AbstractDatabaseMetadataExecutor.java:76)
at
org.apache.shardingsphere.proxy.backend.handler.admin.DatabaseAdminQueryBackendHandler.execute(DatabaseAdminQueryBackendHandler.java:56)
at
org.apache.shardingsphere.proxy.frontend.mysql.command.query.text.query.MySQLComQueryPacketExecutor.execute(MySQLComQueryPacketExecutor.java:94)
at
org.apache.shardingsphere.proxy.frontend.command.CommandExecutorTask.executeCommand(CommandExecutorTask.java:111)
--
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]
