failed to execute query 'LOCK TABLES FOR BACKUP'

Description

When running a backup in mysqld 8.4.0-1 using xtrabackup 8.4.0-2 on a dev server. Mysql crashes and backup does not compete.

Command run: xtrabackup --backup --target-dir='/MysqlBackup/Auto_backup/full_2025050206422913' --user=backupuser --password='***'

Getting the following error:

2025-05-02T08:10:30.772766+05:30 0 [Note] [MY-011825] [Xtrabackup] Executing LOCK TABLES FOR BACKUP ...
xtrabackup: Unknown error 1158
2025-05-02T08:10:31.058905+05:30 0 [ERROR] [MY-011825] [Xtrabackup] failed to execute query 'LOCK TABLES FOR BACKUP' : 2013 (HY000) Lost connection to MySQL server during query..

from the Mysqld logs i get the following:

2025-05-02T02:30:59.083582Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/lib/mysql/mysqlx.sock
terminate called after throwing an instance of 'std::logic_error'
what(): basic_string: construction from null is not valid
2025-05-02T02:40:30Z UTC - mysqld got signal 6 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=f9481a53d2d8b1b714a787ec7b7175be4176d83a
Server Version: 8.4.0-1 Percona Server (GPL), Release 1, Revision 238b3c02

Thread pointer: 0x7f5fd0013860
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 7f609c493b50 thread_stack 0x100000
#0 0xe24694 <unknown>
#1 0xe24c6b <unknown>
#2 0x7f631443e72f <unknown>
#3 0x7f631448b52c <unknown>
#4 0x7f631443e685 <unknown>
#5 0x7f6314428832 <unknown>
#6 0x7f63148a1b20 <unknown>
#7 0x7f63148ad52b <unknown>
#8 0x7f63148ac4f8 <unknown>
#9 0x7f63148acc79 <unknown>
#10 0x7f6314afe2d3 <unknown>
#11 0x7f6314afe970 <unknown>
#12 0x7f63148ad7eb <unknown>
#13 0x7f63148a43d2 <unknown>
#14 0x7f62fc3ff254 <unknown>
#15 0x7f62fc3e1591 <unknown>
#16 0x7f62fc3dfdb9 <unknown>
#17 0x7f62fc3e4792 <unknown>
#18 0x7f62fc39ed3b <unknown>
#19 0xc6055d <unknown>
#20 0xe24d1b <unknown>
#21 0xe273a5 <unknown>
#22 0xccf0ea <unknown>
#23 0xcd2ca0 <unknown>
#24 0xcd4ef1 <unknown>
#25 0xcd5b06 <unknown>
#26 0xe266f6 <unknown>
#27 0x1a060c1 <unknown>
#28 0x7f63144897e1 <unknown>
#29 0x7f631450e7ff <unknown>
#30 0xffffffffffffffff <unknown>

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f5fd0541da0): LOCK TABLES FOR BACKUP
Connection ID (thread ID): 44
Status: NOT_KILLED

Please help us make Percona Server better by reporting any
bugs at

Environment

Red Hat Enterprise Linux release 9.5 (Plow)

Activity

Show:

Satya Bodapati 
May 2, 2025 at 4:58 AM

Please upgrade the server to 8.4.4-4. this is a known issue with server.

Duplicate

Details

Assignee

Reporter

Needs QA

Components

Affects versions

Priority

Created May 2, 2025 at 2:49 AM
Updated May 2, 2025 at 4:58 AM
Resolved May 2, 2025 at 4:58 AM