• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Issue Broken table dns_recs: Corrupt

cokesaeba

New Pleskian
Server operating system version
Ubuntu 22.04.5 LTS
Plesk version and microupdate number
Plesk Obsidian v18.0.67_build1800250217.08
Hi, I am currently having a problem with the dns-recs database. I can not repair from the plesk panel and I can not renew or create new ssl certificates for the domains that I install on the server. I can't upgrade to the new version of plesk. I copy the failures that tells me the server itself:

Broken table dns_recs: Corrupt
Cannot repair InnoDB tables. Use the following KB article:https://support.plesk.com/hc/articles/12377798484375 or restoredaily dumps stored in /var/lib/psa/dumps


Hopefully someone has the solution more “simple”, thanks in advance, since I do not clarify much with the instructions that tells me on that page and I do not know how to recover the backups indicated.
 
error when trying to upgrade plesk

Check the reason for the error (see log file: /var/log/plesk/install/plesk_18.0.68_installation.log), correct it and try again
mysqldump: Error 1034: The index of table `dns_recs` is corrupt; try to fix it by dumping table `dns_recs` in row: 0
 
error trying to assign the ssl certificate for a new domain

Error: Could not retrieve subscription plan-items: DB query failed: SQLSTATE[HY000]: General error: 1712 Index dns_recs is corrupted, query was: SELECT `dns_recs`.* FROM `dns_recs` WHERE (`dns_zone_id` = 1)
 
You need to recreate the broken index from dns_recs.
You can run the following queries to rebuild the indexes:
SQL:
ALTER TABLE `psa`.`dns_recs` DROP PRIMARY KEY, ADD PRIMARY KEY (`id`) USING BTREE;
ALTER TABLE `psa`.`dns_recs` DROP INDEX `dns_zone_id`, ADD INDEX `dns_zone_id` (`dns_zone_id`) USING BTREE;
ALTER TABLE `psa`.`dns_recs` DROP INDEX `type`, ADD INDEX `type` (`type`) USING BTREE;
ALTER TABLE `psa`.`dns_recs` DROP INDEX `host`, ADD INDEX `host` (`host`) USING BTREE;
 
Thank you very much for your help. I have tried to enter the commands you indicated but I get the above error.
 
Were the indexes removed? What happens if you run the queries again?
Did the MariaDB service restart after the above mentioned error?
 
I have tried to enter again the sql codes you mentioned, in the sql query of the dns_recs table in phpmyadmin.

With mariadb stopped it gives this error

error in procesing code, error code 500, error text, error (rejected)

I have restarted mariab and I get the error I mentioned before

Error

SQL query: Copy

ALTER TABLE `psa`.`dns_recs` DROP PRIMARY KEY, ADD PRIMARY KEY (`id`) USING BTREE;

MySQL said: Documentation
#1030 - Got error 106 “Transport endpoint is already connected” from storage engine InnoDB
 
Try to run the sql queries from the CLI. Access the server via SSH, as root, and run
Code:
plesk db
Afterwards paste the sql queries to alter the indexes.
 
Back
Top