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

Assertion `thd->transaction.stmt.is_empty() || thd->in_sub_stmt || (thd->state_flags & Open_tables_state::BACKUPS_AVAIL)' failed in close_thread_tables on slave

    XMLWordPrintable

Details

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

    Description

      perl ./mtr --view-protocol rpl.rpl_parallel_no_log_slave_updates
      

      10.0 4886d14827c

      181209 19:00:32 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master-bin.000001' position 880; GTID position '0-1-3'
      mysqld: /data/src/10.0/sql/sql_base.cc:893: void close_thread_tables(THD*): Assertion `thd->transaction.stmt.is_empty() || thd->in_sub_stmt || (thd->state_flags & Open_tables_state::BACKUPS_AVAIL)' failed.
      181209 19:00:32 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f948d06aee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x00000000005e9e86 in close_thread_tables (thd=0x7f9476c16070) at /data/src/10.0/sql/sql_base.cc:892
      #9  0x00000000006555c5 in mysql_execute_command (thd=0x7f9476c16070) at /data/src/10.0/sql/sql_parse.cc:5175
      #10 0x00000000006589d0 in mysql_parse (thd=0x7f9476c16070, rawbuf=0x7f94788c9e88 "CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `mysqltest_tmp_v` AS SELECT * FROM t3 WHERE a >= 30 ORDER BY a", length=153, parser_state=0x7f9486647a00) at /data/src/10.0/sql/sql_parse.cc:6637
      #11 0x000000000092a116 in Query_log_event::do_apply_event (this=0x7f94788c9cb0, rgi=0x7f9478816800, query_arg=0x7f94788c9e88 "CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `mysqltest_tmp_v` AS SELECT * FROM t3 WHERE a >= 30 ORDER BY a", q_len_arg=153) at /data/src/10.0/sql/log_event.cc:4435
      #12 0x0000000000929127 in Query_log_event::do_apply_event (this=0x7f94788c9cb0, rgi=0x7f9478816800) at /data/src/10.0/sql/log_event.cc:4096
      #13 0x00000000005c1d4c in Log_event::apply_event (this=0x7f94788c9cb0, rgi=0x7f9478816800) at /data/src/10.0/sql/log_event.h:1360
      #14 0x00000000005b8444 in apply_event_and_update_pos (ev=0x7f94788c9cb0, thd=0x7f9476c16070, rgi=0x7f9478816800, rpt=0x7f94788aacf0) at /data/src/10.0/sql/slave.cc:3310
      #15 0x00000000007c7a3e in rpt_handle_event (qev=0x7f947889e270, rpt=0x7f94788aacf0) at /data/src/10.0/sql/rpl_parallel.cc:52
      #16 0x00000000007ca285 in handle_rpl_parallel_thread (arg=0x7f94788aacf0) at /data/src/10.0/sql/rpl_parallel.cc:1202
      #17 0x0000000000acdb54 in pfs_spawn_thread (arg=0x7f9478861270) at /data/src/10.0/storage/perfschema/pfs.cc:1861
      #18 0x00007f948eb53494 in start_thread (arg=0x7f9486648700) at pthread_create.c:333
      #19 0x00007f948d12793f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.