• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Resolved Database error after Upgrade

Dukemaster

Dukemaster

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

Code: 
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]

Code: 
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
 
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.
 
Thank you very, very much @Igor. Hoped that You give me an answer. :)

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

Code: 
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:~#
 
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
 
iionutfili said:
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
Click to expand...
Make sure first that mariadb service is correctly started.
 
Hi @IgorG ,

I just ran the repair tool as well and got:

Code: 
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:

Code: 
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).
 
  • Like
Reactions: B_P
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
Click to expand...

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]
 
Last edited:
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]
 
You must log in or register to reply here.

Similar threads

J
Resolved plesk repair fs - fsmng failed: ERROR: Unable to retrieve repository
Replies
3
Views
811
Josch
J
F
Issue Server Error 500 Plesk\Exception\Database
Replies
3
Views
2K
scsa20
scsa20
P
Issue Broken update after switching from Obsidian 18.0.72 to 18.0.73
Replies
2
Views
543
scsa20
scsa20
T
Issue mysqldump: Got error: 1932: "Table 'psa.WebsitesDiagnostic' doesn't exist in engine" when using LOCK TABLES
Replies
6
Views
3K
TrevorM
T
weareimpulse
Resolved Unable to export a dump of database
Replies
1
Views
2K
weareimpulse
weareimpulse
Back
Top