unexplainable error
I have Apache/php/PostgreSQL on FreeBSD, all latest stable versions.
Every time, after mass import into the database (it's a development
server, so the import updates the database with full dump from the
production server) - the first several clicks on the development web
site return -
PGSQL ERROR: 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.
After hitting few times the refresh button of the browser, all is back
to normal until the next import.
If the FreeBSD is restarted before that, the problem does not exist.
Could anybody advice on the possible reason?
Kind regards,
Iv
On Fri, Nov 16, 2007 at 01:58:21PM +0100, pobox@verysmall.org wrote:
Every time, after mass import into the database (it's a development
server, so the import updates the database with full dump from the
production server) - the first several clicks on the development web
site return -PGSQL ERROR: 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.
My only guess would be something to do with a strange interaction with
connection pooling.
Sam
"pobox@verysmall.org" <pobox@verysmall.org> writes:
I have Apache/php/PostgreSQL on FreeBSD, all latest stable versions.
Every time, after mass import into the database (it's a development
server, so the import updates the database with full dump from the
production server) - the first several clicks on the development web
site return -
PGSQL ERROR: FATAL: terminating connection due to administrator command
This means that something sent the backend a SIGTERM signal. You need
to find out what's doing that.
regards, tom lane