============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Vladimir Dobrokhotov
Your email address : dvs@rybvod.kamchatka.su
Category : runtime: back-end
Severity : critical
Summary: 1.backend crash when frontend do cluster (sometimes!?), 2.cluster does not work
System Configuration
--------------------
Operating System : FreeBSD 2.2.5-RELEASE
PostgreSQL version : 6.5
Compiler used : gcc 2.7.2.1
Hardware:
---------
Pentium, 32 RAM
Versions of other tools:
------------------------
gmake 3.75, flex 2.5.4
--------------------------------------------------------------------------
Problem Description:
--------------------
This problem come from pg6.2.
cluster (unique index btree(4 filelds varchar(4))) not work - "cannot create unique index. Table contains non-unique
values."
In pg6.4.2 command "cluster ind_un.." destroy all indexes on the table but index "ind_un" detroy fields form 2...
In pg6.5 - random one from:
1) ERROR: cannot create unique index. Table contains non-unique values.
2) pgReadData() -- backend closed ... (need restart frontend)
3) pgReadData() -- backend closed ... (need restart backend, frontend)
4) pgReadData() -- backend closed ... (need restart backend, frontend, remove file "temp_1ddbc".)
--------------------------------------------------------------------------
Test Case:
----------
=>create table sns (n1 varchar(4), n2 varchar(4), n3 varchar(4), n4 varchar(4), name text);
CREATE
=>insert into sns values ('0','00','','','a');
INSERT 278624 1
=>insert into sns values ('0','01','','','b');
INSERT 278626 1
=>create unique index sn_b on sns using btree(n1,n2,n3,n4);
CREATE
=>cluster sn_b on sns;
ERROR: Cannot create unique index. Table contains non-unique values
=>cluster sn_b on sns;
pgReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to backend, so further processing is impossible.
Terminating.
#psql dv14
Connection to database 'dv14' failed.
connectDB() -- ...
#su postgres
$~/rc.local
postmaster.
^D#psql dv14
Welcome to the POSTGRES interactive sql monitor.
...
=>cluster sn_b on sns;
ERROR: cannot create temp_44050
(rm ~/data/base/dv14/temp_44050)
=>cluster sn_b on sns;
ERROR: Cannot create unique index. Table contains non-unique values
=>cluster sn_b on sns;
pgReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to backend, so further processing is impossible.
Terminating.
#psql dv14
Welcome to the POSTGRES interactive sql monitor.
...
=>
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------