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

WSREP: binlog ... cache not empty warnings on server with WSREP disabled

    XMLWordPrintable

Details

    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;
      

      10.4 non-debug 3b401a69

       

      line
      2019-12-12 16:17:52 10 [Warning] WSREP: binlog trx cache not empty (34 bytes) @ connection close 10
      2019-12-12 16:17:52 10 [Warning] WSREP: binlog stmt cache not empty (0 bytes) @ connection close 10
      ^ Found warnings in /data/bld/10.4-rel-nightly/mysql-test/var/log/mysqld.1.err

       

      Debug builds additionally fail with MDEV-21307.

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.