mariabackup based on MariaDB server 10.1.29-MariaDB Linux (x86_64) mariabackup: cd to /var/database/restored_xtrabackup/ mariabackup: This target seems to be not prepared yet. mariabackup: xtrabackup_logfile detected: size=71237632, start_lsn=(617690093687) mariabackup: using the following InnoDB configuration for recovery: mariabackup: innodb_data_home_dir = ./ mariabackup: innodb_data_file_path = ibdata1:12M:autoextend mariabackup: innodb_log_group_home_dir = ./ mariabackup: innodb_log_files_in_group = 1 mariabackup: innodb_log_file_size = 71237632 mariabackup: using the following InnoDB configuration for recovery: mariabackup: innodb_data_home_dir = ./ mariabackup: innodb_data_file_path = ibdata1:12M:autoextend mariabackup: innodb_log_group_home_dir = ./ mariabackup: innodb_log_files_in_group = 1 mariabackup: innodb_log_file_size = 71237632 mariabackup: Starting InnoDB instance for recovery. mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) 2018-02-05 14:36:04 140346924488960 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2018-02-05 14:36:04 140346924488960 [Note] InnoDB: The InnoDB memory heap is disabled 2018-02-05 14:36:04 140346924488960 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-05 14:36:04 140346924488960 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-02-05 14:36:04 140346924488960 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-02-05 14:36:04 140346924488960 [Note] InnoDB: Using SSE crc32 instructions 2018-02-05 14:36:04 140346924488960 [Note] InnoDB: Initializing buffer pool, size = 100.0M 2018-02-05 14:36:04 140346924488960 [Note] InnoDB: Completed initialization of buffer pool 2018-02-05 14:36:04 140346924488960 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-05 14:36:04 140346924488960 [Note] InnoDB: Starting crash recovery from checkpoint LSN=617690093687 2018-02-05 14:36:06 140346924488960 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer... 2018-02-05 14:36:07 140346924488960 [Note] InnoDB: Starting a batch to recover 14596 pages from redo log 2018-02-05 14:36:19 140346674882304 [Note] InnoDB: To recover: 5556 pages from log 2018-02-05 14:36:29 140346924488960 [Note] InnoDB: Starting a batch to recover 16395 pages from redo log 2018-02-05 14:36:34 140346700060416 [Note] InnoDB: To recover: 13054 pages from log 2018-02-05 14:36:49 140346700060416 [Note] InnoDB: To recover: 5043 pages from log 2018-02-05 14:37:03 140346924488960 [Note] InnoDB: Starting final batch to recover 708 pages from redo log 2018-02-05 14:37:04 140346691667712 [Note] InnoDB: To recover: 529 pages from log 2018-02-05 14:37:04 7fa510945900 InnoDB: Error: table 'novo_hermods_se/mdl_tag_correlation' InnoDB: in InnoDB data dictionary has tablespace id 19209, InnoDB: but a tablespace with that id does not exist. There is InnoDB: a tablespace of name novo_hermods_se/mdl_tag_correlation and id 19208, though. Have InnoDB: you deleted or moved .ibd files? InnoDB: Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html InnoDB: for how to resolve the issue. 2018-02-05 14:37:04 140346924488960 [Note] InnoDB: 128 rollback segment(s) are active. 2018-02-05 14:37:04 140346924488960 [Note] InnoDB: Waiting for purge to start 2018-02-05 14:37:04 140346924488960 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 617753407686 2018-02-05 14:37:05 140346516276992 [Note] InnoDB: Dumping buffer pool(s) not yet started mariabackup: Recovered WSREP position: c926c607-f9ce-11e6-b203-ce70d0d27d00:179401629 mariabackup: starting shutdown with innodb_fast_shutdown = 1 2018-02-05 14:37:05 140346549847808 [Note] InnoDB: FTS optimize thread exiting. 2018-02-05 14:37:05 140346924488960 [Note] InnoDB: Starting shutdown... 2018-02-05 14:37:06 140346924488960 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2018-02-05 14:37:07 140346924488960 [Warning] InnoDB: Some resources were not cleaned up in shutdown: threads 0, events 17, os_mutexes 16, os_fast_mutexes 33 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: Shutdown completed; log sequence number 617753407696 mariabackup: using the following InnoDB configuration for recovery: mariabackup: innodb_data_home_dir = ./ mariabackup: innodb_data_file_path = ibdata1:12M:autoextend mariabackup: innodb_log_group_home_dir = ./ mariabackup: innodb_log_files_in_group = 2 mariabackup: innodb_log_file_size = 50331648 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: Using mutexes to ref count buffer pool pages 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: The InnoDB memory heap is disabled 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: Compressed tables use zlib 1.2.7 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: Using SSE crc32 instructions 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: Initializing buffer pool, size = 100.0M 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: Completed initialization of buffer pool 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2018-02-05 14:37:07 140346924488960 [Warning] InnoDB: New log files created, LSN=617753407696 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: 128 rollback segment(s) are active. 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: Waiting for purge to start 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 617753408012 mariabackup: starting shutdown with innodb_fast_shutdown = 1 2018-02-05 14:37:07 140346516276992 [Note] InnoDB: Dumping buffer pool(s) not yet started 2018-02-05 14:37:07 140346549847808 [Note] InnoDB: FTS optimize thread exiting. 2018-02-05 14:37:07 140346924488960 [Note] InnoDB: Starting shutdown... 2018-02-05 14:37:08 140346924488960 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool 2018-02-05 14:37:10 140346924488960 [Warning] InnoDB: Some resources were not cleaned up in shutdown: threads 0, events 33, os_mutexes 32, os_fast_mutexes 65 2018-02-05 14:37:10 140346924488960 [Note] InnoDB: Shutdown completed; log sequence number 617753408022 180205 14:37:10 completed OK!