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

galera.galera_last_committed_id MTR failed: Result content mismatch

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Stalled (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.5.3
    • Fix Version/s: 10.5
    • Component/s: Galera, Tests
    • Labels:
      None
    • Environment:
      kvm-deb-xenial-amd64

      Description

      galera.galera_last_committed_id MTR failed on BB, 10.5: Result content mismatch.

      stdio.log:

      10.5.3 CS, d50f776930425e540678238798b4f7666b9cbb76, kvm-deb-xenial-amd64

      galera.galera_last_committed_id 'binlogon,innodb' w2 [ fail ]
              Test ended at 2020-05-04 14:25:51
       
      CURRENT_TEST: galera.galera_last_committed_id
      --- /usr/share/mysql/mysql-test/suite/galera/r/galera_last_committed_id.result	2020-05-04 08:22:31.000000000 -0400
      +++ /dev/shm/var/2/log/galera_last_committed_id.reject	2020-05-04 14:25:51.478655282 -0400
      @@ -8,24 +8,24 @@
       INSERT INTO t1 VALUES (1);
       connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;;
       connection node_1a;
      -SELECT WSREP_LAST_WRITTEN_GTID() != '100-1-2' AS wsrep_written_does_not_match_different_conn;
      +SELECT WSREP_LAST_WRITTEN_GTID() != '100-1-1' AS wsrep_written_does_not_match_different_conn;
       wsrep_written_does_not_match_different_conn
       1
       connection node_2;
      -SELECT WSREP_LAST_WRITTEN_GTID() != '100-1-2' AS wsrep_written_does_not_match_different_nodes;
      +SELECT WSREP_LAST_WRITTEN_GTID() != '100-1-1' AS wsrep_written_does_not_match_different_nodes;
       wsrep_written_does_not_match_different_nodes
       1
       connection node_1;
       INSERT INTO t1 VALUES (1);
       connection node_2;
       wsrep_last_written_seen_id_match
      -1
      +0
       connection node_1;
       SET AUTOCOMMIT=OFF;
       START TRANSACTION;
       INSERT INTO t1 VALUES (1);
      -WSREP_LAST_SEEN_GTID() = '100-1-3'
      -1
      +WSREP_LAST_SEEN_GTID() = '100-1-1'
      +0
       wsrep_last_written_id_match
       1
       COMMIT;
       
      mysqltest: Result content mismatch
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sysprg Julius Goryavsky
              Reporter:
              stepan.patryshev Stepan Patryshev
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: