<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hi,<br class=""><br class="">Our PDNS environment is setup on Centos 7 + PDNS Authoritative 4.0.5 + <span class="">mysql-community 5.7</span><div class=""><br class="">It is noticed that there are regular PowerDNS failure logs below:<br class=""><br class="">2018-02-04T04:29:07.193742+01:00 <a href="http://mpdns.example.com" class="">mpdns.example.com</a> pdns_server[40761]: Feb 04 04:29:07 Unable to AXFR zone ‘<a href="http://lom.example.com" class="">lom.example.com</a>' from remote ‘x.x.x.x:53' (PDNSException): Database failed to start transaction: Could not execute mysql statement: delete from records where domain_id=?: Lock wait timeout exceeded; try restarting transaction<div class=""><br class=""></div><div class="">I looked at PowerDNS list of settings at <a href="https://doc.powerdns.com/md/authoritative/backend-generic-mysql/" class="">https://doc.powerdns.com/md/authoritative/backend-generic-mysql/</a> and do not see any configurable settings for it. Our correct pdns.conf can be seen below:</div></div><div class=""><br class=""></div><span class="">launch=gmysql<br class="">gmysql-host=y.y.y.y<br class="">gmysql-user=auser<br class="">gmysql-dbname=pdns<br class="">gmysql-password=********<br class="">gmysql-timeout=0<br class=""></span><span class=""><br class=""></span><div class=""><span class="">not sure if this cause is on PowerDNS side or MySQL database side. can anybody shed a light here? </span></div><div class=""><span class=""><br class=""></span></div><div class=""><span class="">Thanks,</span></div><div class=""><span class="">Steve</span></div><div class=""><span class=""><br class=""></span></div></body></html>