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

MariaDB server with Galera replication crashes randomly

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 10.1.11
    • Fix Version/s: 10.1.30
    • Component/s: Galera, wsrep
    • Labels:
      None
    • Environment:
      Debian 8, MariaDB 10.1.11, Galera 25.3.12
    • Sprint:
      10.1.12, 10.1.13, 10.2.2-1, 10.2.2-2, 10.2.2-3

      Description

      We have 3 servers with Galera replication. They crash randomly everyday, sometimes few times per day. Configuration file and log report after crash is in attachment.
      MariaDB 10.0.x is working properly. We tested version 10.1.8 and above and every version crashes

      Jan 30 14:30:21 SQL2 mysqld: stack_bottom = 0x7fb970636df8 thread_stack 0x40000
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x7fc1766a732e]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(handle_fatal_signal+0x34d)[0x7fc1761e98fd]
      Jan 30 14:30:22 SQL2 mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0xf8d0)[0x7fc1758188d0]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG21do_checkpoint_requestEm+0x98)[0x7fc17629ede8]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG20checkpoint_and_purgeEm+0x11)[0x7fc17629ee11]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG23trx_group_commit_leaderEPNS_18group_commit_entryE+0x513)[0x7fc1762a1ce3]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG34write_transaction_to_binlog_eventsEPNS_18group_commit_entryE+0x1bb)[0x7fc1762a216b]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_ZN13MYSQL_BIN_LOG27write_transaction_to_binlogEP3THDP17binlog_cache_mngrP9Log_eventbbb+0xcf)[0x7fc1762a239f]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(+0x65951f)[0x7fc1762a251f]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(+0x6598bc)[0x7fc1762a28bc]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(+0x659f8a)[0x7fc1762a2f8a]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z19ha_commit_one_phaseP3THDb+0x92)[0x7fc1761ec262]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z15ha_commit_transP3THDb+0x346)[0x7fc1761eca86]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z17trans_commit_stmtP3THD+0x38)[0x7fc176142f18]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z21mysql_execute_commandP3THD+0xc3c)[0x7fc1760601fc]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x20e)[0x7fc176068a6e]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(+0x420269)[0x7fc176069269]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x181c)[0x7fc17606b0bc]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0x16e)[0x7fc17606bd9e]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(_Z24do_handle_one_connectionP3THD+0x182)[0x7fc176134fc2]
      Jan 30 14:30:22 SQL2 mysqld: /usr/sbin/mysqld(handle_one_connection+0x40)[0x7fc176135180]
      Jan 30 14:30:22 SQL2 mysqld: /lib/x86_64-linux-gnu/libpthread.so.0(+0x80a4)[0x7fc1758110a4]
      Jan 30 14:30:22 SQL2 mysqld: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fc1739bd9cd]

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sachin.setiya.007 Sachin Setiya
              Reporter:
              shell434 Robert Seliga
              Votes:
              3 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: