============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Doug Mitchell
Your email address : doug@mitchcraft.com
Category : runtime: back-end
Severity : serious
Summary: Cluster crashes
System Configuration
--------------------
Operating System : Linux 2.0.36 / RedHat 5.2
PostgreSQL version : 6.4.2
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:
--------------------
Program received signal SIGSEGV, Segmentation fault.
heap_insert (relation=0x81b2ba0, tup=0x0) at heapam.c:1110
1110 if (!OidIsValid(tup->t_oid))
(gdb) bt
#0 heap_insert (relation=0x81b2ba0, tup=0x0) at heapam.c:1110
#1 0x8085b72 in rebuildheap (OIDNewHeap=143620745, OIDOldHeap=138955433,
OIDOldIndex=138955449) at cluster.c:358
#2 0x80858ff in cluster (oldrelname=0x81ac0e0 "docs",
oldindexname=0x81ac0c0 "docs_hash") at cluster.c:161
#3 0x80d635b in ProcessUtility (parsetree=0x81ac100, dest=Remote)
at utility.c:637
#4 0x80d3b0b in pg_exec_query_dest (
query_string=0xbfffd314 "cluster docs_hash on docs;", dest=Remote,
aclOverride=0) at postgres.c:758
#5 0x80d3a43 in pg_exec_query (
query_string=0xbfffd314 "cluster docs_hash on docs;") at postgres.c:699
#6 0x80d4a60 in PostgresMain (argc=10, argv=0xbffff38c, real_argc=8,
real_argv=0xbffffd34) at postgres.c:1645
#7 0x80c06aa in DoBackend (port=0x8172210) at postmaster.c:1532
#8 0x80c0202 in BackendStartup (port=0x8172210) at postmaster.c:1303
#9 0x80bf96d in ServerLoop () at postmaster.c:757
#10 0x80bf54c in PostmasterMain (argc=8, argv=0xbffffd34) at postmaster.c:563
#11 0x8099b40 in main (argc=8, argv=0xbffffd34) at main.c:93
(gdb)
--------------------------------------------------------------------------
Test Case:
----------
Cluster a table which has not been recently vacuumed.
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------