| Lists: | pgsql-bugs |
|---|
| 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:47:53 |
| Message-ID: | 00d501c5777c$6dc934c0$520aa8c0@pduggineni |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Prasad Duggineni" <pduggineni(at)prominencenet(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #1726: Whenever i reboot my tables indexes is getting corrupted. |
| Date: | 2005-06-23 00:40:30 |
| Message-ID: | 27903.1119487230@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
"Prasad Duggineni" <pduggineni(at)prominencenet(dot)com> writes:
> It is throwing=20
> the following ERROR "error index "clusters_pkey" is not a btree"
> I have to reindex the tables every time whenever i reboot.
Could we have a look at the contents of the first page of the index
file when this is happening? Plain old "od -x" will do for making
the dump. See contrib/oid2name if you need help figuring out which
file is the troublesome index.
regards, tom lane