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 user@host “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?