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