lost connection while doing transaction
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.
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.