[MDEV-22936] Assertion `m_curr_row <= m_rows_end' failed in Rows_log_event::unpack_current_row, SEGV in process_str_arg, and errors 171, 1030, 1105, 1223, 1296, 1429, 1610 and 12701 - Jira

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.1(EOL), (18)
10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.4, 11.5(EOL), 11.6(EOL), 11.8, 12.0
Fix Version/s: 10.5, 10.6, 10.11, 11.4, 11.8
Component/s: Replication
Labels:
- affects-tests

Description

Note: --log-bin option is not required.

USE test;

BINLOG 'AMqaOw8BAAAAdAAAAHgAAAAAAAQANS42LjM0LTc5LjEtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAYVx w2w=';

CREATE TABLE t1 (c INT);

BINLOG 'wlZOTxMBAAAAKgAAADwCAAAAACkAAAAAAAEABHRlc3QAAnQxAAIDAwAC wlZOTxcBAAAAJgAAAGICAAAAACkAAAAAAAEAAv/8AgAAAAgAAAA=';

Leads to:

10.5.4 4080e3acefd7e58d88c2f3539fb6a0fb359cf057
mysqld: /test/10.5_dbg/sql/log_event.h:5186: int Rows_log_event::unpack_current_row(rpl_group_info*): Assertion `m_curr_row <= m_rows_end' failed.

10.5.4 4080e3acefd7e58d88c2f3539fb6a0fb359cf057
Core was generated by `/test/MD150620-mariadb-10.5.4-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:57
[Current thread is 1 (Thread 0x14d1458b5700 (LWP 4107605))]
(gdb) bt
#0 __pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57
#1 0x000055fda8ff24c6 in my_write_core (sig=sig@entry=6) at /test/10.5_dbg/mysys/stacktrace.c:518
#2 0x000055fda8794d60 in handle_fatal_signal (sig=6) at /test/10.5_dbg/sql/signal_handler.cc:330
#3 <signal handler called>
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
#5 0x000014d146729801 in __GI_abort () at abort.c:79
#6 0x000014d14671939a in __assert_fail_base (fmt=0x14d1468a07d8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x55fda9335456 "m_curr_row <= m_rows_end", file=file@entry=0x55fda914e080 "/test/10.5_dbg/sql/log_event.h", line=line@entry=5186, function=function@entry=0x55fda93386c0 <Rows_log_event::unpack_current_row(rpl_group_info)::__PRETTY_FUNCTION__> "int Rows_log_event::unpack_current_row(rpl_group_info)") at assert.c:92
#7 0x000014d146719412 in __GI___assert_fail (assertion=assertion@entry=0x55fda9335456 "m_curr_row <= m_rows_end", file=file@entry=0x55fda914e080 "/test/10.5_dbg/sql/log_event.h", line=line@entry=5186, function=function@entry=0x55fda93386c0 <Rows_log_event::unpack_current_row(rpl_group_info)::__PRETTY_FUNCTION__> "int Rows_log_event::unpack_current_row(rpl_group_info)") at assert.c:101
#8 0x000055fda8900539 in Rows_log_event::unpack_current_row (rgi=0x14d125c8d800, this=0x14d125cff288) at /test/10.5_dbg/sql/log_event.h:5186
#9 Rows_log_event::write_row (this=this@entry=0x14d125cff288, rgi=rgi@entry=0x14d125c8d800, overwrite=false) at /test/10.5_dbg/sql/log_event_server.cc:7196
#10 0x000055fda8901452 in Write_rows_log_event::do_exec_row (this=0x14d125cff288, rgi=0x14d125c8d800) at /test/10.5_dbg/sql/log_event_server.cc:7482
#11 0x000055fda88f2223 in Rows_log_event::do_apply_event (this=0x14d125cff288, rgi=0x14d125c8d800) at /test/10.5_dbg/sql/log_event_server.cc:5652
#12 0x000055fda861152d in Log_event::apply_event (rgi=0x14d125c8d800, this=0x14d125cff288) at /test/10.5_dbg/sql/log_event.h:1496
#13 mysql_client_binlog_statement (thd=thd@entry=0x14d125c15088) at /test/10.5_dbg/sql/sql_binlog.cc:357
#14 0x000055fda84ef4de in mysql_execute_command (thd=thd@entry=0x14d125c15088) at /test/10.5_dbg/sql/sql_parse.cc:5865
#15 0x000055fda84f715c in mysql_parse (thd=thd@entry=0x14d125c15088, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14d1458b4350, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:7993
#16 0x000055fda84e3c60 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14d125c15088, packet=packet@entry=0x14d125c67089 "BINLOG 'wlZOTxMBAAAAKgAAADwCAAAAACkAAAAAAAEABHRlc3QAAnQxAAIDAwAC wlZOTxcBAAAAJgAAAGICAAAAACkAAAAAAAEAAv/8AgAAAAgAAAA='", packet_length=packet_length@entry=118, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.5_dbg/sql/sql_parse.cc:1874
#17 0x000055fda84e243a in do_command (thd=0x14d125c15088) at /test/10.5_dbg/sql/sql_parse.cc:1355
#18 0x000055fda863dc47 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x14d127d7a808, put_in_cache=put_in_cache@entry=true) at /test/10.5_dbg/sql/sql_connect.cc:1411
#19 0x000055fda863e363 in handle_one_connection (arg=arg@entry=0x14d127d7a808) at /test/10.5_dbg/sql/sql_connect.cc:1313
#20 0x000055fda8a9f902 in pfs_spawn_thread (arg=0x14d145046c88) at /test/10.5_dbg/storage/perfschema/pfs.cc:2201
#21 0x000014d14740c6db in start_thread (arg=0x14d1458b5700) at pthread_create.c:463
#22 0x000014d14680a88f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Bug confirmed present in:
MariaDB: 10.1.46 (dbg), 10.2.33 (dbg), 10.3.24 (dbg), 10.4.14 (dbg), 10.5.4 (dbg)

Bug confirmed not present in:
MariaDB: 10.1.46 (opt), 10.2.33 (opt), 10.3.24 (opt), 10.4.14 (opt), 10.5.4 (opt)
MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.47 (dbg), 5.6.47 (opt), 5.7.29 (dbg), 5.7.29 (opt), 8.0.19 (dbg), 8.0.19 (opt)

Attachments

Activity

Ascending order - Click to sort in descending order

View 9 older comments

Ramesh Sivaraman added a comment - 2024-08-05 11:46 - edited

Another test case that crashes differently on the 10.6 build, other versions show similar assertion to this issue.

CREATE TABLE t1(a int unsigned key) ENGINE=HEAP partition by key(a) ;

BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';

SET @@global.slave_exec_mode='IDEMPOTENT';

binlog 'bBf2ZBMBAAAANAAAAHUkAAAAAHEAAAAAAAEABHRlc3QAAnQxAAQDDw8IBP0C4h0AaTGFIg==bBf2ZBgBAAAASAAAAL0kAAAAAHEAAAAAAAEABP//8I+kAAABAGIBAGWuv1VNCQAAAPBuWwAAAQBiAQBlrr9VTQkAAADxS9Lu';

Leads to

10.6.19 ee5f7692d78061a938f7a9a3f2d84c0875b8795f (Debug)
mariadbd: /test/10.6_dbg/mysys/my_bitmap.c:542: bitmap_union: Assertion `(*(map)->last_word_ptr & (map)->last_bit_mask) == 0' failed.

10.6.19 ee5f7692d78061a938f7a9a3f2d84c0875b8795f (Debug)
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#1 0x000014831b927859 in __GI_abort () at abort.c:79
#2 0x000014831b927729 in __assert_fail_base (fmt=0x14831babd588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55781e4006d0 "(*(map)->last_word_ptr & (map)->last_bit_mask) == 0",
file=0x55781e4005f0 "/test/10.6_dbg/mysys/my_bitmap.c", line=542, function=<optimized out>) at assert.c:92
#3 0x000014831b938fd6 in __GI___assert_fail (assertion=assertion@entry=0x55781e4006d0 "(*(map)->last_word_ptr & (map)->last_bit_mask) == 0", file=file@entry=0x55781e4005f0 "/test/10.6_dbg/mysys/my_bitmap.c",
line=line@entry=542, function=function@entry=0x55781e400c10 <__PRETTY_FUNCTION__.19601> "bitmap_union") at assert.c:101
#4 0x000055781df0f8ba in bitmap_union (map=0x1482d40262b0, map2=0x1482d402af70) at /test/10.6_dbg/mysys/my_bitmap.c:542
#5 0x000055781da08b6e in ha_partition::index_init (this=0x1482d40298e0, inx=0, sorted=false) at /test/10.6_dbg/sql/ha_partition.cc:5767
#6 0x000055781d8a73f8 in handler::ha_index_init (sorted=false, idx=0, this=0x1482d40298e0) at /test/10.6_dbg/sql/handler.h:3487
#7 Rows_log_event::find_row (this=this@entry=0x1482d401f838, rgi=rgi@entry=0x1482d401eb20) at /test/10.6_dbg/sql/log_event_server.cc:8116
#8 0x000055781d8a80c7 in Update_rows_log_event::do_exec_row (this=0x1482d401f838, rgi=0x1482d401eb20) at /test/10.6_dbg/sql/log_event_server.cc:8556
#9 0x000055781d8981ca in Rows_log_event::do_apply_event (this=0x1482d401f838, rgi=0x1482d401eb20) at /test/10.6_dbg/sql/log_event_server.cc:5856
#10 0x000055781d56fbbf in Log_event::apply_event (rgi=0x1482d401eb20, this=0x1482d401f838) at /test/10.6_dbg/sql/log_event.h:1512
#11 mysql_client_binlog_statement (thd=thd@entry=0x1482d4000d48) at /test/10.6_dbg/sql/sql_binlog.cc:376
#12 0x000055781d443b3f in mysql_execute_command (thd=thd@entry=0x1482d4000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.6_dbg/sql/sql_parse.cc:6039
#13 0x000055781d42b40d in mysql_parse (thd=thd@entry=0x1482d4000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x148318cc6300) at /test/10.6_dbg/sql/sql_parse.cc:8165
#14 0x000055781d4397f8 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1482d4000d48,
packet=packet@entry=0x1482d400afc9 "binlog 'bBf2ZBMBAAAANAAAAHUkAAAAAHEAAAAAAAEABHRlc3QAAnQxAAQDDw8IBP0C4h0AaTGFIg==bBf2ZBgBAAAASAAAAL0kAAAAAHEAAAAAAAEABP//8I+kAAABAGIBAGWuv1VNCQAAAPBuWwAAAQBiAQBlrr9VTQkAAADxS9Lu'", packet_length=packet_length@entry=177, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_class.h:1418
#15 0x000055781d43c17e in do_command (thd=0x1482d4000d48, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_parse.cc:1410
#16 0x000055781d5967ff in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5578201e58a8, put_in_cache=put_in_cache@entry=true) at /test/10.6_dbg/sql/sql_connect.cc:1417
#17 0x000055781d596db4 in handle_one_connection (arg=arg@entry=0x5578201e58a8) at /test/10.6_dbg/sql/sql_connect.cc:1319
#18 0x000055781da15f4e in pfs_spawn_thread (arg=0x5578201d37b8) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201
#19 0x000014831be38609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#20 0x000014831ba24133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Ramesh Sivaraman added a comment - 2024-08-05 11:46 - edited Another test case that crashes differently on the 10.6 build, other versions show similar assertion to this issue. CREATE TABLE t1(a int unsigned key ) ENGINE=HEAP partition by key (a) ; BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=' ; SET @@ global .slave_exec_mode= 'IDEMPOTENT' ; binlog 'bBf2ZBMBAAAANAAAAHUkAAAAAHEAAAAAAAEABHRlc3QAAnQxAAQDDw8IBP0C4h0AaTGFIg==bBf2ZBgBAAAASAAAAL0kAAAAAHEAAAAAAAEABP//8I+kAAABAGIBAGWuv1VNCQAAAPBuWwAAAQBiAQBlrr9VTQkAAADxS9Lu' ; Leads to 10.6.19 ee5f7692d78061a938f7a9a3f2d84c0875b8795f (Debug) mariadbd: /test/10.6_dbg/mysys/my_bitmap.c:542: bitmap_union: Assertion `(*(map)->last_word_ptr & (map)->last_bit_mask) == 0' failed. 10.6.19 ee5f7692d78061a938f7a9a3f2d84c0875b8795f (Debug) #0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50 #1 0x000014831b927859 in __GI_abort () at abort.c:79 #2 0x000014831b927729 in __assert_fail_base (fmt=0x14831babd588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55781e4006d0 "(*(map)->last_word_ptr & (map)->last_bit_mask) == 0", file=0x55781e4005f0 "/test/10.6_dbg/mysys/my_bitmap.c", line=542, function=<optimized out>) at assert.c:92 #3 0x000014831b938fd6 in __GI___assert_fail (assertion=assertion@entry=0x55781e4006d0 "(*(map)->last_word_ptr & (map)->last_bit_mask) == 0", file=file@entry=0x55781e4005f0 "/test/10.6_dbg/mysys/my_bitmap.c", line=line@entry=542, function=function@entry=0x55781e400c10 <__PRETTY_FUNCTION__.19601> "bitmap_union") at assert.c:101 #4 0x000055781df0f8ba in bitmap_union (map=0x1482d40262b0, map2=0x1482d402af70) at /test/10.6_dbg/mysys/my_bitmap.c:542 #5 0x000055781da08b6e in ha_partition::index_init (this=0x1482d40298e0, inx=0, sorted=false) at /test/10.6_dbg/sql/ha_partition.cc:5767 #6 0x000055781d8a73f8 in handler::ha_index_init (sorted=false, idx=0, this=0x1482d40298e0) at /test/10.6_dbg/sql/handler.h:3487 #7 Rows_log_event::find_row (this=this@entry=0x1482d401f838, rgi=rgi@entry=0x1482d401eb20) at /test/10.6_dbg/sql/log_event_server.cc:8116 #8 0x000055781d8a80c7 in Update_rows_log_event::do_exec_row (this=0x1482d401f838, rgi=0x1482d401eb20) at /test/10.6_dbg/sql/log_event_server.cc:8556 #9 0x000055781d8981ca in Rows_log_event::do_apply_event (this=0x1482d401f838, rgi=0x1482d401eb20) at /test/10.6_dbg/sql/log_event_server.cc:5856 #10 0x000055781d56fbbf in Log_event::apply_event (rgi=0x1482d401eb20, this=0x1482d401f838) at /test/10.6_dbg/sql/log_event.h:1512 #11 mysql_client_binlog_statement (thd=thd@entry=0x1482d4000d48) at /test/10.6_dbg/sql/sql_binlog.cc:376 #12 0x000055781d443b3f in mysql_execute_command (thd=thd@entry=0x1482d4000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.6_dbg/sql/sql_parse.cc:6039 #13 0x000055781d42b40d in mysql_parse (thd=thd@entry=0x1482d4000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x148318cc6300) at /test/10.6_dbg/sql/sql_parse.cc:8165 #14 0x000055781d4397f8 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x1482d4000d48, packet=packet@entry=0x1482d400afc9 "binlog 'bBf2ZBMBAAAANAAAAHUkAAAAAHEAAAAAAAEABHRlc3QAAnQxAAQDDw8IBP0C4h0AaTGFIg==bBf2ZBgBAAAASAAAAL0kAAAAAHEAAAAAAAEABP//8I+kAAABAGIBAGWuv1VNCQAAAPBuWwAAAQBiAQBlrr9VTQkAAADxS9Lu'", packet_length=packet_length@entry=177, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_class.h:1418 #15 0x000055781d43c17e in do_command (thd=0x1482d4000d48, blocking=blocking@entry=true) at /test/10.6_dbg/sql/sql_parse.cc:1410 #16 0x000055781d5967ff in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5578201e58a8, put_in_cache=put_in_cache@entry=true) at /test/10.6_dbg/sql/sql_connect.cc:1417 #17 0x000055781d596db4 in handle_one_connection (arg=arg@entry=0x5578201e58a8) at /test/10.6_dbg/sql/sql_connect.cc:1319 #18 0x000055781da15f4e in pfs_spawn_thread (arg=0x5578201d37b8) at /test/10.6_dbg/storage/perfschema/pfs.cc:2201 #19 0x000014831be38609 in start_thread (arg=<optimized out>) at pthread_create.c:477 #20 0x000014831ba24133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Roel Van de Paar added a comment - 2024-08-12 22:15

INSTALL PLUGIN spider SONAME 'ha_spider.so';

CREATE TABLE t1(pk int,cink INT,cik INT,KEY cik (cik)) ENGINE=Spider;

SET @@max_statement_time=1;

BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';

SELECT * FROM t1;

BINLOG 'wlZOTxMBAAAAKgAAADwCAAAAACkAAAAAAAEABHRlc3QAAnQxAAIDAwAC wlZOTxcBAAAAJgAAAGICAAAAACkAAAAAAAEAAv/8AgAAAAgAAAA=';

Gives the customary ERROR 12701 (HY000): Remote MariaDB server has gone away in the CLI and in the error log we see

11.2.5 03807c8449cdccbf5b8afc0dddabb1d8ec7ba85a (Debug)

2024-08-13  8:00:27 4 [ERROR]  BINLOG_BASE64_EVENT: Could not execute Write_rows_v1 event on table test.t1; Remote MariaDB server has gone away, Error_code: 12701; the event's master log FIRST, end_log_pos 610, Internal MariaDB error code: 12701

Roel Van de Paar added a comment - 2024-08-12 22:15 INSTALL PLUGIN spider SONAME 'ha_spider.so' ; CREATE TABLE t1(pk int ,cink INT ,cik INT , KEY cik (cik)) ENGINE=Spider; SET @@max_statement_time=1; BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=' ; SELECT * FROM t1; BINLOG 'wlZOTxMBAAAAKgAAADwCAAAAACkAAAAAAAEABHRlc3QAAnQxAAIDAwAC wlZOTxcBAAAAJgAAAGICAAAAACkAAAAAAAEAAv/8AgAAAAgAAAA=' ; Gives the customary ERROR 12701 (HY000): Remote MariaDB server has gone away in the CLI and in the error log we see 11.2.5 03807c8449cdccbf5b8afc0dddabb1d8ec7ba85a (Debug) 2024-08-13 8:00:27 4 [ERROR] BINLOG_BASE64_EVENT: Could not execute Write_rows_v1 event on table test.t1; Remote MariaDB server has gone away, Error_code: 12701; the event's master log FIRST, end_log_pos 610, Internal MariaDB error code: 12701

Roel Van de Paar added a comment - 2024-09-07 03:53 - edited

Also,

INSTALL PLUGIN spider SONAME 'ha_spider.so';

SET MAX_STATEMENT_TIME=1;

BINLOG ' SOgWTg8CAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';

CREATE TABLE t1(a int)ENGINE=Spider;

ANALYZE TABLE t1;

BINLOG 'wlZOTxMBAAAAKgAAADwCAAAAACkAAAAAAAEABHRlc3QAAnQxAAIDAwAC wlZOTxcBAAAAJgAAAGICAAAAACkAAAAAAAEAAv/8AgAAAAgAAAA=';

2024-09-07 13:51:09 4 [ERROR]  BINLOG_BASE64_EVENT: Could not execute Write_rows_v1 event on table test.t1; Remote MariaDB server has gone away, Error_code: 12701; handler error No Error!; the event's master log FIRST, end_log_pos 610, Internal MariaDB error code: 12701

And

INSTALL PLUGIN spider SONAME 'ha_spider.so';

create TABLE t1(a int)engine=Spider;

insert INTO t1 values(1);

SET @@max_statement_time=1;

BINLOG ' O1ZVRw8BAAAAZgAAAGoAAAAAAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAA7VlVHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC ';

BINLOG 'wlZOTxMBAAAAKgAAADwCAAAAACkAAAAAAAEABHRlc3QAAnQxAAIDAwAC wlZOTxcBAAAAJgAAAGICAAAAACkAAAAAAAEAAv/8AgAAAAgAAAA=';

2024-09-07 14:05:52 4 [ERROR]  BINLOG_BASE64_EVENT: Could not execute Write_rows_v1 event on table test.t1; Remote MariaDB server has gone away, Error_code: 12701; the event's master log FIRST, end_log_pos 610, Internal MariaDB error code: 12701

Roel Van de Paar added a comment - 2024-09-07 03:53 - edited Also, INSTALL PLUGIN spider SONAME 'ha_spider.so' ; SET MAX_STATEMENT_TIME=1; BINLOG ' SOgWTg8CAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=' ; CREATE TABLE t1(a int )ENGINE=Spider; ANALYZE TABLE t1; BINLOG 'wlZOTxMBAAAAKgAAADwCAAAAACkAAAAAAAEABHRlc3QAAnQxAAIDAwAC wlZOTxcBAAAAJgAAAGICAAAAACkAAAAAAAEAAv/8AgAAAAgAAAA=' ; 2024-09-07 13:51:09 4 [ERROR] BINLOG_BASE64_EVENT: Could not execute Write_rows_v1 event on table test.t1; Remote MariaDB server has gone away, Error_code: 12701; handler error No Error!; the event's master log FIRST, end_log_pos 610, Internal MariaDB error code: 12701 And INSTALL PLUGIN spider SONAME 'ha_spider.so' ; create TABLE t1(a int )engine=Spider; insert INTO t1 values (1); SET @@max_statement_time=1; BINLOG ' O1ZVRw8BAAAAZgAAAGoAAAAAAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAA7VlVHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC ' ; BINLOG 'wlZOTxMBAAAAKgAAADwCAAAAACkAAAAAAAEABHRlc3QAAnQxAAIDAwAC wlZOTxcBAAAAJgAAAGICAAAAACkAAAAAAAEAAv/8AgAAAAgAAAA=' ; 2024-09-07 14:05:52 4 [ERROR] BINLOG_BASE64_EVENT: Could not execute Write_rows_v1 event on table test.t1; Remote MariaDB server has gone away, Error_code: 12701; the event's master log FIRST, end_log_pos 610, Internal MariaDB error code: 12701

Roel Van de Paar added a comment - 2025-03-29 04:32

Another crash, present in 10.11+ but not 10.5/10.6. Only present in release/optimized builds.

CREATE TABLE t1 (c INT KEY,id2 INT,id3 INT NOT NULL,KEY(id2),KEY(id3),KEY covering_index (id2,id3));

DELETE FROM t1;

BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=';

SET max_session_mem_used=1;

BINLOG 'wlZOTxMBAAAAKgAAADwCAAAAACkAAAAAAAEABHRlc3QAAnQxAAIDAwAC wlZOTxcBAAAAJgAAAGICAAAAACkAAAAAAAEAAv/8AgAAAAgAAAA=';

Leads to:

CS 10.11.12 43c5d1303f5c7c726db276815c459436110f342f (Optimized) Build 15/02/2025
Core was generated by `/test/MD150225-mariadb-10.11.12-linux-x86_64-opt/bin/mariadbd --no-defaults --m'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0 __strnlen_evex () at ../sysdeps/x86_64/multiarch/strnlen-evex.S:93

[Current thread is 1 (LWP 1128572)]
(gdb) bt
#0 __strnlen_evex () at ../sysdeps/x86_64/multiarch/strnlen-evex.S:93
#1 0x00005dd58e17d281 in process_str_arg (cs=cs@entry=0x5dd58ec6c1f0 <my_charset_utf8mb3_general_ci>, to=0x7277701ccab7 "", end=end@entry=0x7277701ccc8f "", length_arg=0, width=width@entry=65535, par=0x1fad <error: Cannot access memory at address 0x1fad>, print_type=0, nice_cut=0 '\000') at /test/10.11_opt/strings/my_vsnprintf.c:277
#2 0x00005dd58e17c4c3 in my_vsnprintf_ex (cs=0x5dd58ec6c1f0 <my_charset_utf8mb3_general_ci>, to=0xfad <error: Cannot access memory at address 0xfad>, to@entry=0x7277701cca90 "The MariaDB server is running with the ", n=n@entry=512, fmt=0x5dd58e349bd7 "s option so it cannot execute this statement", ap=ap@entry=0x7277701cca70) at /test/10.11_opt/strings/my_vsnprintf.c:729
#3 0x00005dd58e113c99 in my_error (nr=1290, MyFlags=0)at /test/10.11_opt/mysys/my_error.c:120
#4 0x00005dd58dd73407 in Rows_log_event::do_apply_event (this=0x7259d8054118, rgi=0x7259d80573c0) at /test/10.11_opt/sql/log_event_server.cc:6273
#5 0x00005dd58dd64124 in Log_event::apply_event (this=0x7259d8054118, rgi=0x7259d80573c0) at /test/10.11_opt/sql/log_event.cc:4255
#6 0x00005dd58dafe4e7 in mysql_client_binlog_statement (thd=thd@entry=0x7259d8000c68) at /test/10.11_opt/sql/sql_binlog.cc:428
#7 0x00005dd58d9fde33 in mysql_execute_command (thd=thd@entry=0x7259d8000c68, is_called_from_prepared_stmt=false)at /test/10.11_opt/sql/sql_parse.cc:6081
#8 0x00005dd58d9f7531 in mysql_parse (thd=thd@entry=0x7259d8000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7277701cd480)at /test/10.11_opt/sql/sql_parse.cc:8188
#9 0x00005dd58d9f59ec in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7259d8000c68, packet=packet@entry=0x7259d8008759 "BINLOG 'wlZOTxMBAAAAKgAAADwCAAAAACkAAAAAAAEABHRlc3QAAnQxAAIDAwAC wlZOTxcBAAAAJgAAAGICAAAAACkAAAAAAAEAAv/8AgAAAAgAAAA='", packet_length=packet_length@entry=118, blocking=true)at /test/10.11_opt/sql/sql_parse.cc:1905
#10 0x00005dd58d9f7941 in do_command (thd=thd@entry=0x7259d8000c68, blocking=true) at /test/10.11_opt/sql/sql_parse.cc:1418
#11 0x00005dd58db1b9cd in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5dd590652e38, put_in_cache=true)at /test/10.11_opt/sql/sql_connect.cc:1386
#12 0x00005dd58db1b793 in handle_one_connection (arg=arg@entry=0x5dd590652e38)at /test/10.11_opt/sql/sql_connect.cc:1298
#13 0x00005dd58de7433e in pfs_spawn_thread (arg=0x5dd5905f27c8)at /test/10.11_opt/storage/perfschema/pfs.cc:2201
#14 0x0000727770c9ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
#15 0x0000727770d29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

Roel Van de Paar added a comment - 2025-03-29 04:32 Another crash, present in 10.11+ but not 10.5/10.6. Only present in release/optimized builds. CREATE TABLE t1 (c INT KEY ,id2 INT ,id3 INT NOT NULL , KEY (id2), KEY (id3), KEY covering_index (id2,id3)); DELETE FROM t1; BINLOG ' SOgWTg8BAAAAbgAAAHIAAAAAAAQANS42LjMtbTUtZGVidWctbG9nAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAABI6BZOEzgNAAgAEgAEBAQEEgAAVgAEGggAAAAICAgCAAAAAAVAYI8=' ; SET max_session_mem_used=1; BINLOG 'wlZOTxMBAAAAKgAAADwCAAAAACkAAAAAAAEABHRlc3QAAnQxAAIDAwAC wlZOTxcBAAAAJgAAAGICAAAAACkAAAAAAAEAAv/8AgAAAAgAAAA=' ; Leads to: CS 10.11.12 43c5d1303f5c7c726db276815c459436110f342f (Optimized) Build 15/02/2025 Core was generated by `/test/MD150225-mariadb-10.11.12-linux-x86_64-opt/bin/mariadbd --no-defaults --m'. Program terminated with signal SIGSEGV, Segmentation fault. #0 __strnlen_evex () at ../sysdeps/x86_64/multiarch/strnlen-evex.S:93 [Current thread is 1 (LWP 1128572)] (gdb) bt #0 __strnlen_evex () at ../sysdeps/x86_64/multiarch/strnlen-evex.S:93 #1 0x00005dd58e17d281 in process_str_arg (cs=cs@entry=0x5dd58ec6c1f0 <my_charset_utf8mb3_general_ci>, to=0x7277701ccab7 "", end=end@entry=0x7277701ccc8f "", length_arg=0, width=width@entry=65535, par=0x1fad <error: Cannot access memory at address 0x1fad>, print_type=0, nice_cut=0 '\000') at /test/10.11_opt/strings/my_vsnprintf.c:277 #2 0x00005dd58e17c4c3 in my_vsnprintf_ex (cs=0x5dd58ec6c1f0 <my_charset_utf8mb3_general_ci>, to=0xfad <error: Cannot access memory at address 0xfad>, to@entry=0x7277701cca90 "The MariaDB server is running with the ", n=n@entry=512, fmt=0x5dd58e349bd7 "s option so it cannot execute this statement", ap=ap@entry=0x7277701cca70) at /test/10.11_opt/strings/my_vsnprintf.c:729 #3 0x00005dd58e113c99 in my_error (nr=1290, MyFlags=0)at /test/10.11_opt/mysys/my_error.c:120 #4 0x00005dd58dd73407 in Rows_log_event::do_apply_event (this=0x7259d8054118, rgi=0x7259d80573c0) at /test/10.11_opt/sql/log_event_server.cc:6273 #5 0x00005dd58dd64124 in Log_event::apply_event (this=0x7259d8054118, rgi=0x7259d80573c0) at /test/10.11_opt/sql/log_event.cc:4255 #6 0x00005dd58dafe4e7 in mysql_client_binlog_statement (thd=thd@entry=0x7259d8000c68) at /test/10.11_opt/sql/sql_binlog.cc:428 #7 0x00005dd58d9fde33 in mysql_execute_command (thd=thd@entry=0x7259d8000c68, is_called_from_prepared_stmt=false)at /test/10.11_opt/sql/sql_parse.cc:6081 #8 0x00005dd58d9f7531 in mysql_parse (thd=thd@entry=0x7259d8000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7277701cd480)at /test/10.11_opt/sql/sql_parse.cc:8188 #9 0x00005dd58d9f59ec in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7259d8000c68, packet=packet@entry=0x7259d8008759 "BINLOG 'wlZOTxMBAAAAKgAAADwCAAAAACkAAAAAAAEABHRlc3QAAnQxAAIDAwAC wlZOTxcBAAAAJgAAAGICAAAAACkAAAAAAAEAAv/8AgAAAAgAAAA='", packet_length=packet_length@entry=118, blocking=true)at /test/10.11_opt/sql/sql_parse.cc:1905 #10 0x00005dd58d9f7941 in do_command (thd=thd@entry=0x7259d8000c68, blocking=true) at /test/10.11_opt/sql/sql_parse.cc:1418 #11 0x00005dd58db1b9cd in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5dd590652e38, put_in_cache=true)at /test/10.11_opt/sql/sql_connect.cc:1386 #12 0x00005dd58db1b793 in handle_one_connection (arg=arg@entry=0x5dd590652e38)at /test/10.11_opt/sql/sql_connect.cc:1298 #13 0x00005dd58de7433e in pfs_spawn_thread (arg=0x5dd5905f27c8)at /test/10.11_opt/storage/perfschema/pfs.cc:2201 #14 0x0000727770c9ca94 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447 #15 0x0000727770d29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

Roel Van de Paar added a comment - 2025-04-16 14:28

Same, but for RocksDB

INSTALL SONAME 'ha_rocksdb';

BINLOG ' mSKWVg8BAAAAdwAAAHsAAAAAAAQANS44LjAtbTE3LWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAACZIpZWEzgNAAgAEgAEBAQEEgAAXwAEGggAAAAICAgCAAAACgoKKioAEjQA AYzz6oU=';

CREATE TABLE t1 (i1 INT,c INT,PRIMARY KEY(i1)) ENGINE=RocksDB;

BINLOG 'wlZOTxMBAAAAKgAAADwCAAAAACkAAAAAAAEABHRlc3QAAnQxAAIDAwAC wlZOTxcBAAAAJgAAAGICAAAAACkAAAAAAAEAAv/8AgAAAAgAAAA=';

Leads to:

CS 10.11.12 43c5d1303f5c7c726db276815c459436110f342f (Optimized, UBASAN, Clang) Build 15/02/2025

2025-04-17  0:27:06 4 [ERROR]  BINLOG_BASE64_EVENT: Could not read field 'c' of table 'test.t1', Internal MariaDB error code: 1610

2025-04-17  0:27:06 4 [ERROR]  BINLOG_BASE64_EVENT: Could not execute Write_rows_v1 event on table test.t1; Got error 171 "The event was corrupt, leading to illegal data being read" from storage engine ROCKSDB, Error_code: 1030; handler error HA_ERR_CORRUPT_EVENT; the event's master log FIRST, end_log_pos 610, Internal MariaDB error code: 1030

Roel Van de Paar added a comment - 2025-04-16 14:28 Same, but for RocksDB INSTALL SONAME 'ha_rocksdb' ; BINLOG ' mSKWVg8BAAAAdwAAAHsAAAAAAAQANS44LjAtbTE3LWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAACZIpZWEzgNAAgAEgAEBAQEEgAAXwAEGggAAAAICAgCAAAACgoKKioAEjQA AYzz6oU=' ; CREATE TABLE t1 (i1 INT ,c INT , PRIMARY KEY (i1)) ENGINE=RocksDB; BINLOG 'wlZOTxMBAAAAKgAAADwCAAAAACkAAAAAAAEABHRlc3QAAnQxAAIDAwAC wlZOTxcBAAAAJgAAAGICAAAAACkAAAAAAAEAAv/8AgAAAAgAAAA=' ; Leads to: CS 10.11.12 43c5d1303f5c7c726db276815c459436110f342f (Optimized, UBASAN, Clang) Build 15/02/2025 2025-04-17 0:27:06 4 [ERROR] BINLOG_BASE64_EVENT: Could not read field 'c' of table 'test.t1', Internal MariaDB error code: 1610 2025-04-17 0:27:06 4 [ERROR] BINLOG_BASE64_EVENT: Could not execute Write_rows_v1 event on table test.t1; Got error 171 "The event was corrupt, leading to illegal data being read" from storage engine ROCKSDB, Error_code: 1030; handler error HA_ERR_CORRUPT_EVENT; the event's master log FIRST, end_log_pos 610, Internal MariaDB error code: 1030

People

Assignee:: Andrei Elkin

Reporter:: Roel Van de Paar

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2020-06-18 23:58

Updated:: 2025-04-16 14:35

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Activity

People

Dates

Git Integration