Forum OpenACS Q&A: Openacs DB connection issue
I have a OACS 5.1.0 running with Postgres as my DB. Whenever we encounter DB problems like connection and DB restart OACS doesnt recover from that.
Can anyone suggest something or is there a way in OACS to re-connect just incase such problem occurs..
In principle it would probably be feasible to enhance the AOLserver database handling code to recover from a restarted RDBMS, but in practice the need for that is rare, and simply restarting AOLserver is an easy and fairly non-intrusive way to handle it.
Rocael is right, if you are frequently encountering problems that force you to restart your RDBMS, something is very wrong; you need to figure out what and fix it.
It's supposed to work, although I've had some issues with it. It's worth looking at.
If you run more than one server on your machine, schedule the keepalive scripts for each server to a different minute. Otherwise, if you restart your database, all servers want to start at the same time, which will take longer for each so your keepalive schedule (I call every 4 minutes) might be to tight for the server to come up properly.