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
- Updating to 1.9.0
Docs are lacking, I've already run in to some issues: - Firstly the web UI port doesn't work... had to add ```--http-port=9999``` in to the docker run command t...
- problem with domains
I don't know if this is wrong or not but i did what it told me to do to link my domain and still says failed domain has 11 incompatible CAA records.
- 403 The current user has been blocked.
Hello, I have a free plan; I've tried to access my project and I get the message "403 The current user has been blocked." I have database, sites, and auth in us...