com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure Software caused connection abort: recv failed [duplicate]

by

Your mySQL connections are timing out before your connection pool recognizes them. There are multiple ways to fix this:

  1. Increase the timeout value in mysql config file (my.ini)
  2. Reduce the idle time in your connection pool, so that it will discard the connection before mysql will close it
  3. Add a validate connection query in your pool config so that the pool tests each connection before it gives it to you, but this can slow down the system terribly.

More Related Contents:

  1. Using env variable in Spring Boot’s application.properties
  2. Unable to get spring boot to automatically create database schema
  3. Streaming large result sets with MySQL
  4. No Dialect mapping for JDBC type: 1111
  5. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  6. Table ‘DBNAME.hibernate_sequence’ doesn’t exist
  7. How to use Spring Boot with MySQL database and JPA?
  8. How to setup Hibernate to read/write to different datasources?
  9. How to respond with HTTP 400 error in a Spring MVC @ResponseBody method returning String?
  10. Bypass GeneratedValue in Hibernate (merge data not in db?)
  11. “EEE MMM dd HH:mm:ss ZZZ yyyy” date format to java.sql.Date
  12. How does the FetchMode work in Spring Data JPA
  13. How to import spring-config.xml of one project into spring-config.xml of another project?
  14. Generics with Spring RESTTemplate
  15. What is the difference between putting a property on application.yml or bootstrap.yml in spring boot?
  16. How can I use MySQL assign operator(:=) in hibernate native query?
  17. HttpSecurity, WebSecurity and AuthenticationManagerBuilder
  18. package org.springframework.boot does not exist
  19. HTTP request compression
  20. Spring .properties file: get element as an Array
  21. Could not resolve placeholder in string value
  22. Spring security added prefix “ROLE_” to all roles name?
  23. How do I return a video with Spring MVC so that it can be navigated using the html5 tag?
  24. Why this Spring application with java-based configuration don’t work properly
  25. Is there a way to specify a default property value in Spring XML?
  26. Jackson date-format for OffsetDateTime in Spring Boot
  27. java.lang.NoSuchMethodError when the method definitely exists
  28. Spring 3.2.x with Java 8
  29. Is package by feature approach good? [closed]
  30. exception loading sessions from persistent storage

Leave a Comment