Re: [ADMIN] Vacuum analyze problem - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [ADMIN] Vacuum analyze problem
Date
Msg-id 1335.983503502@sss.pgh.pa.us
Whole thread Raw
List pgsql-bugs
John Hatfield <jhatfield@g-s.com.au> writes:
> (gdb) where
> #0  strcoll () at strcoll.c:248
> #1  0x8115b1f in lztext_cmp ()
> #2  0x8115b72 in lztext_eq ()
> #3  0x8098809 in vacuum ()

Hm.  I suspect this is the same problem that a couple of other people
reported recently: crashes inside strcoll(), even though the strings
being passed to it are perfectly OK.

[ digs in archives... ] Dave Cramer reported a similar crash on
2001-01-24, and Jukka Honkela reported one on 2001-01-01.  Dave was
also using 7.0.3, and Jukka current-as-of-then development sources.
Oh, this is interesting: all three of you are running RedHat 7.0!

I had originally assumed that Postgres was somehow clobbering strcoll's
internal locale information structures, but given that the problem is
only being reported on RH 7.0, a bug in strcoll itself is starting to
look like a plausible idea too.

Would one or another of you crank up ye olde debugger and try to figure
this out?  If it is Postgres' fault, I want to fix it ... but it's hard
to do much when I can't reproduce the problem ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: Nat Howard
Date:
Subject: Re: jdbc1 compile problem still present in beta5 (java 1.1.8/freebsd 4.2-STABLE)
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Timestamp field error value