Обсуждение: 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