Re: postgres dies while doing vacuum analyze

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx> writes:
> > [ vacuum analyze dies ]
> > It is running on Redhat Linux 7.1 i686 with 2.4.2-2 kernel.
> > Here is the back trace from gdb
>
> > (gdb) bt
> > #0 strcoll () at strcoll.c:229
>
> We've heard reports before of strcoll() crashing on apparently valid
> input. It seems to be a Red Hat-specific problem; the three reports
> I have in my notes are from people running RH 7.0 (check the archives
> from 1/1/01, 1/24/01, 3/1/01 if you want to see the prior reports).
>
> It's possible that Postgres is doing something that confuses RH's
> locale library, but I dunno what. Since no other platform is reporting
> it, it could also be a plain old bug in that locale library.

After a look into strcoll I found the bug. Attached is a tarball
including a patch for strcoll, glibc.spec and an small program that
shows the bug. Hopefully Trond can address this to the glibc and rpm
experts.

best regards,
Manuel.

>
> We need some RH-er to burrow in with a debugger and figure out what's
> going wrong. The previous reporters don't seem to have done anything;
> are you the man to fix it?
>
> regards, tom lane