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

Galera: Rolling upgrade: node failed with sysbench run and alter table encryption='yes'

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.4.3, 10.3.13
    • Fix Version/s: None
    • Component/s: Galera
    • Labels:
    • Environment:
      Ubuntu 18.04

      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]
      

        Attachments

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

          Activity

            People

            • Assignee:
              teemu.ollakka Teemu Ollakka
              Reporter:
              shako Shahriyar Rzayev
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: