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

mariabackup.xb_compressed_encrypted fails in buildbot with error 194 "Tablespace is missing for a table"

    XMLWordPrintable

    Details

      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.
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.