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

Assertion `!current_stmt_is_commit || !rgi->tables_to_lock' failed in Query_log_event::do_apply_event

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
    • 10.5
    • Replication
    • None

    Description

      mysqld: /10.2/sql/log_event.cc:5144: int Query_log_event::do_apply_event(rpl_group_info*, const char*, uint32): Assertion `!current_stmt_is_commit || !rgi->tables_to_lock' failed.
      200724 13:14:41 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.2.33-MariaDB-debug-log
       
      linux/raise.c:51(__GI_raise)[0x7f82824f87bb]
      stdlib/abort.c:81(__GI_abort)[0x7f82824e3535]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f82824e340f]
      /lib/x86_64-linux-gnu/libc.so.6(+0x30102)[0x7f82824f1102]
      sql/log_event.cc:5145(Query_log_event::do_apply_event(rpl_group_info*, char const*, unsigned int))[0x55dab3df36ee]
      sql/log_event.cc:5040(Query_log_event::do_apply_event(rpl_group_info*))[0x55dab3df3325]
      sql/log_event.h:1452(Log_event::apply_event(rpl_group_info*))[0x55dab39a97d3]
      sql/slave.cc:3567(apply_event_and_update_pos_apply(Log_event*, THD*, rpl_group_info*, int))[0x55dab399e6d5]
      sql/slave.cc:3763(apply_event_and_update_pos_for_parallel(Log_event*, THD*, rpl_group_info*))[0x55dab399eced]
      sql/rpl_parallel.cc:50(rpt_handle_event(rpl_parallel_thread::queued_event*, rpl_parallel_thread*))[0x55dab3c1b60a]
      sql/rpl_parallel.cc:1316(handle_rpl_parallel_thread)[0x55dab3c1e6b5]
      nptl/pthread_create.c:487(start_thread)[0x7f8282c36fa3]
      x86_64/clone.S:97(clone)[0x7f82825ba4cf]
      
      

      Datadir from master and slave attached.
      The assertion is reproducible on 10.5 30c9833751529d4039 (I haven't checked versions before 10.5 yet). To reproduce I started slave with (default cnf+ --slave-skip-errors=all) and then pointed it in binlog from master, where the problem occurred :

       change master to master_host='localhost', master_port=3306, master_user='root', MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=1728186; start slave;
      

      Attachments

        Issue Links

          Activity

            People

              bnestere Brandon Nesterenko
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.