【无标题】xtrabackup --prepare --export 使用export选项时报错

使用全备来执行恢复,在准备阶段使用export option,xtrabackup  --prepare --export 

产生一个错误:

mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.

请问这个错误应该如何处理?

环境如下:

OS: unbuntu 20.04

#xtrabackup8.0.28-20

#mysqld:8.0.28

root@mysql-20220801104446:~# xtrabackup --prepare --export --target-dir=/data/recover/3306/full/
2022-08-03T13:58:36.408833+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksums=1 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=134217728 --innodb_page_size=16384 --innodb_undo_directory=./ --innodb_undo_tablespaces=2 --server-id=416 --innodb_log_checksums=ON --innodb_redo_log_encrypt=0 --innodb_undo_log_encrypt=0 
2022-08-03T13:58:36.409108+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --prepare=1 --export=1 --target-dir=/data/recover/3306/full/ 
/opt/agent/tools/xtrabackup/bin/xtrabackup version 8.0.28-20 based on MySQL server 8.0.28 Linux (x86_64) (revision id: 4cc3081873d)
2022-08-03T13:58:36.409261+08:00 0 [Note] [MY-011825] [Xtrabackup] auto-enabling --innodb-file-per-table due to the --export option
2022-08-03T13:58:36.409334+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /data/recover/3306/full/
2022-08-03T13:58:36.409448+08:00 0 [Note] [MY-011825] [Xtrabackup] This target seems to be not prepared yet.
2022-08-03T13:58:36.409897+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-08-03T13:58:36.422113+08:00 0 [Note] [MY-011825] [Xtrabackup] xtrabackup_logfile detected: size=8388608, start_lsn=(18919848)
2022-08-03T13:58:36.423033+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2022-08-03T13:58:36.423146+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2022-08-03T13:58:36.423216+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2022-08-03T13:58:36.423312+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = .
2022-08-03T13:58:36.423369+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 1
2022-08-03T13:58:36.423455+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 8388608
2022-08-03T13:58:36.423780+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2022-08-03T13:58:36.424038+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration for recovery:
2022-08-03T13:58:36.424125+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2022-08-03T13:58:36.424198+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2022-08-03T13:58:36.424246+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = .
2022-08-03T13:58:36.424287+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 1
2022-08-03T13:58:36.424327+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 8388608
2022-08-03T13:58:36.424371+08:00 0 [Note] [MY-011825] [Xtrabackup] Starting InnoDB instance for recovery.
2022-08-03T13:58:36.424412+08:00 0 [Note] [MY-011825] [Xtrabackup] Using 104857600 bytes for buffer pool (set by --use-memory parameter)
2022-08-03T13:58:36.424481+08:00 0 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available
2022-08-03T13:58:36.424539+08:00 0 [Note] [MY-012944] [InnoDB] Uses event mutexes
2022-08-03T13:58:36.424580+08:00 0 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier
2022-08-03T13:58:36.424623+08:00 0 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.11
2022-08-03T13:58:36.424841+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-08-03T13:58:36.424967+08:00 0 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication.
2022-08-03T13:58:36.425445+08:00 0 [Note] [MY-012203] [InnoDB] Directories to scan './'
2022-08-03T13:58:36.425521+08:00 0 [Note] [MY-012204] [InnoDB] Scanning './'
2022-08-03T13:58:36.426469+08:00 0 [Note] [MY-012208] [InnoDB] Completed space ID check of 6 files.
2022-08-03T13:58:36.427171+08:00 0 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M 
2022-08-03T13:58:36.436431+08:00 0 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool
2022-08-03T13:58:36.488854+08:00 0 [Note] [MY-011951] [InnoDB] page_cleaner coordinator priority: -20
2022-08-03T13:58:36.492720+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2022-08-03T13:58:36.496738+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2022-08-03T13:58:36.500714+08:00 0 [Note] [MY-011954] [InnoDB] page_cleaner worker priority: -20
2022-08-03T13:58:36.600192+08:00 0 [Note] [MY-012560] [InnoDB] The log sequence number 18822879 in the system tablespace does not match the log sequence number 18919848 in the ib_logfiles!
2022-08-03T13:58:36.600380+08:00 0 [Note] [MY-012551] [InnoDB] Database was not shutdown normally!
2022-08-03T13:58:36.600492+08:00 0 [Note] [MY-012552] [InnoDB] Starting crash recovery.
2022-08-03T13:58:36.608816+08:00 0 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 18919437, whereas checkpoint_lsn = 18919848 and start_lsn = 18919424
2022-08-03T13:58:36.608957+08:00 0 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 18919848
2022-08-03T13:58:36.632592+08:00 0 [Note] [MY-013083] [InnoDB] Log background threads are being started...
2022-08-03T13:58:36.682119+08:00 0 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ...
2022-08-03T13:58:36.682506+08:00 0 [Note] [MY-012535] [InnoDB] Apply batch completed!
2022-08-03T13:58:36.782984+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'.
2022-08-03T13:58:36.784346+08:00 0 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'.
2022-08-03T13:58:36.785052+08:00 0 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces.
2022-08-03T13:58:36.785249+08:00 0 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 5973
2022-08-03T13:58:36.799877+08:00 0 [Note] [MY-013779] [InnoDB] Time taken to initialize rseg using 1 thread: 14598 ms.
2022-08-03T13:58:36.800221+08:00 0 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables
2022-08-03T13:58:36.800390+08:00 0 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-08-03T13:58:36.861870+08:00 0 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB.
2022-08-03T13:58:36.862457+08:00 0 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/'
2022-08-03T13:58:36.887250+08:00 0 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2022-08-03T13:58:36.900780+08:00 0 [Note] [MY-012976] [InnoDB] 8.0.28 started; log sequence number 18919858
2022-08-03T13:58:36.901668+08:00 0 [Warning] [MY-012091] [InnoDB] Allocated tablespace ID 1 for sys/sys_config, old maximum was 0
2022-08-03T13:58:36.944852+08:00 0 [Note] [MY-011825] [Xtrabackup] export option is specified.
05:58:36 UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
Thread pointer: 0x5f88660
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7ffe48367910 thread_stack 0x100000
/opt/agent/tools/xtrabackup/bin/xtrabackup(my_print_stacktrace(unsigned char const*, unsigned long)+0x3d) [0x2494f8d]
/opt/agent/tools/xtrabackup/bin/xtrabackup(print_fatal_signal(int)+0x2d3) [0x1272633]
/opt/agent/tools/xtrabackup/bin/xtrabackup(handle_fatal_signal+0x95) [0x1272715]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x153c0) [0x7f53c392d3c0]
/opt/agent/tools/xtrabackup/bin/xtrabackup() [0xcde0e0]
/opt/agent/tools/xtrabackup/bin/xtrabackup() [0xcdf36f]
/opt/agent/tools/xtrabackup/bin/xtrabackup() [0xcf7736]
/opt/agent/tools/xtrabackup/bin/xtrabackup(main+0xfe8) [0xca9af8]
/lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf3) [0x7f53c275a0b3]
/opt/agent/tools/xtrabackup/bin/xtrabackup() [0xcda5c7]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): Connection ID (thread ID): 0
Status: NOT_KILLED


Please report a bug at https://jira.percona.com/projects/PXB
 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值