Xtrabackup Error - SET SESSION lock_wait_timeout=31536000: MySQL server has gone away

Asked by Debashish Majumdar on 2017-01-14

While taking backup of our percona mysql DB, I'm getting this error:

SET SESSION lock_wait_timeout=31536000: MySQL server has gone away

The database is: Server version: 5.7.16-10-log Percona Server (GPL), Release '10', Revision 'a0c7d0d'

The Xtrabackup version that I use is

$ xtrabackup --version xtrabackup version 2.4.5 based on MySQL server 5.7.13 Linux (x86_64) (revision id: e41c0be)

The backup command that I've used is -

innobackupex /backuppath/

I use Ubuntu 16.04.1 LTS (GNU/Linux 4.4.0-59-generic x86_64)

Question information

Language:
English Edit question
Status:
Solved
For:
Percona XtraBackup moved to https://jira.percona.com/projects/PXB Edit question
Assignee:
No assignee Edit question
Solved by:
Debashish Majumdar
Solved:
2017-01-15
Last query:
2017-01-15
Last reply:
Debashish Majumdar (dbadeb) said : #1

A pt-kill was running in the background. It seems that Xtrabackup creates a thread on the MySQL sever that goes into sleep mode till the end when it tries to do a SET SESSION lock_wait_timeout=31536000. After I reran pt-kill with --match-user option that now selectively killed sessions of a particular user and not the one which Xtrabackup was using, it finished fine.