8bit-dns=yes api=yes api-key=changeme cache-ttl=20 config-dir=/etc/pdns daemon=yes default-api-rectify=yes default-ksk-algorithm=ecdsa256 default-ksk-size=0 default-ttl=3600 direct-dnskey=yes disable-axfr=yes distributor-threads=3 dname-processing=yes dnssec-key-cache-ttl=30 dnsupdate=yes domain-metadata-cache-ttl=60 guardian=no launch=gmysql gmysql-user=powerdns gmysql-password=Password gmysql-dbname=powerdns gmysql-host=10.100.2.9 gmysql-dnssec=yes local-address=0.0.0.0,:: local-port=53 log-dns-details=yes log-dns-queries=yes log-timestamp=yes loglevel=9 loglevel-show=yes max-tcp-connection-duration=0 max-tcp-connections=20 max-tcp-connections-per-client=0 max-tcp-transactions-per-conn=0 query-cache-ttl=20 query-local-address=0.0.0.0:: queue-limit=1500 receiver-threads=1 rng=auto server-id=dns2 setgid=pdns setuid=pdns tcp-fast-open=0 tcp-idle-timeout=5 version-string=anonymous webserver-address=0.0.0.0 webserver-allow-from=0.0.0.0,:: webserver-loglevel=detailed webserver-max-bodysize=2 webserver-port=8082 webserver-print-arguments=no write-pid=yes
> On 27 Feb 2025, at 16:30, fr...@kiwazo.be wrote: > > 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 >>> >> >
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
