--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;

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

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