Resolved Database error after Upgrade

[Dukemaster]

Hi,
I just performed an overall test by # plesk repair all -n with the following result:

Checking the consistency of the Plesk database

  Inconsistency in the table 'ModuleSettings' for the column
  module_id: No rows in the table 'Modules' with  = 13 (2 broken
  references) ....................................................... [WARNING]
  To see more details, run the command in the verbose mode: plesk repair db -verbose

Checking system users ............................................... [OK]

root@server:~# plesk repair db -verbose

Checking the Plesk database using the native database server tools
  Run query: CHECK TABLE accounts
  Run query: CHECK TABLE actions
  Run query: CHECK TABLE admin_aliases
  Run query: CHECK TABLE admin_aliases_param
  Run query: CHECK TABLE anon_ftp
.......

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

Checking the consistency of the Plesk database

  Inconsistency in the table 'ModuleSettings' for the column
  module_id: No rows in the table 'Modules' with  = 13 (2 broken
  references) ....................................................... [WARNING]

  Broken references in table 'ModuleSettings':
  *************************** 1. row ***************************
  module_id: 13
       name: eventStatus_activated
      value: true
  *************************** 2. row ***************************
  module_id: 13
       name: eventStatus_enabled
      value: true

  Remove unnecessary rows from the table 'ModuleSettings'? [Y/n]

1. Is there another way to repair it, for the reason that perhaps the 2 rows are needed in future?
2. Or, do you suggest the recommended solution with "Remove unnecessary rows from the table 'ModuleSettings'?" and hitting Y for YES

 

[IgorG]

I've checked on fresh Obsidian and see nothing suspicious after:

# plesk repair db -verbose

In the database no such records:

MariaDB [psa]> select * from ModuleSettings where name like 'eventStatus%'\G
Empty set (0.00 sec)

I suppose you can just safely remove these records.

 

[Dukemaster]

Thank you very, very much @Igor. Hoped that You give me an answer.

Successful done... now:
Error messages: 0; Warnings: 0; Errors resolved: 0

Remove unnecessary rows from the table 'ModuleSettings'? [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.20190924-194823.dump.gz
    Removing unnecessary rows ....................................... [FIXED]

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

root@server:~# plesk repair all -n

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]

Checking system users ............................................... [OK]

Checking Linux system files ......................................... [OK]

Checking virtual hosts' file system ................................. [OK]

Checking Plesk version .............................................. [OK]

Checking for custom configuration templates ......................... [OK]

Checking the JkWorkersFile directive in the Apache configuration .... [OK]

Checking associations between domains and IP addresses .............. [OK]

Checking for corrupted reference between IP collections and
IPaddresses ......................................................... [OK]

Checking for links between APS applications and subscriptions ....... [OK]

Checking for nginx ULIMIT value ..................................... [OK]

Checking for extra configurations in database not owned by any object
................................................................... [OK]

Checking the configuration of Apache modules ........................ [OK]

Checking web server configuration. Please wait ...................... [OK]

Checking the usage of PHP handlers .................................. [OK]

Repairing the mail server configuration ............................. [OK]

Checking the DNS configuration file ................................. [OK]

Restoring DNS server configuration .................................. [OK]

Checking MySQL database servers ..................................... [OK]

Repair databases on available servers ............................... [OK]

Repair database users on available servers .......................... [OK]

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

root@server:~#

 

[iionutfili]

I have the same problem but I got the following error:

Remove unnecessary rows from the table 'dom_param'? [Y/n] y
Creating a database dump ........................................
Execution failed.
Command: /usr/local/psa/bin/mysqldump.sh
Arguments: Array
(
[0] => --title
[1] => preresolve
)

Details: Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
***** problem report *****
Warning: start service mariadb failed
ERROR while trying to establish test connection
Check the error reason, fix and try again

is there a simple solution to solve? thanks

 

[IgorG]

I have the same problem but I got the following error:

Remove unnecessary rows from the table 'dom_param'? [Y/n] y
Creating a database dump ........................................
Execution failed.
Command: /usr/local/psa/bin/mysqldump.sh
Arguments: Array
(
[0] => --title
[1] => preresolve
)

Details: Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
***** problem report *****
Warning: start service mariadb failed
ERROR while trying to establish test connection
Check the error reason, fix and try again

is there a simple solution to solve? thanks

Make sure first that mariadb service is correctly started.

 

[B_P]

Hi @IgorG ,

I just ran the repair tool as well and got:

plesk repair db -n

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 'ModuleSettings' for the column        
  module_id: No rows in the table 'Modules' with id = 78 (2 broken  
  references) ....................................................... [WARNING]
  To see more details, run the command in the verbose mode: plesk repair db -verbose

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

Running in verbose mode, these details are shown:

Inconsistency in the table 'ModuleSettings' for the column         
  module_id: No rows in the table 'Modules' with id = 78 (2 broken   
  references) ....................................................... [WARNING]
 
  Broken references in table 'ModuleSettings':
  *************************** 1. row ***************************
  module_id: 78
       name: contextLines
      value: 20
  *************************** 2. row ***************************
  module_id: 78
       name: searchFiles
      value:


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

(Ubuntu 16.04, Obsidian 18.0.30, MU#2).

 

[IgorG]

Inconsistency in the table 'ModuleSettings' for the column

Unable to repair Plesk database using Repair Kit: Checking the consistency of the Plesk database Inconsistency in the table 'ModuleSettings' for the column module_id

Applicable to: Plesk for Linux Plesk for Windows Symptoms The following warning appears after pressing Repair of Plesk Database in Tools & Settings > Diagnose & Repair or after executi...

support.plesk.com

 

[B_P]

Unable to repair Plesk database using Repair Kit: Checking the consistency of the Plesk database Inconsistency in the table 'ModuleSettings' for the column module_id

Applicable to: Plesk for Linux Plesk for Windows Symptoms The following warning appears after pressing Repair of Plesk Database in Tools & Settings > Diagnose & Repair or after executi...

support.plesk.com

Thanks, this helped!

 

[karam]

Hey everyone, I got this :

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 'smb_roleServicePermissions' for the
column servicePermissionId: No rows in the table
'smb_servicePermissions' with id = 1 .............................. [WARNING]
To see more details, run the command in the verbose mode: plesk repair db -verbose

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

Any advises ?

trying
plesk repair db

will ask me the following, can i safely say Y ?
Remove unnecessary rows from the table 'smb_roleServicePermissions'? [Y/n]

 

[IgorG]

can i safely say Y

If you want to fix it, press Y.

 

[StefSabi]

I have make a plesk update then this mistake

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

Checking the consistency of the Plesk database
The following domains are assigned to already removed IP addresses.
Reassign the domains to existing IP addresses: .................................................................. [ERROR]