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

MariaDB keeps rebooting after upgrade from 10.3.23 to 10.3.31

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 10.3.31
    • N/A
    • Galera
    • None
    • Ubuntu server 20.04

    Description

      Hello,

      I have a 3 nodes cluster. Everything is working fine in 10.3.23 version. When I upgrade a node to 10.3.31, MariaDB keeps restarting every 5 minutes approximatively. Do you know where this problem can come from? If I rollback to 10.3.23, everything is working fine.

      Attachments

        1. mariadb_crashlog.txt
          4 kB
        2. my.cnf.txt
          3 kB
        3. mysql_backtrace.txt
          15 kB

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25835 mariadb 10.3.29 galera cluster crashes with errors like: "[ERROR] WSREP: Trx 236236 tries to abort slave trx 236238."

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            danblack Daniel Black added a comment -

            If you have the opportunity to install some debug symbols https://wiki.ubuntu.com/Debug%20Symbol%20Packages , package mariadb-server-core-10.3-dbg or mariadb-server-core-10.3-dbgsym and look at the backtrace again that would be greatly appreciated.

            If a core file is generated or captured by apport, https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/#getting-backtraces-for-all-threads-from-a-core-file will greatly assist in diagnosing what might have gone wrong.

            danblack Daniel Black added a comment - If you have the opportunity to install some debug symbols https://wiki.ubuntu.com/Debug%20Symbol%20Packages , package mariadb-server-core-10.3-dbg or mariadb-server-core-10.3-dbgsym and look at the backtrace again that would be greatly appreciated. If a core file is generated or captured by apport, https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/#getting-backtraces-for-all-threads-from-a-core-file will greatly assist in diagnosing what might have gone wrong.
            nPerf Franck Laprevote added a comment -

            Hello,
            Thanks for your answer, I'll try again an update with these tools and update this ticket with more info.
            Best regards.

            nPerf Franck Laprevote added a comment - Hello, Thanks for your answer, I'll try again an update with these tools and update this ticket with more info. Best regards.
            nPerf Franck Laprevote added a comment -

            Hello,
            I installed mariadb-server-core-10.3-dbgsym and did an update again, you can find attached the backtrace of the error.
            Also, some information about my installation. I have 3 nodes on Ubuntu 20.04 in a cluster. You can find attached my.cnf config file.
            Specs of the servers:

            • Intel Xeon-E 2274G - 4c/8t - 4 GHz/4.9 GHz
            • 32 GB ECC 2666 MHz
            • 2×960 GB SSD NVMe

            If you need any other info feel free to ask.
            Thanks for your help.
            mysql_backtrace.txt my.cnf.txt

            nPerf Franck Laprevote added a comment - Hello, I installed mariadb-server-core-10.3-dbgsym and did an update again, you can find attached the backtrace of the error. Also, some information about my installation. I have 3 nodes on Ubuntu 20.04 in a cluster. You can find attached my.cnf config file. Specs of the servers: Intel Xeon-E 2274G - 4c/8t - 4 GHz/4.9 GHz 32 GB ECC 2666 MHz 2×960 GB SSD NVMe If you need any other info feel free to ask. Thanks for your help. mysql_backtrace.txt my.cnf.txt
            nPerf Franck Laprevote added a comment -

            Hello,
            Any news on this subject? If you need more information, please feel free to ask.
            Best regards.

            nPerf Franck Laprevote added a comment - Hello, Any news on this subject? If you need more information, please feel free to ask. Best regards.
            danblack Daniel Black added a comment -

            The stack trace assertion looks exactly like MDEV-25835

            danblack Daniel Black added a comment - The stack trace assertion looks exactly like MDEV-25835

            People

              jplindst Jan Lindström (Inactive)
              nPerf Franck Laprevote
              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.