[MDEV-17347] mariabackup example error Created: 2018-10-02  Updated: 2019-01-31  Resolved: 2019-01-31

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

Type: Bug Priority: Major
Reporter: Ian Gilfillan Assignee: Kenneth Dyer (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

Following report received:

Hi I think there's an error on:
https://mariadb.com/kb/en/library/full-backup-and-restore-with-mariadb-backup/
and likely also affects:
https://mariadb.com/kb/en/library/incremental-backup-and-restore-with-mariadb-backup/
This line: "$ mariabackup --prepare --target-dir /var/mariadb/backup/ \
-user backup_user --password backup_passwd" Should not include the "-user
backup_user --password backup_passwd" part. The comment from Vladislav
Vaintroub (2017-10-27 05:13)
https://jira.mariadb.org/browse/MDEV-14150?jql=text%20~%20%22backup%20prepare%20encryption%22
"--prepare does not need user, or password, it does not contact any
server.. , it does not understand --innodb-encrypt-log either, it is not a
server." explains this. Impact of including the username and password when
attempting to prepare an encrypted backup is the following error on Ubuntu
18 / Centos 7 2018-09-27 15:31:53 0 [ERROR] InnoDB: Obtaining redo log
encryption key version 1 failed (4294967295). Maybe the key or the required
encryption key management plugin was not found. 2018-09-27 15:31:53 0
[ERROR] InnoDB: Reading checkpoint encryption info failed. 2018-09-27
15:31:53 0 [ERROR] InnoDB: No valid checkpoint found (corrupted redo log).
You can try --innodb-force-recovery=6 as a last resort. 2018-09-27 15:31:53
0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
... fairly challenging to debug so think best to update the page if
possible.



 Comments   
Comment by Vladislav Vaintroub [ 2018-10-02 ]

greenman, --prepare sort of runs innodb recovery in special mode, and that's it.
encrypted prepare however needs encryption parameters of the server, which it saves during backup phase in backup-my.cnf file in backup directory.

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