[MDEV-11666] rpl.rpl_row_index_choice fails with higher binlog-row-event-max-size Created: 2016-12-24  Updated: 2023-04-27

Status: Confirmed
Project: MariaDB Server
Component/s: Replication, Tests
Affects Version/s: 5.5, 10.0, 10.1, 10.1.20, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Major
Reporter: Nirbhay Choubey (Inactive) Assignee: Andrei Elkin
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-18745 DDL Algorithm <> Copy could break row... Confirmed
relates to MDEV-7635 update defaults and simplify mysqld c... Closed

 Description   

Logging: mtr  rpl.rpl_row_index_choice --mysqld=--binlog-row-event-max-size=8K
...
rpl.rpl_row_index_choice 'innodb_plugin,row' [ fail ]
        Test ended at 2016-12-24 10:48:07
 
CURRENT_TEST: rpl.rpl_row_index_choice
mysqltest: At line 134: failed in 'select master_pos_wait('master-bin.000001', 82051, 300, '')': 2013: Lost connection to MySQL server during query
 
The result from queries just before the failure was:
< snip >
KEY wrong_key6(c)) ENGINE=myisam;
INSERT INTO t2 SELECT d DIV 10, d MOD 41, d MOD 37, d FROM t1;
# Slave will crash if using the wrong or no index
SET GLOBAL debug_dbug="+d,slave_crash_if_wrong_index,slave_crash_if_table_scan";
UPDATE t2 SET d=10042 WHERE d=42;
DELETE FROM t2 WHERE d=53;
SET GLOBAL debug_dbug="";
SELECT * FROM t2 WHERE d IN (10042,53);
a	b	c	d
4	1	5	10042
DROP TABLE t2;
CREATE TABLE t2 (a INT NOT NULL, b INT NOT NULL, c INT NOT NULL, d INT NOT NULL,
KEY expected_key(b),
KEY wrong_key7(d),
KEY wrong_key8(c)) ENGINE=myisam;
INSERT INTO t2 SELECT d DIV 10, d MOD 41, d MOD 37, d FROM t1;
# Slave will crash if using the wrong or no index
SET GLOBAL debug_dbug="+d,slave_crash_if_wrong_index,slave_crash_if_table_scan";
UPDATE t2 SET d=10042 WHERE d=42;
DELETE FROM t2 WHERE d=53;
 
 
2016-12-24 10:48:04 139819621255936 [Note] Slave SQL thread initialized, starting replication in log 'master-bin.000001' at position 4, relay log './slave-relay-bin.000001' position: 4
161224 10:48:05 [ERROR] mysqld got signal 6 ;
 
Thread 1 (Thread 0x7f2a4adb8b00 (LWP 3341)):
#0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
#1  0x000055844b41eacd in my_write_core (sig=6) at /home/nirbhay/project/git-repo/mariadb/10.1/mysys/stacktrace.c:477
#2  0x000055844adb7f67 in handle_fatal_signal (sig=6) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/signal_handler.cc:296
#3  <signal handler called>
#4  0x00007f2a4b005428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
#5  0x00007f2a4b00702a in __GI_abort () at abort.c:89
#6  0x000055844aec3d8f in Rows_log_event::find_row (this=0x7f2a384943f0, rgi=0x7f2a425f0000) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/log_event.cc:12110
#7  0x000055844aec4d9b in Update_rows_log_event::do_exec_row (this=0x7f2a384943f0, rgi=0x7f2a425f0000) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/log_event.cc:12545
#8  0x000055844aebf152 in Rows_log_event::do_apply_event (this=0x7f2a384943f0, rgi=0x7f2a425f0000) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/log_event.cc:10063
#9  0x000055844aae92e3 in Log_event::apply_event (this=0x7f2a384943f0, rgi=0x7f2a425f0000) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/log_event.h:1343
#10 0x000055844aaded93 in apply_event_and_update_pos_apply (ev=0x7f2a384943f0, thd=0x7f2a384e4070, rgi=0x7f2a425f0000, reason=0) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/slave.cc:3469
#11 0x000055844aadf230 in apply_event_and_update_pos (ev=0x7f2a384943f0, thd=0x7f2a384e4070, rgi=0x7f2a425f0000) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/slave.cc:3590
#12 0x000055844aadfa16 in exec_relay_log_event (thd=0x7f2a384e4070, rli=0x7f2a3eeedc20, serial_rgi=0x7f2a425f0000) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/slave.cc:3872
#13 0x000055844aae2bff in handle_slave_sql (arg=0x7f2a3eeec000) at /home/nirbhay/project/git-repo/mariadb/10.1/sql/slave.cc:4958
#14 0x000055844af95738 in pfs_spawn_thread (arg=0x7f2a3ee878f0) at /home/nirbhay/project/git-repo/mariadb/10.1/storage/perfschema/pfs.cc:1860
#15 0x00007f2a4ba2b70a in start_thread (arg=0x7f2a4adb8b00) at pthread_create.c:333
#16 0x00007f2a4b0d682d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109



 Comments   
Comment by Alice Sherepa [ 2019-12-20 ]

 ./mtr rpl_row_index_choice.test

10.4 088de81d965f1b5ae2f50

#3  <signal handler called>
#4  0x00007f26fa536428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
#5  0x00007f26fa53802a in __GI_abort () at abort.c:89
#6  0x000055ccc718d1e1 in Rows_log_event::find_row (this=0x7f269004bdd8, rgi=0x7f2690000a80) at /10.4/sql/log_event.cc:14114
#7  0x000055ccc718e653 in Update_rows_log_event::do_exec_row (this=0x7f269004bdd8, rgi=0x7f2690000a80) at /10.4/sql/log_event.cc:14623
#8  0x000055ccc71872a3 in Rows_log_event::do_apply_event (this=0x7f269004bdd8, rgi=0x7f2690000a80) at /10.4/sql/log_event.cc:11606
#9  0x000055ccc6badad5 in Log_event::apply_event (this=0x7f269004bdd8, rgi=0x7f2690000a80) at /10.4/sql/log_event.h:1482
#10 0x000055ccc6ba03d4 in apply_event_and_update_pos_apply (ev=0x7f269004bdd8, thd=0x7f2690001478, rgi=0x7f2690000a80, reason=0) at /10.4/sql/slave.cc:3956
#11 0x000055ccc6ba0a78 in apply_event_and_update_pos (ev=0x7f269004bdd8, thd=0x7f2690001478, rgi=0x7f2690000a80) at /10.4/sql/slave.cc:4110
#12 0x000055ccc6ba15c2 in exec_relay_log_event (thd=0x7f2690001478, rli=0x55ccca799cc8, serial_rgi=0x7f2690000a80) at /10.4/sql/slave.cc:4431
#13 0x000055ccc6ba4fc6 in handle_slave_sql (arg=0x55ccca798000) at /10.4/sql/slave.cc:5599
#14 0x000055ccc7890729 in pfs_spawn_thread (arg=0x7f26a4085018) at /10.4/storage/perfschema/pfs.cc:1862
#15 0x00007f26fba256ba in start_thread (arg=0x7f26ee969700) at pthread_create.c:333
#16 0x00007f26fa60841d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Generated at Thu Feb 08 07:51:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.