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

    • Type: Bug
    • Status: In Progress (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.1, 10.2, 10.3, 10.4
    • Fix Version/s: 10.1, 10.2, 10.3, 10.4
    • Component/s: wsrep
    • 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;
      

      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

            Assignee:
            jplindst Jan Lindström
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: