[Pdns-users] [OpendbxBackend] execStmt: Unable to execute query - MySQL server has gone away

[Ralf van der Enden]

Dean,

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:
opendbx-host-read=/tmp
opendbx-host-write=/tmp

It should be similar for MySQL.

Cheers,
Ralf

--------------------------------------------------
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

Hello all,

   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.

I'm running:
  Gentoo
  powerdns 2.9.22
  opendbx  1.4.0
  MySQL 5.0.70-r1


Any clues are appreciated.

Thanks,
   ---Dean.


_______________________________________________
Pdns-users mailing list
Pdns-users at mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users