Port Bug Report: PL/pgSQL crashes on the BSDI platform

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgreSQL(dot)org
Subject: Port Bug Report: PL/pgSQL crashes on the BSDI platform
Date: 1999-07-22 02:01:12
Message-ID: 199907220201.WAA34767@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports


============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Roman V. Isaev
Your email address : rm(at)techno(dot)ru

Category : runtime: back-end
Severity : critical

Summary: PL/pgSQL crashes on the BSDI platform

System Configuration
--------------------
Operating System : bsdi bsd/os 3.1

PostgreSQL version : 6.5.1

Compiler used : gcc version 2.7.2.1

Hardware:
---------
p133, 32 meg ram
BSD/OS skylink.ru 3.1 BSDI BSD/OS 3.1 Kernel #0:
Thu Dec 11 13:42:37 MSK/MSD 1997 sysadm(at)c1(dot)techno(dot)ru:/usr/src/sys/compile/MY i386

Versions of other tools:
------------------------
GNU Make version 3.75, lex version 2.5.3

--------------------------------------------------------------------------

Problem Description:
--------------------
create function test() returns int4 as ' begin return 0; end;' language 'plpgsql';
CREATE
select test();
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.

plpgsql regression test does not work too. it did not work in bsdi 2.1, did not work in 3.1, did not work in 4.0. also
because of the closed backend:

QUERY: insert into Room values ('105', 'Office');
QUERY: insert into Room values ('106', 'Office');
QUERY: insert into WSlot values ('WS.001.1a', '001', '', '');
! 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 i
s impossible. Terminating.

--------------------------------------------------------------------------

Test Case:
----------
compile and install 6.5 or 6.5.1 on BSDI BSD/OS box
run
create simple function and try to call it

--------------------------------------------------------------------------

Solution:
---------

--------------------------------------------------------------------------

Browse pgsql-ports by date

  From Date Subject
Next Message Unprivileged user 1999-07-22 02:21:41 Port Bug Report: postgresql Won't Start
Previous Message Ryan Kirkpatrick 1999-07-22 01:39:06 Re: [PORTS] RedHat6.0 & Alpha