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.