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

hi guys
I am attaching the back trace file of the core dump generated. Could any
one have a lok at it and tell whats worng..
Thanx
Anand
On Wed, Jan 24, 2001 at 01:09:44PM -0800, Stephan Szabo wrote:
>
>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
>> >>
>>