Back

[SOLVED] Whatever I do the database shows "Server Error"

  • 0
  • Web
Axentioi
10 Aug, 2023, 09:15

I wanted to delete an attribute from a collection in my database, it's showing "loading" since yesterday, besides that, whatever action I try to do, it's erroring "Server Error"

TL;DR
Issue: User is experiencing a "Server Error" when trying to perform actions on the database. They have tried deleting cache and restarting the server, but the problem persists. The logs show an error stating that the database could not be found. Solution: User discovered that the issue was related to cache. They were able to resolve it by deleting the cache manually on the server and restarting it. They also upgraded the database and deleted any old occurrences. After these steps, the issue seems to be resolved and the database is now working properly.
Axentioi
10 Aug, 2023, 09:24

Doing a server restart, maybe it's fixing

Axentioi
10 Aug, 2023, 09:27

After the restart, I still ahve this

Axentioi
10 Aug, 2023, 11:46

Restarted database, upgraded and deleted all occurencies and now it seems to be working.

D5
10 Aug, 2023, 11:53

@Axentioi Is this cloud or self-hosted?

Axentioi
10 Aug, 2023, 11:54

self-hosted

Axentioi
10 Aug, 2023, 11:54

I also found a strange thing, sometimes it shows old data in the FE

D5
10 Aug, 2023, 11:54

What logs do you have in the MariaDB container and general container?

Axentioi
10 Aug, 2023, 11:56

I'll add the doctor first and then check

Axentioi
10 Aug, 2023, 12:22

I get "Document with the requested ID could not be found."

Axentioi
10 Aug, 2023, 12:22

which is weird, since I do have the requested ID

Axentioi
10 Aug, 2023, 12:22

but in some cases it's now there?

D5
10 Aug, 2023, 12:34

Uh you don't have anything in the container logs?

D5
10 Aug, 2023, 12:34

(Docker)

Axentioi
10 Aug, 2023, 12:54

The logs are just showing the same error that database could not be found

Axentioi
10 Aug, 2023, 12:55

but I figured it's just cache, would've been great to have a button to delete cache instead of going to server and doing cache to 0 and then restarting

Axentioi
10 Aug, 2023, 12:55

now It works good

D5
10 Aug, 2023, 13:00

So @Axentioi your issue is solved now after deleting cache?

Axentioi
10 Aug, 2023, 13:16

Yes

D5
10 Aug, 2023, 13:29

[SOLVED] Whatever I do the database shows "Server Error"

D5
10 Aug, 2023, 13:29

Great! 😁

Reply

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