Try increasing max_allowed_packet in your mysqld config, see if that helps...
Frank > On 27 Feb 2025, at 15:10, Peter Zoltan Keresztes (zozo) via Pdns-users > <pdns-users@mailman.powerdns.com> wrote: > > 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) <zozo6...@gmail.com> >> 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@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@mailman.powerdns.com > https://mailman.powerdns.com/mailman/listinfo/pdns-users
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
