Re: [BUGS] backend crash with inet type

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Chris Dunlop <chris(at)onthe(dot)net(dot)au>
Cc: bugs(at)postgreSQL(dot)org
Subject: Re: [BUGS] backend crash with inet type
Date: 1999-05-10 04:00:08
Message-ID: 199905100400.AAA22617@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


This is fixed in 6.5 beta.

>
> ============================================================================
> POSTGRESQL BUG REPORT TEMPLATE
> ============================================================================
>
>
> Your name : Chris Dunlop
> Your email address : chris(at)onthe(dot)net(dot)au
>
>
> System Configuration
> ---------------------
> Architecture (example: Intel Pentium) : Intel-Pentium
>
> Operating System (example: Linux 2.0.26 ELF) : Linux 2.0.35
>
> PostgreSQL version (example: PostgreSQL-6.4) : PostgreSQL-6.4.2, also snapshot-990320
>
> Compiler used (example: gcc 2.8.0) : gcc 2.7.2.3
>
> Please enter a FULL description of your problem:
> ------------------------------------------------
>
> Attempting to delete from a table by inet, with rows containing NULL inet
> types results in a backend crash
>
>
>
>
> Please describe a way to repeat the problem. Please try to provide a
> concise reproducible example, if at all possible:
> ----------------------------------------------------------------------
>
> create table blah ( ip_address inet );
> CREATE
>
> insert into blah values('0.0.0.0');
> INSERT 18761 1
>
> delete from blah where ip_address = '111.111.111.111';
> DELETE 0
>
> insert into blah values(NULL);
> INSERT 18762 1
>
> delete from blah where ip_address = '111.111.111.111';
> 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.
>
>
>
>
> If you know how this problem might be fixed, list the solution below:
> ---------------------------------------------------------------------
>
>
>
>

--
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

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 1999-05-10 04:44:56 Re: [BUGS] vacuum analyze crashes
Previous Message Bruce Momjian 1999-05-09 15:36:26 Re: your mail