[MDEV-17562] Unable to prepare the mariadb backup Created: 2018-10-29  Updated: 2018-11-02  Resolved: 2018-11-02

Status: Closed
Project: MariaDB Server
Component/s: Backup
Affects Version/s: 10.3.8
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: atul kumar jadhav Assignee: Vladislav Vaintroub
Resolution: Incomplete Votes: 0
Labels: None
Environment:

OS RHEL 7.5, maria db 10.3.8 database server


Attachments: JPEG File error.JPG    

 Description   

Dear Team,
I have taken backup of the mariadb database using the command
mariabackup --backup --target-dir /tmp/FULLBACKUP --user XXXX --password XXXX

but while preparing using the following command
mariabackup --prepare --plugin-dir=/usr/lib64/mysql/plugin/ --plugin-load=file_key_management.so --file-key-management-filename=/etc/mysql/keys.txt --target-dir /tmp/FULLBACKUP/ --user XXXX --password XXXXX --apply-log-only
the restore I am getting the following error:

2018-10-29 18:45:41 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-10-29 18:45:41 0 [Note] InnoDB: Uses event mutexes
2018-10-29 18:45:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2018-10-29 18:45:41 0 [Note] InnoDB: Number of pools: 1
2018-10-29 18:45:41 0 [Note] InnoDB: Using SSE2 crc32 instructions
2018-10-29 18:45:41 0 [Note] InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M
2018-10-29 18:45:41 0 [Note] InnoDB: Completed initialization of buffer pool
2018-10-29 18:45:41 0 [Note] InnoDB: page_cleaner coordinator priority: -20
2018-10-29 18:45:41 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=341724684
2018-10-29 18:45:41 0 [ERROR] InnoDB: Missing MLOG_CHECKPOINT at 341724684 between the checkpoint 341724684 and the end 341728983.
2018-10-29 18:45:41 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-10-29 ]

This looks like it was meant to be a MariaDB Server bug, not MariaDB ColumnStore. I have moved the ticket appropriately.

Comment by atul kumar jadhav [ 2018-10-31 ]

Dear Team,

I used the following prepare statement and it worked:
mariabackup --prepare --target-dir /tmp/FULLBACKUP/ --apply-log-only

In this I removed the user and password provided in the statement while preparing.

issue resolved, please close the request.

Comment by Vladislav Vaintroub [ 2018-11-02 ]

Closing as requested.

Please, do not use encryption plugin related parameters , if you do not need them.

sometimes, but probably rarely, you'll need to fixup the plugin path during --prepare. That happens if you move backup to OS with a different plugin path. In those rare special cases you can use the parameters. In others, please do not.

Generated at Thu Feb 08 08:37:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.