Skip to content
Back

list() is very slow; eventually shows not-existing IDs

  • 0
  • Self Hosted
  • Databases
panda_p
3 Jul, 2025, 10:39

When I use the web browser to view the collections in my database, the documents they contain are normally displayed within a few seconds. For a few days now, however, there has been one particular collection that takes several minutes to display; it only contains 12 very small documents. It is noticeable that 3 of them are invalid in the sense that the displayed ID does not exist. If I mouse-over them in the Browser, the DevTools start to display "404 (Not Found)"; see Screenshot with the big yellow 2. I cannot delete the documents via the WebBrowser. If I try to delete the document programatically using an API-Key, I get a 404 in response. If I retrieve all documents of the collections with the same API-Key via list(), the call is terminated at some point without result with an “ERR_EMPTY-RESPONSE” error; see Screenshot.

  1. what happened and how can I prevent this in the future?
  2. how can I clean the database of the invalid entries?
  3. what is the call to /backups/policies seen in screenshot 1?

Further information:

  • Self-Hosted
  • Appwrite 1.6.1
TL;DR
Issue: Slow list() call, displaying non-existing IDs in a database collection. 1. Potential solutions: - Check for any recent changes or updates that could have caused the slowdown. - Verify the integrity of the database to prevent future occurrences. 2. To clean the database of invalid entries: - Attempt to delete the documents programmatically using an API-Key if the WebBrowser method fails. 3. About /backups/policies call: - Potentially related to backup policies and settings within the system. - Further investigation may be needed to understand its specific functionality in your setup.
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