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

MariaDB server with Galera replication crashes randomly

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

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9478 MariaDB 10.1.10 crashs on Debian Jessie

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9510 Segmentation fault in binlog thread causes crash

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9515 Galera to Galera Async Master / Master Replication Crash Cluster

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9624 mysqld crash

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9715 mysqld got signal 11

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9785 Galera node cant connect to cluster

          • Major - Major loss of function.
          • Closed
          links to

          Web Link Commit

          Activity

            Transition Time In Source Status Execution Times
            Nirbhay Choubey (Inactive) made transition -
            Open In Progress
            		19d 1h 20m 1
            Nirbhay Choubey (Inactive) made transition -
            In Progress Closed
            		32d 13h 29m 1
            Nirbhay Choubey (Inactive) made transition -
            Closed Stalled
            		100d 23h 34m 1
            Andrei Elkin made transition -
            Stalled Closed
            		529d 23h 31m 1

            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.