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 >
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
