vacuum analyze crashes
От | Antonio Garcia Mari |
---|---|
Тема | vacuum analyze crashes |
Дата | |
Msg-id | 199903261719.SAA07732@pixie.at4.net обсуждение исходный текст |
Ответы |
Re: [BUGS] vacuum analyze crashes
|
Список | pgsql-bugs |
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/
В списке pgsql-bugs по дате отправления: