Skip site navigation (1) Skip section navigation (2)

BUG #1726: Whenever i reboot my tables indexes is getting corrupted.

From: "Prasad Duggineni" <pduggineni(at)prominencenet(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1726: Whenever i reboot my tables indexes is getting corrupted.
Date: 2005-06-22 22:32:58
Message-ID: 20050622223258.EB311F0B0C@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1726
Logged by:          Prasad Duggineni
Email address:      pduggineni(at)prominencenet(dot)com
PostgreSQL version: 8.03
Operating system:   Redhat Linux 9.0
Description:        Whenever i reboot my tables indexes is getting
corrupted.
Details: 

It is throwing 
the following ERROR "error index "clusters_pkey" is not a btree"
I have to reindex the tables every time whenever i reboot.



Jun 22 10:52:56 lab5md9181 postgres[947]: [45-1] 2005-06-22 10:52:56 EDT 
LOG:  s
tatement: select gethost()
Jun 22 10:52:56 lab5md9181 postgres[947]: [46-1] 2005-06-22 10:52:56 EDT 
LOG:  s
tatement: select getphysicalip()
Jun 22 10:52:56 lab5md9181 postgres[947]: [47-1] 2005-06-22 10:52:56 EDT 
LOG:  s
tatement: insert into Clusters (clusterID, clusterName, clusterType, 
clusterStat
e,
Jun 22 10:52:56 lab5md9181 postgres[947]: [47-2]  replicationState, 
workingMode,
 maxClusterBw, gkType) values('lab5md9181', 'lab5md9181', 1, 0, 0, 1, 0, 0)
Jun 22 10:52:56 lab5md9181 postgres[947]: [48-1] 2005-06-22 10:52:56 EDT 
ERROR:
 index "clusters_pkey" is not a btree
Jun 22 10:52:56 lab5md9181 postgres[953]: [2-1] 2005-06-22 10:52:56 EDT LOG:

st
atement:
Jun 22 10:52:56 lab5md9181 postgres[953]: [3-1] 2005-06-22 10:52:56 EDT LOG:

st
atement: set DateStyle to 'ISO'
Jun 22 10:52:56 lab5md9181 postgres[953]: [4-1] 2005-06-22 10:52:56 EDT LOG:

st
atement:
Jun 22 10:52:56 lab5md9181 postgres[953]: [5-1] 2005-06-22 10:52:56 EDT LOG:

st
atement: set geqo to 'OFF'
Jun 22 10:52:56 lab5md9181 postgres[953]: [6-1] 2005-06-22 10:52:56 EDT LOG:

st
atement:
Jun 22 10:52:56 lab5md9181 postgres[953]: [7-1] 2005-06-22 10:52:56 EDT LOG:

st
atement: set ksqo to 'ON'
Jun 22 10:52:56 lab5md9181 postgres[953]: [8-1] 2005-06-22 10:52:56 EDT 
ERROR:
unrecognized configuration parameter "ksqo"
Jun 22 10:52:56 lab5md9181 postgres[953]: [9-1] 2005-06-22 10:52:56 EDT LOG:

st
atement: select oid from pg_type where typname='lo'
Jun 22 10:52:56 lab5md9181 postgres[953]: [10-1] 2005-06-22 10:52:56 EDT 
LOG:  s
tatement: select version()
Jun 22 10:52:56 lab5md9181 postgres[953]: [11-1] 2005-06-22 10:52:56 EDT 
LOG:  s
tatement: insert into Clusters (clusterID, clusterName, clusterType, 
clusterStat
e,
Jun 22 10:52:56 lab5md9181 postgres[953]: [11-2]  replicationState, 
workingMode,
 maxClusterBw, gkType) values('lab5md9181', 'lab5md9181', 1, 0, 0, 1, 0, 0)
Jun 22 10:52:56 lab5md9181 postgres[953]: [12-1] 2005-06-22 10:52:56 EDT 
ERROR:
 index "clusters_pkey" is not a btree

pgsql-bugs by date

Next:From: Prasad DuggineniDate: 2005-06-22 22:47:53
Subject: BUG #1726: Whenever i reboot my tables indexes is getting corrupted.
Previous:From: Charlie MonktonDate: 2005-06-22 14:01:15
Subject: BUG #1725: psql --command and PQexec do not work and fail silently

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group