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

2018-02-13 Thread David
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=2

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

2018-02-13 Thread Steve Zeng via Pdns-users
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 reco