Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

xtrabackup doesn't pick up --innodb-log-group-home-dir config parameter

Description

We use xtrabackup to create and prepare backups on an NFS mount. We have about 20 database instances and create weekly full backups. Every week 1-2 backups are failing due to some NFS related problem (“The redo log file ./#innodb_redo/#ib_redo0 size … is not a multiple of innodb_page_size”). A working solution could be if the #innodb_redo resource could be used from a local (not mounted) folder.

The problem/bug is that it seems that xtrabackup doesn’t pick up the related configuration parameter. Tried three ways:

  • through command line parameter to xtrabackup command (--innodb-log-group-home-dir)

  • through .cnf file:

    • [xtrabackup] block, innodb_log_group_home_dir parameter

    • [mysqld] block, innodb_log_group_home_dir parameter

The command which was run:

Contents of the referred config file (./xtrabackup-mysql.cnf):

Environment

None

Activity

Show:

Aaditya Dubey January 14, 2025 at 9:57 AM

Hi

This report is now verified. Thank you!

Bence January 13, 2025 at 3:38 PM

Hello ,

could You manage to have any improvements on this topic?

Aaditya Dubey December 16, 2024 at 3:00 PM

Hi

Sorry for the delay in response, I was on vacation, so I couldn’t check this, I'll replay the steps and update you at the earliest.

Bence December 3, 2024 at 11:34 AM

hello ,

could You play the steps and reproduce the problem? Can I help in anything?

Aaditya Dubey November 21, 2024 at 10:45 AM

Hi

Thank you for the updates. We will take a look and update you further.

Details

Assignee

Reporter

Needs QA

Yes

Affects versions

Priority

Smart Checklist

Created October 22, 2024 at 7:46 AM
Updated January 14, 2025 at 9:57 AM
Configure