[Pdns-users] [OpendbxBackend] execStmt: Unable to execute query - MySQL server has gone away
Ralf van der Enden
tremere at cainites.net
Mon Aug 17 10:59:18 UTC 2009
If you're running MySQL on the same machine as PowerDNS you might wanna try
connecting through a unix socket instead of localhost. It has solved the
exact same issue for me, but with the PgSql database.
This is how I connect to PgSql using a unix socket:
It should be similar for MySQL.
From: "Dean Roman" <droman at oreilly.com>
Sent: Saturday, August 15, 2009 2:12 AM
To: <pdns-users at mailman.powerdns.com>
Subject: [Pdns-users] [OpendbxBackend] execStmt: Unable to execute query -
MySQL server has gone away
I'm getting these errors([OpendbxBackend] execStmt: Unable to execute
query - MySQL server has gone away) sprinkled through my logs, and sometimes
the pdns server will hang for a second, give this error, then 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 am running 2 instances of power dns on the same machine, 1 for
internal, 1 for external. I get the error with both instances.
Any clues are appreciated.
Pdns-users mailing list
Pdns-users at mailman.powerdns.com
More information about the Pdns-users