Re: Automatic recovery process

Hello Martijn,

Wednesday, December 28, 2005, 1:17:54 PM, you wrote:
MvO> > My question is about the last line. Does those connections slow down
MvO> > database startup process? Now it looks like that they do, because
MvO> > when I shutdown backend then database starts immediatel, but I'm not
MvO> > sure, so I would like to hear clear answer :-)
MvO> The problem is that after an unclean shutdown the database server has
MvO> to go through the transaction logs to recover the database. This can
MvO> take time and during that time new connections are rejected. I don't
MvO> think attempting to connect slows anything down materially.

So why after closing all connections database system starts up
immediately? This problem also occurs when backend starts up before
database system and there are connections pending. Always the best
solution is to restart backend. I use Excalibur Datasource component
on the backend for connection pooling.

MvO> I think you're missing the point though. The backend should not be
MvO> crashing. Unfortunatly you didn't show the actual log of when the
MvO> backend crashed so we can only speculate.
MvO> Look for something like
MvO> "exited with error code" or "signal".

LOG: server process (PID 22946) was terminated by signal 11
LOG: terminating any other active server processes

MvO> Do you have any C backend
MvO> "functions you defined yourself?
No, I don't have. I use only JDBC and pgAdmin to connect to database.

Thanks for answer.

--
Best regards,
Grzegorz mailto:goliatus(at)polzone(dot)pl