Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
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
|