Trouble with plpgsql on 7.4.6

From: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
To: pgsql-hackers(at)PostgreSQL(dot)org
Subject: Trouble with plpgsql on 7.4.6
Date: 2004-11-18 18:40:34
Message-ID: 20041118134034.12cb15be.darcy@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)druid(dot)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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-11-18 19:25:41 Re: Trouble with plpgsql on 7.4.6
Previous Message Josh Berkus 2004-11-18 18:04:55 Re: [pgsql-hackers] Timing of pgstats updates