[MDEV-24165] Galera test failure on galera_var_ignore_apply_errors Created: 2020-11-09  Updated: 2023-11-25  Resolved: 2020-11-19

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4
Fix Version/s: 10.4.18, 10.5.9

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates

 Description   
  • http://buildbot.askmonty.org/buildbot/builders/kvm-deb-bionic-amd64/builds/6220/steps/mtr-galera/logs/stdio

    galera.galera_var_ignore_apply_errors 'innodb' w1 [ fail ]
            Test ended at 2020-11-08 21:11:08
     
    CURRENT_TEST: galera.galera_var_ignore_apply_errors
    mysqltest: At line 78: query 'SELECT COUNT(*) as expect_0 FROM t1' failed: 1047: WSREP has not yet prepared node for application use
     
    The result from queries just before the failure was:
    < snip >
    CREATE TABLE t1 (f1 INTEGER);
    SET GLOBAL wsrep_on = OFF;
    ALTER TABLE t1 ADD COLUMN f2 INTEGER;
    SET GLOBAL wsrep_on = ON;
    ALTER TABLE t1 DROP COLUMN f2;
    DROP TABLE t1;
    connection node_2;
    SET GLOBAL wsrep_ignore_apply_errors = 2;
    connection node_1;
    CREATE TABLE t1 (f1 INTEGER);
    SET GLOBAL wsrep_on = OFF;
    INSERT INTO t1 VALUES (1);
    SET GLOBAL wsrep_on = ON;
    DELETE FROM t1 WHERE f1 = 1;
    connection node_1;
    SELECT COUNT(*) as expect_0 FROM t1;
    expect_0
    0
    connection node_2;
    SELECT COUNT(*) as expect_0 FROM t1;
    


Generated at Thu Feb 08 09:27:55 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.