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 2022/10/08 05:40:00 UTC

[GitHub] [shardingsphere] zhaojinchao95 opened a new issue, #21378: Commond ./start.sh -f not work when i have invalid datasource at governance center

zhaojinchao95 opened a new issue, #21378:
URL: https://github.com/apache/shardingsphere/issues/21378

   `Server.yaml : `
   
   ```
   mode:
     type: Cluster
     repository:
       type: ZooKeeper
       props:
         namespace: governance_ds
         server-lists: localhost:2181
         retryIntervalMilliseconds: 500
         timeToLiveSeconds: 60
         maxRetries: 3
         operationTimeoutMilliseconds: 500
   
   rules:
     - !AUTHORITY
       users:
         - root@%:root
         - sharding@:sharding
       provider:
         type: ALL_PERMITTED
     - !TRANSACTION
       defaultType: XA
       providerType: Atomikos
     - !SQL_PARSER
       sqlCommentParseEnabled: true
       sqlStatementCache:
         initialCapacity: 2000
         maximumSize: 65535
       parseTreeCache:
         initialCapacity: 128
         maximumSize: 1024
   
   props:
     sql-show: true
   ```
   
   `Governance center info :`
   
   <img width="1104" alt="image" src="https://user-images.githubusercontent.com/33742097/194690857-8510b015-1ca6-40b2-85a5-15937764260c.png">
   
   
   `./start.sh -f `
   
   `Error message : `
   
   ```
   [ERROR] 2022-10-08 13:29:31.111 [main] com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
   java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
   	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
   	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
   	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:833)
   	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:453)
   	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
   	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
   	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
   	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:354)
   	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
   	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:473)
   	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:554)
   	at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
   	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
   	at org.apache.shardingsphere.infra.database.type.DatabaseTypeEngine.getDatabaseType(DatabaseTypeEngine.java:117)
   	at org.apache.shardingsphere.infra.database.type.DatabaseTypeEngine.getDatabaseType(DatabaseTypeEngine.java:109)
   	at org.apache.shardingsphere.infra.database.type.DatabaseTypeEngine.lambda$getProtocolType$1(DatabaseTypeEngine.java:69)
   	at java.util.Optional.orElseGet(Optional.java:267)
   	at org.apache.shardingsphere.infra.database.type.DatabaseTypeEngine.getProtocolType(DatabaseTypeEngine.java:69)
   	at org.apache.shardingsphere.infra.metadata.database.ShardingSphereDatabasesFactory.create(ShardingSphereDatabasesFactory.java:66)
   	at org.apache.shardingsphere.mode.metadata.MetaDataContextsFactory.create(MetaDataContextsFactory.java:68)
   	at org.apache.shardingsphere.mode.manager.cluster.ClusterContextManagerBuilder.build(ClusterContextManagerBuilder.java:67)
   	at org.apache.shardingsphere.proxy.initializer.BootstrapInitializer.createContextManager(BootstrapInitializer.java:68)
   	at org.apache.shardingsphere.proxy.initializer.BootstrapInitializer.init(BootstrapInitializer.java:58)
   	at org.apache.shardingsphere.proxy.Bootstrap.main(Bootstrap.java:52)
   Exception in thread "main" org.apache.shardingsphere.infra.util.exception.external.sql.type.wrapper.SQLWrapperException
   	at org.apache.shardingsphere.infra.database.type.DatabaseTypeEngine.getDatabaseType(DatabaseTypeEngine.java:120)
   	at org.apache.shardingsphere.infra.database.type.DatabaseTypeEngine.getDatabaseType(DatabaseTypeEngine.java:109)
   	at org.apache.shardingsphere.infra.database.type.DatabaseTypeEngine.lambda$getProtocolType$1(DatabaseTypeEngine.java:69)
   	at java.util.Optional.orElseGet(Optional.java:267)
   	at org.apache.shardingsphere.infra.database.type.DatabaseTypeEngine.getProtocolType(DatabaseTypeEngine.java:69)
   	at org.apache.shardingsphere.infra.metadata.database.ShardingSphereDatabasesFactory.create(ShardingSphereDatabasesFactory.java:66)
   	at org.apache.shardingsphere.mode.metadata.MetaDataContextsFactory.create(MetaDataContextsFactory.java:68)
   	at org.apache.shardingsphere.mode.manager.cluster.ClusterContextManagerBuilder.build(ClusterContextManagerBuilder.java:67)
   	at org.apache.shardingsphere.proxy.initializer.BootstrapInitializer.createContextManager(BootstrapInitializer.java:68)
   	at org.apache.shardingsphere.proxy.initializer.BootstrapInitializer.init(BootstrapInitializer.java:58)
   	at org.apache.shardingsphere.proxy.Bootstrap.main(Bootstrap.java:52)
   ```
   


-- 
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] strongduanmu closed issue #21378: Command ./start.sh -f not work when i have invalid datasource at governance center

Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #21378: Command ./start.sh -f not work when i have invalid datasource at governance center
URL: https://github.com/apache/shardingsphere/issues/21378


-- 
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] FlyingZC commented on issue #21378: Command ./start.sh -f not work when i have invalid datasource at governance center

Posted by GitBox <gi...@apache.org>.
FlyingZC commented on issue #21378:
URL: https://github.com/apache/shardingsphere/issues/21378#issuecomment-1272292047

   Assign me, please. @zhaojinchao95 


-- 
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