Not the answer you need?
Register and ask your own question!

Strange error (At least for me).

ClaudioClaudio EntrantCurrent User Role Novice
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.

Comments

  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    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?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.