[MDEV-18940] Galera: Rolling upgrade: all nodes except upgraded node5 failed with Assertion `meta->gtid.seqno == wsrep_thd_trx_seqno(thd)' with SEQUENCEs Created: 2019-03-15  Updated: 2019-06-18  Resolved: 2019-06-18

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.3.14, 10.4.4
Fix Version/s: 10.3.17, 10.4.7

Type: Bug Priority: Major
Reporter: Shahriyar Rzayev (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: galera
Environment:

Ubuntu 18.04


Attachments: File mynode1_10.3.cnf     File mynode1_10.4.cnf     File mynode2_10.3.cnf     File mynode2_10.4.cnf     File mynode3_10.3.cnf     File mynode3_10.4.cnf     File mynode4_10.3.cnf     File mynode4_10.4.cnf     File mynode5_10.3.cnf     File mynode5_10.4.cnf     File mysql-node1.err    

 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]



 Comments   
Comment by Shahriyar Rzayev (Inactive) [ 2019-03-15 ]

Added all cluster configs + one of error logs after crash.

Generated at Thu Feb 08 08:47:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.