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
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 |
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 |