General error: 2006 MySQL server has gone away

[JanBab]

Hi,
I have problem with one personal account. New emails stopped appearing. And there is not "Check Personal Email Accounts" for this account. Other personal accounts works ok.
This is part of espo log file:

[2023-05-25 00:05:33] ERROR: EmailAccount 5e788fbd65d7d6faf, import message; HY000 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away [] []
[2023-05-25 00:05:33] ERROR: EmailAccount 5e788fbd65d7d6faf, import message; HY000 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away [] []
[2023-05-25 00:05:33] ERROR: JobManager: Failed job running, job '646ea4e2f01b7d06c'. Job CheckEmailAccounts 5e788fbd65d7d6faf: [HY000] SQLSTATE[HY000]: General error: 2006 MySQL server has gone away; at C:\xampp\htdocs\espocrm\application\Espo\Classes\J obs\CheckEmailAccounts.php:61. [] []
[2023-05-25 00:05:33] ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000]: General error: 2006 MySQL server has gone away" at C:\xampp\htdocs\espocrm\application\Espo\ORM\SqlEx ecutor.php line 70 {"exception":"[object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 2006 MySQL server has gone away at C:\\xampp\\htdocs\\espocrm\\application\\Espo\\ORM \\SqlExecutor.php:70)"} []
[2023-05-25 00:06:30] WARNING: JobManager: useProcessPool requires pcntl and posix extensions. [] []
[2023-05-25 00:07:30] WARNING: JobManager: useProcessPool requires pcntl and posix extensions. [] []
[2023-05-25 00:08:30] WARNING: JobManager: useProcessPool requires pcntl and posix extensions. [] []
[2023-05-25 00:09:30] WARNING: JobManager: useProcessPool requires pcntl and posix extensions. [] []
[2023-05-25 00:10:30] WARNING: JobManager: useProcessPool requires pcntl and posix extensions. [] []
[2023-05-25 00:11:34] WARNING: JobManager: useProcessPool requires pcntl and posix extensions. [] []
[2023-05-25 00:11:39] ERROR: EmailAccount 5e788fbd65d7d6faf, import message; HY000 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away [] []
[2023-05-25 00:11:39] ERROR: EmailAccount 5e788fbd65d7d6faf, get message; HY000 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away [] []
[2023-05-25 00:11:39] ERROR: EmailAccount 5e788fbd65d7d6faf, import message; HY000 SQLSTATE[HY000]: General error: 2006 MySQL server has gone away [] []

[victor]

JanBab,

The easiest steps to solve this problem (provided other Personal Email Accounts are working properly):

1. Make this Personal Email Account Inactive and then Active (screenshot 1).
2. If it did not help, then repeat step 1 and enter the required date in Fetch Since, but different from the date set BEFORE (screenshot 2).
3. If this did not help, then delete this Personal Email Account, make Rebuild and create it again, setting approximately the date in Fetch Since, from which the emails stopped appearing.

[lazovic]

Hi JanBab,

You can find the causes of this error here: https://dev.mysql.com/doc/refman/5.7/en/gone-away.html.

Also, we recommend that you install the pcntl and posix extensions for PHP.