Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 8BDEF475C32 for ; Sat, 4 May 2002 14:21:16 -0400 (EDT) Received: from jbarilla.student.princeton.edu (jbarilla.student.Princeton.EDU [140.180.137.120]) by postgresql.org (Postfix) with ESMTP id B19F8475AF9 for ; Sat, 4 May 2002 14:19:35 -0400 (EDT) Received: (from jbarilla@localhost) by jbarilla.student.princeton.edu (8.11.6/8.11.6) id g44IJa818114; Sat, 4 May 2002 14:19:36 -0400 To: pgsql-sql Subject: Re: Syntax error in plpgsql crashes backend References: From: Joseph Barillari X-Public-Key: finger -l jbarilla@phoenix.princeton.edu X-Public-Key-Fingerprint: 99C7 4F49 AF41 AD0F A4FC 529C 215E 1BD2 F6A1 FA37 X-URL: http://www.princeton.edu/~jbarilla Date: Sat, 04 May 2002 14:19:35 -0400 In-Reply-To: (Joseph Barillari's message of "Sat, 04 May 2002 14:09:18 -0400") Message-ID: Lines: 82 User-Agent: Gnus/5.090007 (Oort Gnus v0.07) Emacs/21.2.50 (i686-pc-linux-gnu) MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha1; protocol="application/pgp-signature" X-Archive-Number: 200205/27 X-Sequence-Number: 7663 --=-=-= Content-Transfer-Encoding: quoted-printable 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=3D> \i test CREATE cal=3D> select foo(); foo=20 ----- 1 (1 row) cal=3D> \i test CREATE cal=3D> 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. !>=20 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 s= emaphores 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 p= rogress 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 :=3D '' -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 -- blah blah blah blah blah blah blah blah blah blah blah=20 ''; return 1; end; ' language 'plpgsql'; --=-=-= Content-Type: application/pgp-signature -----BEGIN PGP MESSAGE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: Processed by Mailcrypt 3.5.6 and Gnu Privacy Guard iD8DBQE81CY3IV4b0vah+jcRAnEwAJ0ZBDb+A51zsJKVOt1yi8WyAQlPYwCeME/R LcF/69Gp3EhA8LHLHRQSpJU= =4WkB -----END PGP MESSAGE----- --=-=-=--