[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