Skip to:

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

Xtrabackup failed to execute query 'DO innodb_redo_log_consumer_register("PXB");'

Description

Got below Xtrabackup error when sql_mode = 'ANSI_QUOTES'  and --register-redo-log-consumer option is used :

 

 

How to Repeat :

1) MySQL

 

 

2) Shell

 

 

3) backup.log

Workaround

None. As removing ANSI_QUOTES in sql_mode might affect queries like below :

 

Reference : https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html#sqlmode_ansi_quotes

 

Environment

None

AFFECTED CS IDs

CS0039450

Attachments

1

Activity

Show:

Marcelo Altmann September 28, 2023 at 3:00 PM

Few workarounds:

  1. Increase redo log size and don't use register consumer

  2. take backup on a replica using --safe-slave-backup

  3. Enable redo log archiving

Done

Details

Assignee

Reporter

Needs QA

Yes

Fix versions

Affects versions

Priority

Smart Checklist

Created September 14, 2023 at 7:46 AM
Updated March 6, 2024 at 6:04 PM
Resolved October 11, 2023 at 12:40 PM