Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-34423

Random Communication link failures seen in mariadb galera cluster from application after OS migration from centos7 to rockylinux9

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.5.18
    • N/A
    • Galera
    • 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.

      Attachments

        1. my.cnf
          2 kB
          tech geek
        2. server.cnf
          1.0 kB
          tech geek

        Activity

          People

            Unassigned Unassigned
            techgeek tech geek
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.