reltime with NULL fields crashes backend

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: reltime with NULL fields crashes backend
Date: 2001-04-11 11:38:04
Message-ID: 200104111138.f3BBc4p06732@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Dmitry Tsitelov (cit(at)tag-ltd(dot)spb(dot)ru) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
reltime with NULL fields crashes backend

Long Description
I use expression like int4(reltime(<interval-field>)) to get interval length in seconds. When <interval-field> is NULL backend crashes (psql session):

organizer=> SELECT reltime(task.duration_real) FROM pmgr_task task WHERE task.id = 5;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally before or while processing the request.

#######
OS: FreeBSD 4.1-RELEASE #2
PostgreSQL ver: PostgreSQL 7.0.2 on i386-unknown-freebsdelf4.1, compiled by gcc 2.95.2

####### Postmaster log:

Server process (pid 37685) exited with status 139 at Wed Apr 11 15:33:18 2001
Terminating any active server processes...
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died abnormally a
nd possibly corrupted shared memory.
I have rolled back the current transaction and am going to terminate you
r database system connection and exit.
Please reconnect to the database system and repeat your query.
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died abnormally a
nd possibly corrupted shared memory.
I have rolled back the current transaction and am going to terminate you
r database system connection and exit.
Please reconnect to the database system and repeat your query.
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend died abnormally a
nd possibly corrupted shared memory.
I have rolled back the current transaction and am going to terminate you
r database system connection and exit.
Please reconnect to the database system and repeat your query.
Server processes were terminated at Wed Apr 11 15:33:18 2001
Reinitializing shared memory and semaphores
DEBUG: Data Base System is starting up at Wed Apr 11 15:33:18 2001
The Data Base System is starting up
DEBUG: Data Base System was interrupted being in production at Wed Apr 11 15:27
:41 2001
DEBUG: Data Base System is in production state at Wed Apr 11 15:33:18 2001

Sample Code
CREATE TABLE t ( f interval ); : OK
INSERT INTO t (f) VALUES ('23 s'); : OK
SELECT reltime(f) FROM t; : OK
SELECT int4(reltime(f)) FROM t; : OK
DELETE FROM t; : OK
INSERT INTO t (f) VALUES (NULL); : OK
SELECT reltime(f) FROM t; : Backend crash

SELECT reltime(NULL); : OK
SELECT reltime(interval(NULL)); : Backend crash

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-04-11 13:14:22 result of conversion to timestamp is shifted 1 minute back
Previous Message Rainer Mager 2001-04-11 06:58:34 RE: Problem with 7.0.3 dump -> 7.1b4 restore