pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Error message: "my bits moved right off the end of the world!"
2+ messages / 2 participants
[nested] [flat]

* Error message: "my bits moved right off the end of the world!"
@ 2000-12-07 02:51 Romanenko Mikhail <mikhail@angg.ru>
  2000-12-12 17:55 ` Re: Error message: "my bits moved right off the end of the world!" Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Romanenko Mikhail @ 2000-12-07 02:51 UTC (permalink / raw)
  To: pgsql-interfaces

I'm developing application with Borland C++ Builder as a client and PostgreSQL as a server. Sometime (Almost every other time) the application failed to get loaded and I get an error message in psqlodbc_xxxxxxxxxxxx.log file:

[...]
conn=58919036, query='CREATE TABLE course_dl_tmp10183 (brig_id int2, well varchar(10), pad varchar(7), date_dl date, course_id int2, what varchar(4), course_what varchar(60), course_value time, PRIMARY KEY (course_id));'

NOTICE from backend during send_query: 'NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'course_dl_tmp10183_pkey' for table 'course_dl_tmp10183''

ERROR from backend during send_query: 'FATAL 1:  my bits moved right off the end of the world! Recreate index pg_attribute_relid_attnum_index.'
conn=58919036, query='COMMIT'


Could anybody tell me what does this error message "my bits moved right off the end of the world!" mean. 

Client software:
MS Windows 98
Borland C++ Builder 5.01
BDE 5.1.1
ODBC 3.510.3711.0
PsqlODBC 6.50.0000

Server software
Linux (Dedian woody, kernel 2.2.17, libc6 2.2)
PostgreSQL 7.0.3

Thank you, Mikhail.





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Error message: "my bits moved right off the end of the world!"
  2000-12-07 02:51 Error message: "my bits moved right off the end of the world!" Romanenko Mikhail <mikhail@angg.ru>
@ 2000-12-12 17:55 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2000-12-12 17:55 UTC (permalink / raw)
  To: Romanenko Mikhail <mikhail@angg.ru>; +Cc: pgsql-interfaces

"Romanenko Mikhail" <mikhail@angg.ru> writes:
> Could anybody tell me what does this error message "my bits moved
> right off the end of the world!" mean.

It's an internal error in the btree index routines.

I would *love* to see an example that reproduces this error from a
standing start (ie, newly created database).  I suspect there's a
corner-case bug somewhere in btree, but it's never been possible
to find it without a test case...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-12-12 17:55 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-12-07 02:51 Error message: "my bits moved right off the end of the world!" Romanenko Mikhail <mikhail@angg.ru>
2000-12-12 17:55 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox