/rdsdbdata/log/innodb/ib_logfile0: 'open' returned OS error

MySQL & MariaDB
1

Could anybody have had below error msg when I was executing xtrabackup.

2022-09-01T22:48:27.501931+08:00 0 [Note] [MY-011825] [Xtrabackup] Using server version 8.0.28
2022-09-01T22:48:27.504162+08:00 0 [Note] [MY-011825] [Xtrabackup] uses posix_fadvise().
2022-09-01T22:48:27.504193+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /rdsdbdata/db/
2022-09-01T22:48:27.504208+08:00 0 [Note] [MY-011825] [Xtrabackup] open files limit requested 0, set to 1024
2022-09-01T22:48:27.504238+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration:
2022-09-01T22:48:27.504249+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = /rdsdbdata/db/innodb
2022-09-01T22:48:27.504258+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2022-09-01T22:48:27.504286+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = /rdsdbdata/log/innodb
2022-09-01T22:48:27.504296+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2022-09-01T22:48:27.504306+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 134217728
2022-09-01T22:48:27.504789+08:00 0 [Note] [MY-013251] [InnoDB] Number of pools: 1
2022-09-01T22:48:27.505579+08:00 0 [Note] [MY-011825] [Xtrabackup] inititialize_service_handles suceeded
2022-09-01T22:48:27.608691+08:00 0 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
2022-09-01T22:48:27.608745+08:00 0 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
2022-09-01T22:48:27.608757+08:00 0 [ERROR] [MY-012594] [InnoDB] If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2022-09-01T22:48:27.608771+08:00 0 [ERROR] [MY-012646] [InnoDB] File /rdsdbdata/log/innodb/ib_logfile0: ‘open’ returned OS error 71. Cannot continue operation
2022-09-01T22:48:27.608783+08:00 0 [ERROR] [MY-012981] [InnoDB] Cannot continue operation.

2

Hi @qiujie ,

This error means pxb cannot find ib_logfile. As part of its startup it renames xtrabackup_logfile to ib_logfile0.

Can you please send us an ls from your backup directory?

Also, I noticed that it is looking to find the logfile under log/innodb folder, which seems to be a configuration from your my.cnf.
Can you please try to run prepare as follow:

xtrabackup --no-defaults --prepare --target-dir=/path/to/backup

Thanks

1 Like
3

Thank you for your reply. I used the AWS RDS MySQL. I want to use XtraBackup to backup RSD MySQL. I installed XtraBackup tool on the other AWS EC2(my test server) and I tried run backup command, but it dosn’t work. I am not sure the if the tool have to be installed on AWS RDS server. AWS RDS document said “MySQL database files that can be restored from Amazon S3”. I am not sure if I need use Amazon S3.

1 Like
4

Thank you for your reply. I used the AWS RDS MySQL. I want to use XtraBackup to backup RSD MySQL. I installed XtraBackup tool on the other AWS EC2(my test server) and I tried run backup command, but it dosn’t work. I am not sure the if the tool have to be installed on AWS RDS server. AWS RDS document said “MySQL database files that can be restored from Amazon S3”. I am not sure if I need use Amazon S3.

1 Like
5

Hello, unfortunately you cannot use xtrabackup with RDS as it requires access to the underlying database files, which RDS does not provide as it is a managed service.

1 Like