Not the answer you need?
Register and ask your own question!

XtraBackup fails when locking tables

vuthervuther EntrantCurrent User Role Beginner

I’ve been trying to use XtraBackup to slave my primary database server and whenever it gets to the locking part for the slave information it fails.

Command: innobackupex --compress --compress-threads=8 --parallel=8 --slave-info --user=user --password=pass --stream=xbstream ./ | ssh [email protected] "xbstream -x -C /mysql/backup/"

Xtrabackup ver: 2.0.6

120709 09:36:51 innobackupex: Starting to lock all tables...
>> log scanned up to (13444798539790)
innobackupex: Error: mysql child process has died: ERROR 1205 (HY000) at line 7: Lock wait timeout exceeded; try restarting transaction
while waiting for reply to MySQL request: 'FLUSH TABLES WITH READ LOCK;' at /usr//bin/innobackupex line 374.

I’ve tried this now about 4 times and each time it does this. Does anyone have any idea why it would continue to do this?



Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.