Create index problem ( _bt_sort )

From: Loïc TREGOUËT <loic(at)cri74(dot)org>
To: Loïc TREGOUËT <loic(at)cri74(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Create index problem ( _bt_sort )
Date: 2001-01-29 16:20:50
Message-ID: 3A759862.11DDFE9C@cri74.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-bugs

Hello,

When i try to create a index (btree on text field) after a restore i've
the
following error :
FATAL 1: btree: failed to add item to the page in _bt_sort (2)

But , if i had some rows on this table , the index creation works fine !

The table contains 1 million rows.
I've tried a lot of time , on postgresql 7.0.2 and 6.5.3

Any idea , thanks

raslog=# select count(username) from log2000 ;
count
--------
965047
(1 row)

raslog=# create index user2000 on log2000(username);
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.
raslog=# insert into log2000 select * from log2001 ;
INSERT 0 111729
raslog=# create index user2000 on log2000(username);
CREATE
raslog=#

--
Loïc TREGOUËT

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-01-29 16:47:58 Re: Create index problem ( _bt_sort )
Previous Message Tom Lane 2001-01-29 15:26:33 Re: Database ... has disappeared from pg_database

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-01-29 16:47:58 Re: Create index problem ( _bt_sort )
Previous Message bs 2001-01-29 09:58:03 Re: large objects overwriting bug