Connection refused

[ChrisSka83]

Unfortunately, I can't get any further here and simply can't find the cause.
I have tried to increase the “max allowed packet” on the MySQL server. But as soon as I restart the MySQL server, it is always reset to the default value.

I also have the following error messages in some cases:

[2025-02-17 11:03:07] CRITICAL: (2002) SQLSTATE[HY000] [2002] Connection refused :: GET /Notification/action/notReadCount :: /var/www/vhosts/ESPO/application/Espo/ORM/PDO/MysqlPDOFactory.php(73)
[2025-02-17 11:03:09] CRITICAL: (2002) SQLSTATE[HY000] [2002] Connection refused :: GET /Stream :: /var/www/vhosts/ESPO/application/Espo/ORM/PDO/MysqlPDOFactory.php(73)
[2025-02-17 11:03:09] CRITICAL: (2002) SQLSTATE[HY000] [2002] Connection refused :: GET /Email :: /var/www/vhosts/ESPO/application/Espo/ORM/PDO/MysqlPDOFactory.php(73)
[2025-02-17 11:03:09] CRITICAL: (2002) SQLSTATE[HY000] [2002] Connection refused :: GET /PopupNotification/action/grouped :: /var/www/vhosts/ESPO/application/Espo/ORM/PDO/MysqlPDOFactory.php(73)
[2025-02-17 11:03:09] CRITICAL: (2002) SQLSTATE[HY000] [2002] Connection refused :: GET /Meeting :: /var/www/vhosts/ESPO/application/Espo/ORM/PDO/MysqlPDOFactory.php(73)
[2025-02-17 11:03:09] CRITICAL: (2002) SQLSTATE[HY000] [2002] Connection refused :: GET /Notification/action/notReadCount :: /var/www/vhosts/ESPO/application/Espo/ORM/PDO/MysqlPDOFactory.php(73)​ 

[ChrisSka83]

I can't remember that now.
But since the mailbox is no longer being accessed, no extension has been installed or updated.

However, I have now seen that all jobs (including those from Espo) are not executed if self-created jobs are executed at the same time.
These are always executed on the hour.
I then always get “Failed” for all jobs

I get the message (this is one of many):
[2025-02-10 15:00:04] ERROR: JobTask: Failed to run job '67aa1219cf70f62b0'. Error: SQLSTATE[HY000] [2002] Connection refused

I have also made a post here about my own jobs.
Am I perhaps missing a query, if nothing exists, then ignore or something similar? And why does it fail?

https://forum.espocrm.com/forum/developer-help/114102-job-should-change-status-with-a-specific-user

[lazovic]

Hi ChrisSka83,

As far as I remember, you have already encountered this problem. Hasn't it been solved before? Perhaps some other extension is causing it?

[ChrisSka83]

So if I read the logs correctly, I only get the error message with the “Uncaught Exception Spatie\Async\Output\ParallelError” for this one mailbox

I'm just wondering why it's only with this one and the others work without any problems. And why from one day to the next...

[ChrisSka83]

Update: That was probably not the problem.
After recreation the first mails are fetched and then it disappears again from the scheduled jobs.

[ChrisSka83]

I found out something strange about the e-mail inbox.

I created the mailbox again in Espo and the mails were retrieved as normal.
So I deleted the old one. So far so good.

Now it's getting tricky...
I changed the name of the mailbox back to the old name and the mails are not being retrieved again.
If I change the name, everything is ok again.

Is it possible that if a word appears twice in the name of the mailbox, it will not be retrieved?
I have given the mailbox the company name and the name of the department.
The name of the department also appears in the company name.

[ChrisSka83]

Hello,

unfortunately no one has any idea what is causing the problem?

Has anything changed with the database query since version 9? As I said, I didn't have these error messages in the logs until version 8.

Now I have also noticed that an e-mail box has not been retrieved at all for a few days.
I have checked the settings and they are all OK.
Under Administration > Scheduled Jobs > Check Group Email Accounts, the mailbox is no longer displayed as being retrieved.
I can also access the mailbox normally via Outlook.

I still have the following error message in the logs. Could this be the reason?

[2025-02-09 15:24:04] ERROR: (0) Uncaught Exception Spatie\Async\Output\ParallelError: "PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 20303016 bytes) in /var/www/vhosts/ESPO-CRM/application/Espo/ORM/QueryComposer/BaseQueryComposer.php on line 2295 " at /var/www/vhosts/ESPO-CRM/vendor/spatie/async/src/Output/ParallelError.php line 11 :: /var/www/vhosts/ESPO-CRM/vendor/spatie/async/src/Output/ParallelError.php(11) 

[ChrisSka83]

Hello everyone,

my log files are full of “Connection refused”
I didn't have this with the V8. In the frontend it always says “Error 500” at the top and in the logs it says the following at the bottom.
Does Espo somehow have problems with the MySQL database or what could be the reason?

[2025-02-01 11:38:06] ERROR: JobTask: Failed to run job '679e0721bf3f7305e'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 11:38:06] ERROR: JobTask: Failed to run job '679e075da2555e934'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 11:38:06] ERROR: JobTask: Failed to run job '679e0721b7c8bb6bb'. Error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[2025-02-01 11:38:06] ERROR: JobTask: Failed to run job '679e075da304a75e3'. Error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[2025-02-01 11:38:06] ERROR: JobTask: Failed to run job '679e07998b8bb161d'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 11:53:17] WARNING: E_WARNING: Undefined array key "system"
[2025-02-01 12:52:16] CRITICAL: (2002) SQLSTATE[HY000] [2002] Connection refused :: GET /PopupNotification/action/grouped :: /var/www/vhosts/Espo path/application/Espo/ORM/PDO/MysqlPDOFactory.php(73)
[2025-02-01 12:52:16] CRITICAL: (2002) SQLSTATE[HY000] [2002] Connection refused :: GET /Notification/action/notReadCount :: /var/www/vhosts/Espo path/application/Espo/ORM/PDO/MysqlPDOFactory.php(73)
[2025-02-01 13:07:03] WARNING: E_WARNING: Undefined array key "system"
[2025-02-01 13:12:04] CRITICAL: (HY000) Failed job 679e1d29e0fc84fc8. SQLSTATE[HY000]: General error: 2006 MySQL server has gone away :: /var/www/vhosts/Espo path/application/Espo/ORM/Executor/DefaultSqlExecutor.php(77)
[2025-02-01 13:12:04] CRITICAL: (HY000) Failed job 679e1d65645de868f. SQLSTATE[HY000]: General error: 2006 MySQL server has gone away :: /var/www/vhosts/Espo path/application/Espo/ORM/Executor/DefaultSqlExecutor.php(77)
[2025-02-01 13:12:04] CRITICAL: (HY000) Failed job 679e1d65630fadef5. SQLSTATE[HY000]: General error: 2006 MySQL server has gone away :: /var/www/vhosts/Espo path/application/Espo/ORM/Executor/DefaultSqlExecutor.php(77)
[2025-02-01 13:12:04] ERROR: JobTask: Failed to run job '679e1d656100a932b'. Error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[2025-02-01 13:12:04] ERROR: JobTask: Failed to run job '679e1d29da292b190'. Error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[2025-02-01 13:12:04] ERROR: JobTask: Failed to run job '679e1d6563ba2a972'. Error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[2025-02-01 13:12:04] ERROR: JobTask: Failed to run job '679e1d65630fadef5'. Error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[2025-02-01 13:12:04] ERROR: JobTask: Failed to run job '679e1d29e0fc84fc8'. Error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[2025-02-01 13:12:04] ERROR: JobTask: Failed to run job '679e1d65645de868f'. Error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[2025-02-01 13:12:04] ERROR: JobTask: Failed to run job '679e1d65655d52870'. Error: SQLSTATE[HY000] [2006] MySQL server has gone away
[2025-02-01 13:12:04] ERROR: JobTask: Failed to run job '679e1da237637fb07'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 13:12:04] CRITICAL: (HY000) Failed job 679e1d65641da9220. SQLSTATE[HY000]: General error: 2006 MySQL server has gone away :: /var/www/vhosts/Espo path/application/Espo/ORM/Executor/DefaultSqlExecutor.php(77)
[2025-02-01 13:12:04] ERROR: JobTask: Failed to run job '679e1d65641da9220'. Error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[2025-02-01 13:12:04] ERROR: JobTask: Failed to run job '679e1da23871d6b5e'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 13:12:04] CRITICAL: (HY000) Failed job 679e1d65637584faf. SQLSTATE[HY000]: General error: 2006 MySQL server has gone away :: /var/www/vhosts/Espo path/application/Espo/ORM/Executor/DefaultSqlExecutor.php(77)
[2025-02-01 13:12:04] ERROR: JobTask: Failed to run job '679e1d65637584faf'. Error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[2025-02-01 13:12:04] ERROR: JobTask: Failed to run job '679e1da23d9754ffd'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 13:12:04] ERROR: JobTask: Failed to run job '679e1da2364ba2cd4'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 13:30:39] CRITICAL: (2002) SQLSTATE[HY000] [2002] Connection refused :: GET /Notification/action/notReadCount :: /var/www/vhosts/Espo path/application/Espo/ORM/PDO/MysqlPDOFactory.php(73)
[2025-02-01 13:30:39] CRITICAL: (2002) SQLSTATE[HY000] [2002] Connection refused :: GET /PopupNotification/action/grouped :: /var/www/vhosts/Espo path/application/Espo/ORM/PDO/MysqlPDOFactory.php(73)
[2025-02-01 13:30:39] CRITICAL: (2002) SQLSTATE[HY000] [2002] Connection refused :: GET /Job :: /var/www/vhosts/Espo path/application/Espo/ORM/PDO/MysqlPDOFactory.php(73)
[2025-02-01 13:30:41] CRITICAL: (2002) SQLSTATE[HY000] [2002] Connection refused :: GET /Job :: /var/www/vhosts/Espo path/application/Espo/ORM/PDO/MysqlPDOFactory.php(73)
[2025-02-01 13:30:49] WARNING: E_WARNING: Undefined array key "system"
[2025-02-01 13:42:07] ERROR: JobTask: Failed to run job '679e24aa7ad715669'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 13:42:07] ERROR: JobTask: Failed to run job '679e24323560332aa'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 13:42:07] ERROR: JobTask: Failed to run job '679e24aa7d87dc227'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 13:42:07] ERROR: JobTask: Failed to run job '679e24aa861b8b75d'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:08:54] WARNING: E_WARNING: Undefined array key "system"
[2025-02-01 14:12:17] CRITICAL: (0) Before-save formula script failed. Unexpected ExecutionException. :: /var/www/vhosts/Espo path/application/Espo/Core/Formula/Evaluator.php(124)
[2025-02-01 14:14:03] ERROR: JobTask: Failed to run job '679e2bb2227ddd77c'. Error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[2025-02-01 14:14:03] ERROR: JobTask: Failed to run job '679e2c297b63152ce'. Error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[2025-02-01 14:14:03] ERROR: JobTask: Failed to run job '679e2bee1d094fad3'. Error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[2025-02-01 14:14:03] ERROR: JobTask: Failed to run job '679e2bee1bd60a029'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:14:03] ERROR: JobTask: Failed to run job '679e2c29839dada98'. Error: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[2025-02-01 14:14:03] ERROR: JobTask: Failed to run job '679e2bee1b7b9b10d'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:14:03] ERROR: JobTask: Failed to run job '679e2bb22624036b5'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:14:03] ERROR: JobTask: Failed to run job '679e2bee191aafa47'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:14:03] ERROR: JobTask: Failed to run job '679e2bee1b430e541'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:14:03] ERROR: JobTask: Failed to run job '679e2c297ed4459aa'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:14:03] ERROR: JobTask: Failed to run job '679e2c297cb7e2bf2'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:14:03] ERROR: JobTask: Failed to run job '679e2bee1c27543d9'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:14:03] ERROR: JobTask: Failed to run job '679e2bee1b04fb7e5'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:28:03] ERROR: JobTask: Failed to run job '679e2f354818f669b'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:28:03] ERROR: JobTask: Failed to run job '679e2f35460ad68a7'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:28:03] ERROR: JobTask: Failed to run job '679e2f35471aa3bb1'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:28:03] ERROR: JobTask: Failed to run job '679e2f3545c15aff1'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:28:03] ERROR: JobTask: Failed to run job '679e2f3546c779716'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:28:03] ERROR: JobTask: Failed to run job '679e2f721cd7196ad'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:28:03] CRITICAL: (2002) SQLSTATE[HY000] [2002] Connection refused :: GET /PopupNotification/action/grouped :: /var/www/vhosts/Espo path/application/Espo/ORM/PDO/MysqlPDOFactory.php(73)
[2025-02-01 14:28:03] ERROR: JobTask: Failed to run job '679e2efa1e2014ed5'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:28:03] ERROR: JobTask: Failed to run job '679e2efa21ccea0d4'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:28:03] ERROR: JobTask: Failed to run job '679e2f354349d2e73'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:28:03] ERROR: JobTask: Failed to run job '679e2f72277306362'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:28:03] ERROR: JobTask: Failed to run job '679e2f354654ef23c'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:28:03] ERROR: JobTask: Failed to run job '679e2f722142aefe0'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:28:03] ERROR: JobTask: Failed to run job '679e2f721e2172d0b'. Error: SQLSTATE[HY000] [2002] Connection refused
[2025-02-01 14:28:03] CRITICAL: (2002) SQLSTATE[HY000] [2002] Connection refused :: GET /Notification/action/notReadCount :: /var/www/vhosts/Espo path/application/Espo/ORM/PDO/MysqlPDOFactory.php(73)