postgres crash. HELP

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.

In response to

Responses

Browse pgsql-interfaces by date

  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