<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Aptos;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:12.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#467886;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="NL" link="#467886" vlink="#96607D" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi powerdns mailinglist,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-US">We have some weird behavior and want to know if this is either a misconfiguration on our end or a bug.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">We have build a DNS setup consisting of a single, hidden master server which uses sqlite3 to administrater DNS zone information.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">This sqlite backend database is then replicated to three pdns authorative servers by using sqlite3-rsync. (see:
<a href="https://www.sqlite.org/rsync.html">https://www.sqlite.org/rsync.html</a>)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">This sync seems to be running fine, and the authorative servers are handling the syncing of this file without issues. We do however see some strange behaviour in the logs from time to time:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Jan 27 15:16:54 pdns_server[880067]: Backend reported permanent error which prevented lookup (GSQLBackend unable to lookup <DOMAINNAME HIDDEN>l|ANY':Error while retrieving SQLite query results: database disk image is
malformed (11)), aborting<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Jan 27 13:27:39 pdns_server[880067]: Backend error: GSQLBackend unable to find before/after (before) for domain_id 1988 and qname '2u13167hsjsu39hssbaivjsli8bb47lv: Error while retrieving SQLite query results: database
disk image is malformed (11)<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">When we do integrity checks on the sqlite file, they return without issues. So the data on disk seems to be intact and not seem corrupted like the error message seems to indicate.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">root@nsauth-3 ~ # sqlite3 /var/lib/powerdns/pdns_sql3.db<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">SQLite version 3.40.1 2022-12-28 14:03:47<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Enter ".help" for usage hints.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">sqlite> pragma quik_check;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">sqlite> pragma quick_check;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ok<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">sqlite> pragma integrity_check;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">ok<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">sqlite><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">We also do not have customers reporting issues or see any other abnormal behavior in the operations of the authorative server.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Could someone advise us on how to further troubleshoot this issue?
<o:p></o:p></span></p>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-line-height-alt:10.8pt">
<span style="font-size:11.0pt;font-family:"Segoe UI",sans-serif;color:#1E355E;mso-ligatures:none;mso-fareast-language:NL">Met vriendelijke groet,
<br>
<br>
JACOB DE BROUWER<br>
</span><span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif;color:#1E355E;mso-ligatures:none;mso-fareast-language:NL">NETWORK ENGINEER</span><span style="font-size:11.0pt;font-family:"Segoe UI",sans-serif;color:#1E355E;mso-ligatures:none;mso-fareast-language:NL"><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:8.0pt;font-family:"Segoe UI",sans-serif;color:#1E355E;mso-ligatures:none;mso-fareast-language:NL">Interconnect Services B.V.<br>
<br>
</span><o:p></o:p></p>
</div>
</body>
</html>