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

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

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

Re: [Pdns-users] [External] Notification for domains to ip1:53 failed after retries

2018-01-30 Thread Steve Zeng via Pdns-users
Brian and Pieter, great information. I will check it out. Thanks, Steve > On Jan 25, 2018, at 2:16 AM, Brian Candler wrote: > > On 25/01/2018 10:08, Tom Ivar Helbekkmo wrote: >> I found these two blog postings useful: >> >> https://blog.powerdns.com/2016/01/19/efficient-optional-filtering-of