[MDEV-18742] Galera: Rolling upgrade: node failed with sysbench run and alter table encryption='yes' Created: 2019-02-26  Updated: 2019-03-28

Status: Open
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.4.3, 10.3.13
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Shahriyar Rzayev (Inactive) Assignee: Teemu Ollakka
Resolution: Unresolved 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-node2.err    

 Description   

Used following scenario:

  • Started 5 nodes 10.3
  • Upgraded them to 10.4
  • Run sysbench prepare:

sysbench oltp_read_write --mysql-host=localhost --mysql-user=root --mysql-db=sbtest2 --mysql-socket=/tmp/mysql-node2.sock --tables=10 --table-size=10000 prepare

  • sysbench run and at the same time on another shell run alter several times:

sysbench oltp_read_write --mysql-host=localhost --mysql-user=root --mysql-db=sbtest2 --mysql-socket=/tmp/mysql-node2.sock --tables=10 --table-size=1000000000 run
sysbench 1.0.16 (using bundled LuaJIT 2.1.0-beta2)
 
Running the test with following options:
Number of threads: 1
Initializing random number generator from current time
 
 
Initializing worker threads...
 
Threads started!
 
FATAL: mysql_stmt_execute() returned error 2013 (Lost connection to MySQL server during query) for query 'COMMIT'
FATAL: `thread_run' function failed: /usr/share/sysbench/oltp_common.lua:409: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query

MariaDB [sbtest2]> alter table sbtest5 encrypted=yes;
Query OK, 0 rows affected (0.050 sec)
Records: 0  Duplicates: 0  Warnings: 0
 
MariaDB [sbtest2]> alter table sbtest5 encrypted=yes;
Query OK, 0 rows affected (0.030 sec)
Records: 0  Duplicates: 0  Warnings: 0
 
MariaDB [sbtest2]> alter table sbtest5 encrypted=yes;
Query OK, 0 rows affected (0.053 sec)
Records: 0  Duplicates: 0  Warnings: 0
 
MariaDB [sbtest2]> alter table sbtest5 encrypted=yes;
^[[AERROR 2013 (HY000): Lost connection to MySQL server during query

Failed as:

mysqld: /home/shako/Galera_Tests/MariaDB/sql/wsrep_high_priority_service.cc:616: virtual int Wsrep_replayer_service::apply_write_set(const wsrep::ws_meta&, const wsrep::const_buffer&):
 Assertion `thd->wsrep_trx().is_streaming()' failed.
190226 17:52:00 [ERROR] mysqld got signal 6 ;
sql/wsrep_high_priority_service.cc:617(Wsrep_replayer_service::apply_write_set(wsrep::ws_meta const&, wsrep::const_buffer const&))[0x562ead3cc048]
src/server_state.cpp:272(apply_write_set(wsrep::server_state&, wsrep::high_priority_service&, wsrep::ws_handle const&, wsrep::ws_meta const&, wsrep::const_buffer const&))[0x562eadd286bc]
src/server_state.cpp:989(wsrep::server_state::on_apply(wsrep::high_priority_service&, wsrep::ws_handle const&, wsrep::ws_meta const&, wsrep::const_buffer const&))[0x562eadd2bbca]
wsrep/high_priority_service.hpp:47(wsrep::high_priority_service::apply(wsrep::ws_handle const&, wsrep::ws_meta const&, wsrep::const_buffer const&))[0x562eadd41d8b]
src/wsrep_provider_v26.cpp:489((anonymous namespace)::apply_cb(void*, wsrep_ws_handle const*, unsigned int, wsrep_buf const*, wsrep_trx_meta const*, bool*))[0x562eadd3f484]
src/trx_handle.cpp:426(galera::TrxHandleSlave::apply(void*, wsrep_cb_status (*)(void*, wsrep_ws_handle const*, unsigned int, wsrep_buf const*, wsrep_trx_meta const*, bool*), wsrep_trx_meta const&, bool&))[0x7ffab24e24cf]
src/replicator_smm.cpp:1155(galera::ReplicatorSMM::replay_trx(galera::TrxHandleMaster&, galera::TrxHandleLock&, void*))[0x7ffab251b6f6]
src/wsrep_provider.cpp:311(galera_replay_trx)[0x7ffab2531407]
/home/shako/Galera_Tests/dbs/maria_10.4/bin/mysqld(_ZN5wsrep18wsrep_provider_v266replayERKNS_9ws_handleEPNS_21high_priority_serviceE+0x57)[0x562eadd40941]
src/wsrep_provider_v26.cpp:793(wsrep::wsrep_provider_v26::replay(wsrep::ws_handle const&, wsrep::high_priority_service*))[0x562ead3c7964]
sql/wsrep_client_service.cc:260(Wsrep_client_service::replay())[0x562eadd342b6]
src/transaction.cpp:706(wsrep::transaction::after_statement())[0x562eadd23bfd]
src/client_state.cpp:244(wsrep::client_state::after_statement())[0x562ead186a2d]
sql/wsrep_trans_observer.h:354(wsrep_after_statement(THD*))[0x562ead18aead]
sql/sql_parse.cc:1758(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x562ead189b48]
sql/sql_parse.cc:1357(do_command(THD*))[0x562ead3024d7]
sql/sql_connect.cc:1399(do_handle_one_connection(CONNECT*))[0x562ead30223b]
nptl/pthread_create.c:463(start_thread)[0x7ffab47986db]
x86_64/clone.S:97(clone)[0x7ffab397e88f]


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