DBD::mysql error
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
Medium
|
Alexey Kopytov | ||
2.1 |
Fix Released
|
Medium
|
Alexey Kopytov |
Bug Description
I upgraded from xtrabackup-2.0.7 to xtrabackup-2.1.1 yesterday. I'm using Ubuntu 12.04 LTS and percona-server5.5. Backups worked great until after the upgrade. Here's what happens:
<email address hidden>:/backups# innobackupex /backups/
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Ireland Ltd 2009-2012. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
130516 16:34:30 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:
130516 16:34:30 innobackupex: Connected to MySQL server
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using mysql server version 5.5.30-30.2-log
innobackupex: Created backup directory /backups/
WARNING : A left over instance of xtrabackup pid file '/tmp/xtrabacku
130516 16:34:30 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-
innobackupex: Waiting for ibbackup (pid=7562) to suspend
innobackupex: Suspend file '/backups/
xtrabackup_55 version 2.1.1 for Percona Server 5.5.16 Linux (x86_64) (revision id: 600)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: using O_DIRECT
>> log scanned up to (65109353)
[01] Copying ./ibdata1 to /backups/
>> log scanned up to (65109353)
[01] ...done
>> log scanned up to (65109353)
130516 16:34:33 innobackupex: Continuing after ibbackup has suspended
130516 16:34:33 innobackupex: Starting to lock all tables...
130516 16:34:33 innobackupex: All tables locked and flushed to disk
130516 16:34:33 innobackupex: Starting to backup non-InnoDB tables and files
innobackupex: in subdirectories of '/var/lib/mysql'
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up files '/var/lib/
>> log scanned up to (65109353)
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up files '/var/lib/
>> log scanned up to (65109353)
innobackupex: Backing up files '/var/lib/
>> log scanned up to (65109353)
>> log scanned up to (65109353)
>> log scanned up to (65109353)
innobackupex: Backing up files '/var/lib/
>> log scanned up to (65109353)
>> log scanned up to (65109353)
>> log scanned up to (65109353)
innobackupex: Backing up files '/var/lib/
>> log scanned up to (65109353)
>> log scanned up to (65109353)
>> log scanned up to (65109353)
innobackupex: Backing up files '/var/lib/
>> log scanned up to (65109353)
>> log scanned up to (65109353)
>> log scanned up to (65109353)
130516 16:34:47 innobackupex: Finished backing up non-InnoDB tables and files
130516 16:34:47 innobackupex: Waiting for log copying to finish
xtrabackup: The latest check point (for incremental): '65109353'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (65109353)
xtrabackup: Transaction log of lsn (65109353) to (65109353) was copied.
DBD::mysql::db do failed: Lost connection to MySQL server during query at /usr/bin/
innobackupex: Error:
Error executing 'UNLOCK TABLES': DBD::mysql::db do failed: Lost connection to MySQL server during query at /usr/bin/
The errors at the end indicate it probably relates to the change to use perl dbd::mysql instead of the mysql client directly, but I'm not sure where to go from here.
Related branches
- Alexey Kopytov (community): Approve
-
Diff: 12 lines (+1/-1)1 file modifiedsrc/Makefile (+1/-1)
Jeremy,
It looks like wait_timeout on the server is set to some very small value. Can you confirm this? Thanks.