Re: VACUUM ANALYZE - Mailing list pgsql-general

From Ben-Nes Michael
Subject Re: VACUUM ANALYZE
Date
Msg-id 010c01c11021$9d69b400$aa5796d4@canaan.co.il
Whole thread Raw
In response to Re: VACUUM ANALYZE  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: VACUUM ANALYZE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi

Im never used gdb so I hope I extracted all the Info needed, any why here it
is:

GNU gdb 5.0
Copyright 2000 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "i386-redhat-linux".
Core was generated by `postgres: admin canada-centre.co.il_album [local]
VACUUM    '.
Program terminated with signal 11, Segmentation fault.
#0  0x4014d8e0 in ?? ()


----- Original Message -----
From: "Stephan Szabo" <sszabo@megazone23.bigpanda.com>
To: "Ben-Nes Michael" <miki@canaan.co.il>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, July 18, 2001 9:17 PM
Subject: Re: [GENERAL] VACUUM ANALYZE


>
> It looks like the backend (I'd assume this one) crashed
> with a segmentation fault.
> This should leave a core file (I believe in your db data
> directory).  Can you use a debugger to get a back trace
> from the core file?
>
> On Wed, 18 Jul 2001, Ben-Nes Michael wrote:
>
> > Hi
> >
> > I use 7.1.2 compiled with locale set to the he_IL
> >
> > Last day I re initdb the whole data dir and dumped the data back to the
> > server.
> > Then I tried VACUM ANALYZE which worked :)
> > but next day it stopped working returning the next lines in the log
(link)
> >
> > http://www.canaan.co.il/users/miki/pg_errors.txt



pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: simple linking question
Next
From: Ben-Nes Michael
Date:
Subject: two constrains for one column