<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<br>
Is the domain signed? Did you run pdnsutil rectivy <zone>?<br>
<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">On 2/27/25 06:58, Peter Zoltan
Keresztes (zozo) via Pdns-users wrote:<br>
</div>
<blockquote type="cite"
cite="mid:D227029C-AE1F-435F-8FD7-E9C33D22A639@gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
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
<a class="moz-txt-link-rfc2396E" href="mailto:pdns-users@mailman.powerdns.com"><pdns-users@mailman.powerdns.com></a> 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;"
moz-do-not-send="true">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;"
moz-do-not-send="true">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>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre wrap="" class="moz-quote-pre">_______________________________________________
Pdns-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Pdns-users@mailman.powerdns.com">Pdns-users@mailman.powerdns.com</a>
<a class="moz-txt-link-freetext" href="https://mailman.powerdns.com/mailman/listinfo/pdns-users">https://mailman.powerdns.com/mailman/listinfo/pdns-users</a>
</pre>
</blockquote>
<br>
</body>
</html>