[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.