From: hal.hildebrand at me.com (Hal Hildebrand) Date: Tue, 23 Oct 2012 07:16:44 -0700 Subject: [Pljava-dev] help :pljava sqlj.install_jar('path', 'jarname', true) running infinitely In-Reply-To: References: <50865A3C.7030008@hogranch.com> <55406A22-4853-41AE-A73B-02C93E08EA54@me.com> Message-ID: <73653634-008E-4941-B7E9-9DBEA84412B2@me.com> Did you build these binaries or pull them. I'm not as up on pljava internals as I should be, but it looks like you're running Postgres 8.4. Any reason for that? Can you move to at least 9.1? Might be worth a try. Sent from my Tricorder On Oct 23, 2012, at 5:08 AM, "Nalamothu, Bhaskar" wrote: > Thanks for the qucik replies. It still returning me the same error even with jdk 1.5. > > was there anything wrong with environment variables setting.I have configured env variables in system variables as follows > > path:C:\Program Files (x86)\Java\jdk1.5.0_22\jre\bin;C:\Program Files (x86)\PostgreSQL\8.4\bin;C:\Program Files (x86)\PostgreSQL\8.4\lib;C:\Program Files (x86)\Java\jre1.5.0_22\bin\client > > CLASSPATH:C:\Program Files (x86)\PostgreSQL\8.4\lib;C:\Program Files (x86)\PostgreSQL\8.4\lib\pljava.jar;C:\Program Files (x86)\Java\jdk1.5.0_22\jre\lib\rt.jar > > please find the below error with jdk 1.5 > > # > # An unexpected error has been detected by HotSpot Virtual Machine: > # > # EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x0041384c, pid=3736, tid=1612 > # > # Java VM: Java HotSpot(TM) Client VM (1.5.0_22-b03 mixed mode, sharing) > # Problematic frame: > # C [postgres.exe+0x1384c] > # > > --------------- T H R E A D --------------- > > Current thread (0x04b61768): JavaThread "main" [_thread_in_native, id=1612] > > siginfo: ExceptionCode=0xc0000005, reading address 0x000002bd > > Registers: > EAX=0x00000001, EBX=0x00000000, ECX=0x0000001a, EDX=0x015164e0 > ESP=0x00cbef34, EBP=0x048e40d0, ESI=0x000002bd, EDI=0x048e40f0 > EIP=0x0041384c, EFLAGS=0x00010202 > > Top of Stack: (sp=0x00cbef34) > 0x00cbef34: 00000000 00000000 00cbef60 048d9458 > 0x00cbef44: 67d11b21 015159d0 04b61828 00cbef70 > 0x00cbef54: 67d062ec 04b61828 6d64b174 00cbef70 > 0x00cbef64: 67d11b77 015159d0 01525190 00cbef90 > 0x00cbef74: 67d0f36a 015159d0 6d6c3908 04b61768 > 0x00cbef84: 28079528 28079520 04b61768 00cbefc4 > 0x00cbef94: 04c582ff 04b61828 00cbefcc 01525190 > 0x00cbefa4: 00000000 00cbefa8 28079520 00cbefd8 > > Instructions: (pc=0x0041384c) > 0x0041383c: 7d 04 8b 34 82 8b 3c 87 b9 1a 00 00 00 83 c0 01 > 0x0041384c: f3 a5 3b 45 00 7c e1 85 db 0f 84 14 01 00 00 a1 > > > Stack: [0x008c0000,0x00cc0000), sp=0x00cbef34, free space=4091k > Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code) > C [postgres.exe+0x1384c] > > Java frames: (J=compiled Java code, j=interpreted, Vv=VM code) > j org.postgresql.pljava.internal.Portal._getTupleDesc(J)Lorg/postgresql/pljava/internal/TupleDesc;+0 > j org.postgresql.pljava.internal.Portal.getTupleDesc()Lorg/postgresql/pljava/internal/TupleDesc;+10 > j org.postgresql.pljava.jdbc.SPIResultSet.(Lorg/postgresql/pljava/jdbc/SPIStatement;Lorg/postgresql/pljava/internal/Portal;I)V+25 > j org.postgresql.pljava.jdbc.SPIStatement.executePlan(Lorg/postgresql/pljava/internal/ExecutionPlan;[Ljava/lang/Object;)Z+42 > j org.postgresql.pljava.jdbc.SPIPreparedStatement.execute()Z+62 > j org.postgresql.pljava.jdbc.SPIPreparedStatement.executeQuery()Ljava/sql/ResultSet;+1 > j org.postgresql.pljava.sqlj.Loader.getSchemaLoader(Ljava/lang/String;)Ljava/lang/ClassLoader;+90 > j org.postgresql.pljava.sqlj.Loader.getTypeMap(Ljava/lang/String;)Ljava/util/Map;+54 > v ~StubRoutines::call_stub > > --------------- P R O C E S S --------------- > > Java Threads: ( => current thread ) > 0x04bdda30 JavaThread "Low Memory Detector" daemon [_thread_blocked, id=2692] > 0x04c0b948 JavaThread "CompilerThread0" daemon [_thread_blocked, id=3772] > 0x04bdbbc0 JavaThread "Finalizer" daemon [_thread_blocked, id=2996] > 0x04bdadf8 JavaThread "Reference Handler" daemon [_thread_blocked, id=3528] > =>0x04b61768 JavaThread "main" [_thread_in_native, id=1612] > > Other Threads: > 0x04bd9988 VMThread [id=3592] > 0x04bc9df8 WatcherThread [id=3960] > > VM state:not at safepoint (normal execution) > > VM Mutex/Monitor currently owned by a thread: None > > Heap > def new generation total 576K, used 523K [0x24040000, 0x240e0000, 0x24520000) > eden space 512K, 99% used [0x24040000, 0x240bfc10, 0x240c0000) > from space 64K, 19% used [0x240c0000, 0x240c3228, 0x240d0000) > to space 64K, 0% used [0x240d0000, 0x240d0000, 0x240e0000) > tenured generation total 1408K, used 144K [0x24520000, 0x24680000, 0x28040000) > the space 1408K, 10% used [0x24520000, 0x24544070, 0x24544200, 0x24680000) > compacting perm gen total 8192K, used 457K [0x28040000, 0x28840000, 0x2c040000) > the space 8192K, 5% used [0x28040000, 0x280b2638, 0x280b2800, 0x28840000) > ro space 8192K, 63% used [0x2c040000, 0x2c553e78, 0x2c554000, 0x2c840000) > rw space 12288K, 47% used [0x2c840000, 0x2cde8b00, 0x2cde8c00, 0x2d440000) > > Dynamic libraries: > 0x00400000 - 0x008b5000 C:\Program Files (x86)\PostgreSQL\8.4\bin\postgres.exe > 0x77af0000 - 0x77c70000 C:\Windows\SysWOW64\ntdll.dll > 0x76dd0000 - 0x76ed0000 C:\Windows\syswow64\kernel32.dll > 0x77370000 - 0x773b6000 C:\Windows\syswow64\KERNELBASE.dll > 0x10000000 - 0x10034000 C:\Program Files (x86)\PostgreSQL\8.4\bin\SSLEAY32.dll > 0x00130000 - 0x0022f000 C:\Program Files (x86)\PostgreSQL\8.4\bin\LIBEAY32.dll > 0x74f20000 - 0x74f27000 C:\Windows\system32\WSOCK32.dll > 0x76ac0000 - 0x76af5000 C:\Windows\syswow64\WS2_32.dll > 0x774b0000 - 0x7755c000 C:\Windows\syswow64\msvcrt.dll > 0x76880000 - 0x76970000 C:\Windows\syswow64\RPCRT4.dll > 0x75660000 - 0x756c0000 C:\Windows\syswow64\SspiCli.dll > 0x75650000 - 0x7565c000 C:\Windows\syswow64\CRYPTBASE.dll > 0x76330000 - 0x76349000 C:\Windows\SysWOW64\sechost.dll > 0x76b00000 - 0x76b06000 C:\Windows\syswow64\NSI.dll > 0x76450000 - 0x764e0000 C:\Windows\syswow64\GDI32.dll > 0x76350000 - 0x76450000 C:\Windows\syswow64\USER32.dll > 0x77280000 - 0x77320000 C:\Windows\syswow64\ADVAPI32.dll > 0x76310000 - 0x7631a000 C:\Windows\syswow64\LPK.dll > 0x767e0000 - 0x7687d000 C:\Windows\syswow64\USP10.dll > 0x74e80000 - 0x74f1b000 C:\Windows\WinSxS\x86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4927_none_d08a205e442db5b5\MSVCR80.dll > 0x61cc0000 - 0x61cd3000 C:\Program Files (x86)\PostgreSQL\8.4\bin\libintl-8.dll > 0x66000000 - 0x660e7000 C:\Program Files (x86)\PostgreSQL\8.4\bin\libiconv-2.dll > 0x1c000000 - 0x1c09b000 C:\Program Files (x86)\PostgreSQL\8.4\bin\krb5_32.dll > 0x00240000 - 0x00247000 C:\Program Files (x86)\PostgreSQL\8.4\bin\comerr32.dll > 0x00250000 - 0x00258000 C:\Program Files (x86)\PostgreSQL\8.4\bin\k5sprt32.dll > 0x7c340000 - 0x7c396000 C:\Program Files (x86)\PostgreSQL\8.4\bin\MSVCR71.dll > 0x002e0000 - 0x00301000 C:\Program Files (x86)\PostgreSQL\8.4\bin\gssapi32.dll > 0x00cc0000 - 0x00db1000 C:\Program Files (x86)\PostgreSQL\8.4\bin\libxml2.dll > 0x00310000 - 0x003e9000 C:\Program Files (x86)\PostgreSQL\8.4\bin\iconv.dll > 0x00dc0000 - 0x00dd3000 C:\Program Files (x86)\PostgreSQL\8.4\bin\zlib1.dll > 0x750c0000 - 0x750c8000 C:\Windows\system32\Secur32.dll > 0x77320000 - 0x77365000 C:\Windows\syswow64\WLDAP32.dll > 0x773c0000 - 0x77420000 C:\Windows\system32\IMM32.DLL > 0x769d0000 - 0x76a9c000 C:\Windows\syswow64\MSCTF.dll > 0x74d50000 - 0x74d8c000 C:\Windows\system32\mswsock.dll > 0x74d40000 - 0x74d45000 C:\Windows\System32\wshtcpip.dll > 0x74d30000 - 0x74d36000 C:\Windows\System32\wship6.dll > 0x67d00000 - 0x67d2a000 C:\Program Files (x86)\PostgreSQL\8.4\lib\pljava.dll > 0x6d640000 - 0x6d7de000 C:\Program Files (x86)\Java\jre1.5.0_22\bin\client\jvm.dll > 0x74c00000 - 0x74c32000 C:\Windows\system32\WINMM.dll > 0x74e30000 - 0x74e7b000 C:\Windows\system32\apphelp.dll > 0x6d290000 - 0x6d298000 C:\Program Files (x86)\Java\jre1.5.0_22\bin\hpi.dll > 0x76320000 - 0x76325000 C:\Windows\syswow64\PSAPI.DLL > 0x6d610000 - 0x6d61c000 C:\Program Files (x86)\Java\jre1.5.0_22\bin\verify.dll > 0x6d310000 - 0x6d32d000 C:\Program Files (x86)\Java\jre1.5.0_22\bin\java.dll > 0x6d630000 - 0x6d63f000 C:\Program Files (x86)\Java\jre1.5.0_22\bin\zip.dll > 0x756c0000 - 0x76309000 C:\Windows\syswow64\SHELL32.DLL > 0x76c60000 - 0x76cb7000 C:\Windows\syswow64\SHLWAPI.dll > 0x77590000 - 0x776ec000 C:\Windows\syswow64\ole32.dll > 0x72db0000 - 0x72f4e000 C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7600.16385_none_421189da2b7fabfc\comctl32.dll > 0x76f30000 - 0x76fbf000 C:\Windows\syswow64\OLEAUT32.dll > 0x76fc0000 - 0x7715d000 C:\Windows\syswow64\SETUPAPI.dll > 0x76970000 - 0x76997000 C:\Windows\syswow64\CFGMGR32.dll > 0x76aa0000 - 0x76ab2000 C:\Windows\syswow64\DEVOBJ.dll > 0x76d40000 - 0x76dc3000 C:\Windows\syswow64\CLBCatQ.DLL > 0x74280000 - 0x74375000 C:\Windows\system32\propsys.dll > > VM Arguments: > jvm_args: -Dsqlj.defaultconnection=jdbc:default:connection vfprintf -Xrs > java_command: > Launcher Type: generic > > Environment Variables: > CLASSPATH=C:\Program Files (x86)\PostgreSQL\8.4\lib;C:\Program Files (x86)\PostgreSQL\8.4\lib\pljava.jar;C:\Program Files (x86)\Java\jdk1.5.0_22\jre\lib\rt.jar > PATH=C:\Program Files (x86)\Java\jdk1.5.0_22\jre\bin;C:\Program Files (x86)\PostgreSQL\8.4\bin;C:\Program Files (x86)\PostgreSQL\8.4\lib;C:\Program Files (x86)\Java\jre1.5.0_22\bin\client > USERNAME=postgres > OS=Windows_NT > PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 15 Stepping 13, GenuineIntel > > > > --------------- S Y S T E M --------------- > > OS: Windows 7 , 64 bit Build 7600 > > CPU:total 2 (cores per cpu 2, threads per core 1) family 6 model 15 stepping 13, cmov, cx8, fxsr, mmx, sse, sse2 > > Memory: 4k page, physical 1013736k(222956k free), swap 2062312k(996460k free) > > vm_info: Java HotSpot(TM) Client VM (1.5.0_22-b03) for windows-x86, built on Oct 9 2009 01:15:45 by "java_re" with MS VC++ 6.0 > > time: Tue Oct 23 17:31:51 2012 > elapsed time: 3 seconds > > > -- > Sudha Bhaskar N > Procreate Techno Systems pvt ltd > +91-9948-678-222 > > > > On Tue, Oct 23, 2012 at 5:21 PM, Hal Hildebrand wrote: >> I successfully use 1.6, but only on Linux. >> >> Also, I should point out that 1.6 has been eol'd by oracle. Has pl/java stalled or....? >> >> Sent from my Tricorder >> >> On Oct 23, 2012, at 1:50 AM, John R Pierce wrote: >> >> > On 10/22/12 9:43 PM, Nalamothu, Bhaskar wrote: >> >> # JRE version: 6.0_14-b08 >> >> # Java VM: Java HotSpot(TM) Client VM (14.0-b16 mixed mode, sharing windows-x86 ) >> >> # Problematic frame: >> >> # C [postgres.exe+0x1384c] >> > >> > last I heard, pljava only supports JRE 1.4 or 5, not 6. >> > >> > >> > >> > -- >> > john r pierce N 37, W 122 >> > santa cruz ca mid-left coast >> > >> > _______________________________________________ >> > Pljava-dev mailing list >> > Pljava-dev at pgfoundry.org >> > http://pgfoundry.org/mailman/listinfo/pljava-dev >> _______________________________________________ >> Pljava-dev mailing list >> Pljava-dev at pgfoundry.org >> http://pgfoundry.org/mailman/listinfo/pljava-dev > -------------- next part -------------- An HTML attachment was scrubbed... URL: