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

encryption.innodb_encryption_tables: free(): invalid pointer

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Cannot Reproduce
    • Affects Version/s: 5.7.23-24
    • Fix Version/s: None
    • Component/s: None

      Description

      Test "encryption.innodb_encryption_tables" is sometimes failing with

      encryption.innodb_encryption_tables      w3 [ fail ]  Found warnings/errors in server log file!
              Test ended at 2018-11-16 13:43:21
      line
      Attempting backtrace. You can use the following information to find out
      ^ Found warnings in /var/tmp/portage/dev-db/percona-server-5.7.23.24/temp/var-tests/3/log/mysqld.1.err
      ok
      
      
      
      Server [mysqld.1 - pid: 78408, winpid: 78408] log: 
      Server log from this test:
      ----------SERVER LOG START-----------
      2018-11-16T12:43:14.976695Z 0 [Note] Giving 0 client threads a chance to die gracefully
      2018-11-16T12:43:14.976715Z 0 [Note] Shutting down slave threads
      2018-11-16T12:43:14.976721Z 0 [Note] Forcefully disconnecting 0 remaining clients
      2018-11-16T12:43:14.976727Z 0 [Note] Event Scheduler: Purging the queue. 0 events
      2018-11-16T12:43:14.976829Z 0 [Note] Binlog end
      2018-11-16T12:43:14.978119Z 0 [Note] Shutting down plugin 'ngram'
      2018-11-16T12:43:14.978131Z 0 [Note] Shutting down plugin 'partition'
      2018-11-16T12:43:14.978135Z 0 [Note] Shutting down plugin 'BLACKHOLE'
      2018-11-16T12:43:14.978140Z 0 [Note] Shutting down plugin 'ARCHIVE'
      2018-11-16T12:43:14.978144Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
      2018-11-16T12:43:14.978148Z 0 [Note] Shutting down plugin 'MyISAM'
      2018-11-16T12:43:14.978157Z 0 [Note] Shutting down plugin 'INNODB_TABLESPACES_SCRUBBING'
      2018-11-16T12:43:14.978161Z 0 [Note] Shutting down plugin 'INNODB_TABLESPACES_ENCRYPTION'
      2018-11-16T12:43:14.978165Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
      2018-11-16T12:43:14.978169Z 0 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES'
      2018-11-16T12:43:14.978172Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
      2018-11-16T12:43:14.978176Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
      2018-11-16T12:43:14.978180Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
      2018-11-16T12:43:14.978183Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
      2018-11-16T12:43:14.978187Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
      2018-11-16T12:43:14.978191Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
      2018-11-16T12:43:14.978194Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
      2018-11-16T12:43:14.978198Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
      2018-11-16T12:43:14.978201Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
      2018-11-16T12:43:14.978205Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
      2018-11-16T12:43:14.978208Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
      2018-11-16T12:43:14.978212Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
      2018-11-16T12:43:14.978215Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
      2018-11-16T12:43:14.978219Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
      2018-11-16T12:43:14.978222Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
      2018-11-16T12:43:14.978226Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
      2018-11-16T12:43:14.978229Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
      2018-11-16T12:43:14.978246Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
      2018-11-16T12:43:14.978250Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
      2018-11-16T12:43:14.978254Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
      2018-11-16T12:43:14.978258Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
      2018-11-16T12:43:14.978261Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
      2018-11-16T12:43:14.978272Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
      2018-11-16T12:43:14.978276Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
      2018-11-16T12:43:14.978280Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
      2018-11-16T12:43:14.978284Z 0 [Note] Shutting down plugin 'INNODB_CMP'
      2018-11-16T12:43:14.978288Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
      2018-11-16T12:43:14.978291Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
      2018-11-16T12:43:14.978295Z 0 [Note] Shutting down plugin 'INNODB_TRX'
      2018-11-16T12:43:14.978299Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT_COLS'
      2018-11-16T12:43:14.978302Z 0 [Note] Shutting down plugin 'XTRADB_ZIP_DICT'
      2018-11-16T12:43:14.978306Z 0 [Note] Shutting down plugin 'XTRADB_RSEG'
      2018-11-16T12:43:14.978310Z 0 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES'
      2018-11-16T12:43:14.978313Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
      2018-11-16T12:43:14.978317Z 0 [Note] Shutting down plugin 'InnoDB'
      2018-11-16T12:43:14.978376Z 0 [Note] InnoDB: FTS optimize thread exiting.
      2018-11-16T12:43:14.978529Z 0 [Note] InnoDB: Starting shutdown...
      2018-11-16T12:43:15.078952Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/tmp/portage/dev-db/percona-server-5.7.23.24/temp/var-tests/3/mysqld.1/data/ib_buffer_pool
      2018-11-16T12:43:15.079537Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 181116 15:43:15
      2018-11-16T12:43:15.380035Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
      free(): invalid pointer
      12:43:16 UTC - mysqld got signal 6 ;
      This could be because you hit a bug. It is also possible that this binary
      or one of the libraries it was linked against is corrupt, improperly built,
      or misconfigured. This error can also be caused by malfunctioning hardware.
      Attempting to collect some information that could help diagnose the problem.
      As this is a crash and something is definitely wrong, the information
      collection process might fail.
      Please help us make Percona Server better by reporting any
      bugs at http://bugs.percona.com/
      
      key_buffer_size=1048576
      read_buffer_size=131072
      max_used_connections=1
      max_threads=152
      thread_count=0
      connection_count=0
      It is possible that mysqld could use up to 
      key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 61160 K  bytes of memory
      Hope that's ok; if not, decrease some variables in the equation.
      
      Thread pointer: 0x0
      Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0 thread_stack 0x40000
      /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/percona-server-5.7.23.24_build/sql/mysqld(my_print_stacktrace+0x36)[0x55fedc5e4c56]
      /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/percona-server-5.7.23.24_build/sql/mysqld(handle_fatal_signal+0x454)[0x55fedc445b14]
      /lib64/libpthread.so.0(+0x14a00)[0x7f8aab2f3a00]
      /lib64/libc.so.6(gsignal+0x10b)[0x7f8aaaa4c48b]
      /lib64/libc.so.6(abort+0x121)[0x7f8aaaa35515]
      /lib64/libc.so.6(+0x7ef89)[0x7f8aaaa91f89]
      /lib64/libc.so.6(+0x86ae8)[0x7f8aaaa99ae8]
      /lib64/libc.so.6(+0x8842c)[0x7f8aaaa9b42c]
      /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/percona-server-5.7.23.24_build/sql/mysqld(_Z16sync_check_closev+0x25f)[0x55fedc7b6f2f]
      /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/percona-server-5.7.23.24_build/sql/mysqld(_Z27innobase_shutdown_for_mysqlv+0x30b)[0x55fedc7a690b]
      /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/percona-server-5.7.23.24_build/sql/mysqld(+0xddfd76)[0x55fedc676d76]
      /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/percona-server-5.7.23.24_build/sql/mysqld(_Z22ha_finalize_handlertonP13st_plugin_int+0x2b)[0x55fedbf09cbb]
      /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/percona-server-5.7.23.24_build/sql/mysqld(+0xafa2c9)[0x55fedc3912c9]
      /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/percona-server-5.7.23.24_build/sql/mysqld(+0xaffbf1)[0x55fedc396bf1]
      /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/percona-server-5.7.23.24_build/sql/mysqld(_Z15plugin_shutdownv+0x258)[0x55fedc398668]
      /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/percona-server-5.7.23.24_build/sql/mysqld(+0xba48b1)[0x55fedc43b8b1]
      /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/percona-server-5.7.23.24_build/sql/mysqld(_Z11mysqld_mainiPPc+0x1cac)[0x55fedc4412dc]
      /lib64/libc.so.6(__libc_start_main+0xeb)[0x7f8aaaa3750b]
      /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/percona-server-5.7.23.24_build/sql/mysqld(_start+0x2a)[0x55fedbefe53a]
      You may download the Percona Server operations manual by visiting
      http://www.percona.com/software/percona-server/. You may find information
      in the manual which will help you identify the cause of the crash.
      Writing a core file
      safe_process[78195]: Child process: 78196, killed by signal: 6
      2018-11-16T12:43:18.251983Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
      2018-11-16T12:43:18.253524Z 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory.
      2018-11-16T12:43:18.253537Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
      2018-11-16T12:43:18.253559Z 0 [Note] /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/percona-server-5.7.23.24_build/sql/mysqld (mysqld 5.7.23-24-log) starting as process 78409 ...
      2018-11-16T12:43:18.256561Z 0 [Note] InnoDB: PUNCH HOLE support available
      2018-11-16T12:43:18.256587Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
      2018-11-16T12:43:18.256596Z 0 [Note] InnoDB: Uses event mutexes
      2018-11-16T12:43:18.256604Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
      2018-11-16T12:43:18.256612Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2018-11-16T12:43:18.256620Z 0 [Note] InnoDB: Using Linux native AIO
      2018-11-16T12:43:18.256905Z 0 [Note] InnoDB: Number of pools: 1
      2018-11-16T12:43:18.257009Z 0 [Note] InnoDB: Using CPU crc32 instructions
      2018-11-16T12:43:18.258476Z 0 [Note] InnoDB: Initializing buffer pool, total size = 24M, instances = 1, chunk size = 24M
      2018-11-16T12:43:18.259883Z 0 [Note] InnoDB: Completed initialization of buffer pool
      2018-11-16T12:43:18.260721Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
      2018-11-16T12:43:18.272693Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/tmp/portage/dev-db/percona-server-5.7.23.24/temp/var-tests/3/mysqld.1/data/xb_doublewrite
      2018-11-16T12:43:18.273328Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
      2018-11-16T12:43:18.280755Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/tmp/portage/dev-db/percona-server-5.7.23.24/temp/var-tests/3/mysqld.1/data/xb_doublewrite, size 3932160 bytes
      2018-11-16T12:43:18.292035Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
      2018-11-16T12:43:18.292055Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2018-11-16T12:43:18.292094Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2018-11-16T12:43:18.324315Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
      2018-11-16T12:43:18.325081Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
      2018-11-16T12:43:18.325093Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
      2018-11-16T12:43:18.325373Z 0 [Note] InnoDB: Waiting for purge to start
      2018-11-16T12:43:18.375552Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.23-24 started; log sequence number 5225327
      2018-11-16T12:43:18.375754Z 0 [Note] InnoDB: Creating #1 encryption thread id 139922149193472 total threads 4.
      2018-11-16T12:43:18.375808Z 0 [Note] InnoDB: Creating #2 encryption thread id 139922140800768 total threads 4.
      2018-11-16T12:43:18.375850Z 0 [Note] InnoDB: Creating #3 encryption thread id 139922132408064 total threads 4.
      2018-11-16T12:43:18.375901Z 0 [Note] InnoDB: Creating #4 encryption thread id 139921914328832 total threads 4.
      2018-11-16T12:43:18.375999Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/tmp/portage/dev-db/percona-server-5.7.23.24/temp/var-tests/3/mysqld.1/data/ib_buffer_pool
      2018-11-16T12:43:18.378827Z 0 [Note] Plugin 'FEDERATED' is disabled.
      2018-11-16T12:43:18.392140Z 0 [Warning] unknown variable 'loose-mysqlx-port=10340'
      2018-11-16T12:43:18.392160Z 0 [Warning] unknown variable 'loose-mysqlx-socket=/var/tmp/portage/dev-db/percona-server-5.7.23.24/temp/var-tests/tmp/3/mysqlx.1.sock'
      2018-11-16T12:43:18.392165Z 0 [Warning] unknown variable 'loose-debug-sync-timeout=600'
      2018-11-16T12:43:18.396262Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181116 15:43:18
      2018-11-16T12:43:18.427273Z 0 [Note] Skipping generation of SSL certificates as options related to SSL are specified.
      2018-11-16T12:43:18.427913Z 0 [Warning] CA certificate /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/mysql/mysql-test/std_data/cacert.pem is self signed.
      2018-11-16T12:43:18.427943Z 0 [Note] Skipping generation of RSA key pair as --sha256_password_auto_generate_rsa_keys is set to OFF.
      2018-11-16T12:43:18.427959Z 0 [Note] RSA private key file not found: /var/tmp/portage/dev-db/percona-server-5.7.23.24/temp/var-tests/3/mysqld.1/data//private_key.pem. Some authentication plugins will not work.
      2018-11-16T12:43:18.427967Z 0 [Note] RSA public key file not found: /var/tmp/portage/dev-db/percona-server-5.7.23.24/temp/var-tests/3/mysqld.1/data//public_key.pem. Some authentication plugins will not work.
      2018-11-16T12:43:18.427974Z 0 [Note] Server hostname (bind-address): '*'; port: 10321
      2018-11-16T12:43:18.428011Z 0 [Note] IPv6 is available.
      2018-11-16T12:43:18.428020Z 0 [Note]   - '::' resolves to '::';
      2018-11-16T12:43:18.428071Z 0 [Note] Server socket created on IP: '::'.
      2018-11-16T12:43:18.441318Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
      2018-11-16T12:43:18.453342Z 0 [Note] Event Scheduler: Loaded 0 events
      2018-11-16T12:43:18.453856Z 0 [Note] /var/tmp/portage/dev-db/percona-server-5.7.23.24/work/percona-server-5.7.23.24_build/sql/mysqld: ready for connections.
      Version: '5.7.23-24-log'  socket: '/var/tmp/portage/dev-db/percona-server-5.7.23.24/temp/var-tests/tmp/3/mysqld.1.sock'  port: 10321  Gentoo Linux percona-server-5.7.23.24
      ----------SERVER LOG END-------------
      mysqltest failed but provided no output
      The result from queries just before the failure was:
      < snip >
      create table innodb_normal(c1 bigint not null, b char(200)) engine=innodb;
      create table innodb_compact(c1 bigint not null, b char(200)) engine=innodb row_format=compact;
      create table innodb_dynamic(c1 bigint not null, b char(200)) engine=innodb row_format=dynamic;
      create table innodb_compressed(c1 bigint not null, b char(200)) engine=innodb row_format=compressed;
      create table innodb_redundant(c1 bigint not null, b char(200)) engine=innodb row_format=redundant;
      show warnings;
      Level	Code	Message
      show create table innodb_normal;
      Table	Create Table
      innodb_normal	CREATE TABLE `innodb_normal` (
        `c1` bigint(20) NOT NULL,
        `b` char(200) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ENCRYPTION_KEY_ID=0
      show create table innodb_compact;
      Table	Create Table
      innodb_compact	CREATE TABLE `innodb_compact` (
        `c1` bigint(20) NOT NULL,
        `b` char(200) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT ENCRYPTION_KEY_ID=0
      show create table innodb_dynamic;
      Table	Create Table
      innodb_dynamic	CREATE TABLE `innodb_dynamic` (
        `c1` bigint(20) NOT NULL,
        `b` char(200) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC ENCRYPTION_KEY_ID=0
      show create table innodb_compressed;
      Table	Create Table
      innodb_compressed	CREATE TABLE `innodb_compressed` (
        `c1` bigint(20) NOT NULL,
        `b` char(200) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED ENCRYPTION_KEY_ID=0
      show create table innodb_redundant;
      Table	Create Table
      innodb_redundant	CREATE TABLE `innodb_redundant` (
        `c1` bigint(20) NOT NULL,
        `b` char(200) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT ENCRYPTION_KEY_ID=0
      create procedure innodb_insert_proc (repeat_count int)
      begin
      declare current_num int;
      set current_num = 0;
      while current_num < repeat_count do
      insert into innodb_normal values(current_num, substring(MD5(RAND()), -64));
      set current_num = current_num + 1;
      end while;
      end//
      commit;
      set autocommit=0;
      call innodb_insert_proc(2000);
      commit;
      set autocommit=1;
      insert into innodb_compact select * from innodb_normal;
      insert into innodb_dynamic select * from innodb_normal;
      insert into innodb_compressed select * from innodb_normal;
      insert into innodb_redundant select * from innodb_normal;
      update innodb_normal set c1 = c1 + 1;
      update innodb_compact set c1 = c1 + 1;
      update innodb_dynamic set c1 = c1 + 1;
      update innodb_compressed set c1 = c1 + 1;
      update innodb_redundant set c1 = c1 + 1;
      select count(*) from innodb_normal;
      count(*)
      2000
      select count(*) from innodb_compact where c1 < 1500000;
      count(*)
      2000
      select count(*) from innodb_dynamic where c1 < 1500000;
      count(*)
      2000
      select count(*) from innodb_compressed where c1 < 1500000;
      count(*)
      2000
      select count(*) from innodb_redundant where c1 < 1500000;
      count(*)
      2000
      select count(*) from innodb_compact t1, innodb_normal t2 where
      t1.c1 = t2.c1 and t1.b = t2.b;
      count(*)
      2000
      select count(*) from innodb_dynamic t1, innodb_normal t2 where
      t1.c1 = t2.c1 and t1.b = t2.b;
      count(*)
      2000
      select count(*) from innodb_compressed t1, innodb_normal t2 where
      t1.c1 = t2.c1 and t1.b = t2.b;
      count(*)
      2000
      select count(*) from innodb_redundant t1, innodb_normal t2 where
      t1.c1 = t2.c1 and t1.b = t2.b;
      count(*)
      2000
      SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_encrypted';
      variable_value >= 0
      1
      Warnings:
      Warning	1287	'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead
      SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_decrypted';
      variable_value >= 0
      1
      Warnings:
      Warning	1287	'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead
      SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_page_compressed';
      variable_value >= 0
      Warnings:
      Warning	1287	'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead
      SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_page_decompressed';
      variable_value >= 0
      Warnings:
      Warning	1287	'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead
      # restart
      update innodb_normal set c1 = c1 + 1;
      update innodb_compact set c1 = c1 + 1;
      update innodb_dynamic set c1 = c1 + 1;
      update innodb_compressed set c1 = c1 + 1;
      update innodb_redundant set c1 = c1 + 1;
      select count(*) from innodb_normal;
      count(*)
      2000
      select count(*) from innodb_compact where c1 < 1500000;
      count(*)
      2000
      select count(*) from innodb_dynamic where c1 < 1500000;
      count(*)
      2000
      select count(*) from innodb_compressed where c1 < 1500000;
      count(*)
      2000
      select count(*) from innodb_redundant where c1 < 1500000;
      count(*)
      2000
      select count(*) from innodb_compact t1, innodb_normal t2 where
      t1.c1 = t2.c1 and t1.b = t2.b;
      count(*)
      2000
      select count(*) from innodb_dynamic t1, innodb_normal t2 where
      t1.c1 = t2.c1 and t1.b = t2.b;
      count(*)
      2000
      select count(*) from innodb_compressed t1, innodb_normal t2 where
      t1.c1 = t2.c1 and t1.b = t2.b;
      count(*)
      2000
      select count(*) from innodb_redundant t1, innodb_normal t2 where
      t1.c1 = t2.c1 and t1.b = t2.b;
      count(*)
      2000
      SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_encrypted';
      variable_value >= 0
      1
      Warnings:
      Warning	1287	'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead
      SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_decrypted';
      variable_value >= 0
      1
      Warnings:
      Warning	1287	'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead
      SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_page_compressed';
      variable_value >= 0
      Warnings:
      Warning	1287	'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead
      SELECT variable_value >= 0 FROM information_schema.global_status WHERE variable_name = 'innodb_num_pages_page_decompressed';
      variable_value >= 0
      Warnings:
      Warning	1287	'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead
      drop procedure innodb_insert_proc;
      drop table innodb_normal;
      drop table innodb_compact;
      drop table innodb_dynamic;
      drop table innodb_compressed;
      drop table innodb_redundant;
      
      
       - the logfile can be found in '/var/tmp/portage/dev-db/percona-server-5.7.23.24/temp/var-tests/log/encryption.innodb_encryption_tables/innodb_encryption_tables.log'
      
      Retrying test encryption.innodb_encryption_tables, attempt(2/3)...
      
      worker[2] mysql-test-run: WARNING: Could not find reason for skipping test in /var/tmp/portage/dev-db/percona-server-5.7.23.24/temp/var-tests/2/log/current_test
      encryption.innodb_encryption_discard_import w2 [ skipped ]  Detected by testcase(reason unknown) 
      worker[2] mysql-test-run: WARNING: Could not find reason for skipping test in /var/tmp/portage/dev-db/percona-server-5.7.23.24/temp/var-tests/2/log/current_test
      encryption.innodb_first_page             w2 [ skipped ]  Detected by testcase(reason unknown) 
      encryption.innodb-missing-key            w1 [ pass ]  14782
      encryption.innodb_encryption_tables      w3 [ retry-pass ]   7830
      
      Retrying test encryption.innodb_encryption_tables, attempt(3/3)...
      
      encryption.innodb_encryption_tables      w3 [ retry-pass ]   7680
      

      but like you can see, it is also passing sometimes.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  Whissi Thomas Deutschmann
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: