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

Assertion `! thd->transaction_rollback_request' failed in rows_event_stmt_cleanup

    XMLWordPrintable

Details

    Description

      ./mtr rpl.rpl_temporary_error2,row --mysqld=--slave-skip-errors=all
      

      10.2 3fb3acf58e029203ec04c21a6

      2022-01-14 17:14:03 140033009788672 [Warning] Slave SQL: Could not execute Update_rows_v1 event on table test.t1; Deadlock found when trying to get lock; try restarting transaction, Error_code: 1213; handler error HA_ERR_LOCK_DEADLOCK; the event's master log master-bin.000001, end_log_pos 1823, Gtid 0-1-5, Internal MariaDB error code: 1213
      mysqld: 10.2/src/sql/log_event.cc:11289: int rows_event_stmt_cleanup(rpl_group_info*, THD*): Assertion `! thd->transaction_rollback_request' failed.
      220114 17:14:03 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.2.42-MariaDB-debug-log
      key_buffer_size=1048576
       
      mysys/stacktrace.c:172(my_print_stacktrace)[0x5597e78d8649]
      sql/signal_handler.cc:221(handle_fatal_signal)[0x5597e66fd999]
      sigaction.c:0(__restore_rt)[0x7f5c10dca3c0]
      sql/log_event.cc:11290(rows_event_stmt_cleanup(rpl_group_info*, THD*))[0x5597e6a12d8f]
      sql/log_event.cc:11213(Rows_log_event::do_apply_event(rpl_group_info*))[0x5597e6a12640]
      sql/log_event.h:1462(Log_event::apply_event(rpl_group_info*))[0x5597e5ef356b]
      sql/slave.cc:3469(apply_event_and_update_pos_apply(Log_event*, THD*, rpl_group_info*, int))[0x5597e5ed910c]
      sql/slave.cc:3637(apply_event_and_update_pos(Log_event*, THD*, rpl_group_info*))[0x5597e5ed9bdb]
      sql/slave.cc:3936(exec_relay_log_event(THD*, Relay_log_info*, rpl_group_info*))[0x5597e5edae60]
      sql/slave.cc:5096(handle_slave_sql)[0x5597e5ee249a]
      perfschema/pfs.cc:1871(pfs_spawn_thread)[0x5597e77dcd84]
      nptl/pthread_create.c:478(start_thread)[0x7f5c10dbe609]
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f5c10997293]
       
       
      Query (0x61200002f7c3): UPDATE t1 SET b=1 WHERE a=4
      

      Attachments

        1. reducer329.sh
          413 kB
          Roel Van de Paar

        Issue Links

          Activity

            People

              bnestere Brandon Nesterenko
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.