[Pdns-users] (PDNSException): Database failed to start transaction: Could not execute mysql statement
steve.zeng at booking.com
Tue Feb 6 23:26:07 UTC 2018
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: 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:
not sure if this cause is on PowerDNS side or MySQL database side. can anybody shed a light here?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Pdns-users