Issue Plesk task always queued and never get done

[Nicola Urbinati]

Server operating system version

Ubuntu 22.04.2 LTS

Plesk version and microupdate number

18.0.52 Update #3

Hi,

Since some days, all of the tasks I try to do (wordpress toolkit updates, domain deletion) get stuck in queued state.
I delete them from the tasks tables, try to re-launch them, to no avail: next time I launch them they get stuck.

How can I debug/solve?

Thank you.

 

[Peter Debik]

There is probably a psa service task that is stuck. Maybe something from the nightly maintenance. You can try to find out more in /var/log/plesk/panel.log. You can also look through the "# ps aux" result if you find anything suspicious. You can try to restart sw-engine, sw-cp-server. You can try to stop/start the psa service. Or, if it is a virtual host instance, it can be easiest to reboot.

 

[Nicola Urbinati]

The services restert did not help, nor deleting the tasks in the plesk db.
The reboot API from the GUI responded: "Request to backend API failed with error: Request failed with status code 521"
See if the cli reboot helps.

 

[Nicola Urbinati]

Ok, the reboot seems to have made it, now clearing the plesk db of staled tasks and re-running them helped. Let's see if it's stable.

Anyway, the /var/log/plesk/panel.log is full of

[2023-09-28 16:17:42.349] 3300043:65158b0652f1c ERR [panel] Protocol version '1.6.8.0' is deprecated. Current protocol version is '1.6.9.1'.
[2023-09-28 16:17:42.556] 3301905:65158b0685a78 ERR [panel] Protocol version '1.6.8.0' is deprecated. Current protocol version is '1.6.9.1'.
[2023-09-28 16:17:42.764] 3304577:65158b06b8bd4 ERR [panel] Protocol version '1.6.8.0' is deprecated. Current protocol version is '1.6.9.1'.
[2023-09-28 16:17:42.968] 3305571:65158b06ead63 ERR [panel] Protocol version '1.6.8.0' is deprecated. Current protocol version is '1.6.9.1'.
[2023-09-28 16:17:43.190] 3294671:65158b072ca99 ERR [panel] Protocol version '1.6.8.0' is deprecated. Current protocol version is '1.6.9.1'.
[2023-09-28 16:17:43.396] 3298514:65158b075f205 ERR [panel] Protocol version '1.6.8.0' is deprecated. Current protocol version is '1.6.9.1'.
[2023-09-28 16:17:43.588] 3300043:65158b078e185 ERR [panel] Protocol version '1.6.8.0' is deprecated. Current protocol version is '1.6.9.1'.
[2023-09-28 16:17:43.794] 3301905:65158b07bff2d ERR [panel] Protocol version '1.6.8.0' is deprecated. Current protocol version is '1.6.9.1'.
[2023-09-28 16:17:44.000] 3295883:65158b07f230b ERR [panel] Protocol version '1.6.8.0' is deprecated. Current protocol version is '1.6.9.1'.

and it's difficult to see anything else, but something strange came up for some time:

[2023-09-28 16:22:49.015] 1170:65158c3901ca9 ERR [panel] DB query failed: SQLSTATE[HY000] [2002] No such file or directory:
0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79
        Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
1: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:113
        CommonPanel_Application_Abstract::initDbAdapter()
2: /opt/psa/admin/plib/api-common/AbstractCu.php:1524
        AbstractCu::initDb()
3: /opt/psa/admin/plib/api-common/AbstractCu.php:1550
        AbstractCu::initCLI()
4: /opt/psa/admin/plib/scripts/task-async-executor.php:4
[2023-09-28 16:22:49.017] 1193:65158c39028ae ERR [panel] DB query failed: SQLSTATE[HY000] [2002] No such file or directory:
0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79
        Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
1: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:113
        CommonPanel_Application_Abstract::initDbAdapter()
2: /opt/psa/admin/plib/api-common/AbstractCu.php:1524
        AbstractCu::initDb()
3: /opt/psa/admin/plib/api-common/AbstractCu.php:1550
        AbstractCu::initCLI()
4: /opt/psa/admin/plib/scripts/task-async-executor.php:4
[2023-09-28 16:22:49.020] 1249:65158c390187f ERR [panel] DB query failed: SQLSTATE[HY000] [2002] No such file or directory:
0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79
        Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
1: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:113
        CommonPanel_Application_Abstract::initDbAdapter()
2: /opt/psa/admin/plib/api-common/AbstractCu.php:1524
        AbstractCu::initDb()
3: /opt/psa/admin/plib/api-common/AbstractCu.php:1550
        AbstractCu::initCLI()
4: /opt/psa/admin/plib/scripts/interface_async_executor.php:5

Could it have anything to do with the issue?

 

[Peter Debik]

Yes, it can. If the database is inaccessible, processes may not have been able to complete, hence they hang.