[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