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

[bert hubert]

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.

Thanks.

	Bert

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