Помилка прионовлені оновленні до версії EspoCRM 7.1.7

[CrazyDeaDyshka]

Доброго дня

На данний момент Поточна версія: 7.1.5, При оновлені видає помилку.

Оновлююсь через Термінал.

-----------------------------------------------------------------------------------------------------------

root@**********:/var/www/crm# php command.php upgrade

Current version is 7.1.5.

EspoCRM will be upgraded to version 7.1.7 now. Enter [Y] to continue.

y

This may take a while. Do not close the terminal.

Downloading...

Upgrading...

Initialization...

Copying before upgrade files...

Rebuilding...

Before upgrade script execution...

Rebuilding...

Reverting...

Error: Error occurred while EspoCRM rebuild. Please see the log for more detail.


-----------------------------------------------------------------------------------------------------------


В логах пишить помилку таку.


-----------------------------------------------------------------------------------------------------------


[2022-06-15 10:05:16] ERROR: Upgrade Error: Error: Error occurred while EspoCRM rebuild. Please see the log for more detail. [] []
[2022-06-15 10:05:16] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:16] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:16] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:16] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:16] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Activities/action/popupNotifications; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Activities/action/popupNotifications; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Activities/action/popupNotifications; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Activities/action/popupNotifications; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Activities/action/popupNotifications; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Activities/action/popupNotifications; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [2002] Connection refused" at /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php line 97 {"exception":"[object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php:97)"} []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Activities/action/popupNotifications; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:17] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:18] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:18] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:18] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:18] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:18] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:18] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:18] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:19] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []
[2022-06-15 10:05:19] ERROR: (2002) SQLSTATE[HY000] [2002] Connection refused; GET /Notification/action/notReadCount; line: 97, file: /var/www/crm/application/Espo/ORM/PDO/DefaultPDOProvider.php [] []

-------------------------------------------------------------------------------------------------------
mysql --version

mysql Ver 8.0.23 for Linux on x86_64 (MySQL Community Server - GPL)


Підскажіть рішення.

[dimyy]

А что написано до строчки "Upgrade Error"? В представленном логе нет характерных для rebuild ошибок.

Отдельно по опыту рекомендую посмотреть размер таблички email. В случае существенного размера рекомендуется обновить данную таблицу вручную до запуска процедуры обновления.

Связано с добавлением полей

ALTER TABLE email ADD ics_contents MEDIUMTEXT DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, ADD ics_event_uid VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, ADD created_event_id VARCHAR(24) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, ADD created_event_type VARCHAR(100) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, algorithm = inplace , lock = none;

Добавление с algorithm = inplace , lock = none не пробовал - версия требующая подтверждения и возможно разумно как фичу ввести.