Server Error: when try delete, update a document

Hi 👋, getting this error when try delete or update a document from admin console:

TypeScript

[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

TL;DR

Users are encountering a server error when trying to delete or update a document in the admin console. The error message states "Unknown PDO Type for object" and "There is already an active transaction." Restarting the server temporarily resolves the issue, but it is not a permanent solution. The root cause of the error is unknown. There is a related GitHub issue that may be relevant.

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.