lost connection while doing transaction
Posted by: Warner Krelekamp
Date: July 06, 2023 04:49AM

I have a database with a table energie that is 2.5GB.
The application (NodeRed) cannot update the tabel, gets an error.
I tried:
MariaDB [Huismanager]> check table energie;
ERROR 2013 (HY000): Lost connection to MySQL server during query

When making a backup with HeidiSQL I get different errors. I once got the error that the index was corrupt. So I tried:
MariaDB [Huismanager]> optimize table energie;
ERROR 2013 (HY000): Lost connection to MySQL server during query

The server is running on a virtual machine with debian11 and Node-Red.

Options: ReplyQuote


Subject
Written By
Posted
lost connection while doing transaction
July 06, 2023 04:49AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.