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

galera_var_ignore_apply_errors test freezes

Details

    Description

      galera_var_ignore_apply_errors test freezes, probably a problem on node 2:

      CURRENT_TEST: galera.galera_var_ignore_apply_errors
      mysqltest: In included file "./include/galera_wait_ready.inc": 
      included from /home/jenkins/workspace/Test-Package/mysql-test/suite/galera/t/galera_var_ignore_apply_errors.test at line 80:
      At line 33: "Server did not transition to READY state"
       
      The result from queries just before the failure was:
      < snip >
      DROP TABLE t1;
      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;
       
      More results from queries before failure can be found in /dev/shm/var/4/log/galera_var_ignore_apply_errors.log
       
       - saving '/dev/shm/var/4/log/galera.galera_var_ignore_apply_errors-innodb/' to '/dev/shm/var/log/galera.galera_var_ignore_apply_errors-innodb/'
       
      Retrying test galera.galera_var_ignore_apply_errors, attempt(2/2)...
       
      ***Warnings generated in error logs during shutdown after running tests: galera.galera_var_ignore_apply_errors
       
      2023-11-22 13:05:00 2 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on baf4707d-8937-11ee-b794-1fcbf89ee12a:9

      Attachments

        Issue Links

          Activity

            sysprg Julius Goryavsky created issue -
            sysprg Julius Goryavsky added a comment - May be linked with https://jira.mariadb.org/browse/MDEV-30172
            sysprg Julius Goryavsky made changes -
            Field Original Value New Value
            sysprg Julius Goryavsky added a comment - May be regression of the https://jira.mariadb.org/browse/MDEV-20451
            sysprg Julius Goryavsky made changes -

            And another duplicate/regression: https://jira.mariadb.org/browse/MDEV-24165

            sysprg Julius Goryavsky added a comment - And another duplicate/regression: https://jira.mariadb.org/browse/MDEV-24165
            sysprg Julius Goryavsky made changes -
            sysprg Julius Goryavsky added a comment - And https://jira.mariadb.org/browse/MDEV-26770
            sysprg Julius Goryavsky made changes -
            janlindstrom Jan Lindström made changes -
            janlindstrom Jan Lindström made changes -
            Assignee Seppo Jaakola [ seppo ] Jan Lindström [ JIRAUSER53125 ]

            sysprg All linked actual issues are fixed, does this problem still reproduce?

            janlindstrom Jan Lindström added a comment - sysprg All linked actual issues are fixed, does this problem still reproduce?
            janlindstrom Jan Lindström made changes -
            Status Open [ 1 ] Needs Feedback [ 10501 ]
            julien.fritsch Julien Fritsch made changes -
            Assignee Jan Lindström [ JIRAUSER53125 ] Julius Goryavsky [ sysprg ]
            Status Needs Feedback [ 10501 ] Open [ 1 ]
            Lampio Pekka added a comment -

            I have not been able to reproduce this problem with MariaDB 10.6.17 or 11.4.0.

            Lampio Pekka added a comment - I have not been able to reproduce this problem with MariaDB 10.6.17 or 11.4.0.
            sysprg Julius Goryavsky made changes -
            Priority Critical [ 2 ] Major [ 3 ]
            janlindstrom Jan Lindström made changes -
            Component/s Galera [ 10124 ]
            Component/s Galera [ 14918 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24027 ]
            Key MENT-1997 MDEV-34640
            Affects Version/s 10.6.15-10 [ 29029 ]
            Affects Version/s 10.6.16-11 [ 29415 ]
            Project MariaDB Enterprise [ 11500 ] MariaDB Server [ 10000 ]
            janlindstrom Jan Lindström made changes -
            Assignee Julius Goryavsky [ sysprg ] Jan Lindström [ JIRAUSER53125 ]
            janlindstrom Jan Lindström made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            janlindstrom Jan Lindström added a comment - https://github.com/MariaDB/server/pull/3416
            janlindstrom Jan Lindström made changes -
            Assignee Jan Lindström [ JIRAUSER53125 ] Julius Goryavsky [ sysprg ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            sysprg Julius Goryavsky made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            sysprg Julius Goryavsky made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            sysprg Julius Goryavsky added a comment - Fix merged with the head revision: https://github.com/MariaDB/server/commit/8b51d34462370b96af420587fdc07934abcea8ba
            sysprg Julius Goryavsky made changes -
            Fix Version/s 10.5.26 [ 29832 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            JIraAutomate JiraAutomate made changes -
            Fix Version/s 10.6.19 [ 29833 ]
            Fix Version/s 10.11.9 [ 29834 ]
            Fix Version/s 11.1.6 [ 29835 ]
            Fix Version/s 11.2.5 [ 29836 ]
            Fix Version/s 11.4.3 [ 29837 ]
            Fix Version/s 11.5.2 [ 29838 ]
            dbart Daniel Bartholomew made changes -
            Fix Version/s 10.5.27 [ 29902 ]
            Fix Version/s 10.6.20 [ 29903 ]
            Fix Version/s 10.11.10 [ 29904 ]
            Fix Version/s 11.1.7 [ 29905 ]
            Fix Version/s 11.2.6 [ 29906 ]
            Fix Version/s 11.4.4 [ 29907 ]
            Fix Version/s 10.5.26 [ 29832 ]
            Fix Version/s 10.6.19 [ 29833 ]
            Fix Version/s 10.11.9 [ 29834 ]
            Fix Version/s 11.1.6 [ 29835 ]
            Fix Version/s 11.2.5 [ 29836 ]
            Fix Version/s 11.4.3 [ 29837 ]
            Fix Version/s 11.5.2 [ 29838 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 11.1.7 [ 29905 ]

            People

              sysprg Julius Goryavsky
              sysprg Julius Goryavsky
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.