Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
--source include/have_log_bin.inc
|
--source include/have_binlog_format_mixed.inc
|
|
# Reproducible with MyISAM, InnoDB, Aria |
|
CREATE TABLE t1 (f1 INT); |
CREATE TABLE t2 (f2 INT); |
CREATE TABLE t3 (f3 INT); |
CREATE TABLE t4 (pk INT AUTO_INCREMENT PRIMARY KEY); |
|
CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW INSERT INTO t2 VALUES (); |
CREATE TRIGGER tr2 AFTER INSERT ON t1 FOR EACH ROW INSERT INTO t3 VALUES (); |
CREATE TRIGGER tr3 BEFORE INSERT ON t2 FOR EACH ROW INSERT INTO t4 VALUES (); |
|
LOCK TABLE t1 WRITE; |
INSERT INTO t2 () VALUES (); |
INSERT INTO t3 VALUES (); |
|
# Cleanup
|
|
UNLOCK TABLES;
|
DROP TABLE t1, t2, t3, t4; |
10.2 0c4d11e8199f |
mysqld: /data/src/10.2/sql/log.cc:5623: int THD::binlog_write_table_map(TABLE*, bool, my_bool*): Assertion `is_current_stmt_binlog_format_row()' failed.
|
171122 19:19:47 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007fe2c3215ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x00005616a0bab007 in THD::binlog_write_table_map (this=0x7fe2a0000b00, table=0x7fe2a006b0c0, is_transactional=false, with_annotate=0x7fe2bd4a60f6 "\001") at /data/src/10.2/sql/log.cc:5623
|
#9 0x00005616a0aaf652 in write_locked_table_maps (thd=0x7fe2a0000b00) at /data/src/10.2/sql/handler.cc:5794
|
#10 0x00005616a0aaf71b in binlog_log_row_internal (table=0x7fe2a007cd30, before_record=0x0, after_record=0x7fe2a007e0b8 "\377", log_func=0x5616a0ab23aa <Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, bool, unsigned char const*, unsigned char const*)>) at /data/src/10.2/sql/handler.cc:5825
|
#11 0x00005616a0aaf811 in binlog_log_row (table=0x7fe2a007cd30, before_record=0x0, after_record=0x7fe2a007e0b8 "\377", log_func=0x5616a0ab23aa <Write_rows_log_event::binlog_row_logging_function(THD*, TABLE*, bool, unsigned char const*, unsigned char const*)>) at /data/src/10.2/sql/handler.cc:5857
|
#12 0x00005616a0ab0031 in handler::ha_write_row (this=0x7fe2a007d938, buf=0x7fe2a007e0b8 "\377") at /data/src/10.2/sql/handler.cc:6008
|
#13 0x00005616a080fad0 in write_record (thd=0x7fe2a0000b00, table=0x7fe2a007cd30, info=0x7fe2bd4a64a0) at /data/src/10.2/sql/sql_insert.cc:1929
|
#14 0x00005616a080d587 in mysql_insert (thd=0x7fe2a0000b00, table_list=0x7fe2a0012628, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.2/sql/sql_insert.cc:1057
|
#15 0x00005616a0834bc0 in mysql_execute_command (thd=0x7fe2a0000b00) at /data/src/10.2/sql/sql_parse.cc:4414
|
#16 0x00005616a083fabe in mysql_parse (thd=0x7fe2a0000b00, rawbuf=0x7fe2a0012548 "INSERT INTO t3 VALUES ()", length=24, parser_state=0x7fe2bd4a7200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7869
|
#17 0x00005616a082da4a in dispatch_command (command=COM_QUERY, thd=0x7fe2a0000b00, packet=0x7fe2a01057f1 "INSERT INTO t3 VALUES ()", packet_length=24, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1805
|
#18 0x00005616a082c3a8 in do_command (thd=0x7fe2a0000b00) at /data/src/10.2/sql/sql_parse.cc:1360
|
#19 0x00005616a097998d in do_handle_one_connection (connect=0x5616a4085390) at /data/src/10.2/sql/sql_connect.cc:1354
|
#20 0x00005616a097971a in handle_one_connection (arg=0x5616a4085390) at /data/src/10.2/sql/sql_connect.cc:1260
|
#21 0x00005616a0d96e1a in pfs_spawn_thread (arg=0x5616a4127080) at /data/src/10.2/storage/perfschema/pfs.cc:1863
|
#22 0x00007fe2c4eec494 in start_thread (arg=0x7fe2bd4a8700) at pthread_create.c:333
|
#23 0x00007fe2c32d293f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Also reproducible on 10.3.
Couldn't reproduce on 10.1, MySQL 5.6, 5.7.
No visible effect on non-debug builds.
Attachments
Issue Links
- blocks
-
MDEV-21307 Assertion `cache_mngr->trx_cache.empty() && cache_mngr->stmt_cache.empty()' failed in binlog_close_connection
- Stalled
- relates to
-
MDEV-21307 Assertion `cache_mngr->trx_cache.empty() && cache_mngr->stmt_cache.empty()' failed in binlog_close_connection
- Stalled
-
MDEV-24534 Assertion `!is_current_stmt_binlog_format_row()' failed in THD::restore_stmt_binlog_format
- Open