pg_dump crash
От | Marek Pętlicki |
---|---|
Тема | pg_dump crash |
Дата | |
Msg-id | 20010206224631.B1229@marek.almaran.home обсуждение исходный текст |
Ответы |
Re: pg_dump crash
|
Список | pgsql-general |
Hi, I have just received this crash on pg_dump: PQgetvalue: ERROR! tuple number 0 is out of range 0..-1 Segmentation fault it is 7.0.2 and about 130MB database which worked for me for more than a year (it works as my 'local devel version' of a production system). What can be the cause of this? I have been messing arround with indexes just before the error. I wanted to drop some unused indexes and improve some of my selects with multicolumn ones. I tend to do drop indexes/vacuum analyze/restore indexes every day. When I started my 'drop index/vacuum/reindex' script: BANG! I do: pg_dump -c -s database > schema.sql grep -i "drop\ *index" schema.sql > ix_drop.sql grep -i "create\ *unique\ *index" schema.sql > ix_recreate.sql grep -i "create\ *index" schema.sql >> ix_recreate.sql psql database < ix_drop.sql vacuumdb -v -z database psql database < ix_recreate.sql in bash script. Despites its primitiveness it worked for a few months flawlessly (I run it from cron on my production system nightly). With the vacuum it crashed on a primary index of one of the tables (the biggest one), but dropping/recreating the index fixed the problem. Unfortunately it didn't serve the purpose for the pg_dump... pg_dump refuses working with any parameters (dumping data/schema, selected tables, anything :-( thanks in advance for any hint. -- Marek Pętlicki <marpet@buy.pl>
В списке pgsql-general по дате отправления: