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

[Dean Roman]

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@...
http://mailman.powerdns.com/mailman/listinfo/pdns-users

[Norbert Sendetzky]

Hi Dean

>    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'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 query
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.


Norbert
--
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc




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

[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@...>
Sent: Saturday, August 15, 2009 2:12 AM
To: <pdns-users@...>
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@...
http://mailman.powerdns.com/mailman/listinfo/pdns-users 

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

[Dean Roman]

Norbert, Ralf,

I'll give each of the options you presented a try and report back.

Thanks again,
   ---Dean.


----- "Norbert Sendetzky" <norbert@...> wrote:

> Hi Dean
>
> >    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'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
> query
> 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.
>
>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
>
> _______________________________________________
> Pdns-users mailing list
> Pdns-users@...
> http://mailman.powerdns.com/mailman/listinfo/pdns-users

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