<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<font face="monospace">Added an '</font><font face="monospace">API-RECTIFY
= 0' to the zone meta-data having the deadlocks and the deadlocks
did not reapear until now.<br>
<br>
</font><br>
<div class="moz-cite-prefix">Am 24.11.2021 um 10:38 schrieb Thomas
via Pdns-users:<br>
</div>
<blockquote type="cite"
cite="mid:9268826a-0474-1dcd-6be2-78a9c182c5ed@plant.systems">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<font face="monospace">Hello.<br>
<br>
We are running pdns-4.5.1-1pdns.el8.x86_64 with
MariaDB-server-10.4.21 as backend. I am seeing regular messages
in our pdns 4.5.2 regarding deadlocks in MySQL.<br>
<br>
Exception: GSQLBackend unable to nullify ordername and update
auth for ovpn.spotsystem.net for domain_id 17651: Could not
execute mysql statement: update records set
ordername=NULL,auth=? where domain_id=? and name=? and
disabled=0: Deadlock found when trying to get lock; try
restarting transaction<br>
<br>
I have found the following bug report on Github: <a
class="moz-txt-link-freetext"
href="https://github.com/PowerDNS/pdns/issues/8663"
moz-do-not-send="true">https://github.com/PowerDNS/pdns/issues/8663</a><br>
In the thread above is mentioned that setting</font><code
class="docutils literal notranslate"><span class="pre">
"default-api-rectify = no" resolves the deadlock if I did
understand correctly. <br>
<br>
What does 'api-rectify' do? And is it save to disable?<br>
<br>
Thanks,<br>
Thomas<br>
<br>
<br>
</span></code> <br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
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>