dbTalk Databases Forums  

Re: [BUGS] Error: could not find a feasible split point for "obs_v_file_id_index"

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss Re: [BUGS] Error: could not find a feasible split point for "obs_v_file_id_index" in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] Error: could not find a feasible split point for "obs_v_file_id_index" - 08-30-2004 , 10:32 AM






Robert Creager <Robert_Creager (AT) LogicalChaos (DOT) org> writes:
Quote:
While doing some daily processing, I ran across the following error:

ERROR: could not find a feasible split point for "obs_v_file_id_index"

file_id | integer | not null
Inexes: "obs_v_file_id_index" btree (file_id)
On an index on an *integer* column?? That's a can't-happen error in the
first place, and it's particularly silly when the index entries are
small and fixed-width. I surmise that you have a corrupted index, but
it would be interesting to examine the entrails. Is it repeatable?
Is the database small enough that you could ship me a tarball copy
(or if not, would you be willing to let me into your system to look at
it)?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.