Strange error (At least for me).

Hello everybody, I hope you can help me (and anybody else facing a similar error). When I attempt to use the xtrabackup, after all my databases are dumped the process fails with the following error:
Error: failed to execute query ‘SET SESSION lock_wait_timeout=31536000’: 2006 (HY000) MySQL server has gone away.

If I check the timeout variables, 2 of them show this value:
| lock_wait_timeout | 31536000 |
| rpl_stop_slave_timeout | 31536000 |

Our databases are roughly 400GB big, I wonder if we are hitting one of these timeouts in the backup process or if this is a known bug.
xtrabackup is 2.4.18, and MySQL is 5.7.26

Any help will be really appreciated since we are trying to avoid locking the tables when dumping our data.

1 Like

Hello Claudio
Percona XtraBackup won’t lock InnoDB tables, only MyISAM and other storage engines that don’t use a redo log.
Are you using MyISAM or other storage engines?
If you get that info to me, along with any error logs that are being recorded (if there’s anything beyond that error message) I’ll see if I can get you more advice.
This is a standalone database, is that right?

1 Like

@Claudio Can you show us the command you are using to execute xtrabackup? Are all of your tables InnoDB?

1 Like