Open image in appwrite console = 100% load

Yes, as the title says, I open a file, for example, an Image and the server CPU starts loading to 100% on both cores (2 cores server)

TL;DR

User opened an image in Appwrite console and the server's CPU load jumped to 100%. They received various errors related to database connection and the server crashed. Restarting didn't fix the issue and running Appwrite doctor revealed that MariaDB is down. User wonders if they need to reinstall everything. No backups were done. User suspects the issue may be related to accessing the file but is unsure. They consider deleting everything and starting from scratch. Solution: Reinstalling everything from scratch may be the best option since the data may be corrupted.

Then after a while I get error 0 : aborted

The errors I get in sentry :

TypeScript

Failed to connect to database: SQLSTATE[HY000] [2002] Connection refused
Failed to connect to database: SQLSTATE[HY000] [2002] Host is unreachable
SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Try again```

Seems those errors are after the issue was produced

Restarted the server since Mariadb crashed. Now nothing works 😭

I get error 502: bad gateway

After running Appwrite doctor, Mariadb is down

those are the Mariadb logs

Bruh, reinstall everything or what? 🤯

Did you upgrade to a new version by any chance?

@D5

Nope

Never upgraded or something

It just crashed by accessing a file

Try restrarting everything

Tried, everything got worse

Bruh; worst case scenarios going here

Yep. Seems I will need to delete everything? (Note: no backups where done 🤣).

Note 2: The instance only had data to test (doesn't matter losing all 😅)

But sincerely, I don't see it normal everything going down suddenly after opening a file from console 🤷‍♂️

Seems to be similar to this: https://github.com/appwrite/appwrite/issues/3157

What's weird is that my issue started by accessing a file. First it started loading to 100%, freezed my Appwrite instance. After restarting, nothing works

Okay, after digging into MariaDB docs, it seems like data corrupted (not sure why) and it's stopping to prevent data corruption propagation

That makes a lot of sense

Okay, I think it's better deleting everything and starting from scratch?

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more

Recommended threads

Need support?

Join our Discord

Get premium support