Resolved Error in backup

[LunDys]

Hi,

I'm getting this error on the Plesk Obsidian 18.0.32 in the backup:

DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.dns_recs' doesn't exist, query was: DESCRIBE `dns_recs`

Server never handled dns records for the domains and no domains are back upped due to this error.

How to solve this error?

 

[IgorG]

Have you tried

# plesk repair db

Also you can create lost table manually with help of:

MariaDB [psa]> show create table dns_recs\G
*************************** 1. row ***************************
       Table: dns_recs
Create Table: CREATE TABLE `dns_recs` (
  `time_stamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `dns_zone_id` int(10) unsigned DEFAULT NULL,
  `type` enum('NS','A','AAAA','CNAME','MX','PTR','TXT','AXFR','SRV','DS','CAA','master','none') NOT NULL DEFAULT 'A',
  `host` varchar(255) NOT NULL,
  `displayHost` varchar(255) NOT NULL,
  `val` text NOT NULL,
  `displayVal` text NOT NULL,
  `opt` varchar(255) NOT NULL DEFAULT '',
  `external_id` varchar(255) DEFAULT NULL,
  `ttl` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dns_zone_id` (`dns_zone_id`),
  KEY `host` (`host`),
  KEY `type` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=1094 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)