Back
[1.5.4] MySQL server has gone away
Hello, I have a random error when executing a function.
The function is never executed & I get this error when showing logs from appwrite container:
TypeScript
[Error] Timestamp: 2024-04-19T06:00:24+00:00
[Error] Method: POST
[Error] URL: /v1/functions/:functionId/executions
[Error] Type: PDOException
[Error] Message: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[Error] File: @swoole/library/core/Database/PDOStatementProxy.php
[Error] Line: 44
[Error] Type: Utopia\Exception
[Error] Message: Error handler had an error: Appwrite\Extend\Exception::__construct(): Argument #3 ($code) must be of type ?int, string given, called in /usr/src/code/app/controllers/general.php on line 711
[Error] File: /usr/src/code/vendor/utopia-php/framework/src/App.php
[Error] Line: 574
TL;DR
Developers encountering MySQL server has gone away error when running a function. The function doesn't execute and logs show SQLSTATE[HY000]: General error: 2006. The error is in PDOStatementProxy.php. Issue might be related to the database connection. Check server settings and increase max_allowed_packet. 