Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.5.18
-
None
-
RockyLinux 9.4, MariaDB 10.5.18, Galera 26.4.13
Description
As centos is nearing its end of life we started testing migration of mariadb galera cluster running in centos7 to rockylinux9.4.
We created new instances for rocky linux and installed mariadb 10.5.18 as it was running this version on centos from the following url.
baseurl = https://archive.mariadb.org//mariadb-10.5.18/yum/rhel9-amd64/
We took mariabackup of the database from centos and restored it in the new rocky linux instances. Since, then we have been seeing a lot of communication link failure issues at random times on the application logs which is using grails framework.
Errors as below:
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
...
Caused by: java.sql.SQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1848)
This used to work fine in centos7 with no errors. Nothing in the application or database end has changes except the OS i.e. centos7 to rockylinux9
Any help here will be greatly appreciated.