Home > database >  Consult: mysql: Communications link failure
Consult: mysql: Communications link failure

Time:09-23

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

The last packet successfully received from The server was 1081953 milliseconds line. The last packet sent successfully to The server was 1 milliseconds line.
The above is quoted abnormal

Background description: the company has an own persistence layer framework, connecting the two libraries are two application before, now I put the two engineering combined into one, the persistence layer used within the company and two mybatis, mybatis data source as DBCP, thought each other, but when the test found that two thread pool to a merger, more strange is that it is connect different database, sharing a connection can also find out the correct data, two in a mysql database instance, the problem of the trigger condition is, two queries have switch, if there is no switch, is used normally, once the query library has a switch, after more than 60 seconds, will quote this exception, first of all, can eliminate the cause of the mysql connection timeout, not interactive_timeout and wait_timeout, two values are 2592000, I have a great spirit to solve?

CodePudding user response:

Sorry, wrong, is really two timeout problems
  • Related