Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5660

Assertion `0' fails with different table on master and slave (MySQL:53386)

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 5.1.67, 5.2.14, 5.3.12, 5.5.35, 10.0.8
        • Fix Version/s: 10.0, 5.5
        • Component/s: None
        • Labels:
          None

          Description

          There was MySQL bug http://bugs.mysql.com/bug.php?id=53386 which was fixed long time ago in the tree that later became 5.6.

          
-- source include/have_binlog_format_row.inc
-- source include/master-slave.inc

--connection master

SET SQL_LOG_BIN=0;
CREATE TABLE t1 (a INT, b CHAR(255) CHARACTER SET UTF8) ENGINE=MyISAM;
SET SQL_LOG_BIN=1;

-- connection slave
CREATE TABLE t1 (c INT) ENGINE=MyISAM;

--connection master
INSERT INTO t1 VALUES (1, 'x');

-- sync_slave_with_master

          140212 13:58:24 [ERROR] Slave SQL: Could not read field 'c' of table 'test.t1', Error_code: 1610
mysqld: 5.5/sql/log_event.cc:10124: virtual int Write_rows_log_event::do_exec_row(const Relay_log_info*): Assertion `0' failed.
140212 13:58:24 [ERROR] mysqld got signal 6 ;

          #6  0x00007fc0d2a7c621 in *__GI___assert_fail (assertion=0xe35ef0 "0", file=<optimized out>, line=10124, function=0xe3ab80 "virtual int Write_rows_log_event::do_exec_row(const Relay_log_info*)") at assert.c:81
#7  0x00000000008d0816 in Write_rows_log_event::do_exec_row (this=0x7fc0d205f6a0, rli=0x7fc0cd3e6850) at 5.5/sql/log_event.cc:10124
#8  0x00000000008ccccb in Rows_log_event::do_apply_event (this=0x7fc0d205f6a0, rli=0x7fc0cd3e6850) at 5.5/sql/log_event.cc:8528
#9  0x00000000005ada2c in Log_event::apply_event (this=0x7fc0d205f6a0, rli=0x7fc0cd3e6850) at 5.5/sql/log_event.h:1256
#10 0x00000000005a57ae in apply_event_and_update_pos (ev=0x7fc0d205f6a0, thd=0x7fc0cd2b5060, rli=0x7fc0cd3e6850) at 5.5/sql/slave.cc:2637
#11 0x00000000005a5d43 in exec_relay_log_event (thd=0x7fc0cd2b5060, rli=0x7fc0cd3e6850) at 5.5/sql/slave.cc:2797
#12 0x00000000005a8191 in handle_slave_sql (arg=0x7fc0cd3e5060) at 5.5/sql/slave.cc:3654
#13 0x0000000000985a9d in pfs_spawn_thread (arg=0x7fc0c3133440) at 5.5/storage/perfschema/pfs.cc:1015
#14 0x00007fc0d3fdcb50 in start_thread (arg=<optimized out>) at pthread_create.c:304
#15 0x00007fc0d2b2ba7d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

            Gliffy Diagrams

              Attachments

                Issue Links

                links to

                Web Link Bug #53386 - HA_ERR_CORRUPT_EVENT or debug assertion with different table on slave

                  Activity

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated: