Skip site navigation (1) Skip section navigation (2)

Re: [BUGS] vacuum analyze crashes

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Antonio Garcia Mari <at4(dot)dev(at)at4(dot)net>
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: [BUGS] vacuum analyze crashes
Date: 1999-05-10 04:44:56
Message-ID: 199905100444.AAA23432@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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(at)candle(dot)pha(dot)pa(dot)us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 1999-05-10 16:29:28
Subject: Re: [BUGS] General Bug Report: obscure error when misusing table name as an attribute
Previous:From: Bruce MomjianDate: 1999-05-10 04:00:08
Subject: Re: [BUGS] backend crash with inet type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group