Trouble with plpgsql on 7.4.6 - Mailing list pgsql-hackers

From D'Arcy J.M. Cain
Subject Trouble with plpgsql on 7.4.6
Date
Msg-id 20041118134034.12cb15be.darcy@druid.net
Whole thread Raw
Responses Re: Trouble with plpgsql on 7.4.6  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Has anyone else had any problem installing plpgsql into a 7.4.6
database?  When I try (on NetBSD 2.0RC5) I get the following message:

createlang: language installation failed: server closed the connection
unexpectedly

This does not happen on 7.4.3, the other system that I have installed. 
It doesn't happen if I use 7.4.6 to access a database built by 7.4.3. 
It happens on 7.4.6 if I initdb a new database and simply run the
createlang command against it.  Here is a test script which I ran in a
scratch directory.

initdb .
pg_ctl -D . start
sleep 3
createlang plpgsql template1

The closest thing I could find in the archives is the message about
7.4.5 in
http://archives.postgresql.org/pgsql-hackers/2004-09/msg00915.php.  I
don't think there is a connection but I could be wrong.

I turned on a bunch of logging and this is what gets spit out into the
log:

Nov 18 11:49:18 panther cert198[21983]: [47-1] LOG:  00000: server
process (PID 7864) was terminated by signal 6
Nov 18 11:49:18 panther cert198[21983]: [47-2] LOCATION:  LogChildExit,
postmaster.c:2087
Nov 18 11:49:18 panther cert198[21983]: [48-1] LOG:  00000: terminating
any other active server processes
Nov 18 11:49:18 panther cert198[21983]: [48-2] LOCATION:  CleanupProc,
postmaster.c:2008
Nov 18 11:49:18 panther cert198[21983]: [49-1] LOG:  00000: all server
processes terminated; reinitializing
Nov 18 11:49:18 panther cert198[21983]: [49-2] LOCATION:  reaper,
postmaster.c:1920
Nov 18 11:49:18 panther cert198[1332]: [52-1] LOG:  00000: database
system was interrupted at 2004-11-18 11:43:53 EST
Nov 18 11:49:18 panther cert198[1332]: [52-2] LOCATION:  StartupXLOG,
xlog.c:2610
Nov 18 11:49:18 panther cert198[1332]: [53-1] LOG:  00000: checkpoint
record is at 0/9F5B40
Nov 18 11:49:18 panther cert198[1332]: [53-2] LOCATION:  StartupXLOG,
xlog.c:2628
Nov 18 11:49:18 panther cert198[1332]: [54-1] LOG:  00000: redo record
is at 0/9F5B40; undo record is at 0/0; shutdown TRUE
Nov 18 11:49:18 panther cert198[1332]: [54-2] LOCATION:  StartupXLOG,
xlog.c:2653
Nov 18 11:49:18 panther cert198[1332]: [55-1] LOG:  00000: next
transaction ID: 574; next OID: 74486
Nov 18 11:49:18 panther cert198[1332]: [55-2] LOCATION:  StartupXLOG,
xlog.c:2656
Nov 18 11:49:18 panther cert198[1332]: [56-1] LOG:  00000: database
system was not properly shut down; automatic recovery in progress
Nov 18 11:49:18 panther cert198[1332]: [56-2] LOCATION:  StartupXLOG,
xlog.c:2705
Nov 18 11:49:19 panther cert198[1332]: [57-1] LOG:  00000: redo starts
at 0/9F5B80
Nov 18 11:49:19 panther cert198[1332]: [57-2] LOCATION:  StartupXLOG,
xlog.c:2733
Nov 18 11:49:19 panther cert198[1332]: [58-1] LOG:  00000: invalid magic
number 0000 in log file 0, segment 0, offset 10477568
Nov 18 11:49:19 panther cert198[1332]: [58-2] LOCATION: 
ValidXLOGHeader, xlog.c:2048
Nov 18 11:49:19 panther cert198[1332]: [59-1] LOG:  00000: redo done at
0/9FBCAC
Nov 18 11:49:19 panther cert198[1332]: [59-2] LOCATION:  StartupXLOG,
xlog.c:2765
Nov 18 11:49:21 panther cert198[1332]: [60-1] LOG:  00000: database
system is ready
Nov 18 11:49:21 panther cert198[1332]: [60-2] LOCATION:  StartupXLOG,
xlog.c:2946

-- 
D'Arcy J.M. Cain <darcy@druid.net>         |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: [pgsql-hackers] Timing of pgstats updates
Next
From: Tom Lane
Date:
Subject: Re: Trouble with plpgsql on 7.4.6