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

Assertion `cache_mngr' failed in binlog_get_pending_rows_even

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.2, 11.3, 11.4
    • 11.2, 11.3, 11.4
    • None
    • None

    Description

      mysqld: 11.0/sql/log.cc:6453: Rows_log_event* binlog_get_pending_rows_event(binlog_cache_mngr*, bool): Assertion `cache_mngr' failed.
      230321 10:51:55 [ERROR] mysqld got signal 6 ;
       
      Server version: 11.0.1-MariaDB-debug-log source revision: f9b33ac570337be320f718d52fd88d301a2bc1e7
       
      linux/raise.c:51(__GI_raise)[0x7f021b2c08eb]
      stdlib/abort.c:81(__GI_abort)[0x7f021b2ab535]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f021b2ab40f]
      ??:0(__assert_fail)[0x7f021b2b91a2]
      sql/log.cc:6454(binlog_get_pending_rows_event(binlog_cache_mngr*, bool))[0x56474d1b81f9]
      sql/sql_class.h:2978(THD::binlog_need_stmt_format(bool) const)[0x56474c4960ab]
      sql/sql_update.cc:1323(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, bool, unsigned long long*, unsigned long long*))[0x56474c8f8931]
      sql/sql_parse.cc:4412(mysql_execute_command(THD*, bool))[0x56474c582163]
      sql/sp_head.cc:3857(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x56474c3242cd]
      sql/sp_head.cc:3582(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x56474c3228e6]
      sql/sp_head.cc:3763(sp_instr_stmt::execute(THD*, unsigned int*))[0x56474c323a81]
      sql/sp_head.cc:1459(sp_head::execute(THD*, bool))[0x56474c314730]
      sql/sp_head.cc:2446(sp_head::execute_procedure(THD*, List<Item>*))[0x56474c31a745]
      sql/event_data_objects.cc:1482(Event_job_data::execute(THD*, bool))[0x56474c9b26b8]
      sql/event_scheduler.cc:323(Event_worker_thread::run(THD*, Event_queue_element_for_exec*))[0x56474d2db96b]
      sql/event_scheduler.cc:270(event_worker_thread)[0x56474d2db36b]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x56474d6b8d1f]
      nptl/pthread_create.c:487(start_thread)[0x7f021b778fa3]
       
      Query (0x6250013679a8): UPDATE `t1` SET `col2` = NULL ORDER BY `col1` LIMIT 1
      

      on 11.2-11.4 the assertion is repeatable with the test below (but originally I've got similar on 11.0) - test case from versioning/partition:

      --source include/have_log_bin.inc
      --source include/have_innodb.inc
      --source include/have_partition.inc
       
      set timestamp= unix_timestamp('2000-01-01 00:00:00');
      create or replace table t1 (x int) engine=innodb with system versioning
      partition by system_time interval 1 hour auto partitions 3
      ;
       
      insert into t1 values (1);
      show create table t1;
       
      --connect con8, localhost, root
      --connect con7, localhost, root
      --connect con6, localhost, root
      --connect con5, localhost, root
      --connect con4, localhost, root
      --connect con3, localhost, root
      --connect con2, localhost, root
      --connect con1, localhost, root
      set timestamp= unix_timestamp('2000-01-01 02:00:00');
      send update t1 set x= x + 10;
      --connection con2
      set timestamp= unix_timestamp('2000-01-01 02:00:00');
      send update t1 set x= x + 20;
      --connection con3
      set timestamp= unix_timestamp('2000-01-01 02:00:00');
      send update t1 set x= x + 30;
      --connection con4
      set timestamp= unix_timestamp('2000-01-01 02:00:00');
      send update t1 set x= x + 40;
      --connection con5
      set timestamp= unix_timestamp('2000-01-01 02:00:00');
      send update t1 set x= x + 50;
      --connection con6
      set timestamp= unix_timestamp('2000-01-01 02:00:00');
      send update t1 set x= x + 60;
      --connection con7
      set timestamp= unix_timestamp('2000-01-01 02:00:00');
      send update t1 set x= x + 70;
      --connection con8
      set timestamp= unix_timestamp('2000-01-01 02:00:00');
      update t1 set x= x + 80;
      --connection con1
      reap;
      --disconnect con1
      --connection con2
      reap;
      --disconnect con2
      --connection con3
      reap;
      --disconnect con3
      --connection con4
      reap;
      --disconnect con4
      --connection con5
      reap;
      --disconnect con5
      --connection con6
      reap;
      --disconnect con6
      --connection con7
      reap;
      --disconnect con7
      --disconnect con8
      --connection default
      show create table t1;
       
      drop tables t1;
      set timestamp= default;
      

      mariadbd: /11.2/src/sql/log.cc:6171: Rows_log_event* binlog_get_pending_rows_event(binlog_cache_mngr*, bool): Assertion `cache_mngr' failed.
      240319 16:00:59 [ERROR] mysqld got signal 6 ;
       
      Server version: 11.2.4-MariaDB-debug-log source revision: 1553a9dd79b7777ca5a343b445afb196482564ba
       
      sql/signal_handler.cc:238(handle_fatal_signal)[0x563e22a4392e]
      sigaction.c:0(__restore_rt)[0x7f353cc0d420]
      /lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f353c6e6fd6]
      sql/log.cc:6172(binlog_get_pending_rows_event(binlog_cache_mngr*, bool))[0x563e22dc5005]
      sql/sql_class.h:3035(THD::binlog_need_stmt_format(bool) const)[0x563e21ff6743]
      sql/sql_update.cc:1213(Sql_cmd_update::update_single_table(THD*))[0x563e22480923]
      sql/sql_update.cc:3072(Sql_cmd_update::execute_inner(THD*))[0x563e224938b5]
      sql/sql_select.cc:33603(Sql_cmd_dml::execute(THD*))[0x563e222d3097]
      sql/sql_parse.cc:4425(mysql_execute_command(THD*, bool))[0x563e220eaf08]
      sql/sql_parse.cc:7874(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x563e22102a51]
      sql/sql_parse.cc:1895(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x563e220da93a]
      sql/sql_parse.cc:1406(do_command(THD*, bool))[0x563e220d7684]
      sql/sql_connect.cc:1437(do_handle_one_connection(CONNECT*, bool))[0x563e225ba042]
      sql/sql_connect.cc:1341(handle_one_connection)[0x563e225b999f]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x563e23226efe]
      nptl/pthread_create.c:478(start_thread)[0x7f353cc01609]
       
      Query (0x62900037a2a8): update t1 set x= x + 10
      

      Attachments

        Activity

          People

            Elkin Andrei Elkin
            alice Alice Sherepa
            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.