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

Galera: Rolling upgrade: all nodes except upgraded node5 failed with Assertion `meta->gtid.seqno == wsrep_thd_trx_seqno(thd)' with SEQUENCEs

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.14, 10.4.4
    • Fix Version/s: 10.3.17, 10.4.7
    • Component/s: Galera
    • Labels:
    • Environment:
      Ubuntu 18.04

      Description

      • Started 5 10.3 nodes
      • Trying to do rolling upgrade - upgraded node5
      • Run following SQL on upgraded node5

      CREATE SEQUENCE test.Seq1_1 START WITH 1 INCREMENT BY 1;
      select next value for test.Seq1_1;
      select next value for test.Seq1_1;
      

      All nodes are failing with:

      mysqld: /home/shako/Galera_Tests/MariaDB/sql/wsrep_applier.cc:363: wsrep_cb_status_t wsrep_commit_cb(void*, uint32_t, const wsrep_trx_meta_t*, wsrep_bool_t*, bool): Assertion `meta->gt
      id.seqno == wsrep_thd_trx_seqno(thd)' failed.
      190315 18:56:00 [ERROR] mysqld got signal 6 ;
       
      sql/wsrep_applier.cc:367(wsrep_commit_cb)[0x556877b106cf]
      src/replicator_smm.cpp:463(galera::ReplicatorSMM::apply_trx(void*, galera::TrxHandle*))[0x7f6dd2ba46fc]
      src/replicator_smm.cpp:1248(galera::ReplicatorSMM::process_trx(void*, galera::TrxHandle*))[0x7f6dd2ba6f04]
      src/gcs_action_source.cpp:116(galera::GcsActionSource::dispatch(void*, gcs_action const&, bool&))[0x7f6dd2b8f444]
      src/gcs_action_source.cpp:177(galera::GcsActionSource::process(void*, bool&))[0x7f6dd2b8f8f6]
      src/replicator_smm.cpp:360(galera::ReplicatorSMM::async_recv(void*))[0x7f6dd2ba7598]
      src/wsrep_provider.cpp:271(galera_recv)[0x7f6dd2bb6241]
      sql/wsrep_thd.cc:362(wsrep_replication_process(THD*))[0x556877b11d55]
      sql/wsrep_mysqld.cc:2104(start_wsrep_THD)[0x556877b02e30]
      nptl/pthread_create.c:463(start_thread)[0x7f6dd4bfe6db]
      x86_64/clone.S:97(clone)[0x7f6dd3fe888f]
      

        Attachments

        1. mysql-node1.err
          48 kB
        2. mynode5_10.4.cnf
          1 kB
        3. mynode5_10.3.cnf
          1 kB
        4. mynode4_10.4.cnf
          1 kB
        5. mynode4_10.3.cnf
          1 kB
        6. mynode3_10.4.cnf
          1 kB
        7. mynode3_10.3.cnf
          1 kB
        8. mynode2_10.4.cnf
          1 kB
        9. mynode2_10.3.cnf
          1 kB
        10. mynode1_10.4.cnf
          1 kB
        11. mynode1_10.3.cnf
          1 kB

          Activity

            People

            • Assignee:
              jplindst Jan Lindström
              Reporter:
              shako Shahriyar Rzayev
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: