search

ShahriyarR / MySQL-AutoXtraBackup

MySQL-AutoXtraBackup commandline tool written in Python 3 based on Percona XtraBackup
https://autoxtrabackup.azepug.az/
MIT License
139 stars 79 forks source link

Mysql Restore --prepare option 2 is getting failed-- Kindly Help me #375

Closed bimith closed 4 years ago

bimith commented 4 years ago

autoxtrabackup -v -l DEBUG -lf /else/xb_test/backup_dir/xb.log --defaults-file=/else/xb_test/server_dir/bck.cnf --prepare 2020-02-11 22:20:14 DEBUG <pid.PidFile object at 0x7f704a7055c8> entering setup 2020-02-11 22:20:14 DEBUG <pid.PidFile object at 0x7f704a7055c8> create pidfile: /tmp/autoxtrabackup.pid 2020-02-11 22:20:14 DEBUG <pid.PidFile object at 0x7f704a7055c8> check pidfile: /tmp/autoxtrabackup.pid

Preparing full/inc backups! What do you want to do?

  1. Prepare Backups and keep for future usage. NOTE('Once Prepared Backups Can not be prepared Again')
  2. Prepare Backups and restore/recover/copy-back immediately
  3. Just copy-back previously prepared backups Please Choose one of options and type 1 or 2 or 3: 2

2020-02-11 22:20:19 DEBUG - - - - You have Incremental backups. - - - - 2020-02-11 22:20:19 DEBUG - - - - Preparing Full backup for incrementals - - - - 2020-02-11 22:20:19 DEBUG - - - - Final prepare,will occur after preparing all inc backups - - - - 2020-02-11 22:20:22 DEBUG Running prepare command -> /usr/bin/xtrabackup --prepare --apply-log-only --target-dir=/else/xb_test/backup_dir/full/2020-02-11_22-04-29 --no-version-check 2020-02-11 22:20:30 DEBUG xtrabackup: recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksum_algorithm=strict_crc32 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=2147483648 --innodb_fast_checksum=0 --innodb_page_size=16384 --innodb_log_block_size=512 --innodb_undo_directory=./ --innodb_undo_tablespaces=0 --server-id=0 --redo-log-version=1 xtrabackup: recognized client arguments: --prepare=1 --apply-log-only=1 --target-dir=/else/xb_test/backup_dir/full/2020-02-11_22-04-29 --no-version-check=1 /usr/bin/xtrabackup version 2.4.18 based on MySQL server 5.7.26 Linux (x86_64) (revision id: 29b4ca5) xtrabackup: cd to /else/xb_test/backup_dir/full/2020-02-11_22-04-29/ xtrabackup: This target seems to be not prepared yet. InnoDB: Number of pools: 1 xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(7481437008) xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = . xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = . xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: Starting InnoDB instance for recovery. xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) InnoDB: PUNCH HOLE support available InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Uses event mutexes InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier InnoDB: Compressed tables use zlib 1.2.7 InnoDB: Number of pools: 1 InnoDB: Using CPU crc32 instructions InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M InnoDB: Completed initialization of buffer pool InnoDB: page_cleaner coordinator priority: -20 InnoDB: Highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 7481437008 InnoDB: Doing recovery: scanned up to log sequence number 7481437017 (0%) InnoDB: Database was not shutdown normally! InnoDB: Starting crash recovery. InnoDB: page_cleaner: 1000ms intended loop took 6053ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)

xtrabackup: starting shutdown with innodb_fast_shutdown = 1 InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 7481437026 InnoDB: Number of pools: 1 200211 22:20:29 completed OK! 2020-02-11 22:20:30 DEBUG Preparing Incs: 2020-02-11 22:20:30 DEBUG Preparing last incremental backup, inc backup dir/name is 2020-02-11_22-07-09 2020-02-11 22:20:30 DEBUG Running prepare command -> /usr/bin/xtrabackup --prepare --target-dir=/else/xb_test/backup_dir/full/2020-02-11_22-04-29 --incremental-dir=/else/xb_test/backup_dir/inc/2020-02-11_22-07-09 --no-version-check 2020-02-11 22:22:21 DEBUG xtrabackup: recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksum_algorithm=strict_crc32 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=2147483648 --innodb_fast_checksum=0 --innodb_page_size=16384 --innodb_log_block_size=512 --innodb_undo_directory=./ --innodb_undo_tablespaces=0 --server-id=0 --redo-log-version=1 xtrabackup: recognized client arguments: --prepare=1 --target-dir=/else/xb_test/backup_dir/full/2020-02-11_22-04-29 --incremental-dir=/else/xb_test/backup_dir/inc/2020-02-11_22-07-09 --no-version-check=1 /usr/bin/xtrabackup version 2.4.18 based on MySQL server 5.7.26 Linux (x86_64) (revision id: 29b4ca5) incremental backup from 7481437008 is enabled. xtrabackup: cd to /else/xb_test/backup_dir/full/2020-02-11_22-04-29/ xtrabackup: This target seems to be already prepared with --apply-log-only. InnoDB: Number of pools: 1 xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(7481512812) xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: Generating a list of tablespaces InnoDB: Allocated tablespace ID 5745 for OmNet/ClientAddHist, old maximum was 0 xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//ibdata1.delta is 16384 bytes space id is 0 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//ibdata1.delta to ./ibdata1... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ClientAddHist.ibd.delta is 16384 bytes space id is 5745 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ClientAddHist.ibd.delta to ./OmNet/ClientAddHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ClientAddMrv.ibd.delta is 16384 bytes space id is 5725 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ClientAddMrv.ibd.delta to ./OmNet/ClientAddMrv.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ClntAsgn.ibd.delta is 16384 bytes space id is 5455 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ClntAsgn.ibd.delta to ./OmNet/ClntAsgn.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DealerAddMrv.ibd.delta is 16384 bytes space id is 5987 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DealerAddMrv.ibd.delta to ./OmNet/DealerAddMrv.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DealerAddHist.ibd.delta is 16384 bytes space id is 5988 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DealerAddHist.ibd.delta to ./OmNet/DealerAddHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DealerExch.ibd.delta is 16384 bytes space id is 5458 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DealerExch.ibd.delta to ./OmNet/DealerExch.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/HoldFunds.ibd.delta is 16384 bytes space id is 5994 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/HoldFunds.ibd.delta to ./OmNet/HoldFunds.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/MIS.ibd.delta is 16384 bytes space id is 5460 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/MIS.ibd.delta to ./OmNet/MIS.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/MIS_Temp.ibd.delta is 16384 bytes space id is 5461 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/MIS_Temp.ibd.delta to ./OmNet/MIS_Temp.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/RMSCategories.ibd.delta is 16384 bytes space id is 5857 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/RMSCategories.ibd.delta to ./OmNet/RMSCategories.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/SectorN.ibd.delta is 16384 bytes space id is 5467 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/SectorN.ibd.delta to ./OmNet/SectorN.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortTomMsgHist.ibd.delta is 16384 bytes space id is 6034 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortTomMsgHist.ibd.delta to ./OmNet/PortTomMsgHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortTomMsgMrv.ibd.delta is 16384 bytes space id is 6035 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortTomMsgMrv.ibd.delta to ./OmNet/PortTomMsgMrv.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortTradeHist.ibd.delta is 16384 bytes space id is 6036 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortTradeHist.ibd.delta to ./OmNet/PortTradeHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/TomMsgHist.ibd.delta is 16384 bytes space id is 6031 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/TomMsgHist.ibd.delta to ./OmNet/TomMsgHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/TomMsgMrv.ibd.delta is 16384 bytes space id is 6032 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/TomMsgMrv.ibd.delta to ./OmNet/TomMsgMrv.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/TradeHist.ibd.delta is 16384 bytes space id is 6033 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/TradeHist.ibd.delta to ./OmNet/TradeHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/TempTomRep.ibd.delta is 16384 bytes space id is 5474 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/TempTomRep.ibd.delta to ./OmNet/TempTomRep.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/AcctProducts.ibd.delta is 16384 bytes space id is 5475 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/AcctProducts.ibd.delta to ./OmNet/AcctProducts.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/BasketMsgHist.ibd.delta is 16384 bytes space id is 5996 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/BasketMsgHist.ibd.delta to ./OmNet/BasketMsgHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/BasketMsgMrv.ibd.delta is 16384 bytes space id is 5995 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/BasketMsgMrv.ibd.delta to ./OmNet/BasketMsgMrv.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/MktWatch.ibd.delta is 16384 bytes space id is 5478 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/MktWatch.ibd.delta to ./OmNet/MktWatch.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/RolesHist.ibd.delta is 16384 bytes space id is 5480 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/RolesHist.ibd.delta to ./OmNet/RolesHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/RejMsg.ibd.delta is 16384 bytes space id is 5481 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/RejMsg.ibd.delta to ./OmNet/RejMsg.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PayIn.ibd.delta is 16384 bytes space id is 5992 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PayIn.ibd.delta to ./OmNet/PayIn.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/UserInOut.ibd.delta is 16384 bytes space id is 5991 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/UserInOut.ibd.delta to ./OmNet/UserInOut.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DBVersion.ibd.delta is 16384 bytes space id is 5484 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DBVersion.ibd.delta to ./OmNet/DBVersion.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/TempAuditTrailRep.ibd.delta is 16384 bytes space id is 5485 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/TempAuditTrailRep.ibd.delta to ./OmNet/TempAuditTrailRep.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ComdtyParam.ibd.delta is 16384 bytes space id is 5486 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ComdtyParam.ibd.delta to ./OmNet/ComdtyParam.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ArbSettings.ibd.delta is 16384 bytes space id is 5487 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ArbSettings.ibd.delta to ./OmNet/ArbSettings.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/NSSettings.ibd.delta is 16384 bytes space id is 5488 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/NSSettings.ibd.delta to ./OmNet/NSSettings.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DeletedDealerAddMrv.ibd.delta is 16384 bytes space id is 5989 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DeletedDealerAddMrv.ibd.delta to ./OmNet/DeletedDealerAddMrv.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DeletedDealerAddHist.ibd.delta is 16384 bytes space id is 5990 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DeletedDealerAddHist.ibd.delta to ./OmNet/DeletedDealerAddHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/WebUserModifications.ibd.delta is 16384 bytes space id is 5491 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/WebUserModifications.ibd.delta to ./OmNet/WebUserModifications.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DeletedClientAddMrv.ibd.delta is 16384 bytes space id is 5765 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DeletedClientAddMrv.ibd.delta to ./OmNet/DeletedClientAddMrv.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DeletedClientAddHist.ibd.delta is 16384 bytes space id is 5785 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DeletedClientAddHist.ibd.delta to ./OmNet/DeletedClientAddHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ArbIndex.ibd.delta is 16384 bytes space id is 5494 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ArbIndex.ibd.delta to ./OmNet/ArbIndex.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DealerExchMrv.ibd.delta is 16384 bytes space id is 5495 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DealerExchMrv.ibd.delta to ./OmNet/DealerExchMrv.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/OrderSliceHist.ibd.delta is 16384 bytes space id is 5496 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/OrderSliceHist.ibd.delta to ./OmNet/OrderSliceHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/MenuList.ibd.delta is 16384 bytes space id is 5497 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/MenuList.ibd.delta to ./OmNet/MenuList.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortFixTradeHist.ibd.delta is 16384 bytes space id is 6009 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortFixTradeHist.ibd.delta to ./OmNet/PortFixTradeHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/FixTradeHist.ibd.delta is 16384 bytes space id is 6006 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/FixTradeHist.ibd.delta to ./OmNet/FixTradeHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortFixOrderMrv.ibd.delta is 16384 bytes space id is 5878 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortFixOrderMrv.ibd.delta to ./OmNet/PortFixOrderMrv.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/FixOrderMrv.ibd.delta is 16384 bytes space id is 5879 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/FixOrderMrv.ibd.delta to ./OmNet/FixOrderMrv.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/LedgerReport.ibd.delta is 16384 bytes space id is 5502 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/LedgerReport.ibd.delta to ./OmNet/LedgerReport.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/COROrders.ibd.delta is 16384 bytes space id is 5503 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/COROrders.ibd.delta to ./OmNet/COROrders.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DPMasterHist.ibd.delta is 16384 bytes space id is 5504 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DPMasterHist.ibd.delta to ./OmNet/DPMasterHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DPMasterMrv.ibd.delta is 16384 bytes space id is 5505 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/DPMasterMrv.ibd.delta to ./OmNet/DPMasterMrv.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/BGCCodeMapping.ibd.delta is 16384 bytes space id is 5506 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/BGCCodeMapping.ibd.delta to ./OmNet/BGCCodeMapping.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/NSCSettings.ibd.delta is 16384 bytes space id is 5507 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/NSCSettings.ibd.delta to ./OmNet/NSCSettings.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/SIPInfoMrv.ibd.delta is 16384 bytes space id is 5508 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/SIPInfoMrv.ibd.delta to ./OmNet/SIPInfoMrv.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/SIPInfoHist.ibd.delta is 16384 bytes space id is 5509 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/SIPInfoHist.ibd.delta to ./OmNet/SIPInfoHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortSIPInfoMrv.ibd.delta is 16384 bytes space id is 5510 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortSIPInfoMrv.ibd.delta to ./OmNet/PortSIPInfoMrv.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortSIPInfoHist.ibd.delta is 16384 bytes space id is 5511 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortSIPInfoHist.ibd.delta to ./OmNet/PortSIPInfoHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/NestPRMS.ibd.delta is 16384 bytes space id is 5512 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/NestPRMS.ibd.delta to ./OmNet/NestPRMS.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/BranchClientAdHoc.ibd.delta is 16384 bytes space id is 5513 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/BranchClientAdHoc.ibd.delta to ./OmNet/BranchClientAdHoc.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/CommScripProps.ibd.delta is 16384 bytes space id is 5861 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/CommScripProps.ibd.delta to ./OmNet/CommScripProps.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/EqSIP.ibd.delta is 16384 bytes space id is 5515 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/EqSIP.ibd.delta to ./OmNet/EqSIP.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ClntAsgnHist.ibd.delta is 16384 bytes space id is 5516 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ClntAsgnHist.ibd.delta to ./OmNet/ClntAsgnHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/NetWorthValue.ibd.delta is 16384 bytes space id is 5520 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/NetWorthValue.ibd.delta to ./OmNet/NetWorthValue.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ArbBsktIndxhSettings.ibd.delta is 16384 bytes space id is 5521 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ArbBsktIndxhSettings.ibd.delta to ./OmNet/ArbBsktIndxhSettings.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/FundTransfer.ibd.delta is 16384 bytes space id is 5529 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/FundTransfer.ibd.delta to ./OmNet/FundTransfer.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/AlgoSettings.ibd.delta is 16384 bytes space id is 5674 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/AlgoSettings.ibd.delta to ./OmNet/AlgoSettings.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/NSRMSLimits.ibd.delta is 16384 bytes space id is 5675 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/NSRMSLimits.ibd.delta to ./OmNet/NSRMSLimits.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/RMSExclusionMrv.ibd.delta is 16384 bytes space id is 5690 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/RMSExclusionMrv.ibd.delta to ./OmNet/RMSExclusionMrv.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/RMSExclusionHist.ibd.delta is 16384 bytes space id is 5691 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/RMSExclusionHist.ibd.delta to ./OmNet/RMSExclusionHist.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/RMSCategoriesMrv.ibd.delta is 16384 bytes space id is 5858 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/RMSCategoriesMrv.ibd.delta to ./OmNet/RMSCategoriesMrv.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/MakerCheckerLogs.ibd.delta is 16384 bytes space id is 5859 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/MakerCheckerLogs.ibd.delta to ./OmNet/MakerCheckerLogs.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PostOrderRej.ibd.delta is 16384 bytes space id is 5974 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PostOrderRej.ibd.delta to ./OmNet/PostOrderRej.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ExtUserAccessFlags.ibd.delta is 16384 bytes space id is 5975 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/ExtUserAccessFlags.ibd.delta to ./OmNet/ExtUserAccessFlags.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/EmailLogs.ibd.delta is 16384 bytes space id is 5997 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/EmailLogs.ibd.delta to ./OmNet/EmailLogs.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/CrossDeals.ibd.delta is 16384 bytes space id is 5999 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/CrossDeals.ibd.delta to ./OmNet/CrossDeals.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/TomMsgMrv4L.ibd.delta is 16384 bytes space id is 6012 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/TomMsgMrv4L.ibd.delta to ./OmNet/TomMsgMrv4L.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/TomMsgHist4L.ibd.delta is 16384 bytes space id is 6015 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/TomMsgHist4L.ibd.delta to ./OmNet/TomMsgHist4L.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortTomMsgMrv4L.ibd.delta is 16384 bytes space id is 6018 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortTomMsgMrv4L.ibd.delta to ./OmNet/PortTomMsgMrv4L.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortTomMsgHist4L.ibd.delta is 16384 bytes space id is 6021 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/PortTomMsgHist4L.ibd.delta to ./OmNet/PortTomMsgHist4L.ibd... xtrabackup: page size for /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/RMSBlockHist.ibd.delta is 16384 bytes space id is 6030 Applying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//OmNet/RMSBlockHist.ibd.delta to ./OmNet/RMSBlockHist.ibd... xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 8388608 xtrabackup: Starting InnoDB instance for recovery. xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) InnoDB: PUNCH HOLE support available InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Uses event mutexes InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier InnoDB: Compressed tables use zlib 1.2.7 InnoDB: Number of pools: 1 InnoDB: Using CPU crc32 instructions InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M InnoDB: Completed initialization of buffer pool InnoDB: page_cleaner coordinator priority: -20 InnoDB: Highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 7481512812 InnoDB: Doing recovery: scanned up to log sequence number 7481512821 (0%) InnoDB: Database was not shutdown normally! InnoDB: Starting crash recovery. InnoDB: Removing missing table mysql/engine_cost from InnoDB data dictionary. InnoDB: Removing missing table mysql/gtid_executed from InnoDB data dictionary. InnoDB: Removing missing table mysql/help_category from InnoDB data dictionary. InnoDB: Removing missing table mysql/help_keyword from InnoDB data dictionary. InnoDB: Removing missing table mysql/help_relation from InnoDB data dictionary. InnoDB: Removing missing table mysql/help_topic from InnoDB data dictionary. InnoDB: Removing missing table mysql/innodb_index_stats from InnoDB data dictionary. InnoDB: Removing missing table mysql/innodb_table_stats from InnoDB data dictionary. InnoDB: Removing missing table mysql/plugin from InnoDB data dictionary. InnoDB: Removing missing table mysql/server_cost from InnoDB data dictionary. InnoDB: Removing missing table mysql/servers from InnoDB data dictionary. InnoDB: Removing missing table mysql/slave_master_info from InnoDB data dictionary. InnoDB: Removing missing table mysql/slave_relay_log_info from InnoDB data dictionary. InnoDB: Removing missing table mysql/slave_worker_info from InnoDB data dictionary. InnoDB: Removing missing table mysql/time_zone from InnoDB data dictionary. InnoDB: Removing missing table mysql/time_zone_leap_second from InnoDB data dictionary. InnoDB: Removing missing table mysql/time_zone_name from InnoDB data dictionary. InnoDB: Removing missing table mysql/time_zone_transition from InnoDB data dictionary. InnoDB: Removing missing table mysql/time_zone_transition_type from InnoDB data dictionary. InnoDB: Removing missing table sys/sys_config from InnoDB data dictionary. InnoDB: Creating shared tablespace for temporary tables InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... InnoDB: File './ibtmp1' size is now 12 MB. InnoDB: 96 redo rollback segment(s) found. 1 redo rollback segment(s) are active. InnoDB: 32 non-redo rollback segment(s) are active. InnoDB: page_cleaner: 1000ms intended loop took 40964ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) InnoDB: 5.7.26 started; log sequence number 7481512821

xtrabackup: starting shutdown with innodb_fast_shutdown = 1 InnoDB: FTS optimize thread exiting. InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 7481544648 InnoDB: Number of pools: 1 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/db.opt to ./OmNet/db.opt 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/ClientAddHist.frm to ./OmNet/ClientAddHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/ClientAddMrv.frm to ./OmNet/ClientAddMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/ClntAsgn.frm to ./OmNet/ClntAsgn.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/DealerAddMrv.frm to ./OmNet/DealerAddMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/DealerAddHist.frm to ./OmNet/DealerAddHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/DealerExch.frm to ./OmNet/DealerExch.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/HoldFunds.frm to ./OmNet/HoldFunds.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/MIS.frm to ./OmNet/MIS.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/MIS_Temp.frm to ./OmNet/MIS_Temp.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/PayIn.frm to ./OmNet/PayIn.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/RMSCategories.frm to ./OmNet/RMSCategories.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/SectorN.frm to ./OmNet/SectorN.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/PortTomMsgHist.frm to ./OmNet/PortTomMsgHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/PortTomMsgMrv.frm to ./OmNet/PortTomMsgMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/PortTradeHist.frm to ./OmNet/PortTradeHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/TomMsgHist.frm to ./OmNet/TomMsgHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/TomMsgMrv.frm to ./OmNet/TomMsgMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/TradeHist.frm to ./OmNet/TradeHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/TempTomRep.frm to ./OmNet/TempTomRep.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/AcctProducts.frm to ./OmNet/AcctProducts.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/BasketMsgHist.frm to ./OmNet/BasketMsgHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/BasketMsgMrv.frm to ./OmNet/BasketMsgMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/MktWatch.frm to ./OmNet/MktWatch.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/RolesHist.frm to ./OmNet/RolesHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/RejMsg.frm to ./OmNet/RejMsg.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/UserInOut.frm to ./OmNet/UserInOut.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/DBVersion.frm to ./OmNet/DBVersion.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/TempAuditTrailRep.frm to ./OmNet/TempAuditTrailRep.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/ComdtyParam.frm to ./OmNet/ComdtyParam.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/ArbSettings.frm to ./OmNet/ArbSettings.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/NSSettings.frm to ./OmNet/NSSettings.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/DeletedDealerAddMrv.frm to ./OmNet/DeletedDealerAddMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/DeletedDealerAddHist.frm to ./OmNet/DeletedDealerAddHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/WebUserModifications.frm to ./OmNet/WebUserModifications.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/DeletedClientAddMrv.frm to ./OmNet/DeletedClientAddMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/DeletedClientAddHist.frm to ./OmNet/DeletedClientAddHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/ArbIndex.frm to ./OmNet/ArbIndex.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/DealerExchMrv.frm to ./OmNet/DealerExchMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/OrderSliceHist.frm to ./OmNet/OrderSliceHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/MenuList.frm to ./OmNet/MenuList.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/PortFixTradeHist.frm to ./OmNet/PortFixTradeHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/FixTradeHist.frm to ./OmNet/FixTradeHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/PortFixOrderMrv.frm to ./OmNet/PortFixOrderMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/FixOrderMrv.frm to ./OmNet/FixOrderMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/LedgerReport.frm to ./OmNet/LedgerReport.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/COROrders.frm to ./OmNet/COROrders.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/DPMasterHist.frm to ./OmNet/DPMasterHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/DPMasterMrv.frm to ./OmNet/DPMasterMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/BGCCodeMapping.frm to ./OmNet/BGCCodeMapping.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/NSCSettings.frm to ./OmNet/NSCSettings.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/SIPInfoMrv.frm to ./OmNet/SIPInfoMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/SIPInfoHist.frm to ./OmNet/SIPInfoHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/PortSIPInfoMrv.frm to ./OmNet/PortSIPInfoMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/PortSIPInfoHist.frm to ./OmNet/PortSIPInfoHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/NestPRMS.frm to ./OmNet/NestPRMS.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/BranchClientAdHoc.frm to ./OmNet/BranchClientAdHoc.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/CommScripProps.frm to ./OmNet/CommScripProps.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/EqSIP.frm to ./OmNet/EqSIP.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/ClntAsgnHist.frm to ./OmNet/ClntAsgnHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/MakerCheckerLogs.frm to ./OmNet/MakerCheckerLogs.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/vwTradeHist.frm to ./OmNet/vwTradeHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/vwTomMsgHist.frm to ./OmNet/vwTomMsgHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/vwTomMsgMrv.frm to ./OmNet/vwTomMsgMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/NetWorthValue.frm to ./OmNet/NetWorthValue.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/ArbBsktIndxhSettings.frm to ./OmNet/ArbBsktIndxhSettings.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/FundTransfer.frm to ./OmNet/FundTransfer.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/AlgoSettings.frm to ./OmNet/AlgoSettings.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/NSRMSLimits.frm to ./OmNet/NSRMSLimits.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/CrossDeals.frm to ./OmNet/CrossDeals.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/RMSBlockHist.frm to ./OmNet/RMSBlockHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/RMSExclusionMrv.frm to ./OmNet/RMSExclusionMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/RMSExclusionHist.frm to ./OmNet/RMSExclusionHist.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/RMSCategoriesMrv.frm to ./OmNet/RMSCategoriesMrv.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/PostOrderRej.frm to ./OmNet/PostOrderRej.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/ExtUserAccessFlags.frm to ./OmNet/ExtUserAccessFlags.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/EmailLogs.frm to ./OmNet/EmailLogs.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/PortTomMsgHist4L.frm to ./OmNet/PortTomMsgHist4L.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/PortTomMsgMrv4L.frm to ./OmNet/PortTomMsgMrv4L.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/TomMsgHist4L.frm to ./OmNet/TomMsgHist4L.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [01] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09/OmNet/TomMsgMrv4L.frm to ./OmNet/TomMsgMrv4L.frm 200211 22:21:14 [01] ...done 200211 22:21:14 [00] Copying /else/xb_test/backup_dir/inc/2020-02-11_22-07-09//xtrabackup_info to ./xtrabackup_info 200211 22:21:14 [00] ...done xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = . xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend xtrabackup: innodb_log_group_home_dir = . xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 2147483648 InnoDB: PUNCH HOLE support available InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Uses event mutexes InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier InnoDB: Compressed tables use zlib 1.2.7 InnoDB: Number of pools: 1 InnoDB: Using CPU crc32 instructions InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M InnoDB: Completed initialization of buffer pool InnoDB: page_cleaner coordinator priority: -20 InnoDB: Setting log file ./ib_logfile101 size to 2048 MB InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 InnoDB: Setting log file ./ib_logfile1 size to 2048 MB InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 InnoDB: New log files created, LSN=7481544648 InnoDB: Highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 7481544716 InnoDB: Doing recovery: scanned up to log sequence number 7481544725 (0%) InnoDB: Database was not shutdown normally! InnoDB: Starting crash recovery. InnoDB: Removed temporary tablespace data file: "ibtmp1" InnoDB: Creating shared tablespace for temporary tables InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... InnoDB: File './ibtmp1' size is now 12 MB. InnoDB: 96 redo rollback segment(s) found. 1 redo rollback segment(s) are active. InnoDB: 32 non-redo rollback segment(s) are active. InnoDB: page_cleaner: 1000ms intended loop took 66125ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.) InnoDB: 5.7.26 started; log sequence number 7481544725 xtrabackup: starting shutdown with innodb_fast_shutdown = 1 InnoDB: FTS optimize thread exiting. InnoDB: Starting shutdown... InnoDB: Shutdown completed; log sequence number 7481546402 200211 22:22:21 completed OK! 2020-02-11 22:22:21 DEBUG - - - - The end of the Prepare Stage. - - - - 2020-02-11 22:22:21 DEBUG Shutting Down MySQL server: 2020-02-11 22:22:21 ERROR Could not Shutdown MySQL!. Refer to MySQL error log 2020-02-11 22:22:21 ERROR Unknown operation 'mysql_1'. 2020-02-11 22:22:21 ERROR RuntimeError: FAILED: Shutdown MySQL -> Unknown operation 'mysql_1'. 2020-02-11 22:22:21 DEBUG <pid.PidFile object at 0x7f704a7055c8> closing pidfile: /tmp/autoxtrabackup.pid 2020-02-11 22:22:21 DEBUG <pid.PidFile object at 0x7f704a7055c8> closing pidfile: /tmp/autoxtrabackup.pid