strongduanmu opened a new issue, #25945: URL: https://github.com/apache/shardingsphere/issues/25945
## Bug Report ### Which version of ShardingSphere did you use? [ab2e0b0](https://github.com/apache/shardingsphere/commit/ab2e0b082990b7588b6d440a76c59cf1a578157b) ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy? ShardingSphere-JDBC ### Expected behavior startup shardingsphere jdbc with oracle 19c successfully ### Actual behavior ``` 19:40:35.777 [main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting... 19:40:36.316 [main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed. 19:40:36.657 [main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Starting... 19:40:37.490 [main] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Start completed. java.sql.SQLException: ORA-12801: 并行查询服务器 P002 中发出错误信号 ORA-01006: 绑定变量不存在 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:629) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:563) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1150) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:770) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:298) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:497) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:151) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:936) at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1171) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1100) at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1425) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1308) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3745) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3854) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1097) at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) at org.apache.shardingsphere.infra.metadata.database.schema.loader.metadata.dialect.OracleSchemaMetaDataLoader.loadTablePrimaryKeys(OracleSchemaMetaDataLoader.java:181) at org.apache.shardingsphere.infra.metadata.database.schema.loader.metadata.dialect.OracleSchemaMetaDataLoader.loadColumnMetaDataMap(OracleSchemaMetaDataLoader.java:97) at org.apache.shardingsphere.infra.metadata.database.schema.loader.metadata.dialect.OracleSchemaMetaDataLoader.load(OracleSchemaMetaDataLoader.java:81) at org.apache.shardingsphere.infra.metadata.database.schema.loader.metadata.SchemaMetaDataLoaderEngine.load(SchemaMetaDataLoaderEngine.java:81) at org.apache.shardingsphere.infra.metadata.database.schema.loader.metadata.SchemaMetaDataLoaderEngine.lambda$load$0(SchemaMetaDataLoaderEngine.java:62) at java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:266) at java.util.concurrent.FutureTask.run(FutureTask.java) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: Error : 12801, Position : 0, Sql = SELECT A.OWNER AS TABLE_SCHEMA, A.TABLE_NAME AS TABLE_NAME, B.COLUMN_NAME AS COLUMN_NAME FROM ALL_CONSTRAINTS A INNER JOIN ALL_CONS_COLUMNS B ON A.CONSTRAINT_NAME = B.CONSTRAINT_NAME WHERE CONSTRAINT_TYPE = 'P' AND A.OWNER = :1 AND A.TABLE_NAME IN ('MC_中文表名',,'TT_TMP_ABC'), ``` ### Reason analyze (If you can) ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc. ### Example codes for reproduce this issue (such as a github link). -- 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]
