[Pdns-dev] OpendbxBackend errors

Arjo Hooimeijer arjoslists at deathstar.xs4all.nl
Fri Feb 16 20:34:55 CET 2007


Norbert,

>> Could you give me some more information? Does it respond to every query in 
>> this way? Does this happen as soon as PowerDNS starts up or at a later stage?

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 /usr/sbin/cron[73213]: (root) CMD
(/root/bin/runbackups)
Feb 16 05:00:00 deathstar pdns[61210]: [OpendbxBackend] execStmt: Unable
to execute query - MySQL server has gone away
Feb 16 05:00:00 deathstar pdns[61210]: [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[61210]: Database module reported
condition which prevented lookup - sending out servfail
Feb 16 05:00:00 deathstar pdns[61210]: [OpendbxBackend] execStmt: Unable
to execute query - MySQL server has gone away
Feb 16 05:00:00 deathstar pdns[61210]: [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[61210]: Database module reported
condition which prevented lookup - sending out servfail
Feb 16 05:00:00 deathstar pdns[61210]: [OpendbxBackend] execStmt: Unable
to execute query - MySQL server has gone away
Feb 16 05:00:00 deathstar pdns[61210]: [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[61210]: Database module reported
condition which prevented lookup - sending out servfail
Feb 16 05:00:00 deathstar pdns[61210]: [OpendbxBackend] escape(string):
Unable to escape string - Invalid parameter
Feb 16 05:00:00 deathstar pdns[61210]: [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.

--
Arjo



More information about the Pdns-dev mailing list