postgres crash. HELP
От | Oscar Serrano |
---|---|
Тема | postgres crash. HELP |
Дата | |
Msg-id | NDBBKNFDELOHICEHIMGGIEFHCDAA.oserra@fondos.net обсуждение исходный текст |
Ответ на | Re: Slow Recordset (Joe Shevland <shevlandj@kpi.com.au>) |
Ответы |
Re: postgres crash. HELP
|
Список | 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 по дате отправления: