Resolved On MariaDB update: "mariadb-dump: Got error: 1932: "Table 'psa.module_dnssec_dnsZone' doesn't exist in engine" when using LOCK TABLES"

[TalkBuildHost]

Server operating system version

Ubuntu 24.04 Operating System Ubuntu 24.04.4 LTS

Plesk version and microupdate number

Plesk Obsidian v18.0.78_build1800260529.17 os_

I got this log yesterday I update it no new update but still got this:

mariadb-dump: Got error: 1932: "Table 'psa.module_dnssec_dnsZone' doesn't exist in engine" when using LOCK TABLES

**** Product prep-install started.
Create user 'psaadm' and group 'psaadm'
Group 'psaadm' already exists
Checking for the user 'psaadm'...
User 'psaadm' already exists
Create group 'swkey-data'
Group 'swkey-data' already exists
Trying to add supplementary group 'swkey-data' for user 'psaadm'... already there
Create group 'psaserv'
Group 'psaserv' already exists
Trying to add supplementary group 'psaserv' for user 'psaadm'... already there
Create group 'psacln'
Group 'psacln' already exists
Trying to got legacy variables... done
Trying to save legacy variables... done
Checking that /opt/psa/bin/chrootsh registered as login shell...

===> Performing safe prep-install database actions


===> Upgrading database

Trying to start service mariadb... active
done
Trying to establish test connection... connected
done
Trying to find Plesk database psa... version is 018000000
Trying to backup MySQL database... mariadb-dump: Got error: 1932: "Table 'psa.module_dnssec_dnsZone' doesn't exist in engine" when using LOCK TABLES

ERROR while trying to backup MySQL database

Check the error reason (see log file: /var/log/plesk/install/plesk_18.0.78_installation.log), fix and try again
mariadb-dump: Got error: 1932: "Table 'psa.module_dnssec_dnsZone' doesn't exist in engine" when using LOCK TABLES
***** problem report *****
ERROR while trying to backup MySQL database
Launching component and product checkers...
Downloading file report-update: 0%
Downloading file report-update: 100% was finished.
Downloading file pool/PSA_18.0.78_19254/examiners/py_launcher.sh: 0%
Downloading file pool/PSA_18.0.78_19254/examiners/py_launcher.sh: 100% was finished.

ERROR: An error occurred during performing of installation PREP actions (see log for details). Installation was rolled back.
Warning! Not all packages were installed.
Please check if your system services are operable.
Please resolve this issue and try to install the packages again.
Visit https://support.plesk.com/ to search for a solution.

 

[TalkBuildHost]

what happened!

The root cause was an old DNSSEC extension that had left behind corrupted/orphaned InnoDB tables:

• module_dnssec_dnsZone
• module_dnssec_signingKey
• module_dnssec_version

Plesk's upgrade process performs a database dump before upgrading, and mariadb-dump aborted when it encountered those broken tables. Removing the orphaned DNSSEC tables allowed the backup step to complete and the upgrade to finish.
At this point my server appears healthy and the upgrade succeeded.

 

[TalkBuildHost]

marked solved.