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

Assertion `cache_mngr->trx_cache.empty() && cache_mngr->stmt_cache.empty()' failed in binlog_close_connection

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: In Review (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 5.5, 10.1, 10.2, 10.3, 10.4
    • Fix Version/s: 10.1, 10.2, 10.3, 10.4
    • Component/s: Replication
    • Labels:
      None

      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

          Activity

            People

            Assignee:
            Elkin Andrei Elkin
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: