# Xtrabackup Error - SET SESSION lock\_wait\_timeout=31536000: MySQL server has gone away

**URL:** <https://forums.percona.com/t/xtrabackup-error-set-session-lock-wait-timeout-31536000-mysql-server-has-gone-away/5346>\
**Category:** Percona XtraBackup\
**Created:** [January 13, 2017, 10:35am UTC](https://forums.percona.com/t/xtrabackup-error-set-session-lock-wait-timeout-31536000-mysql-server-has-gone-away/5346 "2017-01-13T10:35:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![debdba](https://avatars.discourse-cdn.com/v4/letter/d/cc9497/32.png) [@debdba](https://forums.percona.com/u/debdba)\
**Post date:** [January 13, 2017, 10:35am UTC](https://forums.percona.com/t/xtrabackup-error-set-session-lock-wait-timeout-31536000-mysql-server-has-gone-away/5346/1 "2017-01-13T10:35:22Z")

</div>

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)

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [March 30, 2017, 1:37am UTC](https://forums.percona.com/t/xtrabackup-error-set-session-lock-wait-timeout-31536000-mysql-server-has-gone-away/5346/2 "2017-03-30T01:37:29Z")

</div>

Do you have any cron which kills long running queries in background e.g. pt-kill ? Can you please post full backup output along with my.cnf contents to check further. I also reported same bug earlier but it’s still not verified.