<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;"><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></body></html>