innobackupex: Error executing 'SET SESSION lock_wait_timeout=31536000': DBD::mysql::db do failed
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
New
|
Undecided
|
Unassigned |
Bug Description
I have a daily backup procecss using Xtrabackup v2.2.9 on a 5.5.42 Community MYSQL server which has just started failing with the following error message:
/db/opt/
>> log scanned up to (1903249685582)
xtrabackup: Creating suspend file '/db/mysql/
>> log scanned up to (1903250264417)
150514 10:40:44 innobackupex: Continuing after ibbackup has suspended
DBD::mysql::db do failed: MySQL server has gone away at /db/opt/
innobackupex: got a fatal error with the following stacktrace: at /db/opt/
main::mysql_
main::mysql_
main::backup() called at /db/opt/
innobackupex: Error:
Error executing 'SET SESSION lock_wait_
150514 10:40:44 innobackupex: Waiting for ibbackup (pid=16768) to finish
NOTE: Same error appears with xtrabackup version 2.2.10.
# rpm -qa | grep xtrabackup
percona-
# xtrabackup --version
xtrabackup version 2.2.10 based on MySQL server 5.6.22 Linux (x86_64) (revision id: )
# rpm -qa|egrep 'perl-5|
perl-5.
perl-libs-
perl-DBIx-
perl-DBI-
perl-libwww-
# rpm -qa | grep MySQL
perl-DBD-
MySQL-shared-
# cat /etc/issue
Red Hat Enterprise Linux Server release 6.1 (Santiago)
Kernel \r on an \m
# uname -a
Linux pchiaquadb01.
my.cnf:
[client]
port = 3306
socket = /db/mysql/
[mysql]
default-
[mysqldump]
quick
max_allowed_packet = 16M
[mysqld]
# generic configuration options
port = 3306
socket = /db/mysql/
basedir = /db/opt/mysql
datadir = /db/mysql/3306/data
character_
tmpdir = /db/mysql/3306/tmp
log_error = /db/mysql/
back_log = 50
#skip-networking
max_connections = 1024
max_connect_errors = 10
max_allowed_packet = 1G
table_open_cache = 2048
max_allowed_packet = 16M
binlog_cache_size = 1M
max_heap_table_size = 64M
read_buffer_size = 2M
read_rnd_
sort_buffer_size = 8M
join_buffer_size = 8M
thread_cache_size = 8
thread_concurrency = 8
thread_stack = 192K
transaction_
tmp_table_size = 64M
sync_binlog = 0
log_warnings
slow_query_log
long_query_time = 2
event_scheduler = 1
lower_case_
expire_logs_days = 14
server_id = 12750
key_buffer_size = 32M
bulk_insert_
myisam_
myisam_
myisam_
myisam_recover
innodb_
innodb_
innodb_
# innodb_
innodb_
innodb_
#innodb_
innodb_
innodb_
#innodb_
innodb_
innodb_
innodb_
# innodb_
innodb_
# innodb_
innodb_
wait_timeout=129600
innodb_
# Standard Replication
#innodb_
log_bin = mysql-bin
log_slave_updates
binlog_format = MIXED
# Currently only InnoDB storage engine is supported
default-
# to avoid issues with 'bulk mode inserts' using autoinc
innodb_
# This is a must for paralell applying
innodb_
# Query Cache is not supported with wsrep
query_cache_size = 0
query_cache_type = 0
summary: |
- innobackupex fails on setting lock_wait_timeout + innobackupex: Error executing 'SET SESSION lock_wait_timeout=31536000': + DBD::mysql::db do failed |
tags: | added: i54292 |
Changed in percona-xtrabackup: | |
status: | Incomplete → New |
Any ideas on how to reproduce this? Maybe something useful from the error log of server failed or anything that may help to create a test case for this?