看一下pxb 和mysql 版本是否一致
percona-xtrabackup-24-2.4.29-1.el7.x86_64.rpm
[root@amysql mysqlbackup]# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3692
Server version: 5.7.40-log MySQL Community Server (GPL)
版本一致，备份其他库没问题
加 --databases 指定对应的数据库进行备份
有其他备库slave ，备份试一下，是这个实例有问题，还是其他的问题
不排除你们有长时间的大事务。
这两个参数 都加大看看。 并行设置为 1， 仅仅备份这一个数据库看看。 有问题的话日志发出来
您的并发 4 ， 最后4个进程都报错了 ，然后退出来了
innobackupex --defaults-file=/etc/my.cnf -u root --parallel=1 –backup-lock-retry-count=20 –backup-lock-timeout=60 /app/mysqlbackup/physic/
看看这个日志发下
1.表rename table一下再试试
2.新建一张表把数据导入到新表再操作备份试试
[root@amysql ~]# innobackupex --defaults-file=/etc/my.cnf -u root --parallel=1 –backup-lock-retry-count=20 –backup-lock-timeout=60 /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=1
240321 15:49:03 innobackupex: Error: extra argument found –backup-lock-timeout=60
240321 15:49:03 innobackupex: Error: extra argument found /app/mysqlbackup/physic/
240321 15:57:49 [01] …done
240321 15:57:49 [01] Copying ./aier_center_log/agic_logs.ibd to /app/mysqlbackup/physic/2024-03-21_15-57-47/aier_center_log/agic_logs.ibd
240321 15:57:49 [01] …done
240321 15:57:49 [01] Copying ./aier_center_log/agrv_logs.ibd to /app/mysqlbackup/physic/2024-03-21_15-57-47/aier_center_log/agrv_logs.ibd
240321 15:57:50 [01] …done
240321 15:57:50 [01] Copying ./aier_center_log/ahis_logs.ibd to /app/mysqlbackup/physic/2024-03-21_15-57-47/aier_center_log/ahis_logs.ibd
240321 15:57:50 [01] …done
240321 15:57:50 [01] Copying ./aier_center_log/ahis_logs_bak.ibd to /app/mysqlbackup/physic/2024-03-21_15-57-47/aier_center_log/ahis_logs_bak.ibd
240321 15:57:50 >> log scanned up to (13066080516)
[01] xtrabackup: Database page corruption detected at page 16386, retrying…
[01] xtrabackup: Database page corruption detected at page 16386, retrying…
[01] xtrabackup: Database page corruption detected at page 16386, retrying…
[01] xtrabackup: Database page corruption detected at page 16386, retrying…
[01] xtrabackup: Database page corruption detected at page 16386, retrying…
[01] xtrabackup: Database page corruption detected at page 16386, retrying…
[01] xtrabackup: Database page corruption detected at page 16386, retrying…
[01] xtrabackup: Database page corruption detected at page 16386, retrying…
[01] xtrabackup: Database page corruption detected at page 16386, retrying…
240321 15:57:51 >> log scanned up to (13066080986)
[01] xtrabackup: Error: failed to read page after 10 retries. File ./aier_center_log/ahis_logs_bak.ibd seems to be corrupted.
[01] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[01] xtrabackup: Error: failed to copy datafile.
只有这个实例下的这个库的某些表有问题，其他库没任何问题
xtrabackup --backup -u root -poracle --parallel=1 --backup-lock-retry-count=20 --backup-lock-timeout=60 --databases aier_center_log --target-dir=/app/mysqlbackup/physic
q清空 /app/mysqlbackup/physic 垃圾数据 执行下看下
重启不一定读到那个问题文件
文件有问题
手动dump备份试试
表重建下试试
是否有坏块，又不在数据块上
xtrabackup --backup -u root -pxxxx --parallel=1 --backup-lock-retry-count=20 --backup-lock-timeout=60 --databases aier_center_log --tables amcs_logs --target-dir=/app/mysqlbackup/physic
这样子试下。
insert select另外一张表看看是什么问题