Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. 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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.0.6
    • Component/s: None
    • Labels:
      None

      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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              knielsen Kristian Nielsen
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: