BUG #1726: Whenever i reboot my tables indexes is getting corrupted.
От | Prasad Duggineni |
---|---|
Тема | BUG #1726: Whenever i reboot my tables indexes is getting corrupted. |
Дата | |
Msg-id | 00d501c5777c$6dc934c0$520aa8c0@pduggineni обсуждение исходный текст |
Ответы |
Re: BUG #1726: Whenever i reboot my tables indexes is getting corrupted.
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1726 Logged by: Prasad Duggineni Email address: pduggineni@prominencenet.com PostgreSQL version: 8.03 Operating system: Redhat Linux 9.0 Description: Whenever i reboot my tables indexes is getting corrupted. Details:=20 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. Jun 22 10:52:56 lab5md9181 postgres[947]: [45-1] 2005-06-22 10:52:56 EDT=20 LOG: s tatement: select gethost() Jun 22 10:52:56 lab5md9181 postgres[947]: [46-1] 2005-06-22 10:52:56 EDT=20 LOG: s tatement: select getphysicalip() Jun 22 10:52:56 lab5md9181 postgres[947]: [47-1] 2005-06-22 10:52:56 EDT=20 LOG: s tatement: insert into Clusters (clusterID, clusterName, clusterType,=20 clusterStat e, Jun 22 10:52:56 lab5md9181 postgres[947]: [47-2] replicationState,=20 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=20 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=20 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=3D'lo' Jun 22 10:52:56 lab5md9181 postgres[953]: [10-1] 2005-06-22 10:52:56 EDT=20 LOG: s tatement: select version() Jun 22 10:52:56 lab5md9181 postgres[953]: [11-1] 2005-06-22 10:52:56 EDT=20 LOG: s tatement: insert into Clusters (clusterID, clusterName, clusterType,=20 clusterStat e, Jun 22 10:52:56 lab5md9181 postgres[953]: [11-2] replicationState,=20 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=20 ERROR: index "clusters_pkey" is not a btree
В списке pgsql-bugs по дате отправления: