[Pljava-dev] help :pljava sqlj.install_jar('path', 'jarname', true) running infinitely

From: bhaskar_nalamothu at pro-hemns(dot)com (Nalamothu, Bhaskar)
To:
Subject: [Pljava-dev] help :pljava sqlj.install_jar('path', 'jarname', true) running infinitely
Date: 2012-10-23 04:43:07
Message-ID: CAOxerh7GyNNzdWSNe0cRsr6_BCtQk7pCa90bNx9HW0vtVNS09A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

Its creating error file into the data folder as follows

#
# A fatal error has been detected by the Java Runtime Environment:
#
# EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x0041384c, pid=4028,
tid=1496
#
# 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]
#
# If you would like to submit a bug report, please visit:
# http://java.sun.com/webapps/bugreport/crash.jsp
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#
--------------- T H R E A D ---------------
Current thread (0x01509000): JavaThread "main" [_thread_in_native,
id=1496, stack(0x008c0000,0x00cc0000)]
siginfo: ExceptionCode=0xc0000005, reading address 0x000002bd
Registers:
EAX=0x00000001, EBX=0x00000000, ECX=0x0000001a, EDX=0x01c664f0
ESP=0x00cbeecc, EBP=0x01f040d0, ESI=0x000002bd, EDI=0x01f040f0
EIP=0x0041384c, EFLAGS=0x00010202
Top of Stack: (sp=0x00cbeecc)
0x00cbeecc: 00000000 00000000 00cbeef8 01ef9458
0x00cbeedc: 67d11b21 01c659e0 01509110 00cbef08
0x00cbeeec: 67d062ec 01509110 000014d9 00cbef08
0x00cbeefc: 67d11b77 01c659e0 01c751a0 00cbef28
0x00cbef0c: 67d0f36a 01c659e0 28546178 28546180
0x00cbef1c: 28546180 28546178 01509000 00cbef60
0x00cbef2c: 04c39e37 01509110 00cbef68 01c751a0
0x00cbef3c: 00000000 00cbef40 28546178 00cbef74
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=0x00cbeecc, 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.<init>(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 )
0x01d35c00 JavaThread "Low Memory Detector" daemon [_thread_blocked,
id=2668, stack(0x08bc0000,0x08fc0000)]
0x01d2f800 JavaThread "CompilerThread0" daemon [_thread_blocked, id=1464,
stack(0x08780000,0x08b80000)]
0x01d24400 JavaThread "Attach Listener" daemon [_thread_blocked, id=2108,
stack(0x08340000,0x08740000)]
0x01ce6400 JavaThread "Finalizer" daemon [_thread_blocked, id=3216,
stack(0x07540000,0x07940000)]
0x01ce1c00 JavaThread "Reference Handler" daemon [_thread_blocked,
id=2784, stack(0x07100000,0x07500000)]
=>0x01509000 JavaThread "main" [_thread_in_native, id=1496,
stack(0x008c0000,0x00cc0000)]
Other Threads:
0x01ce0400 VMThread [stack: 0x06cc0000,0x070c0000] [id=3624]
0x01d37800 WatcherThread [stack: 0x09000000,0x09400000] [id=3228]
VM state:not at safepoint (normal execution)
VM Mutex/Monitor currently owned by a thread: None
Heap
def new generation total 960K, used 560K [0x24500000, 0x24600000,
0x249e0000)
eden space 896K, 55% used [0x24500000, 0x2457c1d8, 0x245e0000)
from space 64K, 99% used [0x245f0000, 0x245ffff8, 0x24600000)
to space 64K, 0% used [0x245e0000, 0x245e0000, 0x245f0000)
tenured generation total 4096K, used 85K [0x249e0000, 0x24de0000,
0x28500000)
the space 4096K, 2% used [0x249e0000, 0x249f5610, 0x249f5800,
0x24de0000)
compacting perm gen total 12288K, used 612K [0x28500000, 0x29100000,
0x2c500000)
the space 12288K, 4% used [0x28500000, 0x28599008, 0x28599200,
0x29100000)
ro space 8192K, 63% used [0x2c500000, 0x2ca196b0, 0x2ca19800,
0x2cd00000)
rw space 12288K, 53% used [0x2cd00000, 0x2d374b80, 0x2d374c00,
0x2d900000)
Dynamic libraries:
0x00400000 - 0x008b5000 C:\Program Files
(x86)\PostgreSQL\8.4\bin\postgres.exe
0x76fc0000 - 0x77140000 C:\Windows\SysWOW64\ntdll.dll
0x74e00000 - 0x74f00000 C:\Windows\syswow64\kernel32.dll
0x74db0000 - 0x74df6000 C:\Windows\syswow64\KERNELBASE.dll
0x10000000 - 0x10034000 C:\Program Files
(x86)\PostgreSQL\8.4\bin\SSLEAY32.dll
0x00cc0000 - 0x00dbf000 C:\Program Files
(x86)\PostgreSQL\8.4\bin\LIBEAY32.dll
0x73090000 - 0x73097000 C:\Windows\system32\WSOCK32.dll
0x76a80000 - 0x76ab5000 C:\Windows\syswow64\WS2_32.dll
0x767e0000 - 0x7688c000 C:\Windows\syswow64\msvcrt.dll
0x74cb0000 - 0x74da0000 C:\Windows\syswow64\RPCRT4.dll
0x74b30000 - 0x74b90000 C:\Windows\syswow64\SspiCli.dll
0x74b20000 - 0x74b2c000 C:\Windows\syswow64\CRYPTBASE.dll
0x74f50000 - 0x74f69000 C:\Windows\SysWOW64\sechost.dll
0x74da0000 - 0x74da6000 C:\Windows\syswow64\NSI.dll
0x76750000 - 0x767e0000 C:\Windows\syswow64\GDI32.dll
0x76ac0000 - 0x76bc0000 C:\Windows\syswow64\USER32.dll
0x75120000 - 0x751c0000 C:\Windows\syswow64\ADVAPI32.dll
0x75ea0000 - 0x75eaa000 C:\Windows\syswow64\LPK.dll
0x76070000 - 0x7610d000 C:\Windows\syswow64\USP10.dll
0x72ff0000 - 0x7308b000
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
0x000d0000 - 0x000d7000 C:\Program Files
(x86)\PostgreSQL\8.4\bin\comerr32.dll
0x000e0000 - 0x000e8000 C:\Program Files
(x86)\PostgreSQL\8.4\bin\k5sprt32.dll
0x7c340000 - 0x7c396000 C:\Program Files
(x86)\PostgreSQL\8.4\bin\MSVCR71.dll
0x00170000 - 0x00191000 C:\Program Files
(x86)\PostgreSQL\8.4\bin\gssapi32.dll
0x00dc0000 - 0x00eb1000 C:\Program Files
(x86)\PostgreSQL\8.4\bin\libxml2.dll
0x00310000 - 0x003e9000 C:\Program Files (x86)\PostgreSQL\8.4\bin\iconv.dll
0x00ec0000 - 0x00ed3000 C:\Program Files (x86)\PostgreSQL\8.4\bin\zlib1.dll
0x73230000 - 0x73238000 C:\Windows\system32\Secur32.dll
0x74f00000 - 0x74f45000 C:\Windows\syswow64\WLDAP32.dll
0x76230000 - 0x76290000 C:\Windows\system32\IMM32.DLL
0x769b0000 - 0x76a7c000 C:\Windows\syswow64\MSCTF.dll
0x72f60000 - 0x72f9c000 C:\Windows\system32\mswsock.dll
0x72f50000 - 0x72f55000 C:\Windows\System32\wshtcpip.dll
0x72f40000 - 0x72f46000 C:\Windows\System32\wship6.dll
0x67d00000 - 0x67d2a000 C:\Program Files
(x86)\PostgreSQL\8.4\lib\pljava.dll
0x6d800000 - 0x6da8b000 C:\Program Files (x86)\Java\jre6\bin\client\jvm.dll
0x72d70000 - 0x72da2000 C:\Windows\system32\WINMM.dll
0x72fa0000 - 0x72feb000 C:\Windows\system32\apphelp.dll
0x6d7b0000 - 0x6d7bc000 C:\Program Files (x86)\Java\jre6\bin\verify.dll
0x6d330000 - 0x6d34f000 C:\Program Files (x86)\Java\jre6\bin\java.dll
0x6d290000 - 0x6d298000 C:\Program Files (x86)\Java\jre6\bin\hpi.dll
0x75110000 - 0x75115000 C:\Windows\syswow64\PSAPI.DLL
0x6d7f0000 - 0x6d7ff000 C:\Program Files (x86)\Java\jre6\bin\zip.dll
0x751c0000 - 0x75e09000 C:\Windows\syswow64\SHELL32.DLL
0x74c20000 - 0x74c77000 C:\Windows\syswow64\SHLWAPI.dll
0x75ee0000 - 0x7603c000 C:\Windows\syswow64\ole32.dll
0x722b0000 - 0x7244e000
C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7600.16385_none_421189da2b7fabfc\comctl32.dll
0x76490000 - 0x7651f000 C:\Windows\syswow64\OLEAUT32.dll
0x74f70000 - 0x7510d000 C:\Windows\syswow64\SETUPAPI.dll
0x76040000 - 0x76067000 C:\Windows\syswow64\CFGMGR32.dll
0x76890000 - 0x768a2000 C:\Windows\syswow64\DEVOBJ.dll
0x74b90000 - 0x74c13000 C:\Windows\syswow64\CLBCatQ.DLL
0x73d80000 - 0x73e75000 C:\Windows\system32\propsys.dll
VM Arguments:
jvm_args: -Dsqlj.defaultconnection=jdbc:default:connection vfprintf -Xrs
java_command: <unknown>
Launcher Type: generic
Environment Variables:
CLASSPATH=C:\Program Files (x86)\PostgreSQL\8.4\lib
PATH=C:\Program Files (x86)\JavaFX\javafx-sdk1.2\bin;C:\Program Files
(x86)\JavaFX\javafx-sdk1.2\emulator\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;PATH;C:\Program
Files (x86)\Java\;C:\IIS-Aid\PHP;C:\Program Files
(x86)\Java\jdk1.6.0_14\jre\bin;C:\Program Files
(x86)\PostgreSQL\8.4\bin;C:\Program Files
(x86)\PostgreSQL\8.4\lib;C:\Program Files (x86)\Java\jre6\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 Build 7600
CPU:total 2 (2 cores per cpu, 1 threads per core) family 6 model 15
stepping 13, cmov, cx8, fxsr, mmx, sse, sse2, sse3, ssse3
Memory: 4k page, physical 1013736k(184852k free), swap 2062312k(1178216k
free)
vm_info: Java HotSpot(TM) Client VM (14.0-b16) for windows-x86 JRE
(1.6.0_14-b08), built on May 21 2009 08:03:56 by "java_re" with MS VC++ 7.1
time: Mon Oct 22 19:10:13 2012
elapsed time: 1 seconds

--
Sudha Bhaskar N
Procreate Techno Systems pvt ltd
+91-9948-678-222

On Mon, Oct 22, 2012 at 7:49 PM, Hal Hildebrand <hal.hildebrand at me.com>wrote:

> Can you provide the contents of the error file you receive?
>
> Sent from my Tricorder
>
> On Oct 22, 2012, at 7:11 AM, "Nalamothu, Bhaskar" <
> bhaskar_nalamothu at pro-hemns.com> wrote:
>
> Dear Dev Team,
>
> I am trying to configure PL/JAVA, my environment details are as follows
>
> 1. OS:Windows7 32 bit, postgres 8.4.11
> 2. Env variables path settings:
>
> C:\Program Files (x86)\Java\jdk1.6.0_14\jre\bin;C:\Program Files
> (x86)\PostgreSQL\8.4\bin;C:\Program Files
> (x86)\PostgreSQL\8.4\lib;C:\Program Files (x86)\Java\jre6\bin\client
>
> 3.i have enabled PL services using install.sql
>
> 4. When i am loading select pljava
> sqlj.install_jar('path','jarname',true), process running infinitely and
> returning a error file in data folder.
>
> --
> Sudha Bhaskar N
> Procreate Techno Systems pvt ltd
> +91-9948-678-222
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20121023/13565abc/attachment.html>

In response to

Responses

Browse pljava-dev by date

  From Date Subject
Next Message John R Pierce 2012-10-23 08:50:04 [Pljava-dev] help :pljava sqlj.install_jar('path', 'jarname', true) running infinitely
Previous Message Hal Hildebrand 2012-10-22 14:19:59 [Pljava-dev] help :pljava sqlj.install_jar('path', 'jarname', true) running infinitely