[Pdns-users] Re: [Pdns-dev] OpendbxBackend errors
norbert at linuxnetworks.de
Fri Feb 16 21:21:53 UTC 2007
> I figured it out. I'm running a cronjob at night doing some backup jobs,
> which include stopping and restarting MySQL.
> This happens as soon as MySQL goes away:
> Extract from my logs:
> Feb 16 05:00:00 deathstar pdns: [OpendbxBackend] execStmt: Unable
> to execute query - MySQL server has gone away
> Feb 16 05:00:00 deathstar pdns: [OpendbxBackend] Unable to bind
> to database on host localhost - Can't connect to local MySQL server
> through socket '/tmp/mysql.sock' (2)
> Feb 16 05:00:00 deathstar pdns: Database module reported
> condition which prevented lookup - sending out servfail
> Feb 16 05:00:00 deathstar pdns: [OpendbxBackend] escape(string):
> Unable to escape string - Invalid parameter
> Feb 16 05:00:00 deathstar pdns: [OpendbxBackend] lookup: Caught
> STL exception - odbx_escape() failed
> OpenDBX (or PowerDNS?) does not recover from this situation until
> PowerDNS is restarted, even after MySQL comes back. I just reproduced
> this behaviour.
The opendbxbackend included in 2.9.20 (up to patch 4) failed to recover from
loosing database connections permanently because it tries to reconnect only
if querying the database failed. Unfortunately, if it couldn't reconnect
immediately it won't be able to escape input (domain names) any more.
The bug is fixed in the patch (version 5) applicable to stock 2.9.20 and
available at http://linuxnetworks.de/pdnsodbx/index.html. I suggest all
package maintainers and users to upgrade to this new version rather soon.
Thank you for everyones help
OpenPGP public key
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 189 bytes
Desc: not available
More information about the Pdns-users