Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
Description
--source include/have_innodb.inc
|
--source include/have_binlog_format_row.inc
|
|
CREATE TABLE t1 (a INT) ENGINE=InnoDB; |
CREATE TABLE t2 (b INT) ENGINE=InnoDB; |
CREATE TABLE t3 (c INT) ENGINE=InnoDB; |
CREATE TRIGGER tr1 BEFORE INSERT ON t3 FOR EACH ROW INSERT INTO t2 VALUES (NULL) ; |
CREATE TRIGGER tr2 BEFORE UPDATE ON t2 FOR EACH ROW SET @a = 1; |
|
LOCK TABLE t3 WRITE; |
SET AUTOCOMMIT = OFF; |
INSERT INTO t2 VALUES (1); |
SAVEPOINT A;
|
UNLOCK TABLES;
|
INSERT INTO t1 VALUES (2); |
|
# Cleanup
|
DROP TABLE t1, t2, t3; |
5.5 e3d3bbf5 |
mysqld: /data/src/5.5/sql/log.cc:1604: int binlog_close_connection(handlerton*, THD*): Assertion `cache_mngr->trx_cache.empty() && cache_mngr->stmt_cache.empty()' failed.
|
191212 16:13:10 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007fbf87806f12 in __GI___assert_fail (assertion=0x558b8eb3fb68 "cache_mngr->trx_cache.empty() && cache_mngr->stmt_cache.empty()", file=0x558b8eb3f7c0 "/data/src/5.5/sql/log.cc", line=1604, function=0x558b8eb42ba0 <binlog_close_connection(handlerton*, THD*)::__PRETTY_FUNCTION__> "int binlog_close_connection(handlerton*, THD*)") at assert.c:101
|
#8 0x0000558b8e5f69ee in binlog_close_connection (hton=0x7fbf86fb13e0, thd=0x7fbf81f93060) at /data/src/5.5/sql/log.cc:1604
|
#9 0x0000558b8e5362f4 in closecon_handlerton (thd=0x7fbf81f93060, plugin=0x7fbf78c1d930, unused=0x0) at /data/src/5.5/sql/handler.cc:678
|
#10 0x0000558b8e397450 in plugin_foreach_with_mask (thd=0x7fbf81f93060, func=0x558b8e53627a <closecon_handlerton(THD*, plugin_ref, void*)>, type=1, state_mask=8, arg=0x0) at /data/src/5.5/sql/sql_plugin.cc:2359
|
#11 0x0000558b8e536342 in ha_close_connection (thd=0x7fbf81f93060) at /data/src/5.5/sql/handler.cc:691
|
#12 0x0000558b8e347031 in THD::~THD (this=0x7fbf81f93060, __in_chrg=<optimized out>) at /data/src/5.5/sql/sql_class.cc:1473
|
#13 0x0000558b8e3472ec in THD::~THD (this=0x7fbf81f93060, __in_chrg=<optimized out>) at /data/src/5.5/sql/sql_class.cc:1503
|
#14 0x0000558b8e2d4a45 in unlink_thd (thd=0x7fbf81f93060) at /data/src/5.5/sql/mysqld.cc:2433
|
#15 0x0000558b8e2d4d63 in one_thread_per_connection_end (thd=0x7fbf81f93060, put_in_cache=true) at /data/src/5.5/sql/mysqld.cc:2538
|
#16 0x0000558b8e48440c in do_handle_one_connection (thd_arg=0x7fbf81f93060) at /data/src/5.5/sql/sql_connect.cc:1279
|
#17 0x0000558b8e4840e8 in handle_one_connection (arg=0x7fbf81f93060) at /data/src/5.5/sql/sql_connect.cc:1184
|
#18 0x0000558b8e808d64 in pfs_spawn_thread (arg=0x7fbf81fb77a0) at /data/src/5.5/storage/perfschema/pfs.cc:1015
|
#19 0x00007fbf88ead4a4 in start_thread (arg=0x7fbf89272700) at pthread_create.c:456
|
#20 0x00007fbf878c3d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
Reproducible on 5.5-10.5 debug builds.
Not reproducible on MySQL 5.6, didn't try other MySQL versions.
No obvious failure on non-debug builds, apart from WSREP warnings on 10.x (MDEV-21308):
2019-12-12 16:14:38 10 [Warning] WSREP: binlog trx cache not empty (34 bytes) @ connection close 10
|
2019-12-12 16:14:38 10 [Warning] WSREP: binlog stmt cache not empty (0 bytes) @ connection close 10
|
But they cannot be causing the problem, since the assertion also fails on 5.5 vanilla tree which doesn't have WSREP.
Attachments
Issue Links
- is blocked by
-
MDEV-14472 Assertion `is_current_stmt_binlog_format_row()' failed in THD::binlog_write_table_map
- Stalled
- relates to
-
MDEV-14472 Assertion `is_current_stmt_binlog_format_row()' failed in THD::binlog_write_table_map
- Stalled