Issue Broken table dns_recs: Corrupt

[cokesaeba]

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.

 

[cokesaeba]

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

 

[cokesaeba]

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)

 

[Raul A.]

You need to recreate the broken index from dns_recs.
You can run the following queries to rebuild the indexes:

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;

 

[cokesaeba]

MySQL said:

#1030 - Got error 106 "Transport endpoint is already connected" from storage engine InnoDB

 

[cokesaeba]

Thank you very much for your help. I have tried to enter the commands you indicated but I get the above error.

 

[Raul A.]

Were the indexes removed? What happens if you run the queries again?
Did the MariaDB service restart after the above mentioned error?

 

[cokesaeba]

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

 

[Raul A.]

Try to run the sql queries from the CLI. Access the server via SSH, as root, and run

plesk db

Afterwards paste the sql queries to alter the indexes.