pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Joseph Barillari <jbarilla@princeton.edu>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Syntax error in plpgsql crashes backend
Date: Sat, 04 May 2002 14:19:35 -0400
Message-ID: <m3lmazhj2g.fsf@washer.barillari.org> (raw)
In-Reply-To: <m3wuujhjjl.fsf@washer.barillari.org>
References: <m3wuujhjjl.fsf@washer.barillari.org>

More fun with the backend: I've found that I can incite a crash by
reloading a long, but syntactically correct function twice. Is this a
problem with my installation? --Joe

cal=> \i test
CREATE
cal=> select foo();
 foo 
-----
   1
(1 row)

cal=> \i test
CREATE
cal=> select foo();
pqReadData() -- backend closed the channel unexpectedly.
	This probably means the backend terminated abnormally
	before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!> 


On the console:

DEBUG:  server process (pid 18109) was terminated by signal 11
DEBUG:  terminating any other active server processes
DEBUG:  all server processes terminated; reinitializing shared memory and semaphores
DEBUG:  database system was interrupted at 2002-05-04 14:18:31 EDT
DEBUG:  checkpoint record is at 0/424D570
DEBUG:  redo record is at 0/424D570; undo record is at 0/0; shutdown TRUE
DEBUG:  next transaction id: 41770; next oid: 164012
DEBUG:  database system was not properly shut down; automatic recovery in progress
FATAL 1:  The database system is starting up
DEBUG:  redo starts at 0/424D5B0
DEBUG:  ReadRecord: record with zero length at 0/4253914
DEBUG:  redo done at 0/42538F0
DEBUG:  database system is ready


Function body:

CREATE OR REPLACE FUNCTION foo()
    RETURNS INTEGER
    AS '
DECLARE
	querystr TEXT;
BEGIN
querystr := ''
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 
             -- blah blah blah blah blah blah blah blah blah blah blah 


'';
return 1;
end;
'
language 'plpgsql';

view thread (7+ messages)  latest in thread

Message-ID: <m3lmazhj2g.fsf@washer.barillari.org>
Permalink:  ../m3lmazhj2g.fsf@washer.barillari.org/
Also on:    postgresql.org/message-id/m3lmazhj2g.fsf@washer.barillari.org

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: jbarilla@princeton.edu
  Subject: Re: Syntax error in plpgsql crashes backend
  In-Reply-To: <m3lmazhj2g.fsf@washer.barillari.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox