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

MariaDB server with Galera replication crashes randomly

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.1.11
    • 10.1.30
    • Galera, wsrep
    • None
    • Debian 8, MariaDB 10.1.11, Galera 25.3.12
    • 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

              sachin.setiya.007 Sachin Setiya (Inactive)
              shell434 Robert Seliga
              Votes:
              3 Vote for this issue
              Watchers:
              9 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.