Jdbc4.CommunicationsException: communication failure

Has anyone encountered such an error in the case of some queries? (jdbc4.CommunicationsException: communication failure)

Typically, this exception means some communication problem between the application and mysql. And you can find many offers posted for a possible reason.

Nothing helped in our case, and after several hours of investigation it turned out that the reason could be completely different.
Maybe the answer below will save you from time to time :)

+3
source share
1 answer

So it turned out that the cause could be the corruption of the mysql data file !! In fact, this can be distorted so that mysql usually works for most queries.

, ( CommunicationException), , . SQLyog :
   : 2013
   MySQL

, domain.err mysql. , , :
InnoDB:

- "innodb_force_recovery" 1. MySQL: , .

CommunicationException , - "" ;-)

,

+5

All Articles