From: jon.brisbin at npcinternational.com (Jon Brisbin)
Date: Fri, 17 Mar 2006 14:22:46 -0600
Subject: [Pljava-dev] pljava kills my postgres server
In-Reply-To: <441B0577.4000402@tada.se>
References: <441B0447.1010002@npcinternational.com> <441B0577.4000402@tada.se>
Message-ID: <441B1A96.6010400@npcinternational.com>

Thomas Hallgren wrote:
> Hi Jon,
> Can you please tell me what Java you're using? 
On both FreeBSD boxes, which are the ones I'm having trouble with:

java version "1.5.0-p2"
Java(TM) 2 Runtime Environment, Standard Edition (build 
1.5.0-p2-jbrisbin_26_oct_2005_11_01)
Java HotSpot(TM) Server VM (build 1.5.0-p2-jbrisbin_26_oct_2005_11_01, 
mixed mode)

On my PowerBook, running postgres 8.1.3, which works just fine and I'm 
not having any problems with:

java version "1.5.0_05"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_05-83)
Java HotSpot(TM) Client VM (build 1.5.0_05-48, mixed mode, sharing)


> If you set the log_min_messages to DEBUG1 you might get something in 
> the log before the dump that might help shed some light. 
Mar 17 14:15:12 development postgres[81573]: [2-1] DEBUG:  Not using 
integer_datetimes
Mar 17 14:15:12 development postgres[81573]: [3-1] DEBUG:  Added JVM 
option string "-Xmx256M"
Mar 17 14:15:12 development postgres[81573]: [4-1] DEBUG:  Added JVM 
option string "-XX:+UseAltSigs"
Mar 17 14:15:12 development postgres[81573]: [5-1] DEBUG:  Added JVM 
option string "-Djava.class.path=/usr/local/pgsql/lib/pljava.jar"
Mar 17 14:15:12 development postgres[81573]: [6-1] DEBUG:  Added JVM 
option string "-Dsqlj.defaultconnection=jdbc:default:connection"
Mar 17 14:15:12 development postgres[81573]: [7-1] DEBUG:  Added JVM 
option string "vfprintf"
Mar 17 14:15:12 development postgres[81573]: [8-1] DEBUG:  Added JVM 
option string "-Xrs"
Mar 17 14:15:12 development postgres[81573]: [9-1] DEBUG:  Creating JavaVM
Mar 17 14:15:17 development kernel: pid 81573 (postgres), uid 70: exited 
on signal 10 (core dumped)
Mar 17 14:15:17 development postgres[81565]: [2-1] LOG:  server process 
(PID 81573) was terminated by signal 10
Mar 17 14:15:17 development postgres[81565]: [3-1] LOG:  terminating any 
other active server processes
Mar 17 14:15:17 development postgres[81565]: [4-1] LOG:  all server 
processes terminated; reinitializing
Mar 17 14:15:17 development postgres[81578]: [5-1] LOG:  database system 
was interrupted at 2006-03-17 14:14:32 CST
Mar 17 14:15:17 development postgres[81578]: [6-1] LOG:  checkpoint 
record is at 0/4E8843D4
Mar 17 14:15:17 development postgres[81578]: [7-1] LOG:  redo record is 
at 0/4E8843D4; undo record is at 0/0; shutdown TRUE
Mar 17 14:15:17 development postgres[81578]: [8-1] LOG:  next 
transaction ID: 83632; next OID: 2541667
Mar 17 14:15:17 development postgres[81578]: [9-1] LOG:  next 
MultiXactId: 1; next MultiXactOffset: 0
Mar 17 14:15:17 development postgres[81578]: [10-1] LOG:  database 
system was not properly shut down; automatic recovery in progress
Mar 17 14:15:17 development postgres[81578]: [11-1] LOG:  record with 
zero length at 0/4E884418
Mar 17 14:15:17 development postgres[81578]: [12-1] LOG:  redo is not 
required
Mar 17 14:15:17 development postgres[81578]: [13-1] LOG:  database 
system is ready
Mar 17 14:15:17 development postgres[81578]: [14-1] LOG:  transaction ID 
wrap limit is 1073823458, limited by database "postgres"
Mar 17 14:15:38 development postgres[81583]: [5-1] LOG:  incomplete 
startup packet

> A stack-trace from the core file might help too of course.
How do I get one of those?

-- 

Thanks!

Jon Brisbin
Webmaster
NPC International, Inc.