<html><head><meta http-equiv="content-type" content="text/html; charset=us-ascii"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div>8bit-dns=yes</div><div>api=yes</div><div>api-key=changeme</div><div>cache-ttl=20</div><div>config-dir=/etc/pdns</div><div>daemon=yes</div><div>default-api-rectify=yes</div><div>default-ksk-algorithm=ecdsa256</div><div>default-ksk-size=0</div><div>default-ttl=3600</div><div>direct-dnskey=yes</div><div>disable-axfr=yes</div><div>distributor-threads=3</div><div>dname-processing=yes</div><div>dnssec-key-cache-ttl=30</div><div>dnsupdate=yes</div><div>domain-metadata-cache-ttl=60</div><div>guardian=no</div><div>launch=gmysql</div><div>gmysql-user=powerdns</div><div>gmysql-password=Password</div><div>gmysql-dbname=powerdns</div><div>gmysql-host=10.100.2.9</div><div>gmysql-dnssec=yes</div><div>local-address=0.0.0.0,::</div><div>local-port=53</div><div>log-dns-details=yes</div><div>log-dns-queries=yes</div><div>log-timestamp=yes</div><div>loglevel=9</div><div>loglevel-show=yes</div><div>max-tcp-connection-duration=0</div><div>max-tcp-connections=20</div><div>max-tcp-connections-per-client=0</div><div>max-tcp-transactions-per-conn=0</div><div>query-cache-ttl=20</div><div>query-local-address=0.0.0.0::</div><div>queue-limit=1500</div><div>receiver-threads=1</div><div>rng=auto</div><div>server-id=dns2</div><div>setgid=pdns</div><div>setuid=pdns</div><div>tcp-fast-open=0</div><div>tcp-idle-timeout=5</div><div>version-string=anonymous</div><div>webserver-address=0.0.0.0</div><div>webserver-allow-from=0.0.0.0,::</div><div>webserver-loglevel=detailed</div><div>webserver-max-bodysize=2</div><div>webserver-port=8082</div><div>webserver-print-arguments=no</div><div>write-pid=yes</div><div><br><blockquote type="cite"><div>On 27 Feb 2025, at 16:30, frank@kiwazo.be wrote:</div><br class="Apple-interchange-newline"><div><meta http-equiv="content-type" content="text/html; charset=us-ascii"><div style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">I just noticed something wierd in your query.<div><br></div><div>> <span style="font-family: HelveticaNeue;"> SELECT content,ttl,prio,type,domain_id,disabled,name,auth,ordername FROM records WHERE (disabled=0 OR ?) and domain_id=? order by name, type</span></div><div><font face="HelveticaNeue"><br></font></div><div><font face="HelveticaNeue">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?</font></div><div><br></div><div><font face="HelveticaNeue">Frank</font></div><div><div><br><blockquote type="cite"><div>On 27 Feb 2025, at 15:23, Peter Zoltan Keresztes (zozo) <zozo6015@gmail.com> wrote:</div><br class="Apple-interchange-newline"><div><meta http-equiv="content-type" content="text/html; charset=us-ascii"><div style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">Just did that increased it to 128M no change whatsoever.<div><br></div><div>Peter<br id="lineBreakAtBeginningOfMessage"><div><br><blockquote type="cite"><div>On 27 Feb 2025, at 16:22, frank@kiwazo.be wrote:</div><br class="Apple-interchange-newline"><div><meta http-equiv="content-type" content="text/html; charset=us-ascii"><div style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><span style="font-family: HelveticaNeue;">Try increasing </span><span style="background-color: rgb(255, 255, 255);"><font color="#1f2328" face="-apple-system, BlinkMacSystemFont, Segoe UI, Noto Sans, Helvetica, Arial, sans-serif, Apple Color Emoji, Segoe UI Emoji"><span style="caret-color: rgb(31, 35, 40);">max_allowed_packet in your mysqld config, see if that helps...</span></font></span><br id="lineBreakAtBeginningOfMessage"><div><br></div><div><br></div><div>Frank</div><div><br><blockquote type="cite"><div>On 27 Feb 2025, at 15:10, Peter Zoltan Keresztes (zozo) via Pdns-users <pdns-users@mailman.powerdns.com> wrote:</div><br class="Apple-interchange-newline"><div><meta http-equiv="content-type" content="text/html; charset=us-ascii"><div style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">This is really strange situation. <div>I have the list of records added to the domain. I can check pdnsutil check-zone <a href="http://zozoo.io/">zozoo.io</a> works with no issue. I edit the zone with pdnsutil edit-zone <a href="http://zozoo.io/">zozoo.io</a> I add yet another boring A record nothing strange, when to apply I get</div><div>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</div><div>I added the record directly into the mysql database. Running a dnsutil check-zone <a href="http://zozoo.io/">zozoo.io</a> same error. I removed the record from the backend via mysql I can run dnsutil check-zone <a href="http://zozoo.io/">zozoo.io</a> with no issues.</div><div><br></div><div>Note I am running powerdns 4.9.4</div><div><br id="lineBreakAtBeginningOfMessage"><div><br><blockquote type="cite"><div>On 27 Feb 2025, at 13:58, Peter Zoltan Keresztes (zozo) <zozo6015@gmail.com> wrote:</div><br class="Apple-interchange-newline"><div><meta http-equiv="content-type" content="text/html; charset=us-ascii"><div style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">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.<div><br></div><div><div>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</div><div> -> ;</div><div>+----+-------------+---------+------------+------+--------------------------+----------------+---------+-----------------------------+------+----------+-------------+</div><div>| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |</div><div>+----+-------------+---------+------------+------+--------------------------+----------------+---------+-----------------------------+------+----------+-------------+</div><div>| 1 | SIMPLE | domains | NULL | ALL | PRIMARY,name_index | NULL | NULL | NULL | 1 | 100.00 | NULL |</div><div>| 1 | SIMPLE | records | NULL | ref | nametype_index,domain_id | nametype_index | 271 | powerdns.domains.name,const | 1 | 10.00 | Using where |</div><div>+----+-------------+---------+------------+------+--------------------------+----------------+---------+-----------------------------+------+----------+-------------+</div><div>2 rows in set, 1 warning (0.01 sec)</div><div><br></div><div><br></div><div><br><blockquote type="cite"><div>On 27 Feb 2025, at 11:04, frank--- via Pdns-users <pdns-users@mailman.powerdns.com> wrote:</div><br class="Apple-interchange-newline"><div><meta charset="UTF-8"><div style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><span style="font-family: HelveticaNeue;">explain select </span><a href="http://domains.id/" style="font-family: HelveticaNeue;">domains.id</a><span style="font-family: HelveticaNeue;">, 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=</span><a href="http://domains.id/" style="font-family: HelveticaNeue;">domains.id</a><span style="font-family: HelveticaNeue;"> AND records.type='SOA' AND records.name=domains.name WHERE records.disabled=0</span></div><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;"></span><br class="Apple-interchange-newline"></div></blockquote></div><br></div></div></div></blockquote></div><br></div></div>_______________________________________________<br>Pdns-users mailing list<br>Pdns-users@mailman.powerdns.com<br>https://mailman.powerdns.com/mailman/listinfo/pdns-users<br></div></blockquote></div><br></div></div></blockquote></div><br></div></div></div></blockquote></div><br></div></div></div></blockquote></div><br></body></html>