贴上已经试过check，optimize，都正常
这张表的数据量如果不大的话，可以尝试使用逻辑导出后，删除原来，再重新导入。然后，再尝试xtrabackup工具导出。
我也试过，但过几天又报类似错误
表结构发下吧
| avis_logs | CREATE TABLE avis_logs (
id bigint(20) NOT NULL,
platform varchar(50) NOT NULL,
level int(11) DEFAULT NULL,
module varchar(200) DEFAULT NULL,
location varchar(100) DEFAULT NULL,
inst_name varchar(80) DEFAULT NULL,
dept_name varchar(80) DEFAULT NULL,
content text,
consume_time bigint(20) DEFAULT NULL,
create_date datetime NOT NULL,
creator varchar(25) NOT NULL,
hosp_id int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
xtrabackup 完整备份日志发一下。 特别是报错的
这个是 innodb 类型的表 。 上面的 没有作用
查看一下数据库的Error日志，看看里面是否有和那张表相关的报错内容
[root@amysql mysqlbackup]# innobackupex --defaults-file=/etc/my.cnf -u root --parallel=4 /app/mysqlbackup/physic/
xtrabackup: recognized server arguments: --datadir=/app/mysqldb/mysqldata --server-id=1 --open_files_limit=65535 --log_bin=/app/mysqldb/mysqlbin/mysql-bin --innodb_data_file_path=ibdata1:200M;ibdata2:200M:autoextend --innodb_log_files_in_group=3 --innodb_log_buffer_size=2M --innodb_log_file_size=100M --innodb_file_per_table=1 --innodb_open_files=500 --innodb_buffer_pool_size=4096M --innodb_io_capacity=2000 --innodb_write_io_threads=8 --innodb_read_io_threads=8 --innodb_flush_log_at_trx_commit=2 --innodb_max_dirty_pages_pct=80 --parallel=4
xtrabackup: recognized client arguments:
240321 14:49:23 innobackupex: Starting the backup operation
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints “completed OK!”.
240321 14:49:23 version_check Connecting to MySQL server with DSN ‘dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/app/mysqldb/mysql.sock’ as ‘root’ (using password: YES).
240321 14:49:23 version_check Connected to MySQL server
240321 14:49:23 version_check Executing a version check against the server…
240321 14:49:23 version_check Done.
240321 14:49:23 Connecting to MySQL server host: localhost, user: root, password: set, port: 3306, socket: /app/mysqldb/mysql.sock
Using server version 5.7.40-log
innobackupex version 2.4.29 based on MySQL server 5.7.44 Linux (x86_64) (revision id: 2e6c0951)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /app/mysqldb/mysqldata
xtrabackup: open files limit requested 65535, set to 655360
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = .
xtrabackup: innodb_data_file_path = ibdata1:200M;ibdata2:200M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 104857600
InnoDB: Number of pools: 1
240321 14:49:23 >> log scanned up to (13065030403)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 2 for mysql/plugin, old maximum was 0
240321 14:49:24 >> log scanned up to (13065030403)
xtrabackup: Starting 4 threads for parallel data files transfer
240321 14:49:25 [01] Copying ./ibdata1 to /app/mysqlbackup/physic/2024-03-21_14-49-23/ibdata1
240321 14:49:25 [04] Copying ./mysql/servers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/servers.ibd
240321 14:49:25 [03] Copying ./mysql/plugin.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/plugin.ibd
240321 14:49:25 [04] …done
240321 14:49:25 [03] …done
240321 14:49:25 [02] Copying ./ibdata2 to /app/mysqlbackup/physic/2024-03-21_14-49-23/ibdata2
240321 14:49:25 [04] Copying ./mysql/help_topic.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/help_topic.ibd
240321 14:49:25 >> log scanned up to (13065030403)
240321 14:49:25 [04] …done
240321 14:49:25 [03] Copying ./mysql/help_category.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/help_category.ibd
240321 14:49:25 [03] …done
240321 14:49:25 [03] Copying ./mysql/help_relation.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/help_relation.ibd
240321 14:49:25 [03] …done
240321 14:49:26 [04] Copying ./mysql/help_keyword.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/help_keyword.ibd
240321 14:49:26 [04] …done
240321 14:49:26 [03] Copying ./mysql/time_zone_name.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/time_zone_name.ibd
240321 14:49:26 [03] …done
240321 14:49:26 [04] Copying ./mysql/time_zone.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/time_zone.ibd
240321 14:49:26 [04] …done
240321 14:49:26 [04] Copying ./mysql/time_zone_transition_type.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/time_zone_transition_type.ibd
240321 14:49:26 [03] Copying ./mysql/time_zone_transition.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/time_zone_transition.ibd
240321 14:49:26 [04] …done
240321 14:49:26 [03] …done
240321 14:49:26 [04] Copying ./mysql/time_zone_leap_second.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/time_zone_leap_second.ibd
240321 14:49:26 [04] …done
240321 14:49:26 [03] Copying ./mysql/innodb_table_stats.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/innodb_table_stats.ibd
240321 14:49:26 [03] …done
240321 14:49:26 [01] …done
240321 14:49:26 >> log scanned up to (13065030767)
240321 14:49:26 [04] Copying ./mysql/innodb_index_stats.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/innodb_index_stats.ibd
240321 14:49:26 [03] Copying ./mysql/slave_master_info.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/slave_master_info.ibd
240321 14:49:26 [01] Copying ./mysql/slave_relay_log_info.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/slave_relay_log_info.ibd
240321 14:49:26 [03] …done
240321 14:49:26 [01] …done
240321 14:49:26 [04] …done
240321 14:49:26 [03] Copying ./mysql/slave_worker_info.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/slave_worker_info.ibd
240321 14:49:26 [03] …done
240321 14:49:26 [01] Copying ./mysql/gtid_executed.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/gtid_executed.ibd
240321 14:49:26 [01] …done
240321 14:49:26 [03] Copying ./mysql/server_cost.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/server_cost.ibd
240321 14:49:26 [03] …done
240321 14:49:26 [04] Copying ./mysql/engine_cost.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/mysql/engine_cost.ibd
240321 14:49:26 [01] Copying ./sys/sys_config.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/sys/sys_config.ibd
240321 14:49:26 [04] …done
240321 14:49:26 [01] …done
240321 14:49:26 [03] Copying ./bootdo/act_evt_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_evt_log.ibd
240321 14:49:26 [03] …done
240321 14:49:26 [04] Copying ./bootdo/act_ge_bytearray.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_ge_bytearray.ibd
240321 14:49:26 [01] Copying ./bootdo/act_ge_property.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_ge_property.ibd
240321 14:49:26 [04] …done
240321 14:49:26 [01] …done
240321 14:49:26 [02] …done
240321 14:49:26 [03] Copying ./bootdo/act_hi_actinst.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_hi_actinst.ibd
240321 14:49:26 [03] …done
240321 14:49:26 [01] Copying ./bootdo/act_hi_attachment.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_hi_attachment.ibd
240321 14:49:26 [04] Copying ./bootdo/act_hi_comment.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_hi_comment.ibd
240321 14:49:26 [02] Copying ./bootdo/act_hi_detail.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_hi_detail.ibd
240321 14:49:26 [01] …done
240321 14:49:26 [04] …done
240321 14:49:26 [02] …done
240321 14:49:26 [03] Copying ./bootdo/act_hi_identitylink.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_hi_identitylink.ibd
240321 14:49:26 [03] …done
240321 14:49:26 [01] Copying ./bootdo/act_hi_procinst.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_hi_procinst.ibd
240321 14:49:26 [04] Copying ./bootdo/act_hi_taskinst.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_hi_taskinst.ibd
240321 14:49:26 [02] Copying ./bootdo/act_hi_varinst.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_hi_varinst.ibd
240321 14:49:26 [04] …done
240321 14:49:26 [01] …done
240321 14:49:26 [02] …done
240321 14:49:26 [03] Copying ./bootdo/act_id_group.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_id_group.ibd
240321 14:49:26 [03] …done
240321 14:49:26 [04] Copying ./bootdo/act_id_info.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_id_info.ibd
240321 14:49:26 [01] Copying ./bootdo/act_id_membership.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_id_membership.ibd
240321 14:49:26 [04] …done
240321 14:49:26 [02] Copying ./bootdo/act_id_user.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_id_user.ibd
240321 14:49:26 [01] …done
240321 14:49:26 [02] …done
240321 14:49:26 [03] Copying ./bootdo/act_procdef_info.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_procdef_info.ibd
240321 14:49:26 [03] …done
240321 14:49:26 [04] Copying ./bootdo/act_re_deployment.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_re_deployment.ibd
240321 14:49:26 [04] …done
240321 14:49:26 [02] Copying ./bootdo/act_re_model.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_re_model.ibd
240321 14:49:26 [02] …done
240321 14:49:27 [01] Copying ./bootdo/act_re_procdef.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_re_procdef.ibd
240321 14:49:27 [03] Copying ./bootdo/act_ru_event_subscr.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_ru_event_subscr.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [03] …done
240321 14:49:27 [04] Copying ./bootdo/act_ru_execution.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_ru_execution.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [02] Copying ./bootdo/act_ru_identitylink.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_ru_identitylink.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [03] Copying ./bootdo/act_ru_job.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_ru_job.ibd
240321 14:49:27 [01] Copying ./bootdo/act_ru_task.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_ru_task.ibd
240321 14:49:27 [04] Copying ./bootdo/act_ru_variable.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/act_ru_variable.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [01] …done
240321 14:49:27 [04] …done
240321 14:49:27 [02] Copying ./bootdo/bb.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/bb.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [04] Copying ./bootdo/binlogtest.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/binlogtest.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [01] Copying ./bootdo/blog_content.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/blog_content.ibd
240321 14:49:27 [03] Copying ./bootdo/cdc_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/cdc_log.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./bootdo/dataset_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dataset_log.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [04] Copying ./bootdo/dbbase_cdc_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dbbase_cdc_logs.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [03] Copying ./bootdo/dm_bi_hospitals.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dm_bi_hospitals.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [01] Copying ./bootdo/dm_dim_business.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dm_dim_business.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./bootdo/dm_dim_hospitals.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dm_dim_hospitals.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [04] Copying ./bootdo/dm_dim_hospitals_copy1.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dm_dim_hospitals_copy1.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [03] Copying ./bootdo/docker_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/docker_logs.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [04] Copying ./bootdo/dq_connector_process_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_connector_process_log.ibd
240321 14:49:27 [01] Copying ./bootdo/dq_connector_info.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_connector_info.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./bootdo/dq_connector_sink_info.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_connector_sink_info.ibd
240321 14:49:27 [03] Copying ./bootdo/dq_connector_sink_rel.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_connector_sink_rel.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [03] …done
240321 14:49:27 [04] Copying ./bootdo/dq_data_compare_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_data_compare_log.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [03] Copying ./bootdo/dq_data_rule_process_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_data_rule_process_log.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [01] Copying ./bootdo/dq_datasource.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_datasource.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./bootdo/dq_db_templates.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_db_templates.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [04] Copying ./bootdo/dq_dict.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_dict.ibd
240321 14:49:27 [03] Copying ./bootdo/dq_excel_datasource.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_excel_datasource.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [03] …done
240321 14:49:27 [01] Copying ./bootdo/dq_excel_templates.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_excel_templates.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./bootdo/dq_httprest_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_httprest_log.ibd
240321 14:49:27 [04] Copying ./bootdo/dq_job.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_job.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [03] Copying ./bootdo/dq_job_connection.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_job_connection.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [01] Copying ./bootdo/dq_job_metadata.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_job_metadata.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./bootdo/dq_job_templates.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_job_templates.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [02] Copying ./bootdo/dq_jobfile.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_jobfile.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [03] Copying ./bootdo/dq_metadata.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dq_metadata.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [02] Copying ./bootdo/ds_dp_employee.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/ds_dp_employee.ibd
240321 14:49:27 [01] Copying ./bootdo/ds_dp_budget.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/ds_dp_budget.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [04] …done
240321 14:49:27 [03] Copying ./bootdo/ds_dp_fn_orghistory.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/ds_dp_fn_orghistory.ibd
240321 14:49:27 [02] Copying ./bootdo/ds_dp_organization.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/ds_dp_organization.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [04] Copying ./bootdo/ds_dp_organization_copy1.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/ds_dp_organization_copy1.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [02] Copying ./bootdo/ds_dp_organization_copy2.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/ds_dp_organization_copy2.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [04] Copying ./bootdo/ds_sy_filebackrestore_cnf.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/ds_sy_filebackrestore_cnf.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [02] Copying ./bootdo/ds_sy_filebackrestore_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/ds_sy_filebackrestore_log.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [04] Copying ./bootdo/dw_dim_map_hospital.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dw_dim_map_hospital.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [02] Copying ./bootdo/dw_metadata.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/dw_metadata.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [02] Copying ./bootdo/imp_reportfile.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/imp_reportfile.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [02] Copying ./bootdo/k8s_controller_cornjob.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/k8s_controller_cornjob.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [02] Copying ./bootdo/k8s_cornjob_splitrule.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/k8s_cornjob_splitrule.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./bootdo/md_city_pop_gdp.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/md_city_pop_gdp.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [04] Copying ./bootdo/md_datasetrowtotal.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/md_datasetrowtotal.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [01] Copying ./bootdo/oa_notify.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/oa_notify.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./bootdo/oa_notify_record.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/oa_notify_record.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [03] Copying ./bootdo/order.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/order.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [01] Copying ./bootdo/salary.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/salary.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./bootdo/sync_run_params.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/sync_run_params.ibd
240321 14:49:27 [03] Copying ./bootdo/sys_dept.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/sys_dept.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [03] …done
240321 14:49:27 [02] Copying ./bootdo/sys_dict.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/sys_dict.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [02] Copying ./bootdo/sys_file.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/sys_file.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [03] Copying ./bootdo/sys_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/sys_log.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [02] Copying ./bootdo/sys_role.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/sys_role.ibd
240321 14:49:27 [01] Copying ./bootdo/sys_menu.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/sys_menu.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] …done
240321 14:49:27 [03] Copying ./bootdo/sys_role_menu.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/sys_role_menu.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [02] Copying ./bootdo/sys_task.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/sys_task.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./bootdo/sys_user.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/sys_user.ibd
240321 14:49:27 [03] Copying ./bootdo/sys_user_plus.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/sys_user_plus.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [03] …done
240321 14:49:27 [02] Copying ./bootdo/sys_user_role.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/sys_user_role.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./bootdo/talend_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/talend_logs.ibd
240321 14:49:27 [03] Copying ./bootdo/talend_meters.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/talend_meters.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [03] …done
240321 14:49:27 [04] …done
240321 14:49:27 [02] Copying ./bootdo/talend_stats.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/talend_stats.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./bootdo/test.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/test.ibd
240321 14:49:27 [03] Copying ./bootdo/test_sql.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/test_sql.ibd
240321 14:49:27 [04] Copying ./bootdo/users.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/bootdo/users.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [03] …done
240321 14:49:27 [04] …done
240321 14:49:27 [02] Copying ./datax@002dweb/job_group.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax@002dweb/job_group.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [03] Copying ./datax@002dweb/job_info.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax@002dweb/job_info.ibd
240321 14:49:27 [01] Copying ./datax@002dweb/job_jdbc_datasource.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax@002dweb/job_jdbc_datasource.ibd
240321 14:49:27 [04] Copying ./datax@002dweb/job_lock.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax@002dweb/job_lock.ibd
240321 14:49:27 [02] Copying ./datax@002dweb/job_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax@002dweb/job_log.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [04] …done
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./datax@002dweb/job_log_report.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax@002dweb/job_log_report.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [04] Copying ./datax@002dweb/job_logglue.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax@002dweb/job_logglue.ibd
240321 14:49:27 [02] Copying ./datax@002dweb/job_permission.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax@002dweb/job_permission.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./datax@002dweb/job_project.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax@002dweb/job_project.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [04] Copying ./datax@002dweb/job_registry.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax@002dweb/job_registry.ibd
240321 14:49:27 [02] Copying ./datax@002dweb/job_template.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax@002dweb/job_template.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./datax@002dweb/job_user.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax@002dweb/job_user.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [03] …done
240321 14:49:27 [04] Copying ./itsm_dev/t_knowledge.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_dev/t_knowledge.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [02] Copying ./itsm_dev/t_knowledge_count.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_dev/t_knowledge_count.ibd
240321 14:49:27 [01] Copying ./itsm_dev/t_knowledge_feedback.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_dev/t_knowledge_feedback.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] …done
240321 14:49:27 [04] Copying ./itsm_dev/t_knowledge_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_dev/t_knowledge_log.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [03] Copying ./itsm_dev/t_knowledge_touch.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_dev/t_knowledge_touch.ibd
240321 14:49:27 [02] Copying ./itsm_dev/t_knowledge_record.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_dev/t_knowledge_record.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [01] Copying ./itsm_sit/t_knowledge.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_sit/t_knowledge.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] …done
240321 14:49:27 [04] Copying ./itsm_sit/t_knowledge_count.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_sit/t_knowledge_count.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [03] Copying ./itsm_sit/t_knowledge_feedback.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_sit/t_knowledge_feedback.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [02] Copying ./itsm_sit/t_knowledge_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_sit/t_knowledge_log.ibd
240321 14:49:27 [01] Copying ./itsm_sit/t_knowledge_record.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_sit/t_knowledge_record.ibd
240321 14:49:27 [04] Copying ./itsm_uat/t_knowledge.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_uat/t_knowledge.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] …done
240321 14:49:27 [04] …done
240321 14:49:27 [03] Copying ./itsm_uat/t_knowledge_count.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_uat/t_knowledge_count.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [02] Copying ./itsm_uat/t_knowledge_feedback.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_uat/t_knowledge_feedback.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./itsm_uat/t_knowledge_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_uat/t_knowledge_log.ibd
240321 14:49:27 [04] Copying ./itsm_uat/t_knowledge_record.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/itsm_uat/t_knowledge_record.ibd
240321 14:49:27 [03] Copying ./xxl_job/schema_version.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/schema_version.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [01] …done
240321 14:49:27 [03] …done
240321 14:49:27 [02] Copying ./xxl_job/xxl_job_qrtz_blob_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_blob_triggers.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [04] Copying ./xxl_job/xxl_job_qrtz_calendars.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_calendars.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [01] Copying ./xxl_job/xxl_job_qrtz_cron_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_cron_triggers.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./xxl_job/xxl_job_qrtz_fired_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_fired_triggers.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [03] Copying ./xxl_job/xxl_job_qrtz_job_details.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_job_details.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [04] Copying ./xxl_job/xxl_job_qrtz_locks.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_locks.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [02] Copying ./xxl_job/xxl_job_qrtz_paused_trigger_grps.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_paused_trigger_grps.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./xxl_job/xxl_job_qrtz_scheduler_state.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_scheduler_state.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [03] Copying ./xxl_job/xxl_job_qrtz_scheduler_state_copy1.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_scheduler_state_copy1.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [04] Copying ./xxl_job/xxl_job_qrtz_simple_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_simple_triggers.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [01] Copying ./xxl_job/xxl_job_qrtz_simprop_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_simprop_triggers.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./xxl_job/xxl_job_qrtz_trigger_group.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_trigger_group.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [03] Copying ./xxl_job/xxl_job_qrtz_trigger_info.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_trigger_info.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [04] Copying ./xxl_job/xxl_job_qrtz_trigger_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_trigger_log.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [01] Copying ./xxl_job/xxl_job_qrtz_trigger_logglue.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_trigger_logglue.ibd
240321 14:49:27 [02] Copying ./xxl_job/xxl_job_qrtz_trigger_registry.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_trigger_registry.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [02] …done
240321 14:49:27 [03] Copying ./xxl_job/xxl_job_qrtz_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job/xxl_job_qrtz_triggers.ibd
240321 14:49:27 [04] Copying ./xxl_job_k8s/schema_version.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/schema_version.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [04] …done
240321 14:49:27 [01] Copying ./xxl_job_k8s/xxl_job_qrtz_blob_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_blob_triggers.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./xxl_job_k8s/xxl_job_qrtz_calendars.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_calendars.ibd
240321 14:49:27 [03] Copying ./xxl_job_k8s/xxl_job_qrtz_cron_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_cron_triggers.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [03] …done
240321 14:49:27 [01] Copying ./xxl_job_k8s/xxl_job_qrtz_job_details.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_job_details.ibd
240321 14:49:27 [04] Copying ./xxl_job_k8s/xxl_job_qrtz_fired_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_fired_triggers.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./xxl_job_k8s/xxl_job_qrtz_locks.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_locks.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [03] Copying ./xxl_job_k8s/xxl_job_qrtz_paused_trigger_grps.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_paused_trigger_grps.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [01] Copying ./xxl_job_k8s/xxl_job_qrtz_scheduler_state.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_scheduler_state.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./xxl_job_k8s/xxl_job_qrtz_simprop_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_simprop_triggers.ibd
240321 14:49:27 [04] Copying ./xxl_job_k8s/xxl_job_qrtz_simple_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_simple_triggers.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [04] …done
240321 14:49:27 [03] Copying ./xxl_job_k8s/xxl_job_qrtz_trigger_group.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_trigger_group.ibd
240321 14:49:27 [01] Copying ./xxl_job_k8s/xxl_job_qrtz_trigger_info.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_trigger_info.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [03] …done
240321 14:49:27 [02] Copying ./xxl_job_k8s/xxl_job_qrtz_trigger_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_trigger_log.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [04] Copying ./xxl_job_k8s/xxl_job_qrtz_trigger_logglue.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_trigger_logglue.ibd
240321 14:49:27 [01] Copying ./xxl_job_k8s/xxl_job_qrtz_trigger_registry.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_trigger_registry.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [01] …done
240321 14:49:27 [03] Copying ./xxl_job_k8s/xxl_job_qrtz_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_k8s/xxl_job_qrtz_triggers.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [02] Copying ./xxl_job_sit/schema_version.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/schema_version.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [04] Copying ./xxl_job_sit/xxl_job_qrtz_blob_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_blob_triggers.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [01] Copying ./xxl_job_sit/xxl_job_qrtz_calendars.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_calendars.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [03] Copying ./xxl_job_sit/xxl_job_qrtz_cron_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_cron_triggers.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [02] Copying ./xxl_job_sit/xxl_job_qrtz_fired_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_fired_triggers.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [04] Copying ./xxl_job_sit/xxl_job_qrtz_job_details.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_job_details.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [01] Copying ./xxl_job_sit/xxl_job_qrtz_locks.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_locks.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [03] Copying ./xxl_job_sit/xxl_job_qrtz_paused_trigger_grps.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_paused_trigger_grps.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [04] Copying ./xxl_job_sit/xxl_job_qrtz_simple_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_simple_triggers.ibd
240321 14:49:27 [02] Copying ./xxl_job_sit/xxl_job_qrtz_scheduler_state.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_scheduler_state.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./xxl_job_sit/xxl_job_qrtz_simprop_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_simprop_triggers.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [03] Copying ./xxl_job_sit/xxl_job_qrtz_trigger_group.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_trigger_group.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [02] Copying ./xxl_job_sit/xxl_job_qrtz_trigger_info.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_trigger_info.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [04] Copying ./xxl_job_sit/xxl_job_qrtz_trigger_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_trigger_log.ibd
240321 14:49:27 [01] Copying ./xxl_job_sit/xxl_job_qrtz_trigger_logglue.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_trigger_logglue.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [04] …done
240321 14:49:27 [03] Copying ./xxl_job_sit/xxl_job_qrtz_trigger_registry.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_trigger_registry.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [02] Copying ./xxl_job_sit/xxl_job_qrtz_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_sit/xxl_job_qrtz_triggers.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./xxl_job_uat/schema_version.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/schema_version.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [04] Copying ./xxl_job_uat/xxl_job_qrtz_blob_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_blob_triggers.ibd
240321 14:49:27 [03] Copying ./xxl_job_uat/xxl_job_qrtz_calendars.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_calendars.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [03] …done
240321 14:49:27 [02] Copying ./xxl_job_uat/xxl_job_qrtz_cron_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_cron_triggers.ibd
240321 14:49:27 [01] Copying ./xxl_job_uat/xxl_job_qrtz_fired_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_fired_triggers.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] …done
240321 14:49:27 [04] Copying ./xxl_job_uat/xxl_job_qrtz_job_details.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_job_details.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [03] Copying ./xxl_job_uat/xxl_job_qrtz_locks.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_locks.ibd
240321 14:49:27 [02] Copying ./xxl_job_uat/xxl_job_qrtz_paused_trigger_grps.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_paused_trigger_grps.ibd
240321 14:49:27 [01] Copying ./xxl_job_uat/xxl_job_qrtz_scheduler_state.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_scheduler_state.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [03] …done
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./xxl_job_uat/xxl_job_qrtz_simple_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_simple_triggers.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./xxl_job_uat/xxl_job_qrtz_trigger_group.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_trigger_group.ibd
240321 14:49:27 [04] Copying ./xxl_job_uat/xxl_job_qrtz_simprop_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_simprop_triggers.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [04] …done
240321 14:49:27 [03] Copying ./xxl_job_uat/xxl_job_qrtz_trigger_info.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_trigger_info.ibd
240321 14:49:27 [02] Copying ./xxl_job_uat/xxl_job_qrtz_trigger_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_trigger_log.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./xxl_job_uat/xxl_job_qrtz_trigger_logglue.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_trigger_logglue.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [04] Copying ./xxl_job_uat/xxl_job_qrtz_trigger_registry.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_trigger_registry.ibd
240321 14:49:27 [03] Copying ./xxl_job_uat/xxl_job_qrtz_triggers.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/xxl_job_uat/xxl_job_qrtz_triggers.ibd
240321 14:49:27 [02] Copying ./aips_dev/t_aips_config.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aips_dev/t_aips_config.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [03] …done
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./datax/job_group.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax/job_group.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [04] Copying ./datax/job_jdbc_datasource.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax/job_jdbc_datasource.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [02] Copying ./datax/job_lock.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax/job_lock.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [03] Copying ./datax/job_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax/job_log.ibd
240321 14:49:27 [01] Copying ./datax/job_log_report.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax/job_log_report.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [04] Copying ./datax/job_logglue.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax/job_logglue.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [04] …done
240321 14:49:27 [02] Copying ./datax/job_permission.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax/job_permission.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./datax/job_project.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax/job_project.ibd
240321 14:49:27 [03] Copying ./datax/job_registry.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax/job_registry.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [03] …done
240321 14:49:27 [04] Copying ./datax/job_template.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax/job_template.ibd
240321 14:49:27 [02] Copying ./datax/job_user.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax/job_user.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./datax/job_info_back.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax/job_info_back.ibd
240321 14:49:27 [03] Copying ./datax/job_info.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/datax/job_info.ibd
240321 14:49:27 [04] Copying ./aips/t_aips_config.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aips/t_aips_config.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [02] Copying ./test/t1.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/test/t1.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] …done
240321 14:49:27 [04] Copying ./test/t2.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/test/t2.ibd
240321 14:49:27 [04] …done
240321 14:49:27 [02] Copying ./aier_center_log/_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/_logs.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./aier_center_log/accs_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/accs_logs.ibd
240321 14:49:27 [01] …done
240321 14:49:27 [04] Copying ./aier_center_log/acrs_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/acrs_logs.ibd
240321 14:49:27 [02] Copying ./aier_center_log/adsp_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/adsp_logs.ibd
240321 14:49:27 [01] Copying ./aier_center_log/aemr_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/aemr_logs.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [03] …done
240321 14:49:27 [01] …done
240321 14:49:27 [02] Copying ./aier_center_log/aemro_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/aemro_logs.ibd
240321 14:49:27 [02] …done
240321 14:49:27 [01] Copying ./aier_center_log/agent_log.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/agent_log.ibd
240321 14:49:27 [03] Copying ./aier_center_log/agic_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/agic_logs.ibd
240321 14:49:27 [03] …done
240321 14:49:27 [04] …done
240321 14:49:27 [02] Copying ./aier_center_log/agrv_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/agrv_logs.ibd
240321 14:49:27 [03] Copying ./aier_center_log/ahis_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/ahis_logs.ibd
240321 14:49:27 [04] Copying ./aier_center_log/ahis_logs_bak.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/ahis_logs_bak.ibd
240321 14:49:27 [03] …done
240321 14:49:27 >> log scanned up to (13065031237)
240321 14:49:27 [01] …done
240321 14:49:27 [02] …done
240321 14:49:28 [03] Copying ./aier_center_log/ahms_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/ahms_logs.ibd
240321 14:49:28 [03] …done
240321 14:49:28 [02] Copying ./aier_center_log/aier@002dmobile@002dportals_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/aier@002dmobile@002dportals_logs.ibd
240321 14:49:28 [01] Copying ./aier_center_log/aitsm_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/aitsm_logs.ibd
240321 14:49:28 >> log scanned up to (13065036843)
240321 14:49:28 [02] …done
240321 14:49:28 [01] …done
240321 14:49:29 [03] Copying ./aier_center_log/alis_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/alis_logs.ibd
240321 14:49:29 [03] …done
240321 14:49:29 [02] Copying ./aier_center_log/alms_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/alms_logs.ibd
240321 14:49:29 [02] …done
240321 14:49:29 [01] Copying ./aier_center_log/amcs_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/amcs_logs.ibd
240321 14:49:29 [03] Copying ./aier_center_log/amms_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/amms_logs.ibd
240321 14:49:29 [03] …done
240321 14:49:29 >> log scanned up to (13065036861)
[01] xtrabackup: Database page corruption detected at page 115, retrying…
240321 14:49:29 [02] Copying ./aier_center_log/amrs_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/amrs_logs.ibd
[01] xtrabackup: Database page corruption detected at page 115, retrying…
[02] xtrabackup: Database page corruption detected at page 73, retrying…
[01] xtrabackup: Database page corruption detected at page 115, retrying…
[02] xtrabackup: Database page corruption detected at page 73, retrying…
[01] xtrabackup: Database page corruption detected at page 115, retrying…
240321 14:49:30 [03] Copying ./aier_center_log/amws_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/amws_logs.ibd
240321 14:49:30 [03] …done
[02] xtrabackup: Database page corruption detected at page 73, retrying…
[01] xtrabackup: Database page corruption detected at page 115, retrying…
[02] xtrabackup: Database page corruption detected at page 73, retrying…
[04] xtrabackup: Database page corruption detected at page 16386, retrying…
[01] xtrabackup: Database page corruption detected at page 115, retrying…
240321 14:49:30 [03] Copying ./aier_center_log/aohs_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/aohs_logs.ibd
240321 14:49:30 [03] …done
240321 14:49:30 [03] Copying ./aier_center_log/apacs_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/apacs_logs.ibd
240321 14:49:30 [03] …done
240321 14:49:30 [03] Copying ./aier_center_log/aplatform_logs.ibd to /app/mysqlbackup/physic/2024-03-21_14-49-23/aier_center_log/aplatform_logs.ibd
[02] xtrabackup: Database page corruption detected at page 73, retrying…
[01] xtrabackup: Database page corruption detected at page 115, retrying…
[04] xtrabackup: Database page corruption detected at page 16386, retrying…
[03] xtrabackup: Database page corruption detected at page 316, retrying…
[02] xtrabackup: Database page corruption detected at page 73, retrying…
[01] xtrabackup: Database page corruption detected at page 115, retrying…
[04] xtrabackup: Database page corruption detected at page 16386, retrying…
[03] xtrabackup: Database page corruption detected at page 316, retrying…
[02] xtrabackup: Database page corruption detected at page 73, retrying…
[01] xtrabackup: Database page corruption detected at page 115, retrying…
[04] xtrabackup: Database page corruption detected at page 16386, retrying…
[03] xtrabackup: Database page corruption detected at page 316, retrying…
[02] xtrabackup: Database page corruption detected at page 73, retrying…
[01] xtrabackup: Error: failed to read page after 10 retries. File ./aier_center_log/amcs_logs.ibd seems to be corrupted.
[01] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[01] xtrabackup: Error: failed to copy datafile.
240321 14:49:30 >> log scanned up to (13065039506)
[04] xtrabackup: Database page corruption detected at page 16386, retrying…
[03] xtrabackup: Database page corruption detected at page 316, retrying…
[02] xtrabackup: Database page corruption detected at page 73, retrying…
[04] xtrabackup: Database page corruption detected at page 16386, retrying…
[03] xtrabackup: Database page corruption detected at page 316, retrying…
[02] xtrabackup: Error: failed to read page after 10 retries. File ./aier_center_log/amrs_logs.ibd seems to be corrupted.
[02] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[02] xtrabackup: Error: failed to copy datafile.
[04] xtrabackup: Database page corruption detected at page 16386, retrying…
[03] xtrabackup: Database page corruption detected at page 316, retrying…
[04] xtrabackup: Database page corruption detected at page 16386, retrying…
[03] xtrabackup: Database page corruption detected at page 316, retrying…
[04] xtrabackup: Database page corruption detected at page 16386, retrying…
[03] xtrabackup: Database page corruption detected at page 316, retrying…
[04] xtrabackup: Error: failed to read page after 10 retries. File ./aier_center_log/ahis_logs_bak.ibd seems to be corrupted.
[04] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[04] xtrabackup: Error: failed to copy datafile.
[03] xtrabackup: Database page corruption detected at page 316, retrying…
[03] xtrabackup: Error: failed to read page after 10 retries. File ./aier_center_log/aplatform_logs.ibd seems to be corrupted.
[03] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[03] xtrabackup: Error: failed to copy datafile.
查看一下本地备份磁盘空间，是否已占满
空间很足
[root@amysql mysqlbackup]# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 7.9G 0 7.9G 0% /dev
tmpfs 7.9G 0 7.9G 0% /dev/shm
tmpfs 7.9G 169M 7.7G 3% /run
tmpfs 7.9G 0 7.9G 0% /sys/fs/cgroup
/dev/sda2 89G 6.7G 83G 8% /
/dev/sdb 300G 15G 286G 5% /app
/dev/sda1 1014M 132M 883M 13% /boot
tmpfs 1.6G 0 1.6G 0% /run/user/0
amrs_logs 这个表正常不 ？？？
amrs_logs 正常
肯定有问题的，着急恢复就备份数据重建表试试。
ahis_logs_bak
aplatform_logs
amrs_logs
amws_logs
amcs_logs 这几个表 select count(1) from 都没问题吧
都没问题
很奇怪，是xtrabackup的bug，还是我这个库aier_center_log中表的特殊问题，其他库都没问题，这个实例有10几个库，就这个库的表备份有问题
您查询下截图 看看。