postgres crash. HELP - Mailing list pgsql-interfaces

From Oscar Serrano
Subject postgres crash. HELP
Date
Msg-id NDBBKNFDELOHICEHIMGGIEFHCDAA.oserra@fondos.net
Whole thread Raw
In response to Re: Slow Recordset  (Joe Shevland <shevlandj@kpi.com.au>)
Responses Re: postgres crash. HELP  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@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.



pgsql-interfaces by date:

Previous
From: "Alexey V. Meledin"
Date:
Subject: How to abstract fully from database with JDBC?
Next
From: Tom Lane
Date:
Subject: Re: postgres crash. HELP