From: | "Oscar Serrano" <oserra(at)fondos(dot)net> |
---|---|
To: | <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | postgres crash. HELP |
Date: | 2000-05-06 06:54:50 |
Message-ID: | NDBBKNFDELOHICEHIMGGIEFHCDAA.oserra@fondos.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Hi:
I don't know how, but Postgres has made a very odd thing.
Suddenly in the directory where I have all the tables, now there is about
1000 files with names like this:
pg_class_oid_index.165 pg_class_oid_index.2835
pg_class_oid_index.1650 pg_class_oid_index.2836
pg_class_oid_index.1651 pg_class_oid_index.2837
pg_class_oid_index.1652 pg_class_oid_index.2838
pg_class_oid_index.1653 pg_class_oid_index.2839
pg_class_oid_index.1654 pg_class_oid_index.284
pg_class_oid_index.1655 pg_class_oid_index.2840
pg_class_oid_index.1656 pg_class_oid_index.2841
pg_class_oid_index.1657 pg_class_oid_index.2842
pg_class_oid_index.1658 pg_class_oid_index.2843
pg_class_oid_index.1659 pg_class_oid_index.2844
pg_class_oid_index.166 pg_class_oid_index.2845
pg_class_oid_index.1660 pg_class_oid_index.2846
pg_class_oid_index.1661 pg_class_oid_index.2847
pg_class_oid_index.1662 pg_class_oid_index.2848
pg_class_oid_index.1663 pg_class_oid_index.2849
And one of my biggest tables, is now like this:
+----------------------------------+----------------------------------+-----
--+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-----
--+
| fecha | datetime |
8 |
| fecha | datetime |
8 |
| cc | int4 |
4 |
| cc | int4 |
4 |
| isin | varchar() |
12 |
| isin | varchar() |
12 |
| valor | float8 |
8 |
| valor | float8 |
8 |
| patrimonio | float8 |
8 |
| patrimonio | float8 |
8 |
| participes | int4 |
4 |
| participes | int4 |
4 |
| pre_max | float8 |
8 |
| pre_max | float8 |
8 |
+----------------------------------+----------------------------------+-----
--+
Index: if_bbsacu
I mean, all the fiels has been duplicated :-???
And the index, the same:
Table = if_bbsacu
+----------------------------------+----------------------------------+-----
--+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-----
--+
| cc | int4 |
4 |
| cc | int4 |
4 |
+----------------------------------+----------------------------------+-----
--+
And now, when I restart postgres, I get this message:
Stopping postgresql service: [ OK ]
Starting postgresql service: FindExec: found "/home/pgsql/bin/postgres"
using argv[0]
binding ShmemCreate(key=56a3b1, size=3896320)
postmaster [16106]
And each time I access for whatever to the table with the duplicate fields,
postgres crashes and I have to restart it.
And when trying to vacuum the table....
[f(at)svr1 pgsql]$ vacuumdb --analyze --verbose -t tf_bbsacu aii
NOTICE: --Relation tf_bbsacu--
NOTICE: Pages 0: Changed 0, Reapped 0, Empty 0, New 0; Tup 0: Vac 0,
Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail.
Space 0/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0 sec.
ERROR: cannot find attribute 2 of relation if_bbsacu
vacuumdb: database vacuum failed on aii.
Does anybody know how to fix it?
Thank you very much.
From | Date | Subject | |
---|---|---|---|
Next Message | Alexey V. Meledin | 2000-05-06 18:57:53 | How to abstract fully from database with JDBC? |
Previous Message | Joe Shevland | 2000-05-05 16:04:40 | Re: Slow Recordset |