Home > Back-end >  An error for help
An error for help

Time:10-18

The 2020-03-03 12:04:53. ERROR 659-5284 [Druid - ConnectionPool - Create - 163045124] com. Alibaba. Druid. Pool. DruidDataSource: Create connection SQLException, url: JDBC: mysql://10.213.205.226:3306/chengde_cs? AllowMultiQueries=true, errorCode 0, state 08 s01

Com.mysql.jdbc.exceptions.jdbc4.Com municationsException: Communications link failure

The last packet sent successfully to The server was 0 milliseconds line. The driver has not received any packets from The server.
At sun. Reflect. GeneratedConstructorAccessor78. NewInstance (Unknown Source) ~ [na: na]
At sun. Reflect. DelegatingConstructorAccessorImpl. NewInstance (Unknown Source) ~ [na: 1.8.0 comes with _131]
The at Java. Lang. Reflect. Constructor. NewInstance (Unknown Source) ~ [na: 1.8.0 comes with _131]
At com. Mysql. JDBC. Util. HandleNewInstance (Util. Java: 425) ~ [mysql connector - Java - 5.1.44. Jar!/: 5.1.44]
At com. Mysql. JDBC. SQLError. CreateCommunicationsException (SQLError. Java: 989) ~ [mysql connector - Java - 5.1.44. Jar!/: 5.1.44]
At com. Mysql. JDBC. MysqlIO. & lt; init> (MysqlIO. Java: 341) ~ [mysql connector - Java - 5.1.44. Jar!/: 5.1.44]
At com. Mysql. JDBC. ConnectionImpl. CoreConnect (ConnectionImpl. Java: 2189) ~ [mysql connector - Java - 5.1.44. Jar!/: 5.1.44]
At com. Mysql. JDBC. ConnectionImpl. ConnectOneTryOnly (ConnectionImpl. Java: 2222) ~ [mysql connector - Java - 5.1.44. Jar!/: 5.1.44]
At com. Mysql. JDBC. ConnectionImpl. CreateNewIO (ConnectionImpl. Java: 2017) ~ [mysql connector - Java - 5.1.44. Jar!/: 5.1.44]
At com. Mysql. JDBC. ConnectionImpl. & lt; init> (ConnectionImpl. Java: 779) ~ [mysql connector - Java - 5.1.44. Jar!/: 5.1.44]
At com. Mysql. JDBC. JDBC4Connection. & lt; init> (JDBC4Connection. Java: 47) ~ [mysql connector - Java - 5.1.44. Jar!/: 5.1.44]
At sun. Reflect. GeneratedConstructorAccessor75. NewInstance (Unknown Source) ~ [na: na]
At sun. Reflect. DelegatingConstructorAccessorImpl. NewInstance (Unknown Source) ~ [na: 1.8.0 comes with _131]
The at Java. Lang. Reflect. Constructor. NewInstance (Unknown Source) ~ [na: 1.8.0 comes with _131]
At com. Mysql. JDBC. Util. HandleNewInstance (Util. Java: 425) ~ [mysql connector - Java - 5.1.44. Jar!/: 5.1.44]
At com. Mysql. JDBC. ConnectionImpl. GetInstance (ConnectionImpl. Java: 389) ~ [mysql connector - Java - 5.1.44. Jar!/: 5.1.44]
At com. Mysql. JDBC. NonRegisteringDriver. Connect (NonRegisteringDriver. Java: 330) ~ [mysql connector - Java - 5.1.44. Jar!/: 5.1.44]
At com. Alibaba. Druid. Filter. FilterChainImpl. Connection_connect (FilterChainImpl. Java: 149) ~ [druid - 1.1.9 jar!/: 1.1.9]
At com. Alibaba. Druid. Filter. Stat. StatFilter. Connection_connect (StatFilter. Java: 218) ~ [druid - 1.1.9 jar!/: 1.1.9]
At com. Alibaba. Druid. Filter. FilterChainImpl. Connection_connect (FilterChainImpl. Java: 143) ~ [druid - 1.1.9 jar!/: 1.1.9]
At com. Alibaba. Druid. Pool. DruidAbstractDataSource. CreatePhysicalConnection (DruidAbstractDataSource. Java: 1515) ~ [druid - 1.1.9 jar!/: 1.1.9]
At com. Alibaba. Druid. Pool. DruidAbstractDataSource. CreatePhysicalConnection (DruidAbstractDataSource. Java: 1578) ~ [druid - 1.1.9 jar!/: 1.1.9]
At com. Alibaba. Druid. Pool. DruidDataSource $CreateConnectionThread. Run (DruidDataSource. Java: 2466) ~ [druid - 1.1.9 jar!/: 1.1.9]
Under Caused by: java.net.ConnectException: Connection timed out: connect
The at java.net.DualStackPlainSocketImpl.connect0 (Native Method) ~ [na: 1.8.0 comes with _131]
The at java.net.DualStackPlainSocketImpl.socketConnect (Unknown Source) ~ [na: 1.8.0 comes with _131]
The at java.net.AbstractPlainSocketImpl.doConnect (Unknown Source) ~ [na: 1.8.0 comes with _131]
The at java.net.AbstractPlainSocketImpl.connectToAddress (Unknown Source) ~ [na: 1.8.0 comes with _131]
The at java.net.AbstractPlainSocketImpl.connect (Unknown Source) ~ [na: 1.8.0 comes with _131]
The at java.net.PlainSocketImpl.connect (Unknown Source) ~ [na: 1.8.0 comes with _131]
The at java.net.SocksSocketImpl.connect (Unknown Source) ~ [na: 1.8.0 comes with _131]
The at java.net.Socket.connect (Unknown Source) ~ [na: 1.8.0 comes with _131]
At com. Mysql. JDBC. StandardSocketFactory. Connect (StandardSocketFactory. Java: 211) ~ [mysql connector - Java - 5.1.44. Jar!/: 5.1.44]
At com. Mysql. JDBC. MysqlIO. & lt; init> (MysqlIO. Java: 300) ~ [mysql connector - Java - 5.1.44. Jar!/: 5.1.44]
. 17 common frames omitted

CodePudding user response:

Database can use 127.0.0.1 link also can use a computer IP address, but you can't use public IP connection (error 2003 10038)
Trying another computer can use public IP connection

CodePudding user response:

Can you ping public IP to see ping, maybe there are IP server limit (namely with IP white list, in the white list of IP to access)

CodePudding user response:

See if the server firewall open, or 3306 port is not open

CodePudding user response:

3306 port opens the
  • Related