[Pdns-users] Need help after the upgrade

[Curtis Maurand]

I can't type: pdnsutil rectify <zone>

Cheers,
Curtis


On 2/27/25 09:46, Curtis Maurand via Pdns-users wrote:
>
> Is the domain signed? Did you run pdnsutil rectivy <zone>?
>
>
>
>
> On 2/27/25 06:58, Peter Zoltan Keresztes (zozo) via Pdns-users wrote:
>> 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
>>>
>>
>>
>> _______________________________________________
>> Pdns-users mailing list
>> Pdns-users at mailman.powerdns.com
>> https://mailman.powerdns.com/mailman/listinfo/pdns-users
>
>
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20250227/3eb3d7f0/attachment-0001.htm>