Server Error when updating an existing document via UpsertDocument

[calm torrent]

I am getting "AppwriteException: general_unknown, Server Error (500)" when using UpsertDocument on Appwrite Cloud from a function with Dart 3.5 runtime and dart_appwrite: 16.2.0. The error only occurs if a document with the same ID already exists. The function works correctly when creating a new document.

[fringe gate]

what's your project ID?

[calm torrent]

messaged you

[fringe gate]

What's your code?

[calm torrent]

the project id is 688ff2ab001d8312a1ef. I DM'd you the function id and a successful vs error execution id (one creating the document, the next attempting to update it)

[fringe gate]

Maybe the user doesn't have access

[calm torrent]

Hmm, I'm using the function's dynamic API key, which has documents.read and documents.write permissions. Is there a specific permission for upsert that I'm missing?

[fringe gate]

Oh interesting...I've definitely seen it work. That's odd you're having this error...

[calm torrent]

I created a test project in attempt to replicate the issue and found that UpsertDocument works at intended... Which is odd, as I'm certain the issue was being thrown at Upsert document in my other project. Maybe it was because of a specific attribute or permission. I'll dive deeper into it and see what I can find. Thanks for your help.

[calm torrent]

Ok, I figured it out. If the data of the document is the same, the server error is thrown.

Full source of project:
https://github.com/Colton127/upsert_document_test/blob/main/lib/main.dart

The commit that introduced the error changed saving data dynamic data to static:
https://github.com/Colton127/upsert_document_test/commit/fe79ba2d54d95d607d50d14040f41235206a0903

The associated functionId is 689508c30014b2cc1e50

One solution is to see if the document already exists, and if so, compare the data to check for changes. But I'd rather avoid unnecessary server requests.

[fringe gate]

💯 i don't think it should fail. I'll need to look into this and reproduce. One thing that would help is if you create a github issue with these details

[fringe gate]

ok weird...i tried an upsert with an existin value but it worked fine..

im making the api call manually though

[fringe gate]

I think I found what might be causing it: https://github.com/utopia-php/database/blob/33f35f5daeebd587f79abf362cfb512b9df3cd50/src/Database/Database.php#L5036-L5039

Have you created a github issue for this?

[calm torrent]

https://github.com/appwrite/appwrite/issues/10326

Got it!

[fringe gate]

🙏🏼 I've escalated this to the team

[fringe gate]

How is it now?