<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<font face="monospace">Thanks for the answer, but all tables are
INNODB.</font><br>
<br>
<div class="moz-cite-prefix">Am 25.11.2021 um 08:50 schrieb Dave
Strydom:<br>
</div>
<blockquote type="cite"
cite="mid:CAHeyidOgh050nY8HVLqGKsR0zydx5-3YCy_pSPznfOiPXyH1pA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Hi,
<div><br>
</div>
<div>Are your pdns tables in MariaDB using MyISAM or InnoDB?</div>
<div><br>
</div>
<div>We had this issue when using MyIASM tables because it does
a full table lock.</div>
<div>Switched it to Innodb which does only row locking and the
issues disappeared.</div>
<div><br>
</div>
<div>- Dave</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, Nov 24, 2021 at 12:58
PM Thomas via Pdns-users <<a
href="mailto:pdns-users@mailman.powerdns.com"
moz-do-not-send="true" class="moz-txt-link-freetext">pdns-users@mailman.powerdns.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div> <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>Am 24.11.2021 um 10:38 schrieb Thomas via Pdns-users:<br>
</div>
<blockquote type="cite"> <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 <a href="http://ovpn.spotsystem.net"
target="_blank" moz-do-not-send="true">ovpn.spotsystem.net</a>
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
href="https://github.com/PowerDNS/pdns/issues/8663"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">https://github.com/PowerDNS/pdns/issues/8663</a><br>
In the thread above is mentioned that setting</font><code
class="gmail-notranslate"><span> "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></fieldset>
<pre>_______________________________________________
Pdns-users mailing list
<a href="mailto:Pdns-users@mailman.powerdns.com" target="_blank" moz-do-not-send="true" class="moz-txt-link-freetext">Pdns-users@mailman.powerdns.com</a>
<a href="https://mailman.powerdns.com/mailman/listinfo/pdns-users" target="_blank" moz-do-not-send="true" class="moz-txt-link-freetext">https://mailman.powerdns.com/mailman/listinfo/pdns-users</a>
</pre>
</blockquote>
<br>
</div>
_______________________________________________<br>
Pdns-users mailing list<br>
<a href="mailto:Pdns-users@mailman.powerdns.com"
target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">Pdns-users@mailman.powerdns.com</a><br>
<a
href="https://mailman.powerdns.com/mailman/listinfo/pdns-users"
rel="noreferrer" target="_blank" moz-do-not-send="true"
class="moz-txt-link-freetext">https://mailman.powerdns.com/mailman/listinfo/pdns-users</a><br>
</blockquote>
</div>
</blockquote>
<br>
</body>
</html>