[MDEV-26154] mariabackup.xb_compressed_encrypted fails in buildbot with error 194 "Tablespace is missing for a table" Created: 2021-07-15  Updated: 2023-11-22

Status: Open
Project: MariaDB Server
Component/s: Encryption, mariabackup, Tests
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6
Fix Version/s: 10.4, 10.5, 10.6

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MDEV-26326 MDEV-24626 (remove synchronous page0 ... Closed

 Description   

Note: I've set affected versions to all, because the test fails on different versions. However, it's possible that these are different failures, or that they are different representations of the same problem; it has to wait for the analysis to be confirmed

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-x86/builds/10323

10.6 429382c29f2d

 
mariabackup.xb_compressed_encrypted '8k,innodb' w2 [ fail ]
 
        Test ended at 2021-07-15 07:50:03
 
 
 
CURRENT_TEST: mariabackup.xb_compressed_encrypted
 
/usr/bin/mariabackup based on MariaDB server 10.6.4-MariaDB debian-linux-gnu (i686)
 
[01] 2021-07-15 07:50:02 Copying ibdata1 to /dev/shm/var/2/mysqld.1/data/./ibdata1
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./xtrabackup_info to /dev/shm/var/2/mysqld.1/data/xtrabackup_info
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./ib_buffer_pool to /dev/shm/var/2/mysqld.1/data/ib_buffer_pool
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./aria_log_control to /dev/shm/var/2/mysqld.1/data/aria_log_control
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./aria_log.00000001 to /dev/shm/var/2/mysqld.1/data/aria_log.00000001
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./performance_schema/db.opt to /dev/shm/var/2/mysqld.1/data/performance_schema/db.opt
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/db.opt to /dev/shm/var/2/mysqld.1/data/sys/db.opt
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/version.frm to /dev/shm/var/2/mysqld.1/data/sys/version.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/sys_config.frm to /dev/shm/var/2/mysqld.1/data/sys/sys_config.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/sys_config.MAI to /dev/shm/var/2/mysqld.1/data/sys/sys_config.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/sys_config.MAD to /dev/shm/var/2/mysqld.1/data/sys/sys_config.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/sys_config_insert_set_user.TRN to /dev/shm/var/2/mysqld.1/data/sys/sys_config_insert_set_user.TRN
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/sys_config_update_set_user.TRN to /dev/shm/var/2/mysqld.1/data/sys/sys_config_update_set_user.TRN
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/sys_config.TRG to /dev/shm/var/2/mysqld.1/data/sys/sys_config.TRG
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/innodb_buffer_stats_by_schema.frm to /dev/shm/var/2/mysqld.1/data/sys/innodb_buffer_stats_by_schema.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024innodb_buffer_stats_by_schema.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/innodb_buffer_stats_by_table.frm to /dev/shm/var/2/mysqld.1/data/sys/innodb_buffer_stats_by_table.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024innodb_buffer_stats_by_table.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/innodb_lock_waits.frm to /dev/shm/var/2/mysqld.1/data/sys/innodb_lock_waits.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024innodb_lock_waits.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024innodb_lock_waits.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/schema_object_overview.frm to /dev/shm/var/2/mysqld.1/data/sys/schema_object_overview.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/schema_auto_increment_columns.frm to /dev/shm/var/2/mysqld.1/data/sys/schema_auto_increment_columns.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024schema_flattened_keys.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024schema_flattened_keys.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/schema_redundant_indexes.frm to /dev/shm/var/2/mysqld.1/data/sys/schema_redundant_indexes.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/ps_check_lost_instrumentation.frm to /dev/shm/var/2/mysqld.1/data/sys/ps_check_lost_instrumentation.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/latest_file_io.frm to /dev/shm/var/2/mysqld.1/data/sys/latest_file_io.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024latest_file_io.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024latest_file_io.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/io_by_thread_by_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/io_by_thread_by_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024io_by_thread_by_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024io_by_thread_by_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/io_global_by_file_by_bytes.frm to /dev/shm/var/2/mysqld.1/data/sys/io_global_by_file_by_bytes.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024io_global_by_file_by_bytes.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/io_global_by_file_by_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/io_global_by_file_by_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024io_global_by_file_by_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024io_global_by_file_by_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/io_global_by_wait_by_bytes.frm to /dev/shm/var/2/mysqld.1/data/sys/io_global_by_wait_by_bytes.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024io_global_by_wait_by_bytes.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/io_global_by_wait_by_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/io_global_by_wait_by_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024io_global_by_wait_by_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/memory_by_user_by_current_bytes.frm to /dev/shm/var/2/mysqld.1/data/sys/memory_by_user_by_current_bytes.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024memory_by_user_by_current_bytes.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/memory_by_host_by_current_bytes.frm to /dev/shm/var/2/mysqld.1/data/sys/memory_by_host_by_current_bytes.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024memory_by_host_by_current_bytes.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/memory_by_thread_by_current_bytes.frm to /dev/shm/var/2/mysqld.1/data/sys/memory_by_thread_by_current_bytes.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024memory_by_thread_by_current_bytes.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/memory_global_by_current_bytes.frm to /dev/shm/var/2/mysqld.1/data/sys/memory_global_by_current_bytes.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024memory_global_by_current_bytes.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024memory_global_by_current_bytes.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/memory_global_total.frm to /dev/shm/var/2/mysqld.1/data/sys/memory_global_total.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024memory_global_total.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024memory_global_total.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/schema_index_statistics.frm to /dev/shm/var/2/mysqld.1/data/sys/schema_index_statistics.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024schema_index_statistics.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024schema_index_statistics.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024ps_schema_table_statistics_io.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/schema_table_statistics.frm to /dev/shm/var/2/mysqld.1/data/sys/schema_table_statistics.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024schema_table_statistics.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024schema_table_statistics.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/schema_table_statistics_with_buffer.frm to /dev/shm/var/2/mysqld.1/data/sys/schema_table_statistics_with_buffer.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024schema_table_statistics_with_buffer.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/schema_tables_with_full_table_scans.frm to /dev/shm/var/2/mysqld.1/data/sys/schema_tables_with_full_table_scans.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024schema_tables_with_full_table_scans.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/schema_unused_indexes.frm to /dev/shm/var/2/mysqld.1/data/sys/schema_unused_indexes.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/schema_table_lock_waits.frm to /dev/shm/var/2/mysqld.1/data/sys/schema_table_lock_waits.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024schema_table_lock_waits.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024schema_table_lock_waits.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/statement_analysis.frm to /dev/shm/var/2/mysqld.1/data/sys/statement_analysis.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024statement_analysis.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024statement_analysis.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/statements_with_errors_or_warnings.frm to /dev/shm/var/2/mysqld.1/data/sys/statements_with_errors_or_warnings.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024statements_with_errors_or_warnings.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/statements_with_full_table_scans.frm to /dev/shm/var/2/mysqld.1/data/sys/statements_with_full_table_scans.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024statements_with_full_table_scans.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024statements_with_full_table_scans.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024ps_digest_avg_latency_distribution.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /dev/shm/var/2/mysqld.1/data/sys/statements_with_runtimes_in_95th_percentile.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024statements_with_runtimes_in_95th_percentile.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/statements_with_sorting.frm to /dev/shm/var/2/mysqld.1/data/sys/statements_with_sorting.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024statements_with_sorting.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024statements_with_sorting.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/statements_with_temp_tables.frm to /dev/shm/var/2/mysqld.1/data/sys/statements_with_temp_tables.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024statements_with_temp_tables.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024statements_with_temp_tables.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/user_summary_by_file_io_type.frm to /dev/shm/var/2/mysqld.1/data/sys/user_summary_by_file_io_type.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024user_summary_by_file_io_type.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024user_summary_by_file_io_type.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/user_summary_by_file_io.frm to /dev/shm/var/2/mysqld.1/data/sys/user_summary_by_file_io.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024user_summary_by_file_io.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024user_summary_by_file_io.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/user_summary_by_statement_type.frm to /dev/shm/var/2/mysqld.1/data/sys/user_summary_by_statement_type.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024user_summary_by_statement_type.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024user_summary_by_statement_type.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/user_summary_by_statement_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/user_summary_by_statement_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024user_summary_by_statement_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024user_summary_by_statement_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/user_summary_by_stages.frm to /dev/shm/var/2/mysqld.1/data/sys/user_summary_by_stages.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024user_summary_by_stages.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024user_summary_by_stages.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/user_summary.frm to /dev/shm/var/2/mysqld.1/data/sys/user_summary.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024user_summary.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024user_summary.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/host_summary_by_file_io_type.frm to /dev/shm/var/2/mysqld.1/data/sys/host_summary_by_file_io_type.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024host_summary_by_file_io_type.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024host_summary_by_file_io_type.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/host_summary_by_file_io.frm to /dev/shm/var/2/mysqld.1/data/sys/host_summary_by_file_io.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024host_summary_by_file_io.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024host_summary_by_file_io.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/host_summary_by_statement_type.frm to /dev/shm/var/2/mysqld.1/data/sys/host_summary_by_statement_type.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024host_summary_by_statement_type.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024host_summary_by_statement_type.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/host_summary_by_statement_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/host_summary_by_statement_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024host_summary_by_statement_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024host_summary_by_statement_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/host_summary_by_stages.frm to /dev/shm/var/2/mysqld.1/data/sys/host_summary_by_stages.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024host_summary_by_stages.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024host_summary_by_stages.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/host_summary.frm to /dev/shm/var/2/mysqld.1/data/sys/host_summary.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024host_summary.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024host_summary.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/wait_classes_global_by_avg_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/wait_classes_global_by_avg_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024wait_classes_global_by_avg_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/wait_classes_global_by_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/wait_classes_global_by_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024wait_classes_global_by_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024wait_classes_global_by_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/waits_by_user_by_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/waits_by_user_by_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024waits_by_user_by_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024waits_by_user_by_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/waits_by_host_by_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/waits_by_host_by_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024waits_by_host_by_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024waits_by_host_by_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/waits_global_by_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/waits_global_by_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024waits_global_by_latency.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024waits_global_by_latency.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/metrics.frm to /dev/shm/var/2/mysqld.1/data/sys/metrics.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/processlist.frm to /dev/shm/var/2/mysqld.1/data/sys/processlist.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024processlist.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024processlist.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/session.frm to /dev/shm/var/2/mysqld.1/data/sys/session.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/x@0024session.frm to /dev/shm/var/2/mysqld.1/data/sys/x@0024session.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./sys/session_ssl_status.frm to /dev/shm/var/2/mysqld.1/data/sys/session_ssl_status.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./test/db.opt to /dev/shm/var/2/mysqld.1/data/test/db.opt
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./test/t1.frm to /dev/shm/var/2/mysqld.1/data/test/t1.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mtr/db.opt to /dev/shm/var/2/mysqld.1/data/mtr/db.opt
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mtr/test_suppressions.frm to /dev/shm/var/2/mysqld.1/data/mtr/test_suppressions.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mtr/test_suppressions.MYI to /dev/shm/var/2/mysqld.1/data/mtr/test_suppressions.MYI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mtr/test_suppressions.MYD to /dev/shm/var/2/mysqld.1/data/mtr/test_suppressions.MYD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mtr/ts_insert.TRN to /dev/shm/var/2/mysqld.1/data/mtr/ts_insert.TRN
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mtr/test_suppressions.TRG to /dev/shm/var/2/mysqld.1/data/mtr/test_suppressions.TRG
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mtr/global_suppressions.frm to /dev/shm/var/2/mysqld.1/data/mtr/global_suppressions.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mtr/global_suppressions.MYI to /dev/shm/var/2/mysqld.1/data/mtr/global_suppressions.MYI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mtr/global_suppressions.MYD to /dev/shm/var/2/mysqld.1/data/mtr/global_suppressions.MYD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mtr/gs_insert.TRN to /dev/shm/var/2/mysqld.1/data/mtr/gs_insert.TRN
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mtr/global_suppressions.TRG to /dev/shm/var/2/mysqld.1/data/mtr/global_suppressions.TRG
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/db.frm to /dev/shm/var/2/mysqld.1/data/mysql/db.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/db.MAI to /dev/shm/var/2/mysqld.1/data/mysql/db.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/db.MAD to /dev/shm/var/2/mysqld.1/data/mysql/db.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/global_priv.frm to /dev/shm/var/2/mysqld.1/data/mysql/global_priv.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/global_priv.MAI to /dev/shm/var/2/mysqld.1/data/mysql/global_priv.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/global_priv.MAD to /dev/shm/var/2/mysqld.1/data/mysql/global_priv.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/user.frm to /dev/shm/var/2/mysqld.1/data/mysql/user.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/roles_mapping.frm to /dev/shm/var/2/mysqld.1/data/mysql/roles_mapping.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/roles_mapping.MAI to /dev/shm/var/2/mysqld.1/data/mysql/roles_mapping.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/roles_mapping.MAD to /dev/shm/var/2/mysqld.1/data/mysql/roles_mapping.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/func.frm to /dev/shm/var/2/mysqld.1/data/mysql/func.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/func.MAI to /dev/shm/var/2/mysqld.1/data/mysql/func.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/func.MAD to /dev/shm/var/2/mysqld.1/data/mysql/func.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/plugin.frm to /dev/shm/var/2/mysqld.1/data/mysql/plugin.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/plugin.MAI to /dev/shm/var/2/mysqld.1/data/mysql/plugin.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/plugin.MAD to /dev/shm/var/2/mysqld.1/data/mysql/plugin.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/servers.frm to /dev/shm/var/2/mysqld.1/data/mysql/servers.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/servers.MAI to /dev/shm/var/2/mysqld.1/data/mysql/servers.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/servers.MAD to /dev/shm/var/2/mysqld.1/data/mysql/servers.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/tables_priv.frm to /dev/shm/var/2/mysqld.1/data/mysql/tables_priv.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/tables_priv.MAI to /dev/shm/var/2/mysqld.1/data/mysql/tables_priv.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/tables_priv.MAD to /dev/shm/var/2/mysqld.1/data/mysql/tables_priv.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/columns_priv.frm to /dev/shm/var/2/mysqld.1/data/mysql/columns_priv.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/columns_priv.MAI to /dev/shm/var/2/mysqld.1/data/mysql/columns_priv.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/columns_priv.MAD to /dev/shm/var/2/mysqld.1/data/mysql/columns_priv.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/help_topic.frm to /dev/shm/var/2/mysqld.1/data/mysql/help_topic.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/help_topic.MAI to /dev/shm/var/2/mysqld.1/data/mysql/help_topic.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/help_topic.MAD to /dev/shm/var/2/mysqld.1/data/mysql/help_topic.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/help_category.frm to /dev/shm/var/2/mysqld.1/data/mysql/help_category.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/help_category.MAI to /dev/shm/var/2/mysqld.1/data/mysql/help_category.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/help_category.MAD to /dev/shm/var/2/mysqld.1/data/mysql/help_category.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/help_relation.frm to /dev/shm/var/2/mysqld.1/data/mysql/help_relation.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/help_relation.MAI to /dev/shm/var/2/mysqld.1/data/mysql/help_relation.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/help_relation.MAD to /dev/shm/var/2/mysqld.1/data/mysql/help_relation.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/help_keyword.frm to /dev/shm/var/2/mysqld.1/data/mysql/help_keyword.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/help_keyword.MAI to /dev/shm/var/2/mysqld.1/data/mysql/help_keyword.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/help_keyword.MAD to /dev/shm/var/2/mysqld.1/data/mysql/help_keyword.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/time_zone_name.frm to /dev/shm/var/2/mysqld.1/data/mysql/time_zone_name.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/time_zone_name.MAI to /dev/shm/var/2/mysqld.1/data/mysql/time_zone_name.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/time_zone_name.MAD to /dev/shm/var/2/mysqld.1/data/mysql/time_zone_name.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/time_zone.frm to /dev/shm/var/2/mysqld.1/data/mysql/time_zone.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/time_zone.MAI to /dev/shm/var/2/mysqld.1/data/mysql/time_zone.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/time_zone.MAD to /dev/shm/var/2/mysqld.1/data/mysql/time_zone.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/time_zone_transition.frm to /dev/shm/var/2/mysqld.1/data/mysql/time_zone_transition.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/time_zone_transition.MAI to /dev/shm/var/2/mysqld.1/data/mysql/time_zone_transition.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/time_zone_transition.MAD to /dev/shm/var/2/mysqld.1/data/mysql/time_zone_transition.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/time_zone_transition_type.frm to /dev/shm/var/2/mysqld.1/data/mysql/time_zone_transition_type.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/time_zone_transition_type.MAI to /dev/shm/var/2/mysqld.1/data/mysql/time_zone_transition_type.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/time_zone_transition_type.MAD to /dev/shm/var/2/mysqld.1/data/mysql/time_zone_transition_type.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/time_zone_leap_second.frm to /dev/shm/var/2/mysqld.1/data/mysql/time_zone_leap_second.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/time_zone_leap_second.MAI to /dev/shm/var/2/mysqld.1/data/mysql/time_zone_leap_second.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/time_zone_leap_second.MAD to /dev/shm/var/2/mysqld.1/data/mysql/time_zone_leap_second.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/proc.frm to /dev/shm/var/2/mysqld.1/data/mysql/proc.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/proc.MAI to /dev/shm/var/2/mysqld.1/data/mysql/proc.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/proc.MAD to /dev/shm/var/2/mysqld.1/data/mysql/proc.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/procs_priv.frm to /dev/shm/var/2/mysqld.1/data/mysql/procs_priv.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/procs_priv.MAI to /dev/shm/var/2/mysqld.1/data/mysql/procs_priv.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/procs_priv.MAD to /dev/shm/var/2/mysqld.1/data/mysql/procs_priv.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/general_log.frm to /dev/shm/var/2/mysqld.1/data/mysql/general_log.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/general_log.CSM to /dev/shm/var/2/mysqld.1/data/mysql/general_log.CSM
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/general_log.CSV to /dev/shm/var/2/mysqld.1/data/mysql/general_log.CSV
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/slow_log.frm to /dev/shm/var/2/mysqld.1/data/mysql/slow_log.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/slow_log.CSM to /dev/shm/var/2/mysqld.1/data/mysql/slow_log.CSM
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/slow_log.CSV to /dev/shm/var/2/mysqld.1/data/mysql/slow_log.CSV
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/event.frm to /dev/shm/var/2/mysqld.1/data/mysql/event.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/event.MAI to /dev/shm/var/2/mysqld.1/data/mysql/event.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/event.MAD to /dev/shm/var/2/mysqld.1/data/mysql/event.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/innodb_table_stats.frm to /dev/shm/var/2/mysqld.1/data/mysql/innodb_table_stats.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/innodb_index_stats.frm to /dev/shm/var/2/mysqld.1/data/mysql/innodb_index_stats.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/transaction_registry.frm to /dev/shm/var/2/mysqld.1/data/mysql/transaction_registry.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/proxies_priv.frm to /dev/shm/var/2/mysqld.1/data/mysql/proxies_priv.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/proxies_priv.MAI to /dev/shm/var/2/mysqld.1/data/mysql/proxies_priv.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/proxies_priv.MAD to /dev/shm/var/2/mysqld.1/data/mysql/proxies_priv.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/table_stats.frm to /dev/shm/var/2/mysqld.1/data/mysql/table_stats.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/table_stats.MAI to /dev/shm/var/2/mysqld.1/data/mysql/table_stats.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/table_stats.MAD to /dev/shm/var/2/mysqld.1/data/mysql/table_stats.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/column_stats.frm to /dev/shm/var/2/mysqld.1/data/mysql/column_stats.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/column_stats.MAI to /dev/shm/var/2/mysqld.1/data/mysql/column_stats.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/column_stats.MAD to /dev/shm/var/2/mysqld.1/data/mysql/column_stats.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/index_stats.frm to /dev/shm/var/2/mysqld.1/data/mysql/index_stats.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/index_stats.MAI to /dev/shm/var/2/mysqld.1/data/mysql/index_stats.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/index_stats.MAD to /dev/shm/var/2/mysqld.1/data/mysql/index_stats.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/gtid_slave_pos.MAI to /dev/shm/var/2/mysqld.1/data/mysql/gtid_slave_pos.MAI
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/gtid_slave_pos.MAD to /dev/shm/var/2/mysqld.1/data/mysql/gtid_slave_pos.MAD
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/gtid_slave_pos.frm to /dev/shm/var/2/mysqld.1/data/mysql/gtid_slave_pos.frm
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/innodb_table_stats.ibd to /dev/shm/var/2/mysqld.1/data/mysql/innodb_table_stats.ibd
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/innodb_index_stats.ibd to /dev/shm/var/2/mysqld.1/data/mysql/innodb_index_stats.ibd
 
[01] 2021-07-15 07:50:02         ...done
 
[01] 2021-07-15 07:50:02 Copying ./mysql/transaction_registry.ibd to /dev/shm/var/2/mysqld.1/data/mysql/transaction_registry.ibd
 
[01] 2021-07-15 07:50:02         ...done
 
[00] 2021-07-15 07:50:02 completed OK!


mysqltest: At line 29: query 'select sum(c1) from t1' failed: ER_GET_ERRNO (1030): Got error 194 "Tablespace is missing for a table" from storage engine InnoDB
 
 
 
The result from queries just before the failure was:
 
CREATE TABLE t1(c1 INT, b VARCHAR(2400), index(b(100),c1))
 
ENGINE=INNODB ROW_FORMAT=compressed ENCRYPTED=YES;
 
BEGIN;
 
COMMIT;
 
# xtrabackup backup
 
drop table t1;
 
# shutdown server
 
# remove datadir
 
# xtrabackup move back
 
# restart
 
select sum(c1) from t1;

From the error log:

CURRENT_TEST: mariabackup.xb_compressed_encrypted
 
2021-07-15  7:49:58 0 [Note] /usr/sbin/mariadbd (mysqld 10.6.4-MariaDB-1:10.6.4+maria~stretch-log) starting as process 10554 ...
 
2021-07-15  7:49:58 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32186)
 
2021-07-15  7:49:58 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
 
2021-07-15  7:49:58 0 [Note] Plugin 'partition' is disabled.
 
2021-07-15  7:49:58 0 [Note] InnoDB: innodb_page_size=8192
 
2021-07-15  7:49:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
 
2021-07-15  7:49:58 0 [Note] InnoDB: Number of pools: 1
 
2021-07-15  7:49:58 0 [Note] InnoDB: Using generic crc32 instructions
 
2021-07-15  7:49:58 0 [Note] mariadbd: O_TMPFILE is not supported on /dev/shm/var/tmp/2/mysqld.1 (disabling future attempts)
 
2021-07-15  7:49:58 0 [Note] InnoDB: Using Linux native AIO
 
2021-07-15  7:49:58 0 [Note] InnoDB: Initializing buffer pool, total size = 8388608, chunk size = 8388608
 
2021-07-15  7:49:58 0 [Note] InnoDB: Completed initialization of buffer pool
 
2021-07-15  7:49:58 0 [Note] InnoDB: Setting O_DIRECT on file ./ibdata1 failed
 
2021-07-15  7:49:58 0 [Note] InnoDB: 128 rollback segments are active.
 
2021-07-15  7:49:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
2021-07-15  7:49:58 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
 
2021-07-15  7:49:58 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
 
2021-07-15  7:49:58 0 [Note] InnoDB: 10.6.4 started; log sequence number 47091; transaction id 17
 
2021-07-15  7:49:58 0 [Note] InnoDB: Creating #1 encryption thread id 2924477248 total threads 4.
 
2021-07-15  7:49:58 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var/2/mysqld.1/data/ib_buffer_pool
 
2021-07-15  7:49:58 0 [Note] InnoDB: Creating #2 encryption thread id 2916084544 total threads 4.
 
2021-07-15  7:49:58 0 [Note] InnoDB: Creating #3 encryption thread id 2907691840 total threads 4.
 
2021-07-15  7:49:58 0 [Note] InnoDB: Creating #4 encryption thread id 2899299136 total threads 4.
 
2021-07-15  7:49:58 0 [Note] InnoDB: Buffer pool(s) load completed at 210715  7:49:58
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_CMP_PER_INDEX' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_CMP' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'FEEDBACK' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_CMPMEM' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'INNODB_SYS_VIRTUAL' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'user_variables' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
 
2021-07-15  7:49:58 0 [Note] Plugin 'unix_socket' is disabled.
 
2021-07-15  7:49:58 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-startup-interval=20'
 
2021-07-15  7:49:58 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-first-interval=60'
 
2021-07-15  7:49:58 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-interval=60'
 
2021-07-15  7:49:58 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-pam-debug'
 
2021-07-15  7:49:58 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-aria'
 
2021-07-15  7:49:58 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-changed_page_bitmaps'
 
2021-07-15  7:49:58 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-debug-sync-timeout=300'
 
2021-07-15  7:49:58 0 [Note] Server socket created on IP: '127.0.0.1'.
 
2021-07-15  7:49:58 0 [Note] /usr/sbin/mariadbd: ready for connections.
 
Version: '10.6.4-MariaDB-1:10.6.4+maria~stretch-log'  socket: '/dev/shm/var/tmp/2/mysqld.1.sock'  port: 16060  mariadb.org binary distribution
 
2021-07-15  7:50:01 0 [Note] /usr/sbin/mariadbd (initiated by: root[root] @ localhost []): Normal shutdown
 
2021-07-15  7:50:01 0 [Note] InnoDB: FTS optimize thread exiting.
 
2021-07-15  7:50:01 0 [Note] InnoDB: Starting shutdown...
 
2021-07-15  7:50:01 0 [Note] InnoDB: Dumping buffer pool(s) to /dev/shm/var/2/mysqld.1/data/ib_buffer_pool
 
2021-07-15  7:50:01 0 [Note] InnoDB: Restricted to 251 pages due to innodb_buf_pool_dump_pct=25
 
2021-07-15  7:50:01 0 [Note] InnoDB: Buffer pool(s) dump completed at 210715  7:50:01
 
2021-07-15  7:50:01 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
 
2021-07-15  7:50:01 0 [Note] InnoDB: Shutdown completed; log sequence number 2884686; transaction id 23
 
2021-07-15  7:50:01 0 [Note] /usr/sbin/mariadbd: Shutdown complete
 
 
 
2021-07-15  7:50:02 0 [Note] /usr/sbin/mariadbd (mysqld 10.6.4-MariaDB-1:10.6.4+maria~stretch-log) starting as process 10763 ...
 
2021-07-15  7:50:02 0 [Warning] Could not increase number of max_open_files to more than 1024 (request: 32186)
 
2021-07-15  7:50:02 0 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
 
2021-07-15  7:50:02 0 [Note] Plugin 'partition' is disabled.
 
2021-07-15  7:50:02 0 [Note] InnoDB: innodb_page_size=8192
 
2021-07-15  7:50:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
 
2021-07-15  7:50:02 0 [Note] InnoDB: Number of pools: 1
 
2021-07-15  7:50:02 0 [Note] InnoDB: Using generic crc32 instructions
 
2021-07-15  7:50:02 0 [Note] mariadbd: O_TMPFILE is not supported on /dev/shm/var/tmp/2/mysqld.1 (disabling future attempts)
 
2021-07-15  7:50:02 0 [Note] InnoDB: Using Linux native AIO
 
2021-07-15  7:50:02 0 [Note] InnoDB: Initializing buffer pool, total size = 8388608, chunk size = 8388608
 
2021-07-15  7:50:02 0 [Note] InnoDB: Completed initialization of buffer pool
 
2021-07-15  7:50:02 0 [Note] InnoDB: Setting O_DIRECT on file ./ibdata1 failed
 
2021-07-15  7:50:02 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 10485760 bytes
 
2021-07-15  7:50:02 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
 
2021-07-15  7:50:02 0 [Note] InnoDB: New log file created, LSN=2883956
 
2021-07-15  7:50:02 0 [Note] InnoDB: 128 rollback segments are active.
 
2021-07-15  7:50:02 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
 
2021-07-15  7:50:02 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
 
2021-07-15  7:50:02 0 [ERROR] InnoDB: Cannot open datafile for read-only: './test/t1.ibd' OS error: 71
 
2021-07-15  7:50:02 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
 
2021-07-15  7:50:02 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
 
2021-07-15  7:50:02 0 [ERROR] InnoDB: Could not find a valid tablespace file for test/t1. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
 
2021-07-15  7:50:02 0 [Warning] InnoDB: Ignoring tablespace for test/t1 because it could not be opened.
 
2021-07-15  7:50:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
 
2021-07-15  7:50:02 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
 
2021-07-15  7:50:02 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
 
2021-07-15  7:50:02 0 [Note] InnoDB: 10.6.4 started; log sequence number 0; transaction id 23
 
2021-07-15  7:50:02 0 [Note] InnoDB: Creating #1 encryption thread id 2924477248 total threads 4.
 
2021-07-15  7:50:02 0 [Note] InnoDB: Creating #2 encryption thread id 2916084544 total threads 4.
 
2021-07-15  7:50:02 0 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var/2/mysqld.1/data/ib_buffer_pool
 
2021-07-15  7:50:02 0 [Note] InnoDB: Creating #3 encryption thread id 2907691840 total threads 4.
 
2021-07-15  7:50:02 0 [Note] InnoDB: Creating #4 encryption thread id 2899299136 total threads 4.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_CMP_PER_INDEX' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_CMP' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'THREAD_POOL_WAITS' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'THREAD_POOL_QUEUES' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'FEEDBACK' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_CMPMEM' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'THREAD_POOL_GROUPS' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'INNODB_SYS_VIRTUAL' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'user_variables' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'THREAD_POOL_STATS' is disabled.
 
2021-07-15  7:50:02 0 [Note] Plugin 'unix_socket' is disabled.
 
2021-07-15  7:50:02 0 [Note] InnoDB: Buffer pool(s) load completed at 210715  7:50:02
 
2021-07-15  7:50:02 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-startup-interval=20'
 
2021-07-15  7:50:02 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-first-interval=60'
 
2021-07-15  7:50:02 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-feedback-debug-interval=60'
 
2021-07-15  7:50:02 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-pam-debug'
 
2021-07-15  7:50:02 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-aria'
 
2021-07-15  7:50:02 0 [Warning] /usr/sbin/mariadbd: unknown option '--loose-changed_page_bitmaps'


2021-07-15  7:50:02 0 [Warning] /usr/sbin/mariadbd: unknown variable 'loose-debug-sync-timeout=300'
 
2021-07-15  7:50:02 0 [ERROR] InnoDB: Failed to find tablespace for table `test`.`t1` in the cache. Attempting to load the tablespace with space id 5
 
2021-07-15  7:50:02 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
 
2021-07-15  7:50:02 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
 
2021-07-15  7:50:02 0 [ERROR] InnoDB: Cannot open datafile for read-only: './test/t1.ibd' OS error: 71
 
2021-07-15  7:50:02 0 [ERROR] InnoDB: Operating system error number 2 in a file operation.
 
2021-07-15  7:50:02 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
 
2021-07-15  7:50:02 0 [ERROR] InnoDB: Could not find a valid tablespace file for test/t1. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.



 Comments   
Comment by Marko Mäkelä [ 2022-01-12 ]

I think that the 10.6 version can be fully explained by MDEV-26326.

Note: There are two variants of the error message. The variant "Tablespace is missing for table" (ER_TABLESPACE_MISSING, without the "a") is much more rare than the HA_ERR_TABLESPACE_MISSING.

I did not find either failure variant for versions older than 10.6. Can you please provide examples of failures for 10.2 to 10.5?

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