Hi 👋, getting this error when try delete or update a document from admin console:
[Error] Timestamp: 2023-08-18T12:29:34+00:00
[Error] Method: DELETE
[Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents/:documentId
[Error] Type: Exception
[Error] Message: Unknown PDO Type for object
[Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Adapter/MariaDB.php
[Error] Line: 1347
[Error] Timestamp: 2023-08-18T12:30:10+00:00
[Error] Method: DELETE
[Error] URL: /v1/databases/:databaseId/collections/:collectionId/documents/:documentId
[Error] Type: PDOException
[Error] Message: There is already an active transaction
[Error] File: @swoole-src/library/core/Database/PDOProxy.php
[Error] Line: 43
Server Error: when try delete a document
Server Error: when try delete, update a document
any idea how this started? you might need to restart the appwrite container or the appwrite stack
No... I have to keep restarting the server so that this error doesn't happen, but that's annoying, there are times when I can't delete a document or update it.
Of course it would be best to try and figure out the root cause
So far, we don't know the root cause
it is necessary to investigate
Are you using relationships?
Hi, yes...
Yes, that's about it, I tried to delete a field that is related and this error happens.
After error, if i try update a field, i get the same error i and need restart appwrite, but cannot delete, first of all i need delete the related field.
I configured the relationship when deleting to make the object null, but it seems that it doesn't have the effect.
This might be totally unrelated 🧐 would you be able to create a GitHub issue for this with reproducible steps?
Maybe this is the same problem: https://github.com/appwrite/appwrite/issues/6012
In this case it is with attribute.
I am facing the same issue with 1.4.3 now..
Recommended threads
- User ID case sensitivity
I see that through REST (and SDK as well), getting a user is not case sensitive. And even though documentation does not clearly state that it is, the wording "V...
- Any way to temporarily bypass the email ...
Hey guys, any way to bypass the email verification to use the accounts again? i need to recover some projects that due to recent changes have been stopped, and ...
- How to use Sites on selfhosted appwrite
whenever I try to create a site even with template it says 404 nginx error