• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

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

W
Issue IPv6 set up under Plesk, but not served for vhost
Replies
3
Views
471
MartinT
M
R
Issue Plesk repair -all error
Replies
4
Views
1K
MARS_NETWORKS
M
M
Question Certificate renew displays empty dialog.
Replies
0
Views
109
mpc
M
Vikelidis Kostas
Issue Failed to copy content of database
Replies
0
Views
342
Vikelidis Kostas
Vikelidis Kostas
T
Issue Server Error 500 Plesk\Exception\Database
Replies
1
Views
1K
Peter Debik
P
Back
Top