# Innobackupex - MySQL server has gone away when SET SESSION lock\_wait\_timeout=31536000

**URL:** <https://forums.percona.com/t/innobackupex-mysql-server-has-gone-away-when-set-session-lock-wait-timeout-31536000/4129>\
**Category:** Percona XtraBackup\
**Created:** [March 27, 2015, 11:09am UTC](https://forums.percona.com/t/innobackupex-mysql-server-has-gone-away-when-set-session-lock-wait-timeout-31536000/4129 "2015-03-27T11:09:38Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrpk1906](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@mrpk1906](https://forums.percona.com/u/mrpk1906)\
**Post date:** [March 27, 2015, 11:09am UTC](https://forums.percona.com/t/innobackupex-mysql-server-has-gone-away-when-set-session-lock-wait-timeout-31536000/4129/1 "2015-03-27T11:09:38Z")

</div>

Hi,

I have mysql server 5.5 with \> 300GB data.  
I tried create a slave from this master server.

When i run innobackupex, it died at SET SESSION lock\_wait\_timeout=31536000

This is error:

```auto
DBD::mysql::db do failed: MySQL server has gone away at /usr/bin/innobackupex line 3045.
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3048
main::mysql_query('HASH(0x19b4fed0)', 'SET SESSION lock_wait_timeout=31536000') called at /usr/bin/innobackupex line 3456
main::mysql_lock_tables('HASH(0x19b4fed0)') called at /usr/bin/innobackupex line 1991
main::backup() called at /usr/bin/innobackupex line 1601
innobackupex: Error:
Error executing 'SET SESSION lock_wait_timeout=31536000': DBD::mysql::db do failed: MySQL server has gone away at /usr/bin/innobackupex line 3045.
150322 21:25:24 innobackupex: Waiting for ibbackup (pid=30331) to finish

```

I tried repeat 2 times but same errors.

I read tutorial at [url][Percona XtraBackup](http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/improved_ftwrl.html%5B/url%5D)  
and set options same this tut but not success.

Sorry, my english is very poor 😃

Thanks!

---

<div class="post-metadata">

**Author:** ![wagnerbianchi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wagnerbianchi/32/802_2.png) [@wagnerbianchi](https://forums.percona.com/u/wagnerbianchi)\
**Post date:** [March 30, 2015, 1:59pm UTC](https://forums.percona.com/t/innobackupex-mysql-server-has-gone-away-when-set-session-lock-wait-timeout-31536000/4129/2 "2015-03-30T13:59:33Z")

</div>

Not sure if this is connected with max\_allowed\_packet, but, is this a teste environment? Can you SET max\_allowed\_packet a little bit higher than the current value and test again?

---

<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, 2015, 3:48pm UTC](https://forums.percona.com/t/innobackupex-mysql-server-has-gone-away-when-set-session-lock-wait-timeout-31536000/4129/3 "2015-03-30T15:48:47Z")

</div>

What version of xtrabackup you are using ?  
$ xtrabackup --version

Also, can you please show me exact command you used to take backup along with my.cnf contents.

---

<div class="post-metadata">

**Author:** ![mrpk1906](https://avatars.discourse-cdn.com/v4/letter/m/73ab20/32.png) [@mrpk1906](https://forums.percona.com/u/mrpk1906)\
**Post date:** [March 31, 2015, 9:13am UTC](https://forums.percona.com/t/innobackupex-mysql-server-has-gone-away-when-set-session-lock-wait-timeout-31536000/4129/4 "2015-03-31T09:13:52Z")

</div>

Hi,

Thanks for your support,

@wagnerbianchi: I set max\_allowed\_packet to 1GB, wait\_timeout and interactive\_timeout=28800 ( default ), lock\_wait\_timeout= 1 year (default) but same error.

@mirfan: i’m using lastest version of xtrabackup

Update: I reinstall xtrabackup with version 2.0.8 and this issue solved.

Thanks!

---

<div class="post-metadata">

**Author:** ![Rudrojit](https://avatars.discourse-cdn.com/v4/letter/r/e47c2d/32.png) [@Rudrojit](https://forums.percona.com/u/Rudrojit)\
**Post date:** [July 31, 2021, 1:35pm UTC](https://forums.percona.com/t/innobackupex-mysql-server-has-gone-away-when-set-session-lock-wait-timeout-31536000/4129/5 "2021-07-31T13:35:54Z")

</div>

Hi @wagnerbianchi  
Exactly what change did you do while reinstalling? I am facing the same issue with Percona-Xtrabackup 8.0.22 and my instance size is 4TB.