From: | Marek Pętlicki <marpet(at)buy(dot)pl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump crash |
Date: | 2001-02-06 21:46:31 |
Message-ID: | 20010206224631.B1229@marek.almaran.home |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)buy(dot)pl>
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Pilosov | 2001-02-06 21:51:07 | Re: new type proposal |
Previous Message | Bruce Momjian | 2001-02-06 21:36:09 | Re: new type proposal |