[Pdns-users] pgsql db lookup failures

[Charles Sprickman]

On Thu, 30 Jun 2011, Steven Crandell wrote:

> Charles,
>
> What method are you using to stop/start postgres while pdns is running?

In this case, I was doing a full start/stop, not a reload (which I think 
is just a HUP).

Thanks,

Charles

> -s
>
> On Thu, Jun 30, 2011 at 5:08 PM, Charles Sprickman <spork at bway.net> wrote:
>
>> Hello,
>>
>> I'm in the middle of testing a new powerdns/postgres setup in native mode
>> with postgres replication.  I've not run into any major issues so far, but
>> I'm seeing some odd behavior on the last server I setup.
>>
>> I started powerdns, and after that had stopped and started postgres a few
>> times to make some config changes.  It seems like powerdns is not dealing
>> with the disappearing postgres process, almost as if the backend connection
>> has not attempted a reconnect:
>>
>> Jun 30 19:46:07 ns3 pdns[1569]: Database module reported condition which
>> prevented lookup (PostgreSQL failed to execute command: FATAL: terminating
>> connection due to administrator command server closed the connection
>> unexpectedly   This probably means the server terminated abnormally
>>  before or while processing the request. ) sending out servfail
>>
>> I got a few of those (accompanied with a servfail response), and then this
>> log line repeats:
>>
>> Jun 30 19:46:07 ns3 pdns[1569]: Database module reported condition which
>> prevented lookup (PostgreSQL failed to execute command: unknown reason)
>> sending out servfail
>>
>> If I repeat the dns query, I get an answer about 2 out of 5 tries, perhaps
>> because one backend connection is properly connected and the others are not.
>>
>> After a restart of powerdns, the issue goes away.
>>
>> This is 3.0.20110509 of powerdns with PostgreSQL 9.0.4.
>>
>> I also am still seeing the issue of the "loglevel=" config not seeming to
>> have an effect on the logging verbosity (currently set to 8, but the logs
>> seem pretty minimal).
>>
>> Thanks,
>>
>> Charles
>> ______________________________**_________________
>> Pdns-users mailing list
>> Pdns-users at mailman.powerdns.**com <Pdns-users at mailman.powerdns.com>
>> http://mailman.powerdns.com/**mailman/listinfo/pdns-users<http://mailman.powerdns.com/mailman/listinfo/pdns-users>
>>
>