• We value your experience with Plesk during 2024
    Plesk strives to perform even better in 2025. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2024.
    Please take this short survey:
    https://pt-research.typeform.com/to/AmZvSXkx
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

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

weareimpulse
Resolved Unable to export a dump of database
Replies
1
Views
402
weareimpulse
weareimpulse
J
Resolved Can't login at Plesk admin panel (Plesk Onyx 17.0.17)
Replies
6
Views
10K
JVG
J
W
Issue IPv6 set up under Plesk, but not served for vhost
Replies
3
Views
940
MartinT
M
R
Issue Plesk repair -all error
Replies
4
Views
2K
MARS_NETWORKS
M
M
Question Certificate renew displays empty dialog.
Replies
0
Views
302
mpc
M
Back
Top