MySQL Forums
Forum List  »  Backup

Mysqlbackup 8.0.19 with backup-to-image option fails on file backup-auto.cnf
Posted by: Christopher Lott
Date: August 13, 2020 10:22AM

I'm using MySQL Enterprise Backup Ver 8.0.19-commercial for Linux, running the mysqlbackup command-line tool. I would like to create a single image file backup and am using the backup-to-image option, also see below. It invariably fails when it tries to create a file backup-auto.cnf within the backup directory. Has anyone else seen this?

What have I tried for --backup-dir argument that fails?
1. Invoke with non-existing directory; fails when creating backup-auto.cnf
2. Create a new directory and invoke with that; fails when creating backup-auto.cnf
3. Create a new directory, add a "datadir" subdirectory with mode 777; but mysqldump refuses to start at all

Please note, found this link with the output of mysqldump version 8.0.16, shows it working fine and NOT creating a file "backup-auto.cnf" so maybe something changed in 8.0.19:
https://docs.oracle.com/cd/E17952_01/mysql-enterprise-backup-8.0-en/mysqlbackup.backup.html

Full output below. Sorry I don't know how to add markup that keeps it fixed-width and verbatim, is that supported in this forum?

Am I missing a required command-line option? Please let me know, thanks in advance.

--

# /usr/bin/mysqlbackup --backup-dir=/tmp/bkup --backup-image=/tmp/bkup/mysqlbackup.mbi backup-to-image
MySQL Enterprise Backup Ver 8.0.19-commercial for Linux on x86_64 (MySQL Enterprise - Commercial)
Copyright (c) 2003, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Starting with following command line ...
/usr/bin/mysqlbackup --backup-dir=/tmp/bkup
--backup-image=/tmp/bkup/mysqlbackup.mbi backup-to-image

IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'backup-to-image' run mysqlbackup
prints "mysqlbackup completed OK!".

200813 16:06:19 MAIN INFO: Starting to log actions.
200813 16:06:19 MAIN INFO: No SSL options specified.
200813 16:06:19 MAIN INFO: MySQL server version is '8.0.19-commercial'
200813 16:06:19 MAIN INFO: MySQL server compile os version is 'Linux'
200813 16:06:19 MAIN INFO: Got some server configuration information from running server.

200813 16:06:19 MAIN INFO: No SSL options specified.
200813 16:06:19 MAIN INFO: Backup directory exists: '/tmp/bkup'
200813 16:06:19 MAIN INFO: MySQL server version_comment is 'MySQL Enterprise Server - Commercial'
200813 16:06:19 MAIN INFO: Mysqlbackup component not installed.
200813 16:06:19 MAIN INFO: Server is not a community server.
200813 16:06:19 MAIN INFO: KEF target path:'/tmp/bkup/meta/keyring_kef'
200813 16:06:19 MAIN INFO: TDE Keyring service initialized.
200813 16:06:19 MAIN INFO: MEB logfile created at /tmp/bkup/meta/MEB_2020-08-13.16-06-19_image_backup.log

--------------------------------------------------------------------
Server Repository Options:
--------------------------------------------------------------------
datadir = /var/lib/mysql/
innodb_data_home_dir =
innodb_data_file_path = ibdata1:12M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_files_in_group = 2
innodb_log_file_size = 52428800
innodb_undo_directory = /var/lib/mysql/
innodb_undo_tablespaces = 2
innodb_buffer_pool_filename = ib_buffer_pool
innodb_page_size = 16384
innodb_checksum_algorithm = crc32

--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /tmp/bkup/datadir
innodb_data_home_dir = /tmp/bkup/datadir
innodb_data_file_path = ibdata1:12M:autoextend
innodb_log_group_home_dir = /tmp/bkup/datadir
innodb_log_files_in_group = 2
innodb_log_file_size = 52428800
innodb_undo_directory = /tmp/bkup/datadir
innodb_undo_tablespaces = 2
innodb_buffer_pool_filename = ib_buffer_pool
innodb_page_size = 16384
innodb_checksum_algorithm = crc32

Backup Image Path = /tmp/bkup/mysqlbackup.mbi
200813 16:06:19 MAIN INFO: Unique generated backup id for this is 15973347795017716

200813 16:06:19 MAIN INFO: Creating 14 buffers each of size 16777216.
200813 16:06:19 MAIN INFO: Failed to start redo log archiving...
200813 16:06:19 MAIN INFO: Found checkpoint at lsn 43050390.
200813 16:06:19 MAIN INFO: Starting log scan from lsn = 43049984 at offset = 2048 and checkpoint = 43050390 in file /var/lib/mysql/ib_logfile0.
200813 16:06:19 MAIN INFO: Full Image Backup operation starts with following threads
1 read-threads 6 process-threads 1 write-threads
200813 16:06:19 MAIN INFO: No SSL options specified.
200813 16:06:19 RDR1 INFO: Copying meta file /tmp/bkup/backup-my.cnf.
200813 16:06:19 RLP1 INFO: Starting to parse redo log at lsn = 43050109, whereas checkpoint_lsn = 43050390.
200813 16:06:19 RDR1 INFO: Copying meta file /tmp/bkup/meta/backup_create.xml.
200813 16:06:19 RDR1 INFO: Copying meta file /tmp/bkup/datadir/backup-auto.cnf.
200813 16:06:19 RDR1 ERROR: Opening of file /tmp/bkup/datadir/backup-auto.cnf failed. Error code: 2, No such file or directory

200813 16:06:19 RDR1 ERROR: Missing file /tmp/bkup/datadir/backup-auto.cnf
200813 16:06:19 RDR1 INFO: Requesting rapid completion of redo log copy.
200813 16:06:19 RDR1 INFO: Requesting completion of redo log copy after LSN 0.
200813 16:06:20 RLR1 INFO: Redo log reader waited 0 times for a total of 0.00 ms for logs to generate.

mysqlbackup exit code: 9, IO operation failed

mysqlbackup failed with errors!

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysqlbackup 8.0.19 with backup-to-image option fails on file backup-auto.cnf
699
August 13, 2020 10:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.