Forum OpenACS Development: postgres related stuff

Collapse
Posted by Mark Aufflick on
Hi All,

I am fighting a postgres issue where my server dies every so often from an untrapped signal 14 (SIGALRM). It is very strange and I am tackling that on the postgres list (although if anyone has any ideas - maybe related to scheduled procs - that would be great).

On a postgres driver related issue (which is kindof an aolserver issue, except that our driver is different - or is it the official driver now? I can't quite tell), my aolserver restarted it's postgres connection a little too quickly, and got:

Error: Ns_PgOpenDb(postgres):  Could not connect to localhost::pump:  FATAL 1:  The database system is in recovery mode

and:

Error: Ns_PgOpenDb(postgres):  Could not connect to localhost::pump:  FATAL 1:  The database system is starting up

and so set the startup page to:

OpenACS could not allocate a handle from database pool etc.

We should test for this somewhere and keep retrying until the db backend is ready...