Back
Utopia\Database\Exception\Duplicate error
On version 1.3.7 My Appwrite server on AWS locked up with:
TypeScript
[Error] Timestamp: 2024-05-21T03:45:45+00:00
[Error] Method: GET
[Error] URL: /v1/databases/:databaseId/collections
[Error] Type: PDOException
[Error] Message: MySQL server has gone away
[Error] File: @swoole-src/library/core/Database/PDOStatementProxy.php
[Error] Line: 64
Then on restarting the server, my appwrite log now has this:
TypeScript
[Error] Timestamp: 2024-05-21T04:00:30+00:00
[Error] Method: GET
[Error] URL: /v1/avatars/browsers/:code
[Error] Type: Utopia\Database\Exception\Duplicate
[Error] Message: Duplicated document: Duplicate entry 'cb710f899a5388a5356d2b0e12d6a353*506' for key '_uid'
[Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Adapter/MariaDB.php
[Error] Line: 619
Seems like the system got stuck dealing with a duplicated document??
Anyone has any tips on how I can deal with this? (not talking about database backup and restore)
TL;DR
Developers reported issues with Appwrite server version 1.3.7 on AWS. The first error was MySQL server going away, and upon server restart, they encountered a 'Utopia\Database\Exception\Duplicate' error indicating a duplicated document entry. The solution provided is to update to a newer version of Appwrite, as improvements have been made since 1.3.7, addressing these issues. 
I'm not sure if these are related. That said, we've made improvements to Appwrite on both of these fronts since 1.3.7
