[Pdns-users] Need help after the upgrade

[Curtis Maurand]

sorry for the bandwidth: pdnsutil rectify-zone <zone>


On 2/27/25 09:47, Curtis Maurand via Pdns-users wrote:
>
> 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
>
>
> _______________________________________________
> 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/da82b7eb/attachment.htm>