Re: Re: backend closing connections while executing...

I believe:

gdb <path to postgres executable> <path to core file>

When you get to the gdb's prompt,
bt will give the backtrace.

On Thu, 25 Jan 2001, Anand Raman wrote:

> hi ..
>
> yes i located the core file and the timestamp indicates that it has been
> generated around the time i was trying out the query.
>
> Can u please tell me how to generate the backtrace.
>
> Sorry not from a c background..
>
> Anand
> On Wed, Jan 24, 2001 at 12:22:21PM -0800, Stephan Szabo wrote:
> >
> >It should mean that the backend exited with a SIGSEGV, probably a bug.
> >There should be a core file in your database directory. Can you get
> >a backtrace from it?
> >
> >On Thu, 25 Jan 2001, Anand Raman wrote:
> >
> >> 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
> >>
>