Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL)
-
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
- relates to
-
MDEV-19302 Assertion `!current_stmt_is_commit || !rgi->tables_to_lock' failed in Query_log_event::do_apply_event
-
- Closed
-
-
MDEV-22338 Assertion `!current_stmt_is_commit || !rgi->tables_to_lock' failed in Query_log_event::do_apply_event
-
- Stalled
-
Activity
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} |
Status | Open [ 1 ] | Confirmed [ 10101 ] |
Fix Version/s | 10.2 [ 14601 ] | |
Affects Version/s | 10.2 [ 14601 ] | |
Assignee | Kristian Nielsen [ knielsen ] | Rasmus Johansson [ ratzpo ] |
Assignee | Rasmus Johansson [ ratzpo ] | Michael Widenius [ monty ] |
Assignee | Michael Widenius [ monty ] | Andrei Elkin [ elkin ] |
Link |
This issue relates to |
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 ] |
Link | This issue relates to MDEV-22338 [ MDEV-22338 ] |
Workflow | MariaDB v3 [ 67601 ] | MariaDB v4 [ 149196 ] |