vacuum full failing in 7.3

[Dmitry Tkach]

Hi, everybody!

I am getting a weird failure, trying to vacuum a table in 7.3 - it says
"ERROR: Index pg_toast_89407_ index is not a btree".
Does it ring a bell to anyone? Any ideas what's wrong? Is it my database
screwed up? I just created it today...
I tried dropping and recreating it... and it seems to be working now.
But still, if it all possible, I would appreciate any ideas as to what
it could be that caused this problem in the first place...

Thanks a lot!

Dima

P.S.

For what it's worth, here is the stack to the place in the code where
the badness happens:
#0 elog (lev=20, fmt=0x81b5f9b "Index %s is not a btree") at elog.c:114
#1 0x0807e18a in _bt_getroot (rel=0x60eba740 , access=1) at nbtpage.c:127
#2 0x08080dce in _bt_endpoint (scan=0x82a7830 , dir=ForwardScan Direction)
at nbtsearch.c:932
#3 0x08080ad8 in _bt_first (scan=0x82a7830 , dir=ForwardScan Direction)
at nbtsearch.c:686
#4 0x0807ef3d in btbulkdelete (fcinfo=0xbfffd 240) at nbtree.c:627
#5 0x08163aa3 in OidFunctionCall 3 (functionId=332 , arg1=1626056512 ,
arg2=135047316, arg3=0) at fmgr.c:1275
#6 0x0807b470 in index_bulk_dele te (indexRelation= 0x60eba740,
callback=0x80ca 894 <dummy_tid_reap ed>, callback_state= 0x0) at
indexam.c:579
#7 0x080ca65c in scan_index (indrel=0x60eba 740, num_tuples=0) at
vacuum.c:2612
#8 0x080c7f8b in full_vacuum_rel (onerel=0x60ebd fa0, vacstmt=0x82a07 68)
at vacuum.c:948
#9 0x080c7e24 in vacuum_rel (relid=89410, vacstmt=0x82a07 68,
expected_relkin d=116 't') at vacuum.c:827
#10 0x080c7e65 in vacuum_rel (relid=89407, vacstmt=0x82a07 68,
expected_relkin d=114 'r') at vacuum.c:850
#11 0x080c7765 in vacuum (vacstmt=0x82a0 768) at vacuum.c:290
#12 0x081198da in pg_exec_query_s tring (query_string=0 x82a0538,
dest=Remote,
parse_context=0 x8294e30) at postgres.c:789
#13 0x0811a9f1 in PostgresMain (argc=4, argv=0xbfffd770 ,
username=0x8258 849 "postgres") at postgres.c:2013

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Tom Lane]

Dmitry Tkach <dm****@openrat ings.com> writes:

I am getting a weird failure, trying to vacuum a table in 7.3 - it says
"ERROR: Index pg_toast_89407_ index is not a btree".
That says the first page of the index was corrupted (version number
field didn't contain the right thing).
Does it ring a bell to anyone? Any ideas what's wrong? Is it my database
screwed up? I just created it today...
I tried dropping and recreating it... and it seems to be working now.

Sounds like you just destroyed all the evidence :-(. I'd wonder about
hardware flakiness for one thing ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend