[Pdns-users] Authority not refreshing stale mysql connections?

[MRob]

On 2016-11-24 12:49, bert hubert wrote:
> MRob,
> 
> It is tremendously helpful if you let us know which version of PowerDNS 
> you
> are running and on which platform.
> 
> We are aware of some versions of PowerDNS having this issue but we need 
> to
> know what you are running.

I'm sorry I left that out. I installed using apt-get on Ubuntu. Package 
is called:

pdns-server 4.0.0~alpha2-3build1

pdns_server --version reports "Authoritative Server 4.0.0-alpha2"

Since you have heard reports of this before, do you know if the problem 
only happens on lightly used systems? In other words, if I move it to 
production where queries happen on a regular basis, will the DB 
connection not go stale?

> On Thu, Nov 24, 2016 at 12:46:42PM -0800, MRob wrote:
>> I have a mysql-backed authority set up locally serving the internal 
>> LAN
>> domain on a test platform (very lightly used at the moment). It 
>> appears that
>> after some time (hours), the DB connection goes stale and queries 
>> return
>> with dig reporting status SERVFAIL. If I wait (not sure how long, but 
>> I
>> think more than 5 minutes, if not a lot longer), the queries will 
>> start
>> working normally again (status NOERROR).
>> 
>> It appears I can cause the same problem prematurely by restarting the 
>> mysql
>> service, which is what leads me to believe PDNS is not refreshing 
>> stale
>> database connections right away (though eventually it does).
>> 
>> Restarting the authority of course fixes the problem, but I'm looking 
>> for a
>> better solution.
>> 
>> Help?
>> _______________________________________________
>> Pdns-users mailing list
>> Pdns-users at mailman.powerdns.com
>> https://mailman.powerdns.com/mailman/listinfo/pdns-users