Re: Need help after the upgrade

This is really strange situation. 
I have the list of records added to the domain. I can check pdnsutil check-zone zozoo.io <http://zozoo.io/> works with no issue. I edit the zone with pdnsutil edit-zone zozoo.io <http://zozoo.io/> I add yet another boring A record nothing strange, when to apply I get
Error: GSQLBackend unable to list domain 'zozoo.io': Could not execute mysql statement: SELECT content,ttl,prio,type,domain_id,disabled,name,auth,ordername FROM records WHERE (disabled=0 OR ?) and domain_id=? order by name, type: Lost connection to server during query
I added the record directly into the mysql database. Running a dnsutil check-zone zozoo.io <http://zozoo.io/> same error. I removed the record from the backend via mysql I can run dnsutil check-zone zozoo.io <http://zozoo.io/> with no issues.

Note I am running powerdns 4.9.4


> On 27 Feb 2025, at 13:58, Peter Zoltan Keresztes (zozo) <[email protected]> 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 <[email protected]> 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
[email protected]
https://mailman.powerdns.com/mailman/listinfo/pdns-users

-----BEGIN PGP SIGNATURE-----

iHUEARYIAB0WIQQCv2JrA9ofeVv6au5T3/UvGHLXHQUCZ8BySwAKCRBT3/UvGHLX
HfOXAP9DdQor8BhfJ8Kjc9AtYLOHYv9CDFm8hGiRvT7yjk6FIAEAwZvNG3droZhW
rr0g+KLS/bB0PB5prY3ArYsEN07+BgM=
=f8t8
-----END PGP SIGNATURE-----