[MDEV-5195] Slave crashes in rpt_handle_event on executing check_warnings and FLUSH LOGS Created: 2013-10-26  Updated: 2013-10-29  Resolved: 2013-10-29

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

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    

--source include/master-slave.inc
 
CREATE TABLE t1 (i INT);
 
FLUSH LOGS;

Executing this MTR test with slave-parallel-threads>0 several times (e.g. with repeat=10) causes a crash:

#2  0x00000000007f2e70 in handle_fatal_signal (sig=11) at /home/elenst/bzr/10.0-knielsen/sql/signal_handler.cc:262
 
#3  <signal handler called>
 
#4  0x0000000000786b54 in rpt_handle_event (qev=0x7fc83c016940, rpt=0x3a58c58) at /home/elenst/bzr/10.0-knielsen/sql/rpl_parallel.cc:44
 
#5  0x000000000078721b in handle_rpl_parallel_thread (arg=0x3a58c58) at /home/elenst/bzr/10.0-knielsen/sql/rpl_parallel.cc:216
 
#6  0x000000000099204e in pfs_spawn_thread (arg=0x3a58e00) at /home/elenst/bzr/10.0-knielsen/storage/perfschema/pfs.cc:1015
 
#7  0x00007fc889deee9a in start_thread (arg=0x7fc8720c7700) at pthread_create.c:308
 
#8  0x00007fc8890e2cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 

revision-id: knielsen@knielsen-hq.org-20131025191714-lclqx9vuu5jrh24z
 
revno: 3687
 
branch-nick: 10.0-knielsen
 
BUILD/compile-pentium-debug-max-no-ndb



 Comments   
Comment by Kristian Nielsen [ 2013-10-28 ]

I am able to repeat this

Comment by Kristian Nielsen [ 2013-10-29 ]

In parallel replication, when the IO thread switches relay log,
the SQL thread re-opens the current relaylog and seeks to the
current position. There was a race that would cause it to
sometimes seek to the wrong position, causing corruption and
crash.

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