Back

Hitting into this after PDOException (There is already an active transaction)

  • 1
  • Databases
mav8rick
17 Oct, 2023, 13:25

I am running Appwrite 1.3.7 and I encountered PDOException after I tried to delete a few documents with relationships. I decided to restart the Appwrite server and now I'm encountering an "unknown" error:

appwrite | [Error] Timestamp: 2023-10-17T13:07:53+00:00 appwrite | [Error] Type: Utopia\Exception appwrite | [Error] Message: Not Found appwrite | [Error] File: /usr/src/code/vendor/utopia-php/framework/src/App.php appwrite | [Error] Line: 803

To be honest, things were really quite OK until we ran into this problem. Not sure what to try.

I don't normally scream for help but this is a case whereby a few weeks' worth of effort would be ruined because we couldn't put up anything for a demo with invited key stakeholders tomorrow.

TL;DR
The user is experiencing a PDOException after trying to delete documents with relationships in Appwrite 1.3.7. They attempted to restart the server but encounter an "unknown" error. They are unsure of what to try next and are in a time crunch for a demo. A possible solution is to restart the server and try again, or if relationships are causing issues, consider using an identifier-based logic to link documents or start over.
darShan
17 Oct, 2023, 17:47

I have seen this on 1.4.5 as well. I had a collection, say A that had relationship with collection B . If I'd perform a delete, the server would freeze and the logs would display the same error as shared above. I had to simply remove the relationship by deleting the whole collection B. A restart later fixed it for me.

Afaik relationships are still marked as experimental so I'd suggest that if you have a lot of data in relationships, use an identifier based logic to link a document or start over.

mav8rick
17 Oct, 2023, 17:58

Thanks for the reply. You are saying that if I delete a doc in collection A and if A has a relationship with collection B then I need to "burn down" the whole collection B?
I had the impression that I'd just kill collection A and recreate that collection

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