[Pdns-users] (PDNSException): Database failed to start transaction: Could not execute mysql statement

[Steve Zeng]

Hi,

Our PDNS environment is setup on Centos 7 + PDNS Authoritative 4.0.5 + mysql-community 5.7

It is noticed that there are regular PowerDNS failure logs below:

2018-02-04T04:29:07.193742+01:00 mpdns.example.com pdns_server[40761]: Feb 04 04:29:07 Unable to AXFR zone ‘lom.example.com' 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

I looked at PowerDNS list of settings at https://doc.powerdns.com/md/authoritative/backend-generic-mysql/ <https://doc.powerdns.com/md/authoritative/backend-generic-mysql/> and do not see any configurable settings for it. Our correct pdns.conf can be seen below:

launch=gmysql
gmysql-host=y.y.y.y
gmysql-user=auser
gmysql-dbname=pdns
gmysql-password=********
gmysql-timeout=0

not sure if this cause is on PowerDNS side or MySQL database side. can anybody shed a light here? 

Thanks,
Steve

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20180206/11a0172d/attachment.html>