Sergei Golubchik added a comment - 2021-04-01 22:14 Well, if it starts at 4, it's a Format_description_log_event

Roel Van de Paar added a comment - 2021-08-21 06:40 CREATE TABLE t (b INT ); XA START 'a' ; INSERT INTO t VALUES (0); BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=' ; Leads to: 10.7.0 52505bf20de0ce77a5c0b0a74af021051987bb0d (Debug) mysqld: /test/10.7_dbg/sql/sql_error.cc:334: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed. 10.7.0 52505bf20de0ce77a5c0b0a74af021051987bb0d (Debug) Core was generated by `/test/MD160821-mariadb-10.7.0-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'. Program terminated with signal SIGABRT, Aborted. #0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 [Current thread is 1 (Thread 0x1503ed6e5700 (LWP 897134))] (gdb) bt #0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 #1 0x000015040456d859 in __GI_abort () at abort.c:79 #2 0x000015040456d729 in __assert_fail_base (fmt=0x150404703588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5583d0f65588 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=0x5583d0f65468 "/test/10.7_dbg/sql/sql_error.cc", line=334, function=<optimized out>) at assert.c:92 #3 0x000015040457ef36 in __GI___assert_fail (assertion=assertion@entry=0x5583d0f65588 "!is_set() || (m_status == DA_OK_BULK && is_bulk_op())", file=file@entry=0x5583d0f65468 "/test/10.7_dbg/sql/sql_error.cc", line=line@entry=334, function=function@entry=0x5583d0f655c0 "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:101 #4 0x00005583d02909bf in Diagnostics_area::set_ok_status (this=0x1503ac006c30, affected_rows=affected_rows@entry=0, last_insert_id=last_insert_id@entry=0, message=message@entry=0x0) at /test/10.7_dbg/sql/sql_error.h:1029 #5 0x00005583d0433118 in my_ok (message=0x0, id=0, affected_rows_arg=0, thd=0x1503ac000db8) at /test/10.7_dbg/sql/sql_class.h:5552 #6 mysql_client_binlog_statement (thd=thd@entry=0x1503ac000db8) at /test/10.7_dbg/sql/sql_binlog.cc:408 #7 0x00005583d02efa87 in mysql_execute_command (thd=thd@entry=0x1503ac000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.7_dbg/sql/sql_parse.cc:5911 #8 0x00005583d02d6ac3 in mysql_parse (thd=thd@entry=0x1503ac000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1503ed6e4400) at /test/10.7_dbg/sql/sql_parse.cc:8030 #9 0x00005583d02e56c8 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1503ac000db8, packet=packet@entry=0x1503ac00b739 "BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9n", 'A' <repeats 24 times>, " ", 'A' <repeats 18 times>, "BI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8='", packet_length=packet_length@entry=159, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_class.h:1357 #10 0x00005583d02e8ae9 in do_command (thd=0x1503ac000db8, blocking=blocking@entry=true) at /test/10.7_dbg/sql/sql_parse.cc:1404 #11 0x00005583d045edd6 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5583d2b32308, put_in_cache=put_in_cache@entry=true) at /test/10.7_dbg/sql/sql_connect.cc:1418 #12 0x00005583d045f3db in handle_one_connection (arg=arg@entry=0x5583d2b32308) at /test/10.7_dbg/sql/sql_connect.cc:1312 #13 0x00005583d08c7ce4 in pfs_spawn_thread (arg=0x5583d2a5b038) at /test/10.7_dbg/storage/perfschema/pfs.cc:2201 #14 0x0000150404a7c609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #15 0x000015040466a293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Bug confirmed present in: MariaDB: 10.2.41 (dbg), 10.3.32 (dbg), 10.4.22 (dbg), 10.5.13 (dbg), 10.6.5 (dbg), 10.7.0 (dbg) MySQL: 5.5.62 (dbg) Bug (or feature/syntax) confirmed not present in: MariaDB: 10.2.41 (opt), 10.3.32 (opt), 10.4.22 (opt), 10.5.13 (opt), 10.6.5 (opt), 10.7.0 (opt) MySQL: 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.35 (dbg), 5.7.35 (opt), 8.0.26 (dbg), 8.0.26 (opt) This particular test appears in suite/rpl/t/rpl_row_corruption.test: ## test #3: check that BINLOG statements will also raise an ## error if containing table map events mapping different ## tables to same table identifier.   CREATE TABLE t1 (c1 INT); CREATE TABLE t2 (c1 INT);   INSERT INTO t1 VALUES (1); INSERT INTO t2 VALUES (1);   # FD event BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8= '/*!*/;   #110708 12:21:44 server id 1 end_log_pos 774 Table_map: `test`.`t1` mapped to number 66 # at 774 #110708 12:21:44 server id 1 end_log_pos 815 Table_map: `test`.`t2` mapped to number 67 # at 815 #110708 12:21:44 server id 1 end_log_pos 855 Update_rows: table id 66 # at 855 #110708 12:21:44 server id 1 end_log_pos 895 Update_rows: table id 67 flags: STMT_END_F SET @@global.debug_dbug="d,inject_tblmap_same_id_maps_diff_table"; --error ER_SLAVE_FATAL_ERROR

Roel Van de Paar added a comment - 2021-09-18 03:05 CREATE TABLE t (c INT); XA START 'a'; SELECT * FROM t WHERE c=0; BINLOG ' O1ZVRw8BAAAAZgAAAGoAAAAAAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAA7VlVHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC ';

Roel Van de Paar added a comment - 2022-01-31 02:14 - edited Please test any fixes with testcase also: CREATE TABLE t (a INT ,b INT ,c BINARY (1),d CHAR (1),e BINARY (1),f VARCHAR (1),g BLOB,h BLOB,id INT , KEY (b), KEY (e)); XA START 'xa_con3' , 'xa_bqual' ,12; INSERT INTO t VALUES (-23,0,0, 'JIa5cvhg6tUx5CrOhuNTZBady8pN6ktM1gz6Mb2UfqsT7EdaB2AxVA7FruicGyEWLJj0qqB9bFtVrTNVTXb9wi3hFQdTPPR0JZRYvefC6zDn6aAxmcz25GAQxMGbInrJ4LVuO77LdQTQ0JJfokf7Y88nbUhobCQdM7yakLV2KRsHK8bVhnNXzkDXXrdzLqlHLApvWQUxghIQYZ188Cgb8WR2mJsXiKCrOUQIEXWZXAck5yAQjqXIZfuuX5F4TUkU' , 'WV0ukE2Zq' , 'Cme5VwrnlhpLsnd5ZlQo7PmPR3UW5ZwYsT3dE1r48wWhO5BwT9HcjxhLU0cU0S1' ,0, '5D' ,0); BINLOG ' O1ZVRw8BAAAAZgAAAGoAAAAAAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAA7VlVHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC ' ; This is a bit of a special testcase. On 10.8.1 it currently crashes with the stack from MDEV-27687 , but I believe this is only because MDEV-27687 masks this bug. This can be proven by the fact that when this testcase is executed against 10.8.0 (@ rev e222e44d1bfc995870430bb90d8ac97e91f66cb4) it crashes with the stack from this bug. Similarly, another testcase from the last comment above will also crash with the stack from MDEV-27687 when executed against 10.8.1 (@ rev 0c5d1342ae6b5ab3256848be7a83e5c3b1f21566) On all other versions, except MySQL 5.5.62, it will crash with the assert/stack from this bug. On MySQL 5.5.62 (only) it will be this assert/stack: (Debug) mysqld: /test/5.5_dbg/sql/sql_error.cc:358: void Diagnostics_area::set_ok_status(THD*, ulonglong, ulonglong, const char*): Assertion `! is_set()' failed. (Debug) Core was generated by `/test/MS121121-mysql-5.5.62-linux-x86_64-dbg/bin/mysqld --no-defaults --core --'. 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 0x1490c8b04700 (LWP 4165693))] (gdb) bt #0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:56 #1 0x000056527a9161f1 in my_write_core (sig=sig@entry=6) at /test/5.5_dbg/mysys/stacktrace.c:433 #2 0x000056527a7d3e1e in handle_fatal_signal (sig=6) at /test/5.5_dbg/sql/signal_handler.cc:247 #3 <signal handler called> #4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 #5 0x00001490d9576859 in __GI_abort () at abort.c:79 #6 0x00001490d9576729 in __assert_fail_base (fmt=0x1490d970c588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x56527abca908 "! is_set()", file=0x56527abca4b8 "/test/5.5_dbg/sql/sql_error.cc", line=358, function=<optimized out>) at assert.c:92 #7 0x00001490d9587f36 in __GI___assert_fail (assertion=assertion@entry=0x56527abca908 "! is_set()", file=file@entry=0x56527abca4b8 "/test/5.5_dbg/sql/sql_error.cc", line=line@entry=358, function=function@entry=0x56527abca598 "void Diagnostics_area::set_ok_status(THD*, ulonglong, ulonglong, const char*)") at assert.c:101 #8 0x000056527a692b89 in Diagnostics_area::set_ok_status (this=0x56527ca74798, thd=thd@entry=0x56527ca71ba0, affected_rows_arg=affected_rows_arg@entry=0, last_insert_id_arg=last_insert_id_arg@entry=0, message_arg=message_arg@entry=0x0) at /test/5.5_dbg/sql/sql_error.cc:374 #9 0x000056527a7506b4 in my_ok (message=0x0, id=0, affected_rows=0, thd=0x56527ca71ba0) at /test/5.5_dbg/sql/sql_class.h:2959 #10 mysql_client_binlog_statement (thd=thd@entry=0x56527ca71ba0) at /test/5.5_dbg/sql/sql_binlog.cc:254 #11 0x000056527a6b6763 in mysql_execute_command (thd=thd@entry=0x56527ca71ba0) at /test/5.5_dbg/sql/sql_parse.cc:4426 #12 0x000056527a6b7c47 in mysql_parse (thd=thd@entry=0x56527ca71ba0, rawbuf=<optimized out>, length=148, parser_state=parser_state@entry=0x1490c8b03610) at /test/5.5_dbg/sql/sql_parse.cc:5831 #13 0x000056527a6b94bd in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x56527ca71ba0, packet=packet@entry=0x56527caf90e1 "BINLOG ' O1ZVRw8BAAAAZgAAAGoAAAAAAAQANS4xLjIzLXJjLWRlYnVnLWxvZw", 'A' <repeats 22 times>, " ", 'A' <repeats 19 times>, "7VlVHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC '", packet_length=packet_length@entry=148) at /test/5.5_dbg/sql/sql_class.h:758 #14 0x000056527a6bad83 in do_command (thd=0x56527ca71ba0) at /test/5.5_dbg/sql/sql_parse.cc:776 #15 0x000056527a76b3f2 in do_handle_one_connection (thd_arg=thd_arg@entry=0x56527ca71ba0) at /test/5.5_dbg/sql/sql_connect.cc:870 #16 0x000056527a76b4c4 in handle_one_connection (arg=0x56527ca71ba0) at /test/5.5_dbg/sql/sql_connect.cc:789 #17 0x00001490d9a7f609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #18 0x00001490d9673293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95 Which is (likely incidentally) the same as the one in the just-fixed MDEV-27536 . Given these findings, it is highly likely there is zero connection between this bug, MDEV-27536 and MDEV-27687 (except for any masking), so I am not linking them for the moment.

Andrei Elkin added a comment - 2022-02-01 16:59 Duplicates MDEV-27536 .