Thread: Error creating index (v6.5)
I'm trying to create the third index in a table populated with 23000 rows and I get : sanluis=> CREATE INDEX art_idx2 ON ARTICULOINFO (shFamilia); 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. We have lost the connection to the backend, so further processing is impossible. Terminating. I can add more index on the same table without problem using other columns, but once the error it seems that art_idx2 doesn't exist but I can recreate it, obtaining : sanluis=> CREATE INDEX art_idx2 ON ARTICULOINFO (shFamilia); ERROR: cannot create art_idx2 I've got postgres 6.5 under Linux 2.2.5 What happens? Thanks in advance. Roberto What happens?
> I'm trying to create the third index in a table populated with 23000 rows > and I get : > > sanluis=> CREATE INDEX art_idx2 ON ARTICULOINFO (shFamilia); > 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. > We have lost the connection to the backend, so further > processing is impossible. Terminating. You're probably out of space in your .../pgsql/data/base directory. > I can add more index on the same table without problem using other columns, The other columns probably generate smaller indices. The message you get can be conceivably caused by more than one problem, but in all cases that I saw it, it was because of the disk shortage. --Gene
Roberto Moreda wrote: > sanluis=> CREATE INDEX art_idx2 ON ARTICULOINFO (shFamilia); > 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. > We have lost the connection to the backend, so further > processing is impossible. Terminating. > What happens? have you inserted a large amount of data before ? probably using copy ? then try vacuum. If that doesnt help try copying your data out, recreating table and copying back in. And don't forget to vacuum. -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Christian Rudow E-Mail: Christian.Rudow@thinx.ch ThinX networked business services Stahlrain 10, CH-5200 Brugg ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~