<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;">Deployed a new mysql server and everything works as expected. Thank you for your patience and all the answers. Based on the configuration file posted if you see ways to improve feel free to to post your suggestions. <div><br></div><div>Regards,</div><div>Peter<br><div><div><blockquote type="cite"><div>On 27 Feb 2025, at 17:12, 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;"><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></div></div></blockquote></div><br></div></div></body></html>