From: | Anand Raman <araman(at)india-today(dot)com> |
---|---|
To: | postgresql <pgsql-general(at)postgresql(dot)org> |
Subject: | backend closing connections while executing... |
Date: | 2001-01-24 19:36:01 |
Message-ID: | 20010125010601.E32124@india-today.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Heiko Irrgang | 2001-01-24 19:39:59 | timestamp usage? |
Previous Message | Stephan Szabo | 2001-01-24 19:34:46 | Re: Performance problem |