From: pierce at hogranch.com (John R Pierce)
Date: Thu, 08 Dec 2011 23:13:03 -0800
Subject: [Pljava-dev] pljava crash in jre
Message-ID: <4EE1B4FF.3000901@hogranch.com>

test platform is: centos6 minimal install, with or without the 
almost-6.1 'cr' files.  64bit.  jdk6u29, pgsql 9.0.5 or 9.0.6...  
postgresql-9.0 installed from depesz' yum.postgresql.org repository.  
pljava binaries built exactly how I detailed here a week back, running 
in /usr/share/pljava/ .

so I've been fighting this hard crash as soon as I ran any pljava on our 
dev servers.   crashes as soon as you run any pljava, including the 
crash-n-burn test: select sysprop( 'java.home' );   nothing I tried 
would work...

crash leaves this lengthy debug file in the /var/lib/pgsql/9.0/data 
directory
http://freescruz.com/hs_err_pid1704.log

it was crashing like this both on a 'real' 12 core 48gb server, and on a 
4-core 6gb VMware ESXi instance, with the same basic configuration.  I 
tried all sorts of variations, still hard crashes as soon as you run any 
pljava, even sysprop

I built a small VM at home, and installed the same versions of 
everything... and it worked.  :-O

narrowed it down.   1 or 4 CPU cores doesn't matter.   our 'large' .conf 
file crashes, and a default small file works.  {!!!},

I've narrowed it down to...

     shared_buffers=2048MB crashes,
     shared_buffers=1024MB works.


-- 
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast