[SOLVED] MySQL Server has gone away
I doubt if I am using an external MySQL because all I did was a default Appwrite install on a Compute Engine
Then you're using MariaDB
This is a completely fresh install, true?
It has some organisations, projects and databases on it.
We've been using it for about 3 months now
You don't have backups?
No
Could you please run the command docker compose logs mariadb
Send here the result
Here you go https://dpaste.org/P98fg
Did you have upgraded recently?
Upgraded to 1.4 from 1.3.7 but things didn't work out and I restored
And after restoring you're getting that or is it just after upgrading?
This error started occuring yesterday. But I had restored a week ago
I see. Seems like your database got corrupted in some way. Maybe you have restarted or your instance crashed?
When I found out that error I decided to run docker compose stop
And docker compose up -d
Now the instance works but I want to find out the cause of MySQL going down so that I can prevent it for longterm
I think it was caused due to a crash in the main container
It's just a hypothesis, so it's not a confirmation. There could be several reasons. I think this should not happen again, however for in case it happens anyways, doing regular backups is the key, so you could restore if data gets corrupted, I don't think this will happen, but better adopt more measures than not doing anythingπ . I was going to send some instructions to recover the database, but seems not needed
From what I understand, it's working now?
Yes it's working now.
What tips can you suggest to keep regular backups?
There are several ways to do backups. I think if you can automate it, that will be the most ideal thing you could do. I automate it by having a bash script that is being automatically triggered that dumps the entire database and uploads it to a FTP server
[SOLVED] MySQL Server has gone away
Thank you
