Port Bug Report: Backend crashes during CLUSTER on large table - Mailing list pgsql-ports

From Unprivileged user
Subject Port Bug Report: Backend crashes during CLUSTER on large table
Date
Msg-id 199902110153.UAA22555@hub.org
Whole thread Raw
List pgsql-ports
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name        : Doug Mitchell
Your email address    : doug@mitchcraft.com

Category        : runtime: back-end
Severity        : serious

Summary: Backend crashes during CLUSTER on large table

System Configuration
--------------------
  Operating System   : Linux 2.0.36 / RedHat 5.2

  PostgreSQL version : 6.4.2 on i686-pc-linux-gnu

  Compiler used      : gcc 2.7.2

Hardware:
---------
PII / 512MB Ram
Linux sunfish 2.0.36 #1 Tue Oct 13 22:17:11 EDT 1998 i686 unknown


Versions of other tools:
------------------------
> rpm -q make flex
make-3.76.1-5
flex-2.5.4a-4

--------------------------------------------------------------------------

Problem Description:
--------------------
The backend dumps core a few seconds after starting the
CLUSTER operation.

--------------------------------------------------------------------------

Test Case:
----------
It seems to only happen if the table has not been vacuumed
in a while.  A freshly vacuumed table usually works.

--------------------------------------------------------------------------

Solution:
---------


--------------------------------------------------------------------------


pgsql-ports by date:

Previous
From: John Gotts
Date:
Subject: LOAD Regression Failures with BSDI 3.1
Next
From: Unprivileged user
Date:
Subject: Port Bug Report: Memory fault core dump when invoking initdb