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

galera_3nodes.GCF-354 MTR fails : WSREP has not yet prepared node for application use

Details

    Description

      galera_3nodes.GCF-354 fails on BB 10.5 and BB 10.6: "WSREP has not yet prepared node for application use".

      stdio.log:

      10.5.7 b30ad01d407c0d7f517a5c46deedefb02212d098

      galera_3nodes.GCF-354 'innodb'           w2 [ fail ]
              Test ended at 2020-10-21 23:50:14
       
      CURRENT_TEST: galera_3nodes.GCF-354
      mysqltest: At line 38: query 'DROP TABLE test.t1' failed: 1047: WSREP has not yet prepared node for application use
       
      The result from queries just before the failure was:
      < snip >
      connection node_3;
      SET SESSION wsrep_on=OFF;
      CREATE TABLE test.t1 (f1 INTEGER) engine=innodb;
      connection node_1;
      CREATE TABLE test.t1 (f1 INTEGER) engine=innodb;
      Timeout in wait_condition.inc for SELECT VARIABLE_VALUE = 'Primary' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status'
      Id	User	Host	db	Command	Time	State	Info	Progress
      2	system user		NULL	Sleep	43	closing tables	NULL	0.000
      1	system user		NULL	Sleep	43	wsrep aborter idle	NULL	0.000
      10	root	localhost	test	Sleep	33		NULL	0.000
      11	root	localhost:57800	test	Query	0	starting	show full processlist	0.000
      SHOW STATUS LIKE 'wsrep_cluster_status';
      Variable_name	Value
      wsrep_cluster_status	non-Primary
      DROP TABLE test.t1;
       
      More results from queries before failure can be found in /dev/shm/var/2/log/GCF-354.log
       
       - saving '/dev/shm/var/2/log/galera_3nodes.GCF-354-innodb/' to '/dev/shm/var/log/galera_3nodes.GCF-354-innodb/'
       
      Retrying test galera_3nodes.GCF-354, attempt(2/3)...
       
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      ***Warnings generated in error logs during shutdown after running tests: galera_3nodes.GCF-354
       
      2020-10-21 23:49:43 1 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on 973ac946-1419-11eb-a49d-42eb092811e5:4
      2020-10-21 23:49:43 2 [ERROR] WSREP: Inconsistency detected: Inconsistent by consensus on 973ac946-1419-11eb-a49d-42eb092811e5:4
      

      Server logs.

      Attachments

        Issue Links

          Activity

            According to the server logs this WSREP error had appeared before GCF-354 started, but during galera.MW-284 running:

            mysqld.3.err.1:

            CURRENT_TEST: galera.MW-284
            2020-10-21 23:38:06 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.7-MariaDB-1:10.5.7+maria~xenial-log) starting as process 6000
            [...]
            2020-10-21 23:38:20 6 [ERROR] Error reading packet from server: WSREP has not yet prepared node for application use (server_errno=1047)
            

            mysqld.3.err.2:

            CURRENT_TEST: galera_3nodes.GCF-354
            2020-10-21 23:49:31 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated
            

            stepan.patryshev Stepan Patryshev (Inactive) added a comment - According to the server logs this WSREP error had appeared before GCF-354 started, but during galera.MW-284 running: mysqld.3.err.1: CURRENT_TEST: galera.MW-284 2020-10-21 23:38:06 0 [Note] /usr/sbin/mariadbd (mysqld 10.5.7-MariaDB-1:10.5.7+maria~xenial-log) starting as process 6000 [...] 2020-10-21 23:38:20 6 [ERROR] Error reading packet from server: WSREP has not yet prepared node for application use (server_errno=1047) mysqld.3.err.2: CURRENT_TEST: galera_3nodes.GCF-354 2020-10-21 23:49:31 0 [Warning] WSREP: option --wsrep-causal-reads is deprecated

            Already fixed & merged with head revisions

            sysprg Julius Goryavsky added a comment - Already fixed & merged with head revisions

            People

              sysprg Julius Goryavsky
              stepan.patryshev Stepan Patryshev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.