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

Assertion `wsrep_thd_is_applying(thd) && !wsrep_thd_is_local_toi(thd)' failed in int wsrep_ignored_error_code(Log_event*, int)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0, 11.1
    • N/A
    • Galera

    Description

      Test case

      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/scripts/mariadb-install-db --no-defaults --force  --auth-root-authentication-method=normal  --basedir=/dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg --datadir=/dev/shm/qa/node1 > /dev/shm/qa/log/startup1.log 2>&1
      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/scripts/mariadb-install-db --no-defaults --force  --auth-root-authentication-method=normal  --basedir=/dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg --datadir=/dev/shm/qa/node2 > /dev/shm/qa/log/startup2.log 2>&1
      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/scripts/mariadb-install-db --no-defaults --force  --auth-root-authentication-method=normal  --basedir=/dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg --datadir=/dev/shm/qa/node3 > /dev/shm/qa/log/startup3.log 2>&1
       
       
      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/bin/mysqld --defaults-file=/dev/shm/qa/conf/node1.cnf --slave-parallel-workers=5 --wsrep-new-cluster > /dev/shm/qa/node1/node1.err 2>&1 &
      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/bin/mysql --user=root --socket=/dev/shm/qa/node1/mysql.sock -Bse"SET SESSION sql_log_bin=0;delete from mysql.user where user='';" > /dev/null 2>&1
      sleep 5
      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/bin/mysqld --defaults-file=/dev/shm/qa/conf/node2.cnf --slave-parallel-workers=5 > /dev/shm/qa/node2/node2.err 2>&1 &
      sleep 20
      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/bin/mysqld --defaults-file=/dev/shm/qa/conf/node3.cnf --slave-parallel-workers=5 > /dev/shm/qa/node3/node3.err 2>&1 &
       
      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/scripts/mariadb-install-db --no-defaults --force  --auth-root-authentication-method=normal --basedir=/dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg --datadir=/dev/shm/qa/mdnode1 > /dev/shm/qa/log/md_startup1.log 2>&1
       
      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/bin/mysqld --defaults-file=/dev/shm/qa/conf/md1.cnf --datadir=/dev/shm/qa/mdnode1 --basedir=/dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg --slave-parallel-workers=5 --log-error=/dev/shm/qa/log/mdnode1.err > /dev/shm/qa/log/mdnode1.err 2>&1 &
      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/bin/mysql --user=root --socket=/tmp/mdnode1.sock -Bse"SET SESSION sql_log_bin=0;delete from mysql.user where user='';SET SESSION sql_log_bin=1;drop database if exists test; create database test;" > /dev/null 2>&1
       
      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/bin/mysql --user=root --socket=/tmp/mdnode1.sock -Bse "flush logs" 2>&1
      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/bin/mysql --user=root --socket=/tmp/mdnode1.sock -Bse 'show master logs' | awk '{print $1}' | tail -1 2>&1
      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/bin/mysql --user=root --socket=/tmp/mdnode1.sock -Bse 'show master logs' | awk '{print $2}' | tail -1 2>&1
      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/bin/mysql --user=root --socket=/tmp/mdnode1.sock -Bse "select @@port" 2>&1
      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/bin/mysql --user=root --socket=/dev/shm/qa/node1/mysql.sock -Bse"CHANGE MASTER  TO MASTER_HOST='127.0.0.1', MASTER_PORT=3600, MASTER_USER='root', MASTER_LOG_FILE='binlog.000002', MASTER_LOG_POS=365 ;START SLAVE ;" 2>&1
       
      /dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/bin/mysql --user=root --socket=/tmp/mdnode1.sock < prepared_statements.sql > /dev/null 2>&1
      

      Leads to

      10.9.0 8680eedb2650ba017305cf8db26c96d056196375 (Debug)

      mysqld: /test/mtest/10.9_dbg/sql/wsrep_mysqld.cc:3364: int wsrep_ignored_error_code(Log_event*, int): Assertion `wsrep_thd_is_applying(thd) && !wsrep_thd_is_local_toi(thd)' failed.
      

      10.9.0 8680eedb2650ba017305cf8db26c96d056196375 (Debug)

      Core was generated by `/dev/shm/qa/GAL_MD300322-mariadb-10.9.0-linux-x86_64-new-dbg/bin/mysqld --defau'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6)
          at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      [Current thread is 1 (Thread 0x1485bc10c700 (LWP 1859798))]
      (gdb) bt
      #0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56
      #1  0x0000560f868d3fb7 in my_write_core (sig=sig@entry=6) at /test/mtest/10.9_dbg/mysys/stacktrace.c:424
      #2  0x0000560f860b46f5 in handle_fatal_signal (sig=6) at /test/mtest/10.9_dbg/sql/signal_handler.cc:345
      #3  <signal handler called>
      #4  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #5  0x00001485fdbfe859 in __GI_abort () at abort.c:79
      #6  0x00001485fdbfe729 in __assert_fail_base (fmt=0x1485fdd94588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x560f86ce7060 "wsrep_thd_is_applying(thd) && !wsrep_thd_is_local_toi(thd)", file=0x560f86ce6198 "/test/mtest/10.9_dbg/sql/wsrep_mysqld.cc", line=3364, function=<optimized out>) at assert.c:92
      #7  0x00001485fdc0ff36 in __GI___assert_fail (assertion=assertion@entry=0x560f86ce7060 "wsrep_thd_is_applying(thd) && !wsrep_thd_is_local_toi(thd)", file=file@entry=0x560f86ce6198 "/test/mtest/10.9_dbg/sql/wsrep_mysqld.cc", line=line@entry=3364, function=function@entry=0x560f86ce7030 "int wsrep_ignored_error_code(Log_event*, int)") at assert.c:101
      #8  0x0000560f8642148c in wsrep_ignored_error_code (ev=ev@entry=0x14856c109d28, error=error@entry=1927) at /test/mtest/10.9_dbg/sql/wsrep_mysqld.cc:3364
      #9  0x0000560f8624d429 in Rows_log_event::do_apply_event (this=0x14856c109d28, rgi=0x14856c143cc0) at /test/mtest/10.9_dbg/include/my_bitmap.h:106
      #10 0x0000560f85caa45d in Log_event::apply_event (rgi=0x14856c143cc0, this=0x14856c109d28) at /test/mtest/10.9_dbg/sql/log_event.h:1566
      #11 apply_event_and_update_pos_apply (ev=ev@entry=0x14856c109d28, thd=thd@entry=0x14857c000ff8, rgi=rgi@entry=0x14856c143cc0, reason=reason@entry=0) at /test/mtest/10.9_dbg/sql/slave.cc:3881
      #12 0x0000560f85cb54aa in apply_event_and_update_pos_for_parallel (ev=ev@entry=0x14856c109d28, thd=thd@entry=0x14857c000ff8, rgi=rgi@entry=0x14856c143cc0) at /test/mtest/10.9_dbg/sql/slave.cc:4078
      #13 0x0000560f85fb24cb in rpt_handle_event (qev=qev@entry=0x14856c1454e8, rpt=rpt@entry=0x14856c00d650) at /test/mtest/10.9_dbg/sql/rpl_parallel.cc:62
      #14 0x0000560f85fb838b in handle_rpl_parallel_thread (arg=arg@entry=0x14856c00d650) at /test/mtest/10.9_dbg/sql/rpl_parallel.cc:1409
      #15 0x0000560f863b254f in pfs_spawn_thread (arg=0x14856c00f248) at /test/mtest/10.9_dbg/storage/perfschema/pfs.cc:2201
      #16 0x00001485fe10d609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #17 0x00001485fdcfb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        1. transactions-alter.zz
          1 kB
          Ramesh Sivaraman
        2. transactions-alter.yy
          5 kB
          Ramesh Sivaraman
        3. prepared_statements.sql
          6 kB
          Ramesh Sivaraman
        4. node3.cnf
          0.9 kB
          Ramesh Sivaraman
        5. node2.cnf
          1.0 kB
          Ramesh Sivaraman
        6. node1.cnf
          1.0 kB
          Ramesh Sivaraman
        7. md1.cnf
          0.3 kB
          Ramesh Sivaraman

        Issue Links

          Activity

            People

              janlindstrom Jan Lindström
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.