# mariabackup --backup --target-dir=/backup --user=root --password=root [00] 2024-02-02 10:15:38 Connecting to MariaDB server host: localhost, user: root, password: set, port: not set, socket: not set [00] 2024-02-02 10:15:38 Using server version 10.11.6-MariaDB-log mariabackup based on MariaDB server 10.11.6-MariaDB Linux (x86_64) [00] 2024-02-02 10:15:38 uses posix_fadvise(). [00] 2024-02-02 10:15:38 cd to /var/lib/mysql/ [00] 2024-02-02 10:15:38 open files limit requested 0, set to 1024 [00] 2024-02-02 10:15:38 mariabackup: using the following InnoDB configuration: [00] 2024-02-02 10:15:38 innodb_data_home_dir = [00] 2024-02-02 10:15:38 innodb_data_file_path = ibdata1:12M:autoextend [00] 2024-02-02 10:15:38 innodb_log_group_home_dir = ./ [00] 2024-02-02 10:15:38 InnoDB: Using Linux native AIO 2024-02-02 10:15:38 0 [Note] InnoDB: Number of transaction pools: 1 2024-02-02 10:15:38 0 [Note] InnoDB: Buffered log writes (block size=512 bytes) [00] 2024-02-02 10:15:38 mariabackup: Generating a list of tablespaces [00] 2024-02-02 10:15:38 DDL tracking : create 23 "./testdb/#sql-alter-4a39-9.ibd" [01] 2024-02-02 10:15:38 Copying ./testdb/test_data.ibd to /backup/testdb/test_data.ibd [01] 2024-02-02 10:15:47 ...done [01] 2024-02-02 10:15:47 Copying ./testdb/partitioned_table#P#part1.ibd to /backup/testdb/partitioned_table#P#part1.ibd [01] 2024-02-02 10:15:47 ...done [01] 2024-02-02 10:15:47 Copying ./testdb/partitioned_table#P#part2.ibd to /backup/testdb/partitioned_table#P#part2.ibd [01] 2024-02-02 10:15:47 ...done [01] 2024-02-02 10:15:47 Copying ./testdb/test_data2.ibd to /backup/testdb/test_data2.ibd [01] 2024-02-02 10:16:01 ...done [01] 2024-02-02 10:16:01 Copying ./testdb/test.ibd to /backup/testdb/test.ibd [01] 2024-02-02 10:16:02 ...done [01] 2024-02-02 10:16:03 Copying ./testdb/example_table.ibd to /backup/testdb/example_table.ibd [01] 2024-02-02 10:16:03 ...done [01] 2024-02-02 10:16:03 Copying ./testdb/test_data1.ibd to /backup/testdb/test_data1.ibd [00] 2024-02-02 10:16:11 Retrying read of log at LSN=2892744515 [00] 2024-02-02 10:16:12 Retrying read of log at LSN=2892744515 [00] 2024-02-02 10:16:13 Retrying read of log at LSN=2892744515 [00] 2024-02-02 10:16:14 Retrying read of log at LSN=2892744515 [00] 2024-02-02 10:16:15 Retrying read of log at LSN=2892744515 [00] 2024-02-02 10:16:16 Retrying read of log at LSN=2892744515 [01] 2024-02-02 10:16:17 ...done [01] 2024-02-02 10:16:17 Copying ./mysql/transaction_registry.ibd to /backup/mysql/transaction_registry.ibd [01] 2024-02-02 10:16:17 ...done [01] 2024-02-02 10:16:17 Copying ./mysql/gtid_slave_pos.ibd to /backup/mysql/gtid_slave_pos.ibd [01] 2024-02-02 10:16:17 ...done [01] 2024-02-02 10:16:17 Copying ./mysql/innodb_table_stats.ibd to /backup/mysql/innodb_table_stats.ibd [01] 2024-02-02 10:16:17 ...done [01] 2024-02-02 10:16:17 Copying ./mysql/innodb_index_stats.ibd to /backup/mysql/innodb_index_stats.ibd [01] 2024-02-02 10:16:17 ...done [01] 2024-02-02 10:16:17 Copying ibdata1 to /backup/ibdata1 [00] 2024-02-02 10:16:18 Retrying read of log at LSN=2892744515 [00] 2024-02-02 10:16:19 Retrying read of log at LSN=2892744515 [00] 2024-02-02 10:16:20 Retrying read of log at LSN=2892744515 [01] 2024-02-02 10:16:21 ...done [00] 2024-02-02 10:16:21 Acquiring BACKUP LOCKS... [00] 2024-02-02 10:16:21 Retrying read of log at LSN=2892744515 [00] 2024-02-02 10:16:21 Starting to backup non-InnoDB tables and files [01] 2024-02-02 10:16:21 Copying ./testdb/partitioned_table.par to /backup/testdb/partitioned_table.par [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./testdb/test_data1.frm to /backup/testdb/test_data1.frm [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Skipping ./testdb/#sql-alter-4a39-9.ibd. [01] 2024-02-02 10:16:21 Copying ./testdb/db.opt to /backup/testdb/db.opt [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Skipping ./testdb/#sql-alter-4a39-9.frm. [01] 2024-02-02 10:16:21 Copying ./testdb/partitioned_table.frm to /backup/testdb/partitioned_table.frm [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./testdb/test_data2.frm to /backup/testdb/test_data2.frm [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./testdb/test_data.frm to /backup/testdb/test_data.frm [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./testdb/test.frm to /backup/testdb/test.frm [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./testdb/example_table.frm to /backup/testdb/example_table.frm [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./mysql/column_stats.MAI to /backup/mysql/column_stats.MAI [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./mysql/help_keyword.MAD to /backup/mysql/help_keyword.MAD [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./mysql/help_topic.frm to /backup/mysql/help_topic.frm [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./mysql/tables_priv.frm to /backup/mysql/tables_priv.frm [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./mysql/table_stats.MAD to /backup/mysql/table_stats.MAD [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./mysql/general_log.CSM to /backup/mysql/general_log.CSM [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./mysql/plugin.MAD to /backup/mysql/plugin.MAD [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./mysql/help_relation.MAD to /backup/mysql/help_relation.MAD [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./mysql/tables_priv.MAI to /backup/mysql/tables_priv.MAI [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./mysql/servers.MAD to /backup/mysql/servers.MAD [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./mysql/plugin.frm to /backup/mysql/plugin.frm [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./mysql/columns_priv.frm to /backup/mysql/columns_priv.frm [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./mysql/help_category.MAI to /backup/mysql/help_category.MAI [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./mysql/time_zone_transition_type.frm to /backup/mysql/time_zone_transition_type.frm [01] 2024-02-02 10:16:21 ...done [01] 2024-02-02 10:16:21 Copying ./mysql/help_topic.MAD to /backup/mysql/help_topic.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/func.MAI to /backup/mysql/func.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/time_zone.MAI to /backup/mysql/time_zone.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/procs_priv.frm to /backup/mysql/procs_priv.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/index_stats.frm to /backup/mysql/index_stats.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/help_keyword.MAI to /backup/mysql/help_keyword.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/table_stats.frm to /backup/mysql/table_stats.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/index_stats.MAD to /backup/mysql/index_stats.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/general_log.frm to /backup/mysql/general_log.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/help_relation.MAI to /backup/mysql/help_relation.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/global_priv.frm to /backup/mysql/global_priv.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/db.opt to /backup/mysql/db.opt [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/time_zone_transition.MAD to /backup/mysql/time_zone_transition.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/slow_log.CSM to /backup/mysql/slow_log.CSM [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/help_category.MAD to /backup/mysql/help_category.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/innodb_index_stats.frm to /backup/mysql/innodb_index_stats.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/help_keyword.frm to /backup/mysql/help_keyword.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/time_zone_transition_type.MAI to /backup/mysql/time_zone_transition_type.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/time_zone.MAD to /backup/mysql/time_zone.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/column_stats.MAD to /backup/mysql/column_stats.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/slow_log.CSV to /backup/mysql/slow_log.CSV [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/help_topic.MAI to /backup/mysql/help_topic.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/roles_mapping.MAI to /backup/mysql/roles_mapping.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/time_zone_name.MAD to /backup/mysql/time_zone_name.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/proc.MAI to /backup/mysql/proc.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/index_stats.MAI to /backup/mysql/index_stats.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/db.frm to /backup/mysql/db.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/time_zone_leap_second.frm to /backup/mysql/time_zone_leap_second.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/proxies_priv.frm to /backup/mysql/proxies_priv.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/event.frm to /backup/mysql/event.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/procs_priv.MAD to /backup/mysql/procs_priv.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/column_stats.frm to /backup/mysql/column_stats.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/global_priv.MAD to /backup/mysql/global_priv.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/innodb_table_stats.frm to /backup/mysql/innodb_table_stats.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/help_relation.frm to /backup/mysql/help_relation.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/time_zone_transition_type.MAD to /backup/mysql/time_zone_transition_type.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/event.MAD to /backup/mysql/event.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/servers.frm to /backup/mysql/servers.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/time_zone_transition.MAI to /backup/mysql/time_zone_transition.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/roles_mapping.frm to /backup/mysql/roles_mapping.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/func.MAD to /backup/mysql/func.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/table_stats.MAI to /backup/mysql/table_stats.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/time_zone.frm to /backup/mysql/time_zone.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/proxies_priv.MAD to /backup/mysql/proxies_priv.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/slow_log.frm to /backup/mysql/slow_log.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/gtid_slave_pos.frm to /backup/mysql/gtid_slave_pos.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/event.MAI to /backup/mysql/event.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/servers.MAI to /backup/mysql/servers.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/general_log.CSV to /backup/mysql/general_log.CSV [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/db.MAI to /backup/mysql/db.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/proxies_priv.MAI to /backup/mysql/proxies_priv.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/procs_priv.MAI to /backup/mysql/procs_priv.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/time_zone_transition.frm to /backup/mysql/time_zone_transition.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/tables_priv.MAD to /backup/mysql/tables_priv.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/time_zone_name.frm to /backup/mysql/time_zone_name.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/global_priv.MAI to /backup/mysql/global_priv.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/plugin.MAI to /backup/mysql/plugin.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/time_zone_leap_second.MAI to /backup/mysql/time_zone_leap_second.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/db.MAD to /backup/mysql/db.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/func.frm to /backup/mysql/func.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/roles_mapping.MAD to /backup/mysql/roles_mapping.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/time_zone_name.MAI to /backup/mysql/time_zone_name.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/time_zone_leap_second.MAD to /backup/mysql/time_zone_leap_second.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/help_category.frm to /backup/mysql/help_category.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/transaction_registry.frm to /backup/mysql/transaction_registry.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/user.frm to /backup/mysql/user.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/proc.frm to /backup/mysql/proc.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/proc.MAD to /backup/mysql/proc.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/columns_priv.MAI to /backup/mysql/columns_priv.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./mysql/columns_priv.MAD to /backup/mysql/columns_priv.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./test/db.opt to /backup/test/db.opt [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/session_ssl_status.frm to /backup/sys/session_ssl_status.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/io_global_by_wait_by_latency.frm to /backup/sys/io_global_by_wait_by_latency.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/schema_unused_indexes.frm to /backup/sys/schema_unused_indexes.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/statement_analysis.frm to /backup/sys/statement_analysis.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/schema_table_statistics.frm to /backup/sys/schema_table_statistics.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/waits_by_user_by_latency.frm to /backup/sys/waits_by_user_by_latency.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/statements_with_full_table_scans.frm to /backup/sys/statements_with_full_table_scans.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/wait_classes_global_by_avg_latency.frm to /backup/sys/wait_classes_global_by_avg_latency.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/user_summary_by_file_io.frm to /backup/sys/user_summary_by_file_io.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024user_summary_by_statement_latency.frm to /backup/sys/x@0024user_summary_by_statement_latency.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024host_summary.frm to /backup/sys/x@0024host_summary.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/user_summary_by_statement_type.frm to /backup/sys/user_summary_by_statement_type.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/host_summary_by_statement_latency.frm to /backup/sys/host_summary_by_statement_latency.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024statements_with_full_table_scans.frm to /backup/sys/x@0024statements_with_full_table_scans.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/io_by_thread_by_latency.frm to /backup/sys/io_by_thread_by_latency.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/user_summary_by_stages.frm to /backup/sys/user_summary_by_stages.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024io_global_by_wait_by_bytes.frm to /backup/sys/x@0024io_global_by_wait_by_bytes.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/user_summary.frm to /backup/sys/user_summary.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024host_summary_by_file_io_type.frm to /backup/sys/x@0024host_summary_by_file_io_type.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/latest_file_io.frm to /backup/sys/latest_file_io.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024io_global_by_file_by_latency.frm to /backup/sys/x@0024io_global_by_file_by_latency.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024schema_tables_with_full_table_scans.frm to /backup/sys/x@0024schema_tables_with_full_table_scans.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/schema_tables_with_full_table_scans.frm to /backup/sys/schema_tables_with_full_table_scans.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/io_global_by_wait_by_bytes.frm to /backup/sys/io_global_by_wait_by_bytes.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/user_summary_by_file_io_type.frm to /backup/sys/user_summary_by_file_io_type.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/memory_by_thread_by_current_bytes.frm to /backup/sys/memory_by_thread_by_current_bytes.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024memory_by_user_by_current_bytes.frm to /backup/sys/x@0024memory_by_user_by_current_bytes.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024innodb_buffer_stats_by_schema.frm to /backup/sys/x@0024innodb_buffer_stats_by_schema.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024host_summary_by_statement_type.frm to /backup/sys/x@0024host_summary_by_statement_type.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024user_summary_by_statement_type.frm to /backup/sys/x@0024user_summary_by_statement_type.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/statements_with_temp_tables.frm to /backup/sys/statements_with_temp_tables.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024processlist.frm to /backup/sys/x@0024processlist.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024innodb_lock_waits.frm to /backup/sys/x@0024innodb_lock_waits.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024wait_classes_global_by_avg_latency.frm to /backup/sys/x@0024wait_classes_global_by_avg_latency.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024host_summary_by_stages.frm to /backup/sys/x@0024host_summary_by_stages.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024waits_global_by_latency.frm to /backup/sys/x@0024waits_global_by_latency.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/schema_object_overview.frm to /backup/sys/schema_object_overview.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024io_global_by_wait_by_latency.frm to /backup/sys/x@0024io_global_by_wait_by_latency.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/innodb_buffer_stats_by_table.frm to /backup/sys/innodb_buffer_stats_by_table.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024wait_classes_global_by_latency.frm to /backup/sys/x@0024wait_classes_global_by_latency.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/host_summary_by_statement_type.frm to /backup/sys/host_summary_by_statement_type.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/db.opt to /backup/sys/db.opt [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024io_by_thread_by_latency.frm to /backup/sys/x@0024io_by_thread_by_latency.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/io_global_by_file_by_latency.frm to /backup/sys/io_global_by_file_by_latency.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/host_summary.frm to /backup/sys/host_summary.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/memory_by_host_by_current_bytes.frm to /backup/sys/memory_by_host_by_current_bytes.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/schema_table_statistics_with_buffer.frm to /backup/sys/schema_table_statistics_with_buffer.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024memory_by_host_by_current_bytes.frm to /backup/sys/x@0024memory_by_host_by_current_bytes.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024schema_table_statistics_with_buffer.frm to /backup/sys/x@0024schema_table_statistics_with_buffer.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/schema_table_lock_waits.frm to /backup/sys/schema_table_lock_waits.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024io_global_by_file_by_bytes.frm to /backup/sys/x@0024io_global_by_file_by_bytes.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024waits_by_host_by_latency.frm to /backup/sys/x@0024waits_by_host_by_latency.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024statement_analysis.frm to /backup/sys/x@0024statement_analysis.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/schema_auto_increment_columns.frm to /backup/sys/schema_auto_increment_columns.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/memory_by_user_by_current_bytes.frm to /backup/sys/memory_by_user_by_current_bytes.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024user_summary_by_file_io.frm to /backup/sys/x@0024user_summary_by_file_io.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/host_summary_by_file_io.frm to /backup/sys/host_summary_by_file_io.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/sys_config.MAI to /backup/sys/sys_config.MAI [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024statements_with_temp_tables.frm to /backup/sys/x@0024statements_with_temp_tables.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024statements_with_sorting.frm to /backup/sys/x@0024statements_with_sorting.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024user_summary_by_stages.frm to /backup/sys/x@0024user_summary_by_stages.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024schema_table_statistics.frm to /backup/sys/x@0024schema_table_statistics.frm [00] 2024-02-02 10:16:22 Retrying read of log at LSN=2892744515 [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024schema_flattened_keys.frm to /backup/sys/x@0024schema_flattened_keys.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /backup/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/statements_with_runtimes_in_95th_percentile.frm to /backup/sys/statements_with_runtimes_in_95th_percentile.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024session.frm to /backup/sys/x@0024session.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024schema_index_statistics.frm to /backup/sys/x@0024schema_index_statistics.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/version.frm to /backup/sys/version.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/processlist.frm to /backup/sys/processlist.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024host_summary_by_file_io.frm to /backup/sys/x@0024host_summary_by_file_io.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /backup/sys/x@0024statements_with_runtimes_in_95th_percentile.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024schema_table_lock_waits.frm to /backup/sys/x@0024schema_table_lock_waits.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024memory_by_thread_by_current_bytes.frm to /backup/sys/x@0024memory_by_thread_by_current_bytes.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024memory_global_total.frm to /backup/sys/x@0024memory_global_total.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/innodb_lock_waits.frm to /backup/sys/innodb_lock_waits.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024latest_file_io.frm to /backup/sys/x@0024latest_file_io.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/sys_config.MAD to /backup/sys/sys_config.MAD [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024innodb_buffer_stats_by_table.frm to /backup/sys/x@0024innodb_buffer_stats_by_table.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/memory_global_by_current_bytes.frm to /backup/sys/memory_global_by_current_bytes.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/innodb_buffer_stats_by_schema.frm to /backup/sys/innodb_buffer_stats_by_schema.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024user_summary_by_file_io_type.frm to /backup/sys/x@0024user_summary_by_file_io_type.frm [01] 2024-02-02 10:16:22 ...done [01] 2024-02-02 10:16:22 Copying ./sys/x@0024waits_by_user_by_latency.frm to /backup/sys/x@0024waits_by_user_by_latency.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/waits_global_by_latency.frm to /backup/sys/waits_global_by_latency.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/x@0024memory_global_by_current_bytes.frm to /backup/sys/x@0024memory_global_by_current_bytes.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/x@0024user_summary.frm to /backup/sys/x@0024user_summary.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/statements_with_sorting.frm to /backup/sys/statements_with_sorting.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/user_summary_by_statement_latency.frm to /backup/sys/user_summary_by_statement_latency.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/metrics.frm to /backup/sys/metrics.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/session.frm to /backup/sys/session.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/sys_config.frm to /backup/sys/sys_config.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/host_summary_by_stages.frm to /backup/sys/host_summary_by_stages.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/x@0024statements_with_errors_or_warnings.frm to /backup/sys/x@0024statements_with_errors_or_warnings.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/io_global_by_file_by_bytes.frm to /backup/sys/io_global_by_file_by_bytes.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/statements_with_errors_or_warnings.frm to /backup/sys/statements_with_errors_or_warnings.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/ps_check_lost_instrumentation.frm to /backup/sys/ps_check_lost_instrumentation.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/schema_index_statistics.frm to /backup/sys/schema_index_statistics.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/schema_redundant_indexes.frm to /backup/sys/schema_redundant_indexes.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/x@0024host_summary_by_statement_latency.frm to /backup/sys/x@0024host_summary_by_statement_latency.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/waits_by_host_by_latency.frm to /backup/sys/waits_by_host_by_latency.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/memory_global_total.frm to /backup/sys/memory_global_total.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/x@0024ps_digest_avg_latency_distribution.frm to /backup/sys/x@0024ps_digest_avg_latency_distribution.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/x@0024ps_schema_table_statistics_io.frm to /backup/sys/x@0024ps_schema_table_statistics_io.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/host_summary_by_file_io_type.frm to /backup/sys/host_summary_by_file_io_type.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./sys/wait_classes_global_by_latency.frm to /backup/sys/wait_classes_global_by_latency.frm [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying ./performance_schema/db.opt to /backup/performance_schema/db.opt [01] 2024-02-02 10:16:23 ...done [00] 2024-02-02 10:16:23 Finished backing up non-InnoDB tables and files [01] 2024-02-02 10:16:23 Copying /var/lib/mysql//aria_log_control to /backup/aria_log_control [01] 2024-02-02 10:16:23 ...done [01] 2024-02-02 10:16:23 Copying /var/lib/mysql//aria_log.00000001 to /backup/aria_log.00000001 [01] 2024-02-02 10:16:23 ...done [00] 2024-02-02 10:16:23 Waiting for log copy thread to read lsn 3030682034 [00] 2024-02-02 10:16:24 Retrying read of log at LSN=2892744515 [00] 2024-02-02 10:16:25 Retrying read of log at LSN=2892744515 [00] 2024-02-02 10:16:26 Retrying read of log at LSN=2892744515 [00] 2024-02-02 10:16:27 Retrying read of log at LSN=2892744515 [00] FATAL ERROR: 2024-02-02 10:16:28 Was only able to copy log from 2825766826 to 2892744515, not 3030682034; try increasing innodb_log_file_size