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 2021/07/23 09:34:31 UTC
[GitHub] [shardingsphere] changming8 opened a new issue #11474: Protocol incompatibility between ShardingSphere-proxy and Tbase
changming8 opened a new issue #11474:
URL: https://github.com/apache/shardingsphere/issues/11474
## Bug Report
We use the TBase database, and we use shardingSphere-proxy as database middleware. After the proxy is successfully deployed, there is no exception, but the application side reports a protocol error:
WARN operator.DBPreProc [331] : Reconnect database after 10 seconds due to the following error: Protocol error. Session setup failed.
21/07/23 14:57:14 WARN operator.DBPreProc [331] : Reconnect database after 10 seconds due to the following error: Protocol error. Session setup failed.
21/07/23 14:57:24 INFO core.Engine [532] : ----> Current job status: JOB_INITIALIZER_FAIL(32)
21/07/23 14:57:24 ERROR core.Engine [576] : Job init error detected, status = JOB_INITIALIZER_FAIL
21/07/23 14:57:24 ERROR core.Engine [146] : Fail to call job initializer .
java.lang.Exception: java.sql.SQLException: Failed to connect database after retry 3 times.
at com.tencent.teg.dc.dx.operator.DBPreProc.doInit(DBPreProc.java:34)
at com.tencent.teg.dc.dx.core.Engine.startEngine(Engine.java:140)
at com.tencent.teg.dc.dx.core.AnyLoader.startJob(AnyLoader.java:250)
at com.tencent.teg.dc.dx.core.AnyLoader.main(AnyLoader.java:115)
at com.tencent.teg.dc.dx.core.Launcher.main(Launcher.java:11)
Caused by: java.sql.SQLException: Failed to connect database after retry 3 times.
at com.tencent.teg.dc.dx.utils.DxDBUtils.getConnectionFailover(DxDBUtils.java:329)
at com.tencent.teg.dc.dx.operator.DBPreProc.doInit(DBPreProc.java:31)
... 4 more
Caused by: org.postgresql.util.PSQLException: Protocol error. Session setup failed.
at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:496)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:112)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:30)
at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
How to solve it?
--
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] changming8 commented on issue #11474: Protocol incompatibility between ShardingSphere-proxy and Tbase
Posted by GitBox <gi...@apache.org>.
changming8 commented on issue #11474:
URL: https://github.com/apache/shardingsphere/issues/11474#issuecomment-893132394
It's OK to replace with a higher version of PG driver. Proxy is incompatible with postgresql-9. X driver
--
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] changming8 closed issue #11474: Protocol incompatibility between ShardingSphere-proxy and Tbase
Posted by GitBox <gi...@apache.org>.
changming8 closed issue #11474:
URL: https://github.com/apache/shardingsphere/issues/11474
--
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] changming8 closed issue #11474: Protocol incompatibility between ShardingSphere-proxy and Tbase
Posted by GitBox <gi...@apache.org>.
changming8 closed issue #11474:
URL: https://github.com/apache/shardingsphere/issues/11474
--
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] changming8 commented on issue #11474: Protocol incompatibility between ShardingSphere-proxy and Tbase
Posted by GitBox <gi...@apache.org>.
changming8 commented on issue #11474:
URL: https://github.com/apache/shardingsphere/issues/11474#issuecomment-893132394
It's OK to replace with a higher version of PG driver. Proxy is incompatible with postgresql-9. X driver
--
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