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

rpl.rpl_row_index_choice fails with higher binlog-row-event-max-size

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.1.20, 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
    • 10.5, 10.6
    • Replication, Tests
    • None

    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
      

      Attachments

        Issue Links

          Activity

            alice Alice Sherepa added a comment -

             ./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
            

            alice Alice Sherepa added a comment - ./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

            People

              Elkin Andrei Elkin
              nirbhay_c Nirbhay Choubey (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.