I have reinstalled the pdns exported the zones to csv files and readied the used one using pdnsutil however when I try to save sometimes I am getting the same errors.
mysql> explain select domains.id, domains.name, records.content, domains.type,
domains.master, domains.notified_serial, domains.last_check, domains.account,
domains.catalog from domains LEFT JOIN records ON records.domain_id=domains.id
AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0
-> ;
+----+-------------+---------+------------+------+--------------------------+----------------+---------+-----------------------------+------+----------+-------------+
| id | select_type | table | partitions | type | possible_keys |
key | key_len | ref | rows | filtered |
Extra |
+----+-------------+---------+------------+------+--------------------------+----------------+---------+-----------------------------+------+----------+-------------+
| 1 | SIMPLE | domains | NULL | ALL | PRIMARY,name_index |
NULL | NULL | NULL | 1 | 100.00 | NULL
|
| 1 | SIMPLE | records | NULL | ref | nametype_index,domain_id |
nametype_index | 271 | powerdns.domains.name,const | 1 | 10.00 |
Using where |
+----+-------------+---------+------------+------+--------------------------+----------------+---------+-----------------------------+------+----------+-------------+
2 rows in set, 1 warning (0.01 sec)
> On 27 Feb 2025, at 11:04, frank--- via Pdns-users
> <pdns-users@mailman.powerdns.com> wrote:
>
> explain select domains.id <http://domains.id/>, domains.name,
> records.content, domains.type, domains.master, domains.notified_serial,
> domains.last_check, domains.account, domains.catalog from domains LEFT JOIN
> records ON records.domain_id=domains.id <http://domains.id/> AND
> records.type='SOA' AND records.name=domains.name WHERE records.disabled=0
>
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
