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
- hi guys! my site is not accesible in my ...
- Appwrite project paused
I have github student account. The auth has been paused however the database is working fine. I cant see any option to resume from my console panel. It is just ...
- MongoDb Database Breaks integer[] & bigi...
I've got a table with the below column created. When I try to insert the value `[-3408048000]` into it, the dart sdk cloud function call is successful (no error...