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

Random crash: [ERROR] mysqld got signal 6 ;

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.4.8, 10.4.10
    • Fix Version/s: 10.4.12
    • Component/s: Galera, Server
    • Labels:
    • Environment:
      Ubuntu 16

      Description

      Hi,

      Since we are using MariaDB 10.4.8 we've been getting several issues. We have a cluster of 3 nodes with Galera. In the last week, we've got some crashes everyday. Yesterday, we experienced a crash every 5 mins that usually meant two severs down.

      For this reason, we upgraded to 10.4.10 to see if this version patched anything related to our crashes. However, we again were in the same escenario.

      Finally, we had to perform a rollback to an older version: 10.2.29. And since yesterday we do not have any crashes.

      I'm attaching logs from 10.4.8 and 10.4.10 that were continuously crashing. Everytime same traces. We cannot reproduce this again as we are in production and need stability, so we are not in that version again, a bit worried to upgrade again in a near future.

      Some key lines in the logs:

      For 10.4.8:

      Nov 20 13:55:04 be61 mysqld[46559]: mysqld: /home/buildbot/buildbot/build/mariadb-10.4.8/wsrep-lib/src/transaction.cpp:951: void wsrep::transaction::after_replay(const wsrep::transaction&): Assertion `other.state() == s_committed || other.state() == s_aborted' failed.
      Nov 20 13:55:04 be61 mysqld[46559]: 191120 13:55:04 [ERROR] mysqld got signal 6 ;
      

      For 10.4.10:

      Nov 20 19:45:52 be60 mysqld[3322]: mysqld: /home/buildbot/buildbot/build/mariadb-10.4.10/wsrep-lib/src/transaction.cpp:1038: void wsrep::transaction::after_replay(const wsrep::transaction&): Assertion `other.state() == s_committed || other.state() == s_aborted' failed.
      Nov 20 19:45:52 be60 mysqld[3322]: 191120 19:45:52 [ERROR] mysqld got signal 6 ;
      

      Do you need any more information?

        Attachments

        1. Galera Log 2.txt
          6 kB
          Mark Hughes
        2. galera-log-random-crash-10.4.10.txt
          12 kB
          Ibai Valencia
        3. galera-log-random-crash-10.4.8.txt
          14 kB
          Ibai Valencia
        4. Mysql Log Public.log
          24 kB
          Mark Hughes

          Issue Links

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              ibaivalencia Ibai Valencia
              Votes:
              3 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: