org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection;

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)

at com.sun.proxy.$Proxy45.selectOne(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)

at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:82)

at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)

at com.sun.proxy.$Proxy46.selectByPrimaryKey(Unknown Source)

...

Caused by: org.apache.ibatis.exceptions.PersistenceException:

### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

...

### The error occurred while executing a query

### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

2018-11-29 16:12:05.339+0800 ERROR c.a.h.a.s.i.ClientService.bindClient(70) - clientId:A4EB30DB4E28I29O61L27D76A07985374146F81A,appId:1,appVersion:1.0.8

com.jfinal.plugin.activerecord.ActiveRecordException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'A4EB30DB4E28I29O61L27D76A07985374146F81A-1' for key 'client_id_app_id'

at com.jfinal.plugin.activerecord.Model.save(Model.java:455)

...

...

 

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'A4EB30DB4E28I29O61L27D76A07985374146F81A-1' for key 'client_id_app_id'

at sun.reflect.GeneratedConstructorAccessor113.newInstance(Unknown Source)

...

 

多次无法重启tomcat，一旦报错或异常，记得重点查看日志，问题出在哪就很清晰了，此是因为无法获得JDBD连接，原来是阿里云数据库服务到期了