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

Assertion `!current_stmt_is_commit || !rgi->tables_to_lock' failed in Query_log_event::do_apply_event(rpl_group_info*, const char*, uint32)

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1(EOL), 10.2(EOL)
    • 10.3.0
    • Replication
    • None

    Description

      Stack trace from 10.1 commit 536112dd

      10.1/sql/log_event.cc:4103: int Query_log_event::do_apply_event(rpl_group_info*, const char*, uint32): Assertion `!current_stmt_is_commit || !rgi->tables_to_lock' failed.
      150521 19:33:11 [ERROR] mysqld got signal 6 ;
       
      #6  0x00007f411ca86311 in *__GI___assert_fail (assertion=0x7f411fe19f88 "!current_stmt_is_commit || !rgi->tables_to_lock", file=<optimized out>, line=4103, function=0x7f411fe1e240 "int Query_log_event::do_apply_event(rpl_group_info*, const char*, uint32)") at assert.c:81
      #7  0x00007f411f6e3250 in Query_log_event::do_apply_event (this=0x7f410e8b0230, rgi=0x7f410e820800, query_arg=0x7f410e885579 "COMMIT", q_len_arg=6) at 10.1/sql/log_event.cc:4103
      #8  0x00007f411f6e2f73 in Query_log_event::do_apply_event (this=0x7f410e8b0230, rgi=0x7f410e820800) at 10.1/sql/log_event.cc:4013
      #9  0x00007f411f32a6c9 in Log_event::apply_event (this=0x7f410e8b0230, rgi=0x7f410e820800) at 10.1/sql/log_event.h:1347
      #10 0x00007f411f32026f in apply_event_and_update_pos (ev=0x7f410e8b0230, thd=0x7f410e849070, rgi=0x7f410e820800, rpt=0x0) at 10.1/sql/slave.cc:3274
      #11 0x00007f411f320a86 in exec_relay_log_event (thd=0x7f410e849070, rli=0x7f410fc0ac40, serial_rgi=0x7f410e820800) at 10.1/sql/slave.cc:3577
      #12 0x00007f411f323d68 in handle_slave_sql (arg=0x7f410fc09000) at 10.1/sql/slave.cc:4677
      #13 0x00007f411faa61a2 in pfs_spawn_thread (arg=0x7f411c01fc70) at 10.1/storage/perfschema/pfs.cc:1860
      #14 0x00007f411eaa1b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
      #15 0x00007f411cb3695d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
      

      --source include/master-slave.inc
      --source include/have_innodb.inc
      --source include/have_binlog_format_row.inc
       
      CREATE TABLE t1 (i INT) ENGINE=InnoDB;
      CREATE TABLE t2 (j INT) ENGINE=MyISAM;
       
      --delimiter ||
      CREATE TRIGGER tr AFTER INSERT ON t1 FOR EACH ROW 
      BEGIN 
        SET @a = unknown_column_just_to_raise_an_error; 
        INSERT INTO t2 VALUES (NULL) ; 
      END||
      --delimiter ;
       
      --error ER_BAD_FIELD_ERROR
      INSERT INTO t1 VALUES (1);
       
      --sync_slave_with_master
      

      Attachments

        Issue Links

          Activity

            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Description {noformat:title=Stack trace from 10.1 commit 536112dd}
            10.1/sql/log_event.cc:4103: int Query_log_event::do_apply_event(rpl_group_info*, const char*, uint32): Assertion `!current_stmt_is_commit || !rgi->tables_to_lock' failed.
            150521 19:33:11 [ERROR] mysqld got signal 6 ;

            #6 0x00007f411ca86311 in *__GI___assert_fail (assertion=0x7f411fe19f88 "!current_stmt_is_commit || !rgi->tables_to_lock", file=<optimized out>, line=4103, function=0x7f411fe1e240 "int Query_log_event::do_apply_event(rpl_group_info*, const char*, uint32)") at assert.c:81
            #7 0x00007f411f6e3250 in Query_log_event::do_apply_event (this=0x7f410e8b0230, rgi=0x7f410e820800, query_arg=0x7f410e885579 "COMMIT", q_len_arg=6) at 10.1/sql/log_event.cc:4103
            #8 0x00007f411f6e2f73 in Query_log_event::do_apply_event (this=0x7f410e8b0230, rgi=0x7f410e820800) at 10.1/sql/log_event.cc:4013
            #9 0x00007f411f32a6c9 in Log_event::apply_event (this=0x7f410e8b0230, rgi=0x7f410e820800) at 10.1/sql/log_event.h:1347
            #10 0x00007f411f32026f in apply_event_and_update_pos (ev=0x7f410e8b0230, thd=0x7f410e849070, rgi=0x7f410e820800, rpt=0x0) at 10.1/sql/slave.cc:3274
            #11 0x00007f411f320a86 in exec_relay_log_event (thd=0x7f410e849070, rli=0x7f410fc0ac40, serial_rgi=0x7f410e820800) at 10.1/sql/slave.cc:3577
            #12 0x00007f411f323d68 in handle_slave_sql (arg=0x7f410fc09000) at 10.1/sql/slave.cc:4677
            #13 0x00007f411faa61a2 in pfs_spawn_thread (arg=0x7f411c01fc70) at 10.1/storage/perfschema/pfs.cc:1860
            #14 0x00007f411eaa1b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
            #15 0x00007f411cb3695d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
            {noformat}

            {code:sql}
            --source include/master-slave.inc
            --source include/have_innodb.inc
            --source include/have_binlog_format_row.inc

            CREATE TABLE t1 (i INT) ENGINE=InnoDB;
            CREATE TABLE t2 (j INT) ENGINE=MyISAM;

            --delimiter ||
            CREATE TRIGGER tr AFTER INSERT ON t1 FOR EACH ROW
            BEGIN
              SET @a = unknown_column_just_to_raise_an_error;
              INSERT INTO t2 VALUES (NULL) ;
            END||
            --delimiter ;

            --error ER_BAD_FIELD_ERROR
            INSERT INTO t1 VALUES (1);

            --connection master

            --sync_slave_with_master
            {code}

            {noformat:title=Stack trace from 10.1 commit 536112dd}
            10.1/sql/log_event.cc:4103: int Query_log_event::do_apply_event(rpl_group_info*, const char*, uint32): Assertion `!current_stmt_is_commit || !rgi->tables_to_lock' failed.
            150521 19:33:11 [ERROR] mysqld got signal 6 ;

            #6 0x00007f411ca86311 in *__GI___assert_fail (assertion=0x7f411fe19f88 "!current_stmt_is_commit || !rgi->tables_to_lock", file=<optimized out>, line=4103, function=0x7f411fe1e240 "int Query_log_event::do_apply_event(rpl_group_info*, const char*, uint32)") at assert.c:81
            #7 0x00007f411f6e3250 in Query_log_event::do_apply_event (this=0x7f410e8b0230, rgi=0x7f410e820800, query_arg=0x7f410e885579 "COMMIT", q_len_arg=6) at 10.1/sql/log_event.cc:4103
            #8 0x00007f411f6e2f73 in Query_log_event::do_apply_event (this=0x7f410e8b0230, rgi=0x7f410e820800) at 10.1/sql/log_event.cc:4013
            #9 0x00007f411f32a6c9 in Log_event::apply_event (this=0x7f410e8b0230, rgi=0x7f410e820800) at 10.1/sql/log_event.h:1347
            #10 0x00007f411f32026f in apply_event_and_update_pos (ev=0x7f410e8b0230, thd=0x7f410e849070, rgi=0x7f410e820800, rpt=0x0) at 10.1/sql/slave.cc:3274
            #11 0x00007f411f320a86 in exec_relay_log_event (thd=0x7f410e849070, rli=0x7f410fc0ac40, serial_rgi=0x7f410e820800) at 10.1/sql/slave.cc:3577
            #12 0x00007f411f323d68 in handle_slave_sql (arg=0x7f410fc09000) at 10.1/sql/slave.cc:4677
            #13 0x00007f411faa61a2 in pfs_spawn_thread (arg=0x7f411c01fc70) at 10.1/storage/perfschema/pfs.cc:1860
            #14 0x00007f411eaa1b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
            #15 0x00007f411cb3695d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
            {noformat}

            {code:sql}
            --source include/master-slave.inc
            --source include/have_innodb.inc
            --source include/have_binlog_format_row.inc

            CREATE TABLE t1 (i INT) ENGINE=InnoDB;
            CREATE TABLE t2 (j INT) ENGINE=MyISAM;

            --delimiter ||
            CREATE TRIGGER tr AFTER INSERT ON t1 FOR EACH ROW
            BEGIN
              SET @a = unknown_column_just_to_raise_an_error;
              INSERT INTO t2 VALUES (NULL) ;
            END||
            --delimiter ;

            --error ER_BAD_FIELD_ERROR
            INSERT INTO t1 VALUES (1);

            --sync_slave_with_master
            {code}

            elenst Elena Stepanova made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.2 [ 14601 ]
            Affects Version/s 10.2 [ 14601 ]
            Assignee Kristian Nielsen [ knielsen ] Rasmus Johansson [ ratzpo ]
            monty Michael Widenius made changes -
            Assignee Rasmus Johansson [ ratzpo ] Michael Widenius [ monty ]
            elenst Elena Stepanova made changes -
            Assignee Michael Widenius [ monty ] Andrei Elkin [ elkin ]
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            Fix Version/s 10.3.0 [ 22127 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.1 [ 16100 ]
            Assignee Andrei Elkin [ elkin ] Michael Widenius [ monty ]
            Resolution Fixed [ 1 ]
            Status Confirmed [ 10101 ] Closed [ 6 ]
            alice Alice Sherepa made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 67601 ] MariaDB v4 [ 149196 ]

            People

              monty Michael Widenius
              elenst Elena Stepanova
              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.