Re: VACUUM ANALYZE

oops, mistake yes i am using older version.

glibc-2.1.94-3
glibc-devel-2.1.94-3

ill upgrade then ill compile with enable-debug

----- Original Message ----- 
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Ben-Nes Michael" <miki@canaan.co.il>
Cc: <pgsql-general@postgresql.org>
Sent: Friday, July 20, 2001 8:01 PM
Subject: Re: [GENERAL] VACUUM ANALYZE 


> "Ben-Nes Michael" <miki@canaan.co.il> writes:
> > (gdb) bt
> > #0  0x4014d8e0 in ?? ()
> > #1  0x8123a52 in ?? ()
> > #2  0x8123a9f in ?? ()
> > #3  0x8123caa in ?? ()
> > [ etc ]
> 
> Sigh, that's no help at all :-(.  Looks like you are using a postgres
> executable that's been stripped of all symbolic information.  Don't
> suppose you want to compile from source to make a more debuggable copy?
> 
> Actually, maybe it's not quite no help at all.  I'm going to guess from
> the numeric values that the core dump is occurring in a system library
> (since the top address is so far different from the rest).  Since this
> is a vacuum analyze, and since it's on a redhat machine, I'm going to
> leap to a conclusion: maybe you are running into the known strcoll()
> bug.  Are you running glibc earlier than 2.2.3?  If so, an update to
> 2.2.3 may fix it.  See the thread at
> 
> http://fts.postgresql.org/db/mw/msg.html?mid=1021209
> 
> regards, tom lane
> 
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--------------------------