innobackupex doesn't copy xtrabackup_logfile if 'UNLOCK TABLES' times out at end of script
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Triaged
|
High
|
Valentine Gostev | ||
1.6 |
Triaged
|
High
|
Valentine Gostev | ||
2.0 |
Triaged
|
High
|
Valentine Gostev |
Bug Description
After it flushes tables with read lock during the the "innobackupex: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ and .opt files" phase, UNLOCK TABLES will sometimes timeout due to whatever $process may be occurring within my application at the time (maybe an ALTER, massive traffic, etc).
So, I end up with:
xtrabackup: Transaction log of lsn (574 2452056146) to (574 3374977342) was copied.
innobackupex: Error: mysql child process has died: ERROR 2006 (HY000) at line 19: MySQL server has gone away
while waiting for reply to MySQL request: 'UNLOCK TABLES;' at /usr/bin/
innobackupex dies waiting for unlock tables to complete, but it doesn't copy the xtrabackup_logfile over to the target server.
It just leaves it behind in /tmp on the source server. If i manually copy it over then everything's fine, and recovery completes as normal.
Changed in percona-xtrabackup: | |
importance: | Undecided → Medium |
milestone: | none → release-1.2 |
Changed in percona-xtrabackup: | |
assignee: | nobody → Aleksandr Kuzminsky (akuzminsky) |
Changed in percona-xtrabackup: | |
milestone: | 1.2 → 1.3.1 |
Changed in percona-xtrabackup: | |
milestone: | 1.3.1 → none |
Changed in percona-xtrabackup: | |
importance: | Medium → High |
assignee: | Aleksandr Kuzminsky (akuzminsky) → nobody |
tags: | added: innobackupex |
Is this still reproducible in current xtrabackup? there have been a lot of bug fixes since this bug was filed. Please try to reproduce with a more recent release.
thanks for your report, and sorry it has stagnated for so long.