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

Node has been dropped from the cluster on Startup / Shutdown with async replica

Details

    Description

       
      		 
      2023-06-02 12:40:14 14 [Note] Slave I/O thread: Start asynchronous replication to master 'root@127.0.0.1:1600
      		 
      0' in log 'mysqld-bin.000002' at position 4
      		 
      2023-06-02 12:40:14 15 [Note] Slave SQL thread initialized, starting replication in log 'mysqld-bin.000002' a
      		 
      t position 4, relay log './mysqld-relay-bin.000001' position: 4; GTID position ''
      		 
      2023-06-02 12:40:14 0 [Note] /home/jan/work/mariadb/10.5e/sql/mysqld: ready for connections.
      		 
      Version: '10.4.29-20-MariaDB-debug-log'  socket: '/home/jan/work/mariadb/10.5e/mysql-test/var/tmp/mysqld.4.so
      		 
      ck'  port: 16003  Source distribution
      		 
      2023-06-02 12:40:14 14 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:16000',replication starts
      		 
       at GTID position ''
      		 
      2023-06-02 12:40:14 15 [ERROR] Slave SQL: Error 'WSREP has not yet prepared node for application use' on quer
      		 
      y. Default database: 'test'. Query: 'CREATE TABLE t1 (id bigint primary key, msg varchar(100)) engine=innodb'
      		 
      , Gtid 1-1-1, Internal MariaDB error code: 1047
      		 
      2023-06-02 12:40:14 15 [ERROR] Slave SQL: Node has dropped from cluster, Gtid 1-1-1, Internal MariaDB error c
      		 
      ode: 1047

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32780 galera_as_slave_replay: assertion in the wsrep::transaction::before_rollback()

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33977 MariaDB hangs on --wsrep-recover phase

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34211 Seconds_Behind_Master gives impossible values

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34924 gtid_slave_pos table rows newer been deleted on non replica nodes (wsrep_gtid_mode = 1)

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35627 mysql.gtid_slave_pos gets really big

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34170 table gtid_slave_pos entries never been deleted with wsrep_gtid_mode = 0

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28373 mysql.gtid_slave_pos DDL/DML statements are written into the binary log

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32740 wsrep_gtid_domain_id is disregarded on any node other than bootstrapped node when the wsrep_gtid_mode is set to ON with wsrep_provider_version 26.4.14 (Galera 4)

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35157 wrong binlog timestamps on secondary nodes of a galera cluster

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            janlindstrom Jan Lindström added a comment -

            https://github.com/MariaDB/server/pull/2691

            janlindstrom Jan Lindström added a comment - https://github.com/MariaDB/server/pull/2691
            sysprg Julius Goryavsky added a comment -

            Fix merged with head revision: https://github.com/MariaDB/server/commit/277968aa4cfa46a290af1c44e9d756381005939a

            sysprg Julius Goryavsky added a comment - Fix merged with head revision: https://github.com/MariaDB/server/commit/277968aa4cfa46a290af1c44e9d756381005939a
            serg Sergei Golubchik added a comment -

            10.5+ need a different fix. And the test case has to be run in buildbot

            serg Sergei Golubchik added a comment - 10.5+ need a different fix. And the test case has to be run in buildbot
            sysprg Julius Goryavsky added a comment -

            Added additional fix for 10.5+ https://github.com/MariaDB/server/commit/c3fdfbdbd82c43f867ed82232e3b3077c485c5e1

            sysprg Julius Goryavsky added a comment - Added additional fix for 10.5+ https://github.com/MariaDB/server/commit/c3fdfbdbd82c43f867ed82232e3b3077c485c5e1

            People

              sysprg Julius Goryavsky
              janlindstrom Jan Lindström
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.