Re: Create index problem ( _bt_sort )

> > raslog=# create index user2000 on log2000(username);
> > FATAL 1:  btree: failed to add item to the page in _bt_sort (2)
> >>
> >> How long are the usernames?  IIRC, 7.0.* has some edge cases that might
> >> fail when items approach the maximum allowed size of 1/3 page (~ 2700
> >> bytes).
>
> > The maximum length , is about 40 character (but not 2700 bytes).
>
> Hmm, then it's not what I thought.  Would you be willing to send me
> a pg_dump of that table?  (Don't send it to the whole list!)

I've got similar error.
=====
CREATE  INDEX "abcid_idx" on "abc" using btree ( "abcid" );
FATAL 1:  btree: failed to add item to the page in _bt_sort (2)
pqReadData() -- backend closed the channel unexpectedly.
 This probably means the backend terminated abnormally
 before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
=====
I couldn't reproduece this error with the same procedure.

(First of all, I did this for testing performance, so the indexed col has
the same text data and 500,000 rows. After Drop/Create table the same
table with the same data, PostgreSQL stops complainning.
My PostgreSQL has 32KB page size, and enabled multi-byte char code support.)

My locale is
======
LANG=ja_JP.eucJP
LC_CTYPE="ja_JP.eucJP"
LC_NUMERIC="ja_JP.eucJP"
LC_TIME="ja_JP.eucJP"
LC_COLLATE="ja_JP.eucJP"
LC_MONETARY="ja_JP.eucJP"
LC_MESSAGES="ja_JP.eucJP"
LC_PAPER="ja_JP.eucJP"
LC_NAME="ja_JP.eucJP"
LC_ADDRESS="ja_JP.eucJP"
LC_TELEPHONE="ja_JP.eucJP"
LC_MEASUREMENT="ja_JP.eucJP"
LC_IDENTIFICATION="ja_JP.eucJP"
LC_ALL=
=====

I guess there are something wrong in _bt_sort(2) or locale?

--
Yasuo Ohgaki