Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
-
Can result in unexpected behaviour
Description
# Run with |
# --mysqld=--binlog_format=row --mysqld=--wsrep-cluster-address=gcomm:// --mysqld=--wsrep-on --mysqld=--wsrep-provider=/lib/libgalera_smm.so |
# (use any valid path to Galera library) |
# The sleep is for WSREP to start up, it should disappear |
# when the test case is added to the galera suite |
--sleep 3
|
|
|
--source include/have_innodb.inc
|
|
|
CREATE TABLE t (a INT) ENGINE=InnoDB; |
--delimiter $
|
CREATE FUNCTION f() RETURNS INT |
BEGIN
|
INSERT INTO t VALUES (1); |
RETURN 0; |
END $ |
--delimiter ;
|
|
|
START TRANSACTION; |
SELECT f(); |
ROLLBACK; |
|
|
DROP TABLE t; |
DROP FUNCTION f; |
|
main 8cb64d1c900469b30273dd2bc5998a72f5851919 |
mariadbd: /data/bld/main-asan-ubsan/sql/sql_parse.cc:7446: void THD::reset_for_next_command(bool): Assertion `binlog_table_maps == 0 || locked_tables_mode == LTM_LOCK_TABLES' failed.
|
260125 21:26:27 [ERROR] /share8t/bld/main-asan-ubsan/sql/mariadbd got signal 6 ;
|
|
|
#10 0x00007fe9ae853eb2 in __GI___assert_fail (assertion=0x55ae3873daa0 "binlog_table_maps == 0 || locked_tables_mode == LTM_LOCK_TABLES", file=0x55ae38737b00 "/data/bld/main-asan-ubsan/sql/sql_parse.cc", line=7446, function=0x55ae3873da00 "void THD::reset_for_next_command(bool)") at ./assert/assert.c:101
|
#11 0x000055ae3493d5a3 in THD::reset_for_next_command (this=this@entry=0x62c000230218, do_clear_error=do_clear_error@entry=true) at /data/bld/main-asan-ubsan/sql/sql_parse.cc:7446
|
#12 0x000055ae34983d4c in mysql_parse (thd=thd@entry=0x62c000230218, rawbuf=rawbuf@entry=0x62d0001f4438 "ROLLBACK", length=length@entry=8, parser_state=parser_state@entry=0x7fe990312a10) at /data/bld/main-asan-ubsan/sql/sql_parse.cc:7891
|
#13 0x000055ae34988790 in wsrep_mysql_parse (thd=thd@entry=0x62c000230218, rawbuf=0x62d0001f4438 "ROLLBACK", length=8, parser_state=parser_state@entry=0x7fe990312a10) at /data/bld/main-asan-ubsan/sql/sql_parse.cc:7755
|
#14 0x000055ae3498e025 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62c000230218, packet=packet@entry=0x6290002fd219 "ROLLBACK", packet_length=packet_length@entry=8, blocking=blocking@entry=true) at /data/bld/main-asan-ubsan/sql/sql_parse.cc:1883
|
#15 0x000055ae3499af07 in do_command (thd=thd@entry=0x62c000230218, blocking=blocking@entry=true) at /data/bld/main-asan-ubsan/sql/sql_parse.cc:1432
|
#16 0x000055ae351faa48 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x60800002abb8, put_in_cache=put_in_cache@entry=true) at /data/bld/main-asan-ubsan/sql/sql_connect.cc:1503
|
#17 0x000055ae351fbbb1 in handle_one_connection (arg=0x60800002abb8) at /data/bld/main-asan-ubsan/sql/sql_connect.cc:1415
|
#18 0x000055ae36e4ece3 in pfs_spawn_thread (arg=0x61700002df98) at /data/bld/main-asan-ubsan/storage/perfschema/pfs.cc:2198
|
#19 0x00007fe9ae8a81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#20 0x00007fe9ae92885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
The failure started happening after the main commit of MDEV-34705:
commit 7081f2a58ec459c55296dcf700e2f4cc1c85b4e7
|
Author: Kristian Nielsen
|
Date: Sun Feb 25 17:41:50 2024 +0100
|
|
|
Binlog-in-engine: New binlog implementation integrated in InnoDB
|
Attachments
Issue Links
- is caused by
-
MDEV-34705 Improving performance of binary logging by removing the need of syncing it
-
- In Testing
-