[Pljava-dev] pljava state

so, I am going to need to build pljava to work with RHEL6, 64bit Sun
JDK1.6 and 64bit postgres 9.0 as distributed from yum.postgresql.org ....

I started going over the pljava wiki stuff, it didn't seem like there's
been much work, the wiki was talking about gcj and jdk 1.4 and stuff.
last time I was building pljava was for pg 8.4 on AIX and Solaris

whats the status of this project?

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

John R Pierce <pierce at hogranch.com> writes:

> whats the status of this project?

PL/Java is actively maintained, though not developed as actively as
I'd hope.

There is support for JDK 1.6 on a different branch - which I hope to
merge soon [*] and start releasing 2.0 candidates.

If there is a definite deadline you need to have met your best bet is
to contact 2ndQuadrant which pays for my time.

The wiki and docs are unfortunately not up to date.

[*] For some value of soon.

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/

On 09/27/11 7:22 AM, Johann 'Myrkraverk' Oskarsson wrote:
> John R Pierce<pierce at hogranch.com> writes:
>
>> whats the status of this project?
> PL/Java is actively maintained, though not developed as actively as
> I'd hope.
>
> There is support for JDK 1.6 on a different branch - which I hope to
> merge soon [*] and start releasing 2.0 candidates.

ok, heres where I'm at...

64bit postgresql 9.0.5 from yum.postgresql.org, on 64bit CentOS 6.0 w/
latest patches, with 64bit Sun JDK 1.5.latest installed in
/usr/java/jdk1.5.0_22/

JDK 1.6 is also in /usr/java/jdk1.6.0_26 which is our default java for
our projects, but our pljava stuff should work fine with 1.5 (it did
before on PG 8.4 with solaris and aix).

So, I built pljava, specifing the option for rpath at build time,

export
PATH=/usr/java/jdk1.5.0_22/bin:/usr/pgsql-9.0/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/piercej/bin
export JAVA_HOME=/usr/java/jdk1.5.0_22
export USE_LD_RPATH=1
make clean
make
make install

I installed it using the install.jar..

$ java -cp build/deploy.jar:postgresql-9.0-802.jdbc3.jar
org.postgresql.pljava.deploy.Deployer -database lss -user XXX -password
XXX -install

(no output, but various objects were created in the database).

I try running...

lss=# select
sqlj.install_jar('/home/XXXX/pljava-1.4.3/build/examples.jar','samples',true);

(yes, the postgres server process can read my $HOME)
and k-rash, postgres goes down and recovers, leaving this lovely error
log... any clues would be greatly appreciated...

$ cat hs_err_pid3933.log
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# SIGSEGV (0xb) at pc=0x00007f52ca3d9306, pid=3933, tid=139995980908480
#
# Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_22-b03 mixed mode)
# Problematic frame:
# J java.lang.String.indexOf(II)I
#

--------------- T H R E A D ---------------

Current thread (0x0000000000d58880): JavaThread "main"
[_thread_in_Java, id=3933]

siginfo:si_signo=11, si_errno=0, si_code=2, si_addr=0x00007f525ab7b000

Registers:
RAX=0x00000000ffffffff, RBX=0x0000000000000065, RCX=0x0000000000000000,
RDX=0x0000000000000021
RSP=0x00007fffa916a458, RBP=0x00007fffa916a4d8, RSI=0x000000000000006d,
RDI=0x0000000000000021
R8 =0x0000000000000021, R9 =0x000000000000002f, R10=0x0000000000000021,
R11=0x00000000ffffffff
R12=0x00007f528525d320, R13=0x00007f5284ebd7eb, R14=0x00007fffa916a4f0,
R15=0x0000000000d58880
RIP=0x00007f52ca3d9306, EFL=0x0000000000010202,
CSGSFS=0x0000000000000033, ERR=0x0000000000000004
TRAPNO=0x000000000000000e

Top of Stack: (sp=0x00007fffa916a458)
0x00007fffa916a458: 00007f52ca3d80a4 00007fffa916a4d8
0x00007fffa916a468: 00007fffa916a4f0 00007fffa916a4d8
0x00007fffa916a478: 00007fffa916a480 00007f52ca37be1a
0x00007fffa916a488: 0000000000000000 000000000000002f
0x00007fffa916a498: 00007f528525d320 00007fffa916a4a0
0x00007fffa916a4a8: 00007f5284ebd7eb 00007fffa916a4f0
0x00007fffa916a4b8: 00007f5284f51858 0000000000000000
0x00007fffa916a4c8: 00007f5284ebd7f8 00007fffa916a4e8
0x00007fffa916a4d8: 00007fffa916a530 00007f52ca37be1a
0x00007fffa916a4e8: 000000000000002f 00007f528525d320
0x00007fffa916a4f8: 00007fffa916a4f8 00007f5284ed53f0
0x00007fffa916a508: 00007fffa916a548 00007f5284f4d018
0x00007fffa916a518: 0000000000000000 00007f5284ed5418
0x00007fffa916a528: 00007fffa916a540 00007fffa916a588
0x00007fffa916a538: 00007f52ca37bd36 00007f528525d320
0x00007fffa916a548: 00007f52b4d82888 00007fffa916a550
0x00007fffa916a558: 00007f5284ed5c96 00007fffa916a5a0
0x00007fffa916a568: 00007f5284f4d018 0000000000000000
0x00007fffa916a578: 00007f5284ed5cb0 00007fffa916a598
0x00007fffa916a588: 00007fffa916a5f0 00007f52ca37bde1
0x00007fffa916a598: 00007f528525d320 00007f52b4d82888
0x00007fffa916a5a8: 0000000000000000 00007f52b4d82888
0x00007fffa916a5b8: 00007fffa916a5a8 00007f5284ed434a
0x00007fffa916a5c8: 00007fffa916a620 00007f5284f4d018
0x00007fffa916a5d8: 0000000000000000 00007f5284ed4398
0x00007fffa916a5e8: 00007fffa916a610 00007fffa916a670
0x00007fffa916a5f8: 00007f52ca37bde1 0000000000000000
0x00007fffa916a608: 0000000000000000 0000000000000000
0x00007fffa916a618: 00007f528525d320 00007f52b4d82888
0x00007fffa916a628: 00000013c2c30801 00007f52b4d82888
0x00007fffa916a638: 00007fffa916a628 00007f528507af94
0x00007fffa916a648: 00007fffa916a6a0 00007f528507b638

Instructions: (pc=0x00007f52ca3d9306)
0x00007f52ca3d92f6: ff ff ff ff 41 8b c3 4c 8b 6c 24 18 48 83 c4 48
0x00007f52ca3d9306: 85 05 f4 1c 7a 90 c3 44 8b c1 e9 16 fe ff ff 45

Stack: [0x00007fffa8f6d000,0x00007fffa916d000), sp=0x00007fffa916a458,
free space=2037k
Native frames: (J=compiled Java code, j=interpreted, Vv=VM code,
C=native code)
J java.lang.String.indexOf(II)I
j java.lang.ClassLoader.checkName(Ljava/lang/String;)Z+16
j
java.lang.ClassLoader.findLoadedClass(Ljava/lang/String;)Ljava/lang/Class;+6
j java.lang.ClassLoader.loadClass(Ljava/lang/String;Z)Ljava/lang/Class;+2
j
sun.misc.Launcher$AppClassLoader.loadClass(Ljava/lang/String;Z)Ljava/lang/Class;+36
j java.lang.ClassLoader.loadClass(Ljava/lang/String;)Ljava/lang/Class;+3
j
java.util.ResourceBundle.loadBundle(Ljava/lang/ClassLoader;Ljava/lang/String;Ljava/util/Locale;)Ljava/lang/Object;+6
j
java.util.ResourceBundle.findBundle(Ljava/lang/ClassLoader;Ljava/lang/String;Ljava/util/Locale;Ljava/lang/String;Ljava/lang/Objec
t;)Ljava/lang/Object;+238
j
java.util.ResourceBundle.getBundleImpl(Ljava/lang/String;Ljava/util/Locale;Ljava/lang/ClassLoader;)Ljava/util/ResourceBundle;+145
j
java.util.ResourceBundle.getBundle(Ljava/lang/String;Ljava/util/Locale;)Ljava/util/ResourceBundle;+5
j sun.text.resources.LocaleData$1.run()Ljava/lang/Object;+8
v ~StubRoutines::call_stub
V [libjvm.so+0x389df5]
V [libjvm.so+0x56f5f9]
V [libjvm.so+0x389c05]
V [libjvm.so+0x3eea2b]
C [libjava.so+0xcf7e]
Java_java_security_AccessController_doPrivileged__Ljava_security_PrivilegedAction_2+0xe
j
java.security.AccessController.doPrivileged(Ljava/security/PrivilegedAction;)Ljava/lang/Object;+0
j
sun.text.resources.LocaleData.getBundle(Ljava/lang/String;Ljava/util/Locale;)Ljava/util/ResourceBundle;+9
j
sun.text.resources.LocaleData.getLocaleElements(Ljava/util/Locale;)Ljava/util/ResourceBundle;+3
j
java.text.DateFormatSymbols.cacheLookup(Ljava/util/Locale;)[Ljava/util/ResourceBundle;+26
j java.text.DateFormatSymbols.initializeData(Ljava/util/Locale;)V+2
j java.text.DateFormatSymbols.<init>(Ljava/util/Locale;)V+49
j
java.util.TimeZone.retrieveDisplayNames(Ljava/lang/String;Ljava/util/Locale;)[Ljava/lang/String;+5
j
java.util.TimeZone.getDisplayNames(Ljava/lang/String;Ljava/util/Locale;)[Ljava/lang/String;+82
j
java.util.TimeZone.getDisplayName(ZILjava/util/Locale;)Ljava/lang/String;+45
j java.util.Date.toString()Ljava/lang/String;+157
j java.util.Properties.store(Ljava/io/OutputStream;Ljava/lang/String;)V+65
j org.postgresql.pljava.internal.ELogHandler.init()V+63
j org.postgresql.pljava.internal.Session.init()J+0
v ~StubRoutines::call_stub
V [libjvm.so+0x389df5]
V [libjvm.so+0x56f5f9]
V [libjvm.so+0x389c05]
V [libjvm.so+0x3b7595]
V [libjvm.so+0x3a6907]

--------------- P R O C E S S ---------------

Java Threads: ( => current thread )
0x0000000000e0b250 JavaThread "Low Memory Detector" daemon
[_thread_blocked, id=3942]
0x0000000000e097d0 JavaThread "CompilerThread1" daemon
[_thread_blocked, id=3941]
0x0000000000e08410 JavaThread "CompilerThread0" daemon
[_thread_in_native, id=3940]
0x0000000000e07060 JavaThread "AdapterThread" daemon
[_thread_blocked, id=3939]
0x0000000000df6d90 JavaThread "Finalizer" daemon [_thread_blocked,
id=3938]
0x0000000000df6570 JavaThread "Reference Handler" daemon
[_thread_blocked, id=3937]
=>0x0000000000d58880 JavaThread "main" [_thread_in_Java, id=3933]

Other Threads:
0x0000000000df21c0 VMThread [id=3936]
0x0000000000d6c450 WatcherThread [id=3943]

VM state:not at safepoint (normal execution)

VM Mutex/Monitor currently owned by a thread: None

Heap
PSYoungGen total 37376K, used 1287K [0x00007f52b4d60000,
0x00007f52b7710000, 0x00007f52ca2b0000)
eden space 32064K, 4% used
[0x00007f52b4d60000,0x00007f52b4ea1d48,0x00007f52b6cb0000)
from space 5312K, 0% used
[0x00007f52b71e0000,0x00007f52b71e0000,0x00007f52b7710000)
to space 5312K, 0% used
[0x00007f52b6cb0000,0x00007f52b6cb0000,0x00007f52b71e0000)
PSOldGen total 85376K, used 0K [0x00007f528a2b0000,
0x00007f528f610000, 0x00007f52b4d60000)
object space 85376K, 0% used
[0x00007f528a2b0000,0x00007f528a2b0000,0x00007f528f610000)
PSPermGen total 21248K, used 3779K [0x00007f5284eb0000,
0x00007f5286370000, 0x00007f528a2b0000)
object space 21248K, 17% used
[0x00007f5284eb0000,0x00007f5285260fc0,0x00007f5286370000)

Dynamic libraries:
00400000-00899000 r-xp 00000000 fd:00 528972
/usr/pgsql-9.0/bin/postgres
00a99000-00aa4000 rw-p 00499000 fd:00 528972
/usr/pgsql-9.0/bin/postgres
00aa4000-00b07000 rw-p 00000000 00:00 0
00c56000-00f21000 rw-p 00000000 00:00 0
[heap]
3c5f800000-3c5f81e000 r-xp 00000000 fd:00 130822
/lib64/ld-2.12.so
3c5fa1e000-3c5fa1f000 r--p 0001e000 fd:00 130822
/lib64/ld-2.12.so
3c5fa1f000-3c5fa20000 rw-p 0001f000 fd:00 130822
/lib64/ld-2.12.so
3c5fa20000-3c5fa21000 rw-p 00000000 00:00 0
3c5fc00000-3c5fc02000 r-xp 00000000 fd:00 130836
/lib64/libdl-2.12.so
3c5fc02000-3c5fe02000 ---p 00002000 fd:00 130836
/lib64/libdl-2.12.so
3c5fe02000-3c5fe03000 r--p 00002000 fd:00 130836
/lib64/libdl-2.12.so
3c5fe03000-3c5fe04000 rw-p 00003000 fd:00 130836
/lib64/libdl-2.12.so
3c60000000-3c60175000 r-xp 00000000 fd:00 130823
/lib64/libc-2.12.so
3c60175000-3c60375000 ---p 00175000 fd:00 130823
/lib64/libc-2.12.so
3c60375000-3c60379000 r--p 00175000 fd:00 130823
/lib64/libc-2.12.so
3c60379000-3c6037a000 rw-p 00179000 fd:00 130823
/lib64/libc-2.12.so
3c6037a000-3c6037f000 rw-p 00000000 00:00 0
3c60400000-3c60417000 r-xp 00000000 fd:00 130932
/lib64/libpthread-2.12.so
3c60417000-3c60617000 ---p 00017000 fd:00 130932
/lib64/libpthread-2.12.so
3c60617000-3c60618000 r--p 00017000 fd:00 130932
/lib64/libpthread-2.12.so
3c60618000-3c60619000 rw-p 00018000 fd:00 130932
/lib64/libpthread-2.12.so
3c60619000-3c6061d000 rw-p 00000000 00:00 0
3c60c00000-3c60c83000 r-xp 00000000 fd:00 130854
/lib64/libm-2.12.so
3c60c83000-3c60e82000 ---p 00083000 fd:00 130854
/lib64/libm-2.12.so
3c60e82000-3c60e83000 r--p 00082000 fd:00 130854
/lib64/libm-2.12.so
3c60e83000-3c60e84000 rw-p 00083000 fd:00 130854
/lib64/libm-2.12.so
3c61000000-3c6101d000 r-xp 00000000 fd:00 130926
/lib64/libselinux.so.1
3c6101d000-3c6121c000 ---p 0001d000 fd:00 130926
/lib64/libselinux.so.1
3c6121c000-3c6121d000 r--p 0001c000 fd:00 130926
/lib64/libselinux.so.1
3c6121d000-3c6121e000 rw-p 0001d000 fd:00 130926
/lib64/libselinux.so.1
3c6121e000-3c6121f000 rw-p 00000000 00:00 0
3c61800000-3c61815000 r-xp 00000000 fd:00 130858
/lib64/libz.so.1.2.3
3c61815000-3c61a14000 ---p 00015000 fd:00 130858
/lib64/libz.so.1.2.3
3c61a14000-3c61a15000 rw-p 00014000 fd:00 130858
/lib64/libz.so.1.2.3
3c62400000-3c62416000 r-xp 00000000 fd:00 130896
/lib64/libresolv-2.12.so
3c62416000-3c62616000 ---p 00016000 fd:00 130896
/lib64/libresolv-2.12.so
3c62616000-3c62617000 r--p 00016000 fd:00 130896
/lib64/libresolv-2.12.so
3c62617000-3c62618000 rw-p 00017000 fd:00 130896
/lib64/libresolv-2.12.so
3c62618000-3c6261a000 rw-p 00000000 00:00 0
3c6ac00000-3c6ad47000 r-xp 00000000 fd:00 395964
/usr/lib64/libxml2.so.2.7.6
3c6ad47000-3c6af47000 ---p 00147000 fd:00 395964
/usr/lib64/libxml2.so.2.7.6
3c6af47000-3c6af50000 rw-p 00147000 fd:00 395964
/usr/lib64/libxml2.so.2.7.6
3c6af50000-3c6af52000 rw-p 00000000 00:00 0
3c6b000000-3c6b003000 r-xp 00000000 fd:00 131090
/lib64/libcom_err.so.2.1
3c6b003000-3c6b202000 ---p 00003000 fd:00 131090
/lib64/libcom_err.so.2.1
3c6b202000-3c6b203000 rw-p 00002000 fd:00 131090
/lib64/libcom_err.so.2.1
3c6b400000-3c6b571000 r-xp 00000000 fd:00 398036
/usr/lib64/libcrypto.so.1.0.0
3c6b571000-3c6b770000 ---p 00171000 fd:00 398036
/usr/lib64/libcrypto.so.1.0.0
3c6b770000-3c6b793000 rw-p 00170000 fd:00 398036
/usr/lib64/libcrypto.so.1.0.0
3c6b793000-3c6b796000 rw-p 00000000 00:00 0
3c6b800000-3c6b80a000 r-xp 00000000 fd:00 131079
/lib64/libkrb5support.so.0.1
3c6b80a000-3c6ba09000 ---p 0000a000 fd:00 131079
/lib64/libkrb5support.so.0.1
3c6ba09000-3c6ba0a000 rw-p 00009000 fd:00 131079
/lib64/libkrb5support.so.0.1
3c6bc00000-3c6bc27000 r-xp 00000000 fd:00 131088
/lib64/libk5crypto.so.3.1
3c6bc27000-3c6be27000 ---p 00027000 fd:00 131088
/lib64/libk5crypto.so.3.1
3c6be27000-3c6be29000 rw-p 00027000 fd:00 131088
/lib64/libk5crypto.so.3.1
3c6c000000-3c6c0d0000 r-xp 00000000 fd:00 131092
/lib64/libkrb5.so.3.3
3c6c0d0000-3c6c2cf000 ---p 000d0000 fd:00 131092
/lib64/libkrb5.so.3.3
3c6c2cf000-3c6c2da000 rw-p 000cf000 fd:00 131092
/lib64/libkrb5.so.3.3
3c6c400000-3c6c402000 r-xp 00000000 fd:00 131077
/lib64/libkeyutils.so.1.3
3c6c402000-3c6c601000 ---p 00002000 fd:00 131077
/lib64/libkeyutils.so.1.3
3c6c601000-3c6c602000 rw-p 00001000 fd:00 131077
/lib64/libkeyutils.so.1.3
3c6c800000-3c6c858000 r-xp 00000000 fd:00 130838
/lib64/libfreebl3.so
3c6c858000-3c6ca57000 ---p 00058000 fd:00 130838
/lib64/libfreebl3.so
3c6ca57000-3c6ca59000 rw-p 00057000 fd:00 130838
/lib64/libfreebl3.so
3c6ca59000-3c6ca5d000 rw-p 00000000 00:00 0
3c6cc00000-3c6cc38000 r-xp 00000000 fd:00 131093
/lib64/libgssapi_krb5.so.2.2
3c6cc38000-3c6ce37000 ---p 00038000 fd:00 131093
/lib64/libgssapi_krb5.so.2.2
3c6ce37000-3c6ce39000 rw-p 00037000 fd:00 131093
/lib64/libgssapi_krb5.so.2.2
3c6d000000-3c6d007000 r-xp 00000000 fd:00 130840
/lib64/libcrypt-2.12.so
3c6d007000-3c6d207000 ---p 00007000 fd:00 130840
/lib64/libcrypt-2.12.so
3c6d207000-3c6d208000 r--p 00007000 fd:00 130840
/lib64/libcrypt-2.12.so
3c6d208000-3c6d209000 rw-p 00008000 fd:00 130840
/lib64/libcrypt-2.12.so
3c6d209000-3c6d237000 rw-p 00000000 00:00 0
3c6d400000-3c6d40c000 r-xp 00000000 fd:00 130844
/lib64/libpam.so.0.82.2
3c6d40c000-3c6d60c000 ---p 0000c000 fd:00 130844
/lib64/libpam.so.0.82.2
3c6d60c000-3c6d60d000 rw-p 0000c000 fd:00 130844
/lib64/libpam.so.0.82.2
3c6e000000-3c6e053000 r-xp 00000000 fd:00 400568
/usr/lib64/libssl.so.1.0.0
3c6e053000-3c6e253000 ---p 00053000 fd:00 400568
/usr/lib64/libssl.so.1.0.0
3c6e253000-3c6e25b000 rw-p 00053000 fd:00 400568
/usr/lib64/libssl.so.1.0.0
3c6e400000-3c6e416000 r-xp 00000000 fd:00 131042
/lib64/libnsl-2.12.so
3c6e416000-3c6e615000 ---p 00016000 fd:00 131042
/lib64/libnsl-2.12.so
3c6e615000-3c6e616000 r--p 00015000 fd:00 131042
/lib64/libnsl-2.12.so
3c6e616000-3c6e617000 rw-p 00016000 fd:00 131042
/lib64/libnsl-2.12.so
3c6e617000-3c6e619000 rw-p 00000000 00:00 0
3c6e800000-3c6e816000 r-xp 00000000 fd:00 130834
/lib64/libaudit.so.1.0.0
3c6e816000-3c6ea15000 ---p 00016000 fd:00 130834
/lib64/libaudit.so.1.0.0
3c6ea15000-3c6ea16000 r--p 00015000 fd:00 130834
/lib64/libaudit.so.1.0.0
3c6ea16000-3c6ea17000 rw-p 00016000 fd:00 130834
/lib64/libaudit.so.1.0.0
3c70000000-3c70043000 r-xp 00000000 fd:00 400569
/usr/lib64/libldap-2.4.so.2.5.2
3c70043000-3c70242000 ---p 00043000 fd:00 400569
/usr/lib64/libldap-2.4.so.2.5.2
3c70242000-3c70244000 rw-p 00042000 fd:00 400569
/usr/lib64/libldap-2.4.so.2.5.2
3c70c00000-3c70c19000 r-xp 00000000 fd:00 400567
/usr/lib64/libsasl2.so.2.0.23
3c70c19000-3c70e19000 ---p 00019000 fd:00 400567
/usr/lib64/libsasl2.so.2.0.23
3c70e19000-3c70e1a000 rw-p 00019000 fd:00 400567
/usr/lib64/libsasl2.so.2.0.23
3c71000000-3c7100d000 r-xp 00000000 fd:00 400566
/usr/lib64/liblber-2.4.so.2.5.2
3c7100d000-3c7120d000 ---p 0000d000 fd:00 400566
/usr/lib64/liblber-2.4.so.2.5.2
3c7120d000-3c7120e000 rw-p 0000d000 fd:00 400566
/usr/lib64/liblber-2.4.so.2.5.2
7f5258000000-7f5258021000 rw-p 00000000 00:00 0
7f5258021000-7f525c000000 ---p 00000000 00:00 0
7f525ff13000-7f525ff3a000 r--s 00000000 fd:00 413979
/usr/share/pljava.jar
7f525ff3a000-7f5260000000 r--s 00000000 fd:00 1443672
/usr/java/jdk1.5.0_22/jre/lib/ext/localedata.jar
7f5260000000-7f5260048000 rw-p 00000000 00:00 0
7f5260048000-7f5264000000 ---p 00000000 00:00 0
7f5264000000-7f5264021000 rw-p 00000000 00:00 0
7f5264021000-7f5268000000 ---p 00000000 00:00 0
7f5268000000-7f5268021000 rw-p 00000000 00:00 0
7f5268021000-7f526c000000 ---p 00000000 00:00 0
7f526c000000-7f526c0ec000 rw-p 00000000 00:00 0
7f526c0ec000-7f5270000000 ---p 00000000 00:00 0
7f5270000000-7f5270021000 rw-p 00000000 00:00 0
7f5270021000-7f5274000000 ---p 00000000 00:00 0
7f5274000000-7f5274021000 rw-p 00000000 00:00 0
7f5274021000-7f5278000000 ---p 00000000 00:00 0
7f5278000000-7f5278021000 rw-p 00000000 00:00 0
7f5278021000-7f527c000000 ---p 00000000 00:00 0
7f527c000000-7f527c021000 rw-p 00000000 00:00 0
7f527c021000-7f5280000000 ---p 00000000 00:00 0
7f5280000000-7f5280021000 rw-p 00000000 00:00 0
7f5280021000-7f5284000000 ---p 00000000 00:00 0
7f528401e000-7f5284049000 r--s 00000000 fd:00 1442607
/usr/java/jdk1.5.0_22/jre/lib/ext/sunpkcs11.jar
7f5284049000-7f5284070000 r--s 00000000 fd:00 1442608
/usr/java/jdk1.5.0_22/jre/lib/ext/sunjce_provider.jar
7f5284070000-7f5284071000 ---p 00000000 00:00 0
7f5284071000-7f5284171000 rwxp 00000000 00:00 0
7f5284171000-7f5284174000 ---p 00000000 00:00 0
7f5284174000-7f5284272000 rwxp 00000000 00:00 0
7f5284272000-7f5284275000 ---p 00000000 00:00 0
7f5284275000-7f5284373000 rwxp 00000000 00:00 0
7f5284373000-7f5284376000 ---p 00000000 00:00 0
7f5284376000-7f5284474000 rwxp 00000000 00:00 0
7f5284474000-7f5284477000 ---p 00000000 00:00 0
7f5284477000-7f5284575000 rwxp 00000000 00:00 0
7f5284575000-7f5284578000 ---p 00000000 00:00 0
7f5284578000-7f5284676000 rwxp 00000000 00:00 0
7f5284676000-7f5284679000 ---p 00000000 00:00 0
7f5284679000-7f5284777000 rwxp 00000000 00:00 0
7f5284777000-7f5284778000 ---p 00000000 00:00 0
7f5284778000-7f5284878000 rwxp 00000000 00:00 0
7f5284878000-7f5284903000 rw-p 00000000 00:00 0
7f5284903000-7f5284904000 ---p 00000000 00:00 0
7f5284904000-7f5284a04000 rwxp 00000000 00:00 0
7f5284a04000-7f5284a05000 ---p 00000000 00:00 0
7f5284a05000-7f5284b10000 rwxp 00000000 00:00 0
7f5284b10000-7f5284b2f000 rwxp 00000000 00:00 0
7f5284b2f000-7f5284b59000 rwxp 00000000 00:00 0
7f5284b59000-7f5284c85000 rwxp 00000000 00:00 0
7f5284c85000-7f5284c90000 rwxp 00000000 00:00 0
7f5284c90000-7f5284caf000 rwxp 00000000 00:00 0
7f5284caf000-7f5284cd9000 rwxp 00000000 00:00 0
7f5284cd9000-7f5284e04000 rwxp 00000000 00:00 0
7f5284e04000-7f5284e1a000 rwxp 00000000 00:00 0
7f5284e1a000-7f5284eaf000 rwxp 00000000 00:00 0
7f5284eaf000-7f5286370000 rwxp 00000000 00:00 0
7f5286370000-7f528a2b0000 rwxp 00000000 00:00 0
7f528a2b0000-7f528f610000 rwxp 00000000 00:00 0
7f528f610000-7f52b4d60000 rwxp 00000000 00:00 0
7f52b4d60000-7f52b7710000 rwxp 00000000 00:00 0
7f52b7710000-7f52ca2b0000 rwxp 00000000 00:00 0
7f52ca2b6000-7f52ca2b9000 r--s 00000000 fd:00 1442605
/usr/java/jdk1.5.0_22/jre/lib/ext/dnsns.jar
7f52ca2b9000-7f52ca2c3000 rwxp 00000000 00:00 0
7f52ca2c3000-7f52ca379000 rwxp 00000000 00:00 0
7f52ca379000-7f52ca5e9000 rwxp 00000000 00:00 0
7f52ca5e9000-7f52cd379000 rwxp 00000000 00:00 0
7f52cd379000-7f52cdbf6000 r--s 00000000 fd:00 1316197
/usr/java/jdk1.5.0_22/jre/lib/charsets.jar
7f52cdbf6000-7f52cdc0b000 r--s 00000000 fd:00 1316220
/usr/java/jdk1.5.0_22/jre/lib/jce.jar
7f52cdc0b000-7f52cdc90000 r--s 00000000 fd:00 1316191
/usr/java/jdk1.5.0_22/jre/lib/jsse.jar
7f52cdc90000-7f52cdcfa000 rw-p 00000000 00:00 0
7f52cdcfa000-7f52d0359000 r--s 00000000 fd:00 1316223
/usr/java/jdk1.5.0_22/jre/lib/rt.jar
7f52d0359000-7f52d0367000 r-xp 00000000 fd:00 1442629
/usr/java/jdk1.5.0_22/jre/lib/amd64/libzip.so
7f52d0367000-7f52d0469000 ---p 0000e000 fd:00 1442629
/usr/java/jdk1.5.0_22/jre/lib/amd64/libzip.so
7f52d0469000-7f52d046d000 rw-p 00010000 fd:00 1442629
/usr/java/jdk1.5.0_22/jre/lib/amd64/libzip.so
7f52d046d000-7f52d0491000 r-xp 00000000 fd:00 1442640
/usr/java/jdk1.5.0_22/jre/lib/amd64/libjava.so
7f52d0491000-7f52d0591000 ---p 00024000 fd:00 1442640
/usr/java/jdk1.5.0_22/jre/lib/amd64/libjava.so
7f52d0591000-7f52d0597000 rw-p 00024000 fd:00 1442640
/usr/java/jdk1.5.0_22/jre/lib/amd64/libjava.so
7f52d0597000-7f52d05a4000 r-xp 00000000 fd:00 1442623
/usr/java/jdk1.5.0_22/jre/lib/amd64/libverify.so
7f52d05a4000-7f52d06a3000 ---p 0000d000 fd:00 1442623
/usr/java/jdk1.5.0_22/jre/lib/amd64/libverify.so
7f52d06a3000-7f52d06a6000 rw-p 0000c000 fd:00 1442623
/usr/java/jdk1.5.0_22/jre/lib/amd64/libverify.so
7f52d06a6000-7f52d06ad000 r-xp 00000000 fd:00 1442631
/usr/java/jdk1.5.0_22/jre/lib/amd64/native_threads/libhpi.s
o
7f52d06ad000-7f52d07ae000 ---p 00007000 fd:00 1442631
/usr/java/jdk1.5.0_22/jre/lib/amd64/native_threads/libhpi.s
o
7f52d07ae000-7f52d07b1000 rw-p 00008000 fd:00 1442631
/usr/java/jdk1.5.0_22/jre/lib/amd64/native_threads/libhpi.s
o
7f52d07b1000-7f52d0e8e000 r-xp 00000000 fd:00 1442645
/usr/java/jdk1.5.0_22/jre/lib/amd64/server/libjvm.so
7f52d0e8e000-7f52d0f8d000 ---p 006dd000 fd:00 1442645
/usr/java/jdk1.5.0_22/jre/lib/amd64/server/libjvm.so
7f52d0f8d000-7f52d110a000 rw-p 006dc000 fd:00 1442645
/usr/java/jdk1.5.0_22/jre/lib/amd64/server/libjvm.so
7f52d110a000-7f52d1139000 rw-p 00000000 00:00 0
7f52d1139000-7f52d1167000 r-xp 00000000 fd:00 529367
/usr/pgsql-9.0/lib/pljava.so
7f52d1167000-7f52d1366000 ---p 0002e000 fd:00 529367
/usr/pgsql-9.0/lib/pljava.so
7f52d1366000-7f52d1369000 rw-p 0002d000 fd:00 529367
/usr/pgsql-9.0/lib/pljava.so
7f52d1369000-7f52d14cc000 rw-p 00000000 00:00 0
7f52d14cc000-7f52d14d8000 r-xp 00000000 fd:00 130845
/lib64/libnss_files-2.12.so
7f52d14d8000-7f52d16d7000 ---p 0000c000 fd:00 130845
/lib64/libnss_files-2.12.so
7f52d16d7000-7f52d16d8000 r--p 0000b000 fd:00 130845
/lib64/libnss_files-2.12.so
7f52d16d8000-7f52d16d9000 rw-p 0000c000 fd:00 130845
/lib64/libnss_files-2.12.so
7f52d16d9000-7f5354cd3000 rw-s 00000000 00:04 98304
/SYSV0052e2c1 (deleted)
7f5354cd3000-7f535ab64000 r--p 00000000 fd:00 413912
/usr/lib/locale/locale-archive
7f535ab64000-7f535ab70000 rw-p 00000000 00:00 0
7f535ab72000-7f535ab7a000 rw-s 00000000 fd:00 1444885
/tmp/hsperfdata_postgres/3933
7f535ab7a000-7f535ab7b000 rw-p 00000000 00:00 0
7f535ab7b000-7f535ab7c000 r--p 00000000 00:00 0
7f535ab7c000-7f535ab7d000 rw-p 00000000 00:00 0
7fffa8f6d000-7fffa8f70000 ---p 00000000 00:00 0
7fffa8f71000-7fffa916d000 rwxp 00000000 00:00 0
[stack]
7fffa916d000-7fffa916f000 rw-p 00000000 00:00 0
7fffa91ff000-7fffa9200000 r-xp 00000000 00:00 0
[vdso]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0
[vsyscall]

VM Arguments:
jvm_args: -Dsqlj.defaultconnection=jdbc:default:connection vfprintf -Xrs
java_command: <unknown>
Launcher Type: generic

Environment Variables:
PATH=/usr/lib64/qt-3.3/bin:/usr/java/jdk1.6.0_26/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin
SHELL=/bin/bash

Signal Handlers:
SIGSEGV: [libjvm.so+0x668110], sa_mask[0]=0x7ffbfeff, sa_flags=0x14000004
SIGBUS: [libjvm.so+0x668110], sa_mask[0]=0x7ffbfeff, sa_flags=0x14000004
SIGFPE: [libjvm.so+0x56e860], sa_mask[0]=0x7ffbfeff, sa_flags=0x14000004
SIGPIPE: [libjvm.so+0x56e860], sa_mask[0]=0x7ffbfeff, sa_flags=0x14000004
SIGILL: [libjvm.so+0x56e860], sa_mask[0]=0x7ffbfeff, sa_flags=0x14000004
SIGUSR1: [postgres: piercej lss [local] SELECT+0x1f2aa0],
sa_mask[0]=0x00000000, sa_flags=0x14000000
SIGUSR2: [libjvm.so+0x570710], sa_mask[0]=0x00000000, sa_flags=0x14000004
SIGHUP: [postgres: piercej lss [local] SELECT+0x2013f0],
sa_mask[0]=0x00000000, sa_flags=0x14000000
SIGINT: [pljava.so+0x22900], sa_mask[0]=0x00000000, sa_flags=0x14000000
SIGQUIT: [pljava.so+0x22cb0], sa_mask[0]=0x00000000, sa_flags=0x14000000
SIGTERM: [pljava.so+0x22930], sa_mask[0]=0x00000000, sa_flags=0x14000000

--------------- S Y S T E M ---------------

OS:CentOS Linux release 6.0 (Final)

uname:Linux 2.6.32-71.29.1.el6.x86_64 #1 SMP Mon Jun 27 19:49:27 BST
2011 x86_64
libc:glibc 2.12 NPTL 2.12
rlimit: STACK 10240k, CORE 0k, NPROC 1024, NOFILE 1024, AS infinity
load average:0.46 0.25 0.10

CPU:total 2 em64t

Memory: 4k page, physical 8194876k(6392400k free), swap
10305528k(10305528k free)

vm_info: Java HotSpot(TM) 64-Bit Server VM (1.5.0_22-b03) for
linux-amd64, built on Oct 9 2009 01:32:14 by java_re with gcc 3.2.2 (
SuSE Linux)

time: Tue Sep 27 13:34:40 2011
elapsed time: 0 seconds

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

John R Pierce <pierce at hogranch.com> writes:

>
> lss=# select sqlj.install_jar(
> '/home/XXXX/pljava-1.4.3/build/examples.jar', 'samples', true);
>

Here you probably need to prefix the path with 'file://', as in

lss=# sqlj.install_jar(
'file:///home/XXXX/pljava-1.4.3/build/examples.jar', 'samples', true);

> and k-rash, postgres goes down and recovers, leaving this lovely
> error log... any clues would be greatly appreciated...

That crash is however rather unfortunate. If the above fix works I
can work on "securing" the crash. If that doesn't work, there is a
more serious error somewhere.

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/

On 09/27/11 4:34 PM, Johann 'Myrkraverk' Oskarsson wrote:
> Here you probably need to prefix the path with 'file://', as in
>
> lss=# sqlj.install_jar(
> 'file:///home/XXXX/pljava-1.4.3/build/examples.jar', 'samples', true);
>
>> > and k-rash, postgres goes down and recovers, leaving this lovely
>> > error log... any clues would be greatly appreciated...
> That crash is however rather unfortunate. If the above fix works I
> can work on "securing" the crash. If that doesn't work, there is a
> more serious error somewhere.

hmmm.

In sql, I...

lss=# select
sqlj.install_jar('file:///home/piercej/pljava-1.4.3/build/examples.jar','samples',true);
The connection to the server was lost. Attempting reset: Failed.
!>

and java drops a different error...

$ more hs_err_pid5197.log
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
# SIGSEGV (0xb) at pc=0x00007f52ca3da552, pid=5197, tid=139995980908480
#
# Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_22-b03 mixed mode)
# Problematic frame:
# J java.lang.String.hashCode()I
#

--------------- T H R E A D ---------------

Current thread (0x0000000000d588a0): JavaThread "main"
[_thread_in_Java, id=5197]

siginfo:si_signo=11, si_errno=0, si_code=2, si_addr=0x00007f525ab7b000

Registers:
RAX=0x00000000b2cfc518, RBX=0x00007fffa916a6c0, RCX=0x00007f52b4ea0630,
RDX=0x00007f52ca3d8500
RSP=0x00007fffa916a698, RBP=0x00007fffa916a710, RSI=0x00007f52d101bca0,
RDI=0x00007fffa916a680
R8 =0x00007f52d101f608, R9 =0x00007f52d100b2a8, R10=0x0000000000000114,
R11=0x00007f535ab7a000
R12=0x00007fffa916a6f8, R13=0x00007f528525efdf, R14=0x00007fffa916a738,
R15=0x0000000000d588a0
RIP=0x00007f52ca3da552, EFL=0x0000000000010202,
CSGSFS=0x0000000000000033, ERR=0x0000000000000004
TRAPNO=0x000000000000000e

Top of Stack: (sp=0x00007fffa916a698)
0x00007fffa916a698: 00007f52ca3d851e 00007fffa916a710
0x00007fffa916a6a8: 00007fffa916a738 00007fffa916a710
0x00007fffa916a6b8: 00007fffa916a6c0 00007f52ca37be1a
0x00007fffa916a6c8: 00007f52b4ea0630 00007f52b4e9de08
0x00007fffa916a6d8: 00007fffa916a6d8 00007f528525efdf
0x00007fffa916a6e8: 00007fffa916a738 00007f528525f520
0x00007fffa916a6f8: 0000000000000000 00007f528525f038
0x00007fffa916a708: 00007fffa916a720 00007fffa916a788
0x00007fffa916a718: 00007f52ca37befe 00007f52b4d7ef60
0x00007fffa916a728: 00007f52b4ea0630 00007f52b4d82888
0x00007fffa916a738: 00007f52b4e9de08 0000000000000001
0x00007fffa916a748: 00007f52b4e9deb8 00007fffa916a740
0x00007fffa916a758: 00007f5285259b5d 00007fffa916a7c0
0x00007fffa916a768: 00007f528525dae0 0000000000000000
0x00007fffa916a778: 00007f5285259ba0 00007fffa916a7a8
0x00007fffa916a788: 00007fffa916a800 00007f52ca37befe
0x00007fffa916a798: 0000000000000000 00007f52b4e9deb8
0x00007fffa916a7a8: 00007f52b4ea0b00 00007f52b4d7ef60
0x00007fffa916a7b8: 00007f52b4ea0630 00007f52b4d82888
0x00007fffa916a7c8: 00007fffa916a7c8 00007f52852592aa
0x00007fffa916a7d8: 00007fffa916a848 00007f528525dae0
0x00007fffa916a7e8: 0000000000000000 00007f52852592d0
0x00007fffa916a7f8: 00007fffa916a828 00007fffa916a888
0x00007fffa916a808: 00007f52ca37bde1 0000000000000000
0x00007fffa916a818: 00007f52b4ea0630 0000000000000001
0x00007fffa916a828: 00007f52b4ea0b00 00007f52b4d7ef60
0x00007fffa916a838: 00007f52b4ea06c8 00007f52b4ea04a0
0x00007fffa916a848: 00007f52b4d82888 00007fffa916a850
0x00007fffa916a858: 00007f528525914d 00007fffa916a900
0x00007fffa916a868: 00007f528525dae0 0000000000000000
0x00007fffa916a878: 00007f52852591d0 00007fffa916a8f0
0x00007fffa916a888: 00007fffa916a940 00007f52ca37bde1

Instructions: (pc=0x00007f52ca3da552)
0x00007f52ca3da542: 45 3b d0 7c d9 eb 02 33 c0 89 41 20 48 83 c4 38
0x00007f52ca3da552: 85 05 a8 0a 7a 90 c3 4c 8b d9 48 89 6c 24 18 4c

Stack: [0x00007fffa8f6d000,0x00007fffa916d000), sp=0x00007fffa916a698,
free space=2037k
Native frames: (J=compiled Java code, j=interpreted, Vv=VM code,
C=native code)
J java.lang.String.hashCode()I
j
java.util.ResourceBundle.putBundleInCache(Ljava/lang/ClassLoader;Ljava/lang/String;Ljava/util/Locale;Ljava/lang/Object;)V+13
j
java.util.ResourceBundle.propagate(Ljava/lang/ClassLoader;Ljava/util/Vector;Ljava/util/Vector;Ljava/util/Locale;Ljava/lang/Object
;)Ljava/lang/Object;+42
j
java.util.ResourceBundle.getBundleImpl(Ljava/lang/String;Ljava/util/Locale;Ljava/lang/ClassLoader;)Ljava/util/ResourceBundle;+381
j
java.util.ResourceBundle.getBundle(Ljava/lang/String;Ljava/util/Locale;)Ljava/util/ResourceBundle;+5
j sun.text.resources.LocaleData$1.run()Ljava/lang/Object;+8
v ~StubRoutines::call_stub
V [libjvm.so+0x389df5]
V [libjvm.so+0x56f5f9]
V [libjvm.so+0x389c05]
V [libjvm.so+0x3eea2b]
C [libjava.so+0xcf7e]
Java_java_security_AccessController_doPrivileged__Ljava_security_PrivilegedAction_2+0xe
j
java.security.AccessController.doPrivileged(Ljava/security/PrivilegedAction;)Ljava/lang/Object;+0
j
sun.text.resources.LocaleData.getBundle(Ljava/lang/String;Ljava/util/Locale;)Ljava/util/ResourceBundle;+9
j
sun.text.resources.LocaleData.getDateFormatZoneData(Ljava/util/Locale;)Ljava/util/ResourceBundle;+3
j
java.text.DateFormatSymbols.cacheLookup(Ljava/util/Locale;)[Ljava/util/ResourceBundle;+33
j java.text.DateFormatSymbols.initializeData(Ljava/util/Locale;)V+2
j java.text.DateFormatSymbols.<init>(Ljava/util/Locale;)V+49
j
java.util.TimeZone.retrieveDisplayNames(Ljava/lang/String;Ljava/util/Locale;)[Ljava/lang/String;+5
j
java.util.TimeZone.getDisplayNames(Ljava/lang/String;Ljava/util/Locale;)[Ljava/lang/String;+82
j
java.util.TimeZone.getDisplayName(ZILjava/util/Locale;)Ljava/lang/String;+45
j java.util.Date.toString()Ljava/lang/String;+157
j java.util.Properties.store(Ljava/io/OutputStream;Ljava/lang/String;)V+65
j org.postgresql.pljava.internal.ELogHandler.init()V+63
j org.postgresql.pljava.internal.Session.init()J+0
v ~StubRoutines::call_stub
V [libjvm.so+0x389df5]
V [libjvm.so+0x56f5f9]
V [libjvm.so+0x389c05]
V [libjvm.so+0x3b7595]
V [libjvm.so+0x3a6907]

(etc etc etc..... is this enough?)

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

On 09/27/11 5:13 PM, John R Pierce wrote:
>
> lss=# select
> sqlj.install_jar('file:///home/piercej/pljava-1.4.3/build/examples.jar','samples',true);
>
> The connection to the server was lost. Attempting reset: Failed.
> !>
>
> and java drops a different error...
>
> $ more hs_err_pid5197.log
> #
> # An unexpected error has been detected by HotSpot Virtual Machine:
> #
> # SIGSEGV (0xb) at pc=0x00007f52ca3da552, pid=5197, tid=139995980908480
> #
> # Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_22-b03 mixed mode)
> # Problematic frame:
> # J java.lang.String.hashCode()I
> #

I'm still stuck here... pg 9.0.5, centos 6.0, Sun jdk 1.5.0_26, all 64bit.

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