Re: a strange error

From: Marc Schablewski <ms(at)clickware(dot)de>
To: Iv Ray <pobox(at)verysmall(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: a strange error
Date: 2009-05-27 12:48:09
Message-ID: 4A1D3689.3090008@clickware.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I guess this has nothing to do with postgres. Your web applicationdoes
some kind of connection pooling and doesn't notice when you shut down
the database. When you access the application after you reinitialized
the database it will use these old and now invald connections and run
into the given error. After some requests, your webserver will spawn new
child processes while others die and those new processes connect to the
new database. To solve this, you should restart your application as well.

Marc

Iv Ray wrote:
> We are using PostgreSQL for more than 5 years by now and at least the
> last 2-3 years we experience the following situation.
>
> We refresh the live database on the development server using the
> following shell script -
>
> /usr/local/etc/rc.d/postgresql stop
> rm -r /home/data/postgresql/data
> /usr/local/etc/rc.d/postgresql initdb -D /home/data/postgresql/data
> /usr/local/etc/rc.d/postgresql start
> psql -f /home/database.sql -d template1 -U pgsql
>
> (FreeBSD 6.x, PostgreSQL 8.3)
>
> Everything works perfect, except the following -
>
> When the db is refreshed, the first click inside the web application
> that uses it (php 5.x, Apache 2.x), and some of the next clicks (i. e.
> the 3rd, 5th, 8th, 12th) result in the following error -
> PGSQL ERROR: server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> After two dozen of clicks and several such messages, the application
> operates normally until the next refresh.
>
> Could somebody give us a tip what might be the reason?
>
> Iv
>

--
click:ware Informationstechnik GmbH
i. A. Marc Schablewski

Hausanschrift:
Kamekestraße 19
50672 Köln

Postanschrift:
Postfach 10 04 22
50444 Köln

Tel: (+49) 0221 139988-0
Fax: (+49) 0221 139988-79

Geschäftsführer: Dipl.-Ing. Thomas Goerner
Handelsregisternr: HRB 31438 ( Amtsgericht Köln )

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2009-05-27 12:57:37 Re: a strange error
Previous Message Iv Ray 2009-05-27 12:24:44 a strange error