-
Notifications
You must be signed in to change notification settings - Fork 3.8k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We鈥檒l occasionally send you account related emails.
Already on GitHub? Sign in to your account
馃悰 Bug Report: [1.4.X - 1.5.X] Function throws MySQL server has gone away #7930
Comments
The same thing happens here when I try to delete a user. 2024-04-13T18:09:56.129491976Z [Error] Timestamp: 2024-04-13T18:09:56+00:00
2024-04-13T18:09:56.129518338Z [Error] Method: DELETE
2024-04-13T18:09:56.129522956Z [Error] URL: /v1/users/:userId
2024-04-13T18:09:56.129537495Z [Error] Type: Utopia\Database\Exception
2024-04-13T18:09:56.129541492Z [Error] Message: MySQL server has gone away
2024-04-13T18:09:56.129545160Z [Error] File: /usr/src/code/vendor/utopia-php/database/src/Database/Adapter/MariaDB.php
2024-04-13T18:09:56.129548757Z [Error] Line: 1372 |
Is it random on your side too? |
Yes, I'd say it's pretty random, I've had the problem 2 times on different actions and each time I solved it by restarting the appwrite docker instances. |
@Emilien-Lambert, after conducting some investigations, I believe there鈥檚 a bug related to 1.4.X statistics. Why?
Appwrite 1.5.X completely overhauls the statistics system. I upgraded my instance to 1.5.4 yesterday, and so far, it appears to be much improved. I haven鈥檛 encountered this error since the upgrade (wish me lucks :p). As a temporary workaround, consider the following:
Please note that this is purely speculative on my part. 馃槉 Any advice of Appwrite team like @stnguyen90 or @Meldiron would be great 馃憤 |
@istornz Thank you for this valuable information. 馃憤 |
@Emilien-Lambert Hello, do you have tried any of theses solutions? |
I updated my instance to |
@Emilien-Lambert Very nice, exactly the same way for me 馃憤 |
I'm come back because it seems the issue is not fixed yet on 1.5.X ... I'm getting the same issue (with more error details) when executing a function:
EDIT: Another crash with an another function, with the same error
|
@Emilien-Lambert Can you have tested more on your side? It seems it's better on my side but had some crash again... |
@istornz Yes, I've used appwrite a lot since then and I've had no problems with So I opted for a radical solution. I retrieved all my documents in JSON via the SDK, then I completely redeployed an Appwrite instance via the Since then, with a fresh installation of I know the solution isn't great, but it's the only way I could find in the time I had available. |
Okay thanks for your reply, I noticed an amelioration with 1.5.X but some random errors appears again on my side so I decided to use Firebase functions as a temporary workaround since we found the solution of this issue. Can you check if this error appear again (if any) and tell us here to track more info about this issue 馃憤 |
馃憻 Reproduction steps
Sometimes, when I try to call a function from Appwrite, I got the error :
When I try to check on Appwrite, the function was not called at all, there is no failing execution in the execution list...
I looked into
docker logs appwrite
right after this issue & get this strange log:I ran
docker logs appwrite-mariadb
and I get:馃憤 Expected behavior
It should execute all functions without error
馃憥 Actual Behavior
Sometimes function throw error 500
馃幉 Appwrite version
Version 1.4.x
馃捇 Operating system
Linux
馃П Your Environment
I use an Hetzner instance
馃憖 Have you spent some time to check if this issue has been raised before?
馃彚 Have you read the Code of Conduct?
The text was updated successfully, but these errors were encountered: