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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: In Progress (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.5.6
    • Fix Version/s: 10.5
    • Component/s: Galera, Tests
    • Labels:
      None
    • Environment:
      kvm-rpm-centos74-aarch64

      Description

      galera_3nodes.GCF-354 failed on BB 10.5: "query 'DROP TABLE test.t1' failed: 1047: WSREP has not yet prepared node for application use".

      stdio.log:

      10.5.6 97a4a3872e5037b8db1e8c27152740190330ab9c

      galera_3nodes.GCF-354 'innodb'           w1 [ fail ]
              Test ended at 2020-08-26 15:20:24
       
      CURRENT_TEST: galera_3nodes.GCF-354
      mysqltest: At line 36: 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 >
      SET wsrep_on=OFF;
      CREATE TABLE test.t1 (f1 INTEGER);
      connection node_1;
      CREATE TABLE test.t1 (f1 INTEGER);
      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	42	wsrep aborter idle	NULL	0.000
      1	system user		NULL	Sleep	42	closing tables	NULL	0.000
      10	root	localhost	test	Sleep	33		NULL	0.000
      11	root	localhost:59516	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;
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              stepan.patryshev Stepan Patryshev
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: