[Pdns-users] (PDNSException): Database failed to start transaction: Could not execute mysql statement
opendak at shaw.ca
Tue Feb 13 19:54:03 UTC 2018
On 2018-02-13 10:57 AM, Steve Zeng via Pdns-users wrote:
> I have our DBAs looked into this and got some findings and feedback:
> I see an deadlock for:
> (1) = delete from records where domain_id=217
> (2) = delete from records where domain_id=217
> So something tries to delete everything for domain=217 while other
> transactions have a lock on some of the records.
> Adding an ORDER BY to the delete query for whole domains might prevent
> that from happening.
> I searched PowerDNS 4.0.5 source code and find the following occurrences
> of the matching SQL statements. are they configurable or we have to
> patch the source code in order to test?
Bottom half of
More information about the Pdns-users