This has been fixed in 6.5beta.
[Charset ISO-8859-1 unsupported, filtering to ASCII...]
> Hi all,
> i recently suscribed the bugs list and this is my first post to it. I
> want to report a strange bug related to the 'vacuum analyze'
> command.
>
> Every time 'Vacuum analyze' find any table containing the value ''
> (empty string) in the same column in two different rows it crashes
> with the following error message:
> 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.
>
>
> The following text reproduces the problem:
>
> $ createdb test_db
> $ psql test_db
> Welcome to the POSTGRESQL interactive sql monitor:
> Please read the file COPYRIGHT for copyright terms of
> POSTGRESQL
>
> type \? for help on slash commands
> type \q to quit
> type \g or terminate with semicolon to execute query
> You are currently connected to the database: test_db
>
> test_db=> create table test (
> test_db-> string1 varchar(10));
> CREATE
> test_db=> insert into test values ('test string');
> INSERT 185001 1
> test_db=> vacuum analyze;
> VACUUM
> test_db=> insert into test values ('');
> INSERT 185003 1
> test_db=> vacuum analyze;
> VACUUM
> test_db=> insert into test values ('');
> INSERT 185005 1
> test_db=> vacuum analyze;
> 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.
>
>
> my conf:
> postgres 6.4.2
> linux 2.0.35 Intel
> Pentium 233 192MB RAM
>
>
> Antonio Garcia Mari
> AT4.net Internet y Comunicaci_n
> http://www.at4.net/
>
>
>
>
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
