Re: backend closing connections while executing...

hi guys
on looking at the postgres log i could find this information too

DEBUG: Data Base System is in production state at Wed Jan 24 20:20:26 2001
Server process (pid 22751) exited with status 139 at Wed Jan 24 20:23:33 2001
Terminating any active server processes...
Server processes were terminated at Wed Jan 24 20:23:33 2001
Reinitializing shared memory and semaphores
DEBUG: Data Base System is starting up at Wed Jan 24 20:23:33 2001
DEBUG: Data Base System was interrupted being in production at Wed Jan 24 20:20:26 2001
DEBUG: Data Base System is in production state at Wed Jan 24 20:23:33 2001
The Data Base System is starting up

What is status 139 and how can i avoid it..

Thanks for any help
Anand

On Thu, Jan 25, 2001 at 01:06:01AM +0530, Anand Raman wrote:
>hi guys
>
>While executing a simple query my the psql session reports that the
>session has closed abnormally..
>
>Can any one point out why .. The sample sql query is as follows..
>
>arttoday=# select
>arttoday-# art1.name,
>arttoday-# CASE WHEN exh.title IS NULL THEN 'Untitled' ELSE exh.title END,
>arttoday-# ltrim(to_char(exh_dist.length,'9999D99')) ||
>arttoday-# CASE WHEN exh_dist.breadth IS NOT NULL
>arttoday-# THEN ' x '||ltrim(to_char(exh_dist.breadth,'9999D00'))||' cms.'
>arttoday-# ELSE ' cms '||exh_dist.dimensional_aspect END
>arttoday-# from
>arttoday-# exhibit_distributions exh_dist,
>arttoday-# exhibits exh,
>arttoday-# artists art1
>arttoday-# where
>arttoday-# exh_dist.gallery_id = 21
>arttoday-# and exh_dist.exhibit_id = exh.exhibit_id
>arttoday-# and exh.artist_id2 IS NULL
>arttoday-# and exh.artist_id1 = art1.artist_id;
>pqReadData() -- backend closed the channel unexpectedly.
>This probably means the backend terminated abnormally
>before or while processing the request.
>The connection to the server was lost. Attempting reset:
>Succeeded.
>
>I am running postgresql 702 on Redhat..
>
>I use the following command line parameters to start the db
>pg_ctl -o '-i -B 100 -N 50 -o "-C -F -S4096"' start 1>postmaster.log 2>&1
>
>The tables are fairly small with 600 odd rows ..
>
>Also when i do a query as simple as
>arttoday=# select ltrim(to_char(exh_dist.length,'9999D99')) from exhibit_distributions exh_dist
>the backend closes abnormally..
>
>Can any help me out of this ..
>
>Thanks
>Anand