You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2023/01/18 05:38:39 UTC
[GitHub] [shardingsphere] zhaojinchao95 opened a new issue, #23624: Verify storage unit is consistent with the current proxy protocol when REGISTER STORAGE UNITS;
zhaojinchao95 opened a new issue, #23624:
URL: https://github.com/apache/shardingsphere/issues/23624
master [f52f4846](https://github.com/apache/shardingsphere/commit/f52f4846ce4cdce734dd79dcad1f94e1c50d408d)
```
mode:
type: Cluster
repository:
type: ZooKeeper
props:
namespace: governance_ds
server-lists: localhost:2181
retryIntervalMilliseconds: 500
timeToLiveSeconds: 60
maxRetries: 3
operationTimeoutMilliseconds: 500
authority:
users:
- user: root@%
password: root
- user: sharding
password: sharding
privilege:
type: ALL_PERMITTED
props:
proxy-frontend-database-protocol-type: PostgreSQL
```
--
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] RaigorJiang commented on issue #23624: Verify storage unit is consistent with the current proxy protocol when REGISTER STORAGE UNITS;
Posted by GitBox <gi...@apache.org>.
RaigorJiang commented on issue #23624:
URL: https://github.com/apache/shardingsphere/issues/23624#issuecomment-1386608042
In this part, we need to collect metadata according to the databaseType of storage unit.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] zhaojinchao95 closed issue #23624: Verify storage unit is consistent with the current proxy protocol when REGISTER STORAGE UNITS;
Posted by "zhaojinchao95 (via GitHub)" <gi...@apache.org>.
zhaojinchao95 closed issue #23624: Verify storage unit is consistent with the current proxy protocol when REGISTER STORAGE UNITS;
URL: https://github.com/apache/shardingsphere/issues/23624
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] zhaojinchao95 commented on issue #23624: Verify storage unit is consistent with the current proxy protocol when REGISTER STORAGE UNITS;
Posted by GitBox <gi...@apache.org>.
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org