[Pdns-users] [OpendbxBackend] execStmt: Unable to execute query - MySQL server has gone away
droman at oreilly.com
Mon Aug 17 17:27:38 UTC 2009
I'll give each of the options you presented a try and report back.
----- "Norbert Sendetzky" <norbert at linuxnetworks.de> wrote:
> Hi Dean
> > I'm getting these errors([OpendbxBackend] execStmt: Unable to
> > query - MySQL server has gone away) sprinkled through my logs, and
> > sometimes the pdns server will hang for a second, give this error,
> > successfully resolve, other times, it won't resolve at all.
> > I have MySQL max_connections set very high...4096. This system
> is still
> > in development, so it's not getting hit hard or very often.
> > I'm running:
> > Gentoo
> > powerdns 2.9.22
> > opendbx 1.4.0
> > MySQL 5.0.70-r1
> The MySQL server closes connections to clients after some idle time,
> even if
> the client is still alive. This only happens in setups that get only a
> from time to time. The only known solution is to set the timeout on
> the MySQL
> default idle timeout higher. If you put you system into production,
> you won't
> see this happening again.
> OpenPGP public key
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
More information about the Pdns-users