[MDEV-5207] Assertion `pos_in_file == info->end_of_file' fails on restart of a slave with parallel threads after master switches on binlog_checksum Created: 2013-10-30  Updated: 2013-11-07  Resolved: 2013-11-07

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: 10.0.6

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Kristian Nielsen
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-4506 MWL#184: Parallel replication of grou... Closed

 Description   

mysqld: /home/elenst/bzr/10.0-knielsen/mysys/mf_iocache.c:1287: _my_b_seq_read: Assertion `pos_in_file == info->end_of_file' failed.
131030 16:24:57 [ERROR] mysqld got signal 6 ;

#5  0x00007f1e45358b8b in __GI_abort () at abort.c:91
#6  0x00007f1e4534e0ee in __assert_fail_base (fmt=<optimized out>, assertion=0xeb26b0 "pos_in_file == info->end_of_file", file=0xeb2150 "/home/elenst/bzr/10.0-knielsen/mysys/mf_iocache.c", line=<optimized out>, function=<optimized out>) at assert.c:94
#7  0x00007f1e4534e192 in __GI___assert_fail (assertion=0xeb26b0 "pos_in_file == info->end_of_file", file=0xeb2150 "/home/elenst/bzr/10.0-knielsen/mysys/mf_iocache.c", line=1287, function=0xeb281f "_my_b_seq_read") at assert.c:103
#8  0x0000000000ccc8b7 in _my_b_seq_read (info=0x33ab628, Buffer=0x7f1e3c27d740 "p\327'<\036\177", Count=19) at /home/elenst/bzr/10.0-knielsen/mysys/mf_iocache.c:1287
#9  0x00000000008d4743 in Log_event::read_log_event (file=0x33ab628, log_lock=0x0, description_event=0x7f1dfc026f80, crc_check=1 '\001') at /home/elenst/bzr/10.0-knielsen/sql/log_event.cc:1422
#10 0x0000000000595a3b in next_event (rgi=0x7f1dfc025f90, event_size=0x7f1e3c27d8a8) at /home/elenst/bzr/10.0-knielsen/sql/slave.cc:5946
#11 0x000000000058e435 in exec_relay_log_event (thd=0x7f1dfc02ba40, rli=0x33aadb8, serial_rgi=0x7f1dfc025f90) at /home/elenst/bzr/10.0-knielsen/sql/slave.cc:3286
#12 0x0000000000591852 in handle_slave_sql (arg=0x33a9570) at /home/elenst/bzr/10.0-knielsen/sql/slave.cc:4419
#13 0x00000000009921f6 in pfs_spawn_thread (arg=0x7f1df4013cd0) at /home/elenst/bzr/10.0-knielsen/storage/perfschema/pfs.cc:1015
#14 0x00007f1e4611ee9a in start_thread (arg=0x7f1e3c27e700) at pthread_create.c:308
#15 0x00007f1e45412cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

# Run the test case with slave_parallel_threads > 0 and with --repeat, e.g.
# perl ./mtr --mysqld=--slave-parallel-threads=1 --repeat=10 main.t1
 
--source include/master-slave.inc
 
set @save_binlog_checksum = @@global.binlog_checksum;
 
create table t1 (i int);
insert into t1 values (1),(2);
insert into t1 values (3),(4);
insert into t1 values (5),(6);
insert into t1 values (7),(8);
insert into t1 values (9),(10);
 
set @@global.binlog_checksum = CRC32;
 
connection slave;
source include/stop_slave.inc;
source include/start_slave.inc;
 
connection master;
set @@global.binlog_checksum = @save_binlog_checksum;
drop table t1;
 
sync_slave_with_master;
 
--source include/rpl_end.inc

revision-id: knielsen@knielsen-hq.org-20131030065230-kp8dykgyeth6ma55
revno: 3690
branch-nick: 10.0-knielsen
BUILD/compile-pentium-debug-max-no-ndb



 Comments   
Comment by Kristian Nielsen [ 2013-11-07 ]

No longer repeatable at revid:elenst@gmail.com-20131107003152-oc8uagy0axcwr6u1

I believe this is fixed by one or more of the patches for MDEV-5217.

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