zhaojinchao95 commented on issue #23624:
URL:
https://github.com/apache/shardingsphere/issues/23624#issuecomment-1386519772
```
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database
'pg_catalog'
at
java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at
java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at
java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
at
com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:110)
at
com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
at
org.apache.shardingsphere.infra.metadata.data.collector.ShardingSphereTableDataCollectorUtil.collectRowData(ShardingSphereTableDataCollectorUtil.java:56)
at
org.apache.shardingsphere.infra.metadata.data.collector.tables.PgNamespaceTableCollector.collect(PgNamespaceTableCollector.java:48)
at
org.apache.shardingsphere.data.pipeline.core.execute.ShardingSphereDataScheduleCollector$ShardingSphereDataCollectorRunnable.collectForTable(ShardingSphereDataScheduleCollector.java:111)
at
org.apache.shardingsphere.data.pipeline.core.execute.ShardingSphereDataScheduleCollector$ShardingSphereDataCollectorRunnable.lambda$collectForSchema$2(ShardingSphereDataScheduleCollector.java:98)
at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)
at
org.apache.shardingsphere.data.pipeline.core.execute.ShardingSphereDataScheduleCollector$ShardingSphereDataCollectorRunnable.collectForSchema(ShardingSphereDataScheduleCollector.java:96)
at
org.apache.shardingsphere.data.pipeline.core.execute.ShardingSphereDataScheduleCollector$ShardingSphereDataCollectorRunnable.lambda$collectForDatabase$1(ShardingSphereDataScheduleCollector.java:89)
at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)
at
org.apache.shardingsphere.data.pipeline.core.execute.ShardingSphereDataScheduleCollector$ShardingSphereDataCollectorRunnable.collectForDatabase(ShardingSphereDataScheduleCollector.java:87)
at
org.apache.shardingsphere.data.pipeline.core.execute.ShardingSphereDataScheduleCollector$ShardingSphereDataCollectorRunnable.lambda$run$0(ShardingSphereDataScheduleCollector.java:79)
at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)
at
org.apache.shardingsphere.data.pipeline.core.execute.ShardingSphereDataScheduleCollector$ShardingSphereDataCollectorRunnable.run(ShardingSphereDataScheduleCollector.java:77)
at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at
java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
at
java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
[ERROR] 2023-01-18 13:42:09.959 [ShardingSphere-data-collect-0]
o.a.s.d.p.c.e.ShardingSphereDataScheduleCollector - Collect data failed!
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database
'pg_catalog'
at
java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at
java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at
java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
at
com.zaxxer.hikari.pool.ProxyStatement.executeQuery(ProxyStatement.java:110)
at
com.zaxxer.hikari.pool.HikariProxyStatement.executeQuery(HikariProxyStatement.java)
at
org.apache.shardingsphere.infra.metadata.data.collector.ShardingSphereTableDataCollectorUtil.collectRowData(ShardingSphereTableDataCollectorUtil.java:56)
at
org.apache.shardingsphere.infra.metadata.data.collector.tables.PgClassTableCollector.collect(PgClassTableCollector.java:54)
at
org.apache.shardingsphere.data.pipeline.core.execute.ShardingSphereDataScheduleCollector$ShardingSphereDataCollectorRunnable.collectForTable(ShardingSphereDataScheduleCollector.java:111)
at
org.apache.shardingsphere.data.pipeline.core.execute.ShardingSphereDataScheduleCollector$ShardingSphereDataCollectorRunnable.lambda$collectForSchema$2(ShardingSphereDataScheduleCollector.java:98)
at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)
at
org.apache.shardingsphere.data.pipeline.core.execute.ShardingSphereDataScheduleCollector$ShardingSphereDataCollectorRunnable.collectForSchema(ShardingSphereDataScheduleCollector.java:96)
at
org.apache.shardingsphere.data.pipeline.core.execute.ShardingSphereDataScheduleCollector$ShardingSphereDataCollectorRunnable.lambda$collectForDatabase$1(ShardingSphereDataScheduleCollector.java:89)
at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)
at
org.apache.shardingsphere.data.pipeline.core.execute.ShardingSphereDataScheduleCollector$ShardingSphereDataCollectorRunnable.collectForDatabase(ShardingSphereDataScheduleCollector.java:87)
at
org.apache.shardingsphere.data.pipeline.core.execute.ShardingSphereDataScheduleCollector$ShardingSphereDataCollectorRunnable.lambda$run$0(ShardingSphereDataScheduleCollector.java:79)
at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)
at
org.apache.shardingsphere.data.pipeline.core.execute.ShardingSphereDataScheduleCollector$ShardingSphereDataCollectorRunnable.run(ShardingSphereDataScheduleCollector.java:77)
at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at
java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
at
java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
```
--
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]
