[Pdns-users] Need help after the upgrade

[Peter Zoltan Keresztes (zozo)]

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 at 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
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20250227/f2984faf/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 228 bytes
Desc: Message signed with OpenPGP
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20250227/f2984faf/attachment.sig>