Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5016

[PS8QA] PS upgrade is crashing if system tablespace encryption is enabled

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 8.0, Not 5.7
    • Fix Version/s: 8.0.13-3
    • Component/s: None
    • Labels:
      None

      Description

      Testcase 

      rm -rf /dev/shm/qa/1001 
      mkdir -p /dev/shm/qa/1001/logs
      mkdir -p /dev/shm/qa/1001/mysqldir/psdata 
      
      Attached CNF files
      
      1) DB initialization
      
      /dev/shm/qa/ps57/bin/mysqld --no-defaults --initialize-insecure --basedir=/dev/shm/qa/ps57 --datadir=/dev/shm/qa/1001/mysqldir/psdata --early-plugin-load=keyring_file.so --keyring_file_data=/dev/shm/qa/1001/mysqldir/psdata/keyring --innodb_sys_tablespace_encrypt=ON
      
       2) Startup command
      
      /dev/shm/qa/ps57/bin/mysqld --defaults-file=/dev/shm/qa/1001/ps_lower.cnf --basedir=/dev/shm/qa/ps57 --datadir=/dev/shm/qa/1001/mysqldir/psdata --port=55727 & 
      
      3) SQL 
      /dev/shm/qa/ps57/bin/mysql -uroot -S/dev/shm/qa/1001/ps_lower.sock -e"drop database if exists test_encrypt; create database test_encrypt"
      
      sysbench /usr/share/sysbench/oltp_insert.lua --mysql_storage_engine=innodb --table-size=1000 --tables=2 --mysql-db=test_encrypt --mysql-user=root --threads=2 --db-driver=mysql --mysql-socket=/dev/shm/qa/1001/ps_lower.sock prepare
      
      /dev/shm/qa/ps57/bin/mysql -uroot -S/dev/shm/qa/1001/ps_lower.sock -e"ALTER TABLE test_encrypt.sbtest1 TABLESPACE=innodb_system"
      
      4) Shutdown PS-5.7
      
      mysqladmin -uroot -S/dev/shm/qa/1001/ps_lower.sock shutdown
      
      5) Start PS with 8.0 base
      
      /dev/shm/qa/ps80/bin/mysqld --defaults-file=/dev/shm/qa/1001/ps_upper.cnf --basedir=/dev/shm/qa/ps80 --datadir=/dev/shm/qa/1001/mysqldir/psdata --port=55727 &

      GDB info

      #0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
      #1  0x00000000041a7698 in my_write_core (sig=6) at /qa/work/bug/PS-80_dbg/mysys/stacktrace.cc:278
      #2  0x00000000030f9c7b in handle_fatal_signal (sig=6) at /qa/work/bug/PS-80_dbg/sql/signal_handler.cc:254
      #3  <signal handler called>
      #4  0x00007f8ea7e38428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
      #5  0x00007f8ea7e3a02a in __GI_abort () at abort.c:89
      #6  0x00007f8ea7e30bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x523f067 "0", file=file@entry=0x523f828 "/qa/work/bug/PS-80_dbg/sql/sql_class.cc", line=line@entry=2850, function=function@entry=0x5242040 <THD::send_statement_status()::__PRETTY_FUNCTION__> "void THD::send_statement_status()") at assert.c:92
      #7  0x00007f8ea7e30c82 in __GI___assert_fail (assertion=0x523f067 "0", file=0x523f828 "/qa/work/bug/PS-80_dbg/sql/sql_class.cc", line=2850, function=0x5242040 <THD::send_statement_status()::__PRETTY_FUNCTION__> "void THD::send_statement_status()") at assert.c:101
      #8  0x0000000002e951bc in THD::send_statement_status (this=0x89eea50) at /qa/work/bug/PS-80_dbg/sql/sql_class.cc:2850
      #9  0x0000000002f84683 in Ed_connection::execute_direct (this=0x7f8e964fc580, server_runnable=0x7f8e964fc500) at /qa/work/bug/PS-80_dbg/sql/sql_prepare.cc:3268
      #10 0x0000000002f84520 in Ed_connection::execute_direct (this=0x7f8e964fc580, sql_text=...) at /qa/work/bug/PS-80_dbg/sql/sql_prepare.cc:3241
      #11 0x00000000040c4dbb in execute_query (thd=0x89eea50, q_buf="CREATE TABLE dd_properties(\n  properties MEDIUMBLOB\n) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC STATS_PERSISTENT=0 TABLESPACE=mysql") at /qa/work/bug/PS-80_dbg/sql/dd/impl/bootstrapper.cc:91
      #12 0x00000000040c6177 in (anonymous namespace)::initialize_dd_properties (thd=0x89eea50) at /qa/work/bug/PS-80_dbg/sql/dd/impl/bootstrapper.cc:282
      #13 0x00000000040d153f in dd::bootstrap::initialize_dictionary (thd=0x89eea50, is_dd_upgrade_57=true, d=0x8994f00) at /qa/work/bug/PS-80_dbg/sql/dd/impl/bootstrapper.cc:2181
      #14 0x00000000040c39e6 in dd::upgrade_57::do_pre_checks_and_initialize_dd (thd=0x89eea50) at /qa/work/bug/PS-80_dbg/sql/dd/upgrade/upgrade.cc:1048
      #15 0x0000000003206b82 in bootstrap::handle_bootstrap (arg=0x89eea50) at /qa/work/bug/PS-80_dbg/sql/bootstrap.cc:346
      #16 0x0000000004299410 in pfs_spawn_thread (arg=0x89fb2b0) at /qa/work/bug/PS-80_dbg/storage/perfschema/pfs.cc:2836
      #17 0x00007f8ea9bb26ba in start_thread (arg=0x7f8e964fe700) at pthread_create.c:333
      #18 0x00007f8ea7f0a41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
       

        Smart Checklist

          Attachments

          1. ps_lower.cnf
            0.8 kB
          2. ps_upper.cnf
            0.8 kB

            Issue Links

              Activity

                People

                • Assignee:
                  laurynas.biveinis Laurynas Biveinis
                  Reporter:
                  ramesh.sivaraman Ramesh Sivaraman
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 6 minutes
                    6m