From: Oscar Serrano <oserra@fondos.net>
To: pgsql-interfaces@postgresql.org
Subject: postgres crash. HELP
Date: Sat, 6 May 2000 08:54:50 +0200
Message-ID: <NDBBKNFDELOHICEHIMGGIEFHCDAA.oserra@fondos.net> (raw)
In-Reply-To: <3912F118.8C354300@kpi.com.au>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: oserra@fondos.net
Subject: Re: postgres crash. HELP
In-Reply-To: <NDBBKNFDELOHICEHIMGGIEFHCDAA.oserra@fondos.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox