Stack of processes where Plesk repair does not finish

Category：Plesk

Pub.date：2020-10-13

Plesk Obsidian Web Admin Edition<br>
Plesk Obsidian 18.0.30 Update #2<br>
CentOS Linux 7.8

Tools and Settings > Diagnose and Repair

In the file system diagnostics, the progress icon seems to be stuck around without stopping.

## Document

<a href="https://support.plesk.com/hc/en-us/articles/360020006474-Plesk-Repair-Kit-is-stuck-on-on-checking-repairing" target="_blank">https://support.plesk.com/hc/en-us/articles/360020006474-Plesk-Repair-Kit-is-stuck-on-on-checking-repairing</a>

<a href="https://support.plesk.com/hc/en-us/articles/360010324980" target="_blank">https://support.plesk.com/hc/en-us/articles/360010324980</a>

## First backup

Back up the psa database for the time being

## Survey and implementation according to the procedure

The following steps are not always correct.

```
# plesk db "select * from ModuleSettings where value ='progress'\G"
*************************** 1. row ***************************
module_id: 9
     name: repair_status_FileSystem
    value: progress

# plesk db "select * from longtasks where status<>'done' and type='ext-repair-kit-task_repair'\G"
*************************** 1. row ***************************
      startTime: 2020-10-13 13:39:32
             id: 1417
           type: ext-repair-kit-task_repair
         status: error
statusProcessed: 0
        context: c4ca4238a0b923820dcc509a6f75849b
 progressStatus: error
 progressParams: a:2:{s:12:"errorMessage";s:77:"Invalid usage of pm_Settings::set. Value length 5000 expected, 7697 received.";s:9:"errorCode";i:0;}
    progressMax: 100
  progressValue: 0
     finishTime: 2020-10-13 13:39:51
            pid: 4386
     externalId: NULL

# plesk db "DELETE FROM ModuleSettings WHERE value = 'progress' AND name LIKE '%status_FileSystem%';"

# plesk db "DELETE FROM ModuleSettings WHERE value = 'progress' AND name = 'repair_status_PleskInstallation';"

# plesk db "DELETE FROM longtasks WHERE type='ext-repair-kit-task_repair'"
```

DB repair after implementation

```
# plesk repair db

Checking the Plesk database using the native database server tools .. [OK]

Checking the structure of the Plesk database ........................ [OK]

Checking the consistency of the Plesk database

Inconsistency in the table 'longtaskparams' for the column task_id:
  No rows in the table 'longtasks' with id = 1356 (4 broken
  references) ....................................................... [WARNING]
  To see more details, run the command in the verbose mode: plesk repair db -verbose
  Remove unnecessary rows from the table 'longtaskparams'? [Y/n] y
    Creating a database dump ........................................ [OK]
    A dump of the database was created before an attempt to repair the database: /var/lib/psa/dumps/mysql.preresolve.20201013-140417.dump.gz
    Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'longtaskparams' for the column task_id:
  No rows in the table 'longtasks' with id = 1357 (4 broken
  references) ....................................................... [WARNING]
  To see more details, run the command in the verbose mode: plesk repair db -verbose
  Remove unnecessary rows from the table 'longtaskparams'? [Y/n] y
    Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'longtaskparams' for the column task_id:
  No rows in the table 'longtasks' with id = 1360 (4 broken
  references) ....................................................... [WARNING]
  To see more details, run the command in the verbose mode: plesk repair db -verbose
  Remove unnecessary rows from the table 'longtaskparams'? [Y/n] y
    Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'longtaskparams' for the column task_id:
  No rows in the table 'longtasks' with id = 1361 (4 broken
  references) ....................................................... [WARNING]
  To see more details, run the command in the verbose mode: plesk repair db -verbose
  Remove unnecessary rows from the table 'longtaskparams'? [Y/n] y
    Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'longtaskparams' for the column task_id:
  No rows in the table 'longtasks' with id = 1362 (4 broken
  references) ....................................................... [WARNING]
  To see more details, run the command in the verbose mode: plesk repair db -verbose
  Remove unnecessary rows from the table 'longtaskparams'? [Y/n] y
    Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'longtaskparams' for the column task_id:
  No rows in the table 'longtasks' with id = 1363 (4 broken
  references) ....................................................... [WARNING]
  To see more details, run the command in the verbose mode: plesk repair db -verbose
  Remove unnecessary rows from the table 'longtaskparams'? [Y/n] y
    Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'longtaskparams' for the column task_id:
  No rows in the table 'longtasks' with id = 1411 (4 broken
  references) ....................................................... [WARNING]
  To see more details, run the command in the verbose mode: plesk repair db -verbose
  Remove unnecessary rows from the table 'longtaskparams'? [Y/n] y
    Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'longtaskparams' for the column task_id:
  No rows in the table 'longtasks' with id = 1412 (4 broken
  references) ....................................................... [WARNING]
  To see more details, run the command in the verbose mode: plesk repair db -verbose
  Remove unnecessary rows from the table 'longtaskparams'? [Y/n] y
    Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'longtaskparams' for the column task_id:
  No rows in the table 'longtasks' with id = 1415 (4 broken
  references) ....................................................... [WARNING]
  To see more details, run the command in the verbose mode: plesk repair db -verbose
  Remove unnecessary rows from the table 'longtaskparams'? [Y/n] y
    Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'longtaskparams' for the column task_id:
  No rows in the table 'longtasks' with id = 1416 (4 broken
  references) ....................................................... [WARNING]
  To see more details, run the command in the verbose mode: plesk repair db -verbose
  Remove unnecessary rows from the table 'longtaskparams'? [Y/n] y
    Removing unnecessary rows ....................................... [FIXED]

Inconsistency in the table 'longtaskparams' for the column task_id:
  No rows in the table 'longtasks' with id = 1417 (4 broken
  references) ....................................................... [WARNING]
  To see more details, run the command in the verbose mode: plesk repair db -verbose
  Remove unnecessary rows from the table 'longtaskparams'? [Y/n] y
    Removing unnecessary rows ....................................... [FIXED]

Error messages: 0; Warnings: 11; Errors resolved: 11
```

DB repair again just in case

```
# plesk repair db

Checking the Plesk database using the native database server tools .. [OK]

Checking the structure of the Plesk database ........................ [OK]

Checking the consistency of the Plesk database ...................... [OK]

Error messages: 0; Warnings: 0; Errors resolved: 0

#
```

## Is there any cache left?

Since the display of twirl does not stop yet, the cache is deleted

```
# service sw-engine stop
Stopping sw-engine (via systemctl):                        [  OK  ]

# rm -rf /var/lock/lmlib/container_locks

# rm -f /usr/local/psa/var/cache/*

# service sw-engine start
Starting sw-engine (via systemctl):                        [  OK  ]

#
```

## Is this the correct answer?

Isn't the cache left, just the progress display disappearing?

```
# plesk db "select * from ModuleSettings where name like '%repair_progress%' and value=1;"
+-----------+-----------------+-------+
| module_id | name            | value |
+-----------+-----------------+-------+
|         9 | repair_progress | 1     |
+-----------+-----------------+-------+

# plesk db "select * from longtasks where type='ext-repair-kit-task_repair'\G"

# plesk db "DELETE FROM ModuleSettings where name like '%repair_progress%' and value=1;"

# plesk db "select * from ModuleSettings where name like '%repair_progress%' and value=1;"

#
```

It seems that the stack and its display have disappeared and it has returned to normal.

CONTENTS

Plesk

How to install SSH2 extension for PHP8.3 on Plesk

Flutter

Android Studio. Could not determine java version. Unable to find bundled Java version.

JavaScript

Video loading with JavaScript