I just noticed something wierd in your query. > SELECT content,ttl,prio,type,domain_id,disabled,name,auth,ordername FROM > records WHERE (disabled=0 OR ?) and domain_id=? order by name, type
That "disabled=0 or ?" construct seems off to me. Can you please post your full and unedited (only mask the passwords, nothing else) PowerDNS config file? Frank > On 27 Feb 2025, at 15:23, Peter Zoltan Keresztes (zozo) <zozo6...@gmail.com> > wrote: > > Just did that increased it to 128M no change whatsoever. > > Peter > >> On 27 Feb 2025, at 16:22, fr...@kiwazo.be wrote: >> >> 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
