From: p.peisker at web.de (Patrick Peisker) Date: Wed, 22 Feb 2006 09:03:09 +0100 Subject: [Pljava-dev] Multithreading Message-ID: <802199725@web.de> Hi, i use the PL/Java 1.1.0 released and here are some logs: postgresql-2006-XX-XX_XXXXXXX.log: 2006-02-22 08:48:04 INFO: 22 Feb 06 08:48:04 core.ManageNotifyThread [ManageNotifyThread.createThread] Start creating thread 2006-02-22 08:48:04 INFO: 22 Feb 06 08:48:04 core.ManageNotifyThread [ManageNotifyThread.createThread] End of creating thread 2006-02-22 08:48:04 INFO: 22 Feb 06 08:48:04 core.NotifyThread [NotifyThread.run] Runs ... 2006-02-22 08:48:04 INFO: 22 Feb 06 08:48:04 core.NotifyThread [NotifyThread.run] Events.size: 5 2006-02-22 08:48:04 INFO: 22 Feb 06 08:48:04 core.NotifyThread [NotifyThread.run] Start calling webservice! 2006-02-22 08:48:04 INFO: 22 Feb 06 08:48:04 core.NotifyThread [NotifyThread.run] Webservice: Create Service! 2006-02-22 08:48:04 LOG: server process (PID 1476) was terminated by signal 1 2006-02-22 08:48:04 LOG: terminating any other active server processes 2006-02-22 08:48:04 WARNING: terminating connection because of crash of another server process 2006-02-22 08:48:04 DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. 2006-02-22 08:48:04 HINT: In a moment you should be able to reconnect to the database and repeat your command. 2006-02-22 08:48:04 LOG: all server processes terminated; reinitializing 2006-02-22 08:48:04 LOG: database system was interrupted at 2006-02-22 08:47:17 Westeurop?ische Normalzeit 2006-02-22 08:48:04 LOG: checkpoint record is at 0/363D9BF0 2006-02-22 08:48:04 LOG: redo record is at 0/363D9BF0; undo record is at 0/0; shutdown TRUE 2006-02-22 08:48:04 LOG: next transaction ID: 13585; next OID: 256247 2006-02-22 08:48:04 LOG: next MultiXactId: 1; next MultiXactOffset: 0 2006-02-22 08:48:04 LOG: database system was not properly shut down; automatic recovery in progress 2006-02-22 08:48:04 LOG: redo starts at 0/363D9C38 2006-02-22 08:48:04 LOG: record with zero length at 0/3673EB88 2006-02-22 08:48:04 LOG: redo done at 0/3673EB58 2006-02-22 08:48:05 LOG: database system is ready 2006-02-22 08:48:05 LOG: transaction ID wrap limit is 2147484148, limited by database "postgres" hs_err_pid1476.log: # # An unexpected error has been detected by HotSpot Virtual Machine: # # EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x6dd02b5d, pid=1476, tid=1224 # # Java VM: Java HotSpot(TM) Client VM (1.5.0_04-b05 mixed mode) # Problematic frame: # C [libpljava.dll+0x2b5d] # --------------- T H R E A D --------------- Current thread (0x024d2308): JavaThread "NotifyThread" [_thread_in_native, id=1224] siginfo: ExceptionCode=0xc0000005, reading address 0x00000004 Registers: EAX=0x00000000, EBX=0x0880e7c8, ECX=0x0e482b00, EDX=0x0880eae8 ESP=0x0efbf680, EBP=0x0efbf680, ESI=0x0880e7c8, EDI=0x024d2308 EIP=0x6dd02b5d, EFLAGS=0x00010206 Top of Stack: (sp=0x0efbf680) 0x0efbf680: 0efbf6ac 025f826f 024d23c4 0efbf6b4 0x0efbf690: 0efbf690 00000000 0efbf6b8 0880eae8 0x0efbf6a0: 00000000 0880e7c8 0efbf6bc 0efbf6e0 0x0efbf6b0: 025f29fa 0880ea90 025f6453 08000001 0x0efbf6c0: 04b65230 0efbf6bc 0880e5ae 0efbf700 0x0efbf6d0: 0880eae8 00000000 0880e638 0efbf704 0x0efbf6e0: 0efbf720 025f29fa 00000000 00000000 0x0efbf6f0: 00000000 00000000 00000000 00000000 Instructions: (pc=0x6dd02b5d) 0x6dd02b4d: 68 80 d1 6d 5d c2 08 00 55 89 e5 a1 c0 8e d1 6d 0x6dd02b5d: 8b 40 04 5d c2 08 00 55 89 e5 a1 c0 8e d1 6d c6 Stack: [0x0ebc0000,0x0efc0000), sp=0x0efbf680, free space=4093k Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code) C [libpljava.dll+0x2b5d] j org.postgresql.pljava.jdbc.Invocation._getCurrent()Lorg/postgresql/pljava/jdbc/Invocation;+0 j org.postgresql.pljava.jdbc.Invocation.current()Lorg/postgresql/pljava/jdbc/Invocation;+6 j org.postgresql.pljava.jdbc.SPIConnection.prepareStatement(Ljava/lang/String;)Ljava/sql/PreparedStatement;+45 j org.postgresql.pljava.sqlj.Loader.findClass(Ljava/lang/String;)Ljava/lang/Class;+52 j java.lang.ClassLoader.loadClass(Ljava/lang/String;Z)Ljava/lang/Class;+43 j java.lang.ClassLoader.loadClass(Ljava/lang/String;)Ljava/lang/Class;+3 j java.lang.ClassLoader.loadClassInternal(Ljava/lang/String;)Ljava/lang/Class;+2 v ~StubRoutines::call_stub V [jvm.dll+0x82696] V [jvm.dll+0xd6fd9] V [jvm.dll+0x82567] V [jvm.dll+0x8240f] V [jvm.dll+0xf3dde] V [jvm.dll+0xf3668] V [jvm.dll+0xf3152] V [jvm.dll+0xf305e] V [jvm.dll+0x5fdfd] V [jvm.dll+0x7d113] j core.NotifyThread.run()V+76 v ~StubRoutines::call_stub V [jvm.dll+0x82696] V [jvm.dll+0xd6fd9] V [jvm.dll+0x82567] V [jvm.dll+0x822c4] V [jvm.dll+0x9d216] V [jvm.dll+0x101489] V [jvm.dll+0x101457] C [MSVCRT.dll+0x85bc] C [KERNEL32.dll+0xb388] Java frames: (J=compiled Java code, j=interpreted, Vv=VM code) j org.postgresql.pljava.jdbc.Invocation._getCurrent()Lorg/postgresql/pljava/jdbc/Invocation;+0 j org.postgresql.pljava.jdbc.Invocation.current()Lorg/postgresql/pljava/jdbc/Invocation;+6 j org.postgresql.pljava.jdbc.SPIConnection.prepareStatement(Ljava/lang/String;)Ljava/sql/PreparedStatement;+45 j org.postgresql.pljava.sqlj.Loader.findClass(Ljava/lang/String;)Ljava/lang/Class;+52 j java.lang.ClassLoader.loadClass(Ljava/lang/String;Z)Ljava/lang/Class;+43 j java.lang.ClassLoader.loadClass(Ljava/lang/String;)Ljava/lang/Class;+3 j java.lang.ClassLoader.loadClassInternal(Ljava/lang/String;)Ljava/lang/Class;+2 v ~StubRoutines::call_stub j core.NotifyThread.run()V+76 v ~StubRoutines::call_stub --------------- P R O C E S S --------------- Java Threads: ( => current thread ) =>0x024d2308 JavaThread "NotifyThread" [_thread_in_native, id=1224] 0x015af648 JavaThread "Low Memory Detector" daemon [_thread_blocked, id=300] 0x0246a3c0 JavaThread "CompilerThread0" daemon [_thread_blocked, id=1908] 0x015a93e8 JavaThread "Finalizer" daemon [_thread_blocked, id=1304] 0x015a7ef8 JavaThread "Reference Handler" daemon [_thread_blocked, id=1916] 0x01564d80 JavaThread "main" [_thread_in_native, id=1408] Other Threads: 0x02466e78 VMThread [id=1284] 0x0246bb90 WatcherThread [id=332] VM state:not at safepoint (normal execution) VM Mutex/Monitor currently owned by a thread: None Heap def new generation total 576K, used 344K [0x04670000, 0x04710000, 0x04b50000) eden space 512K, 54% used [0x04670000, 0x046b62d0, 0x046f0000) from space 64K, 99% used [0x046f0000, 0x046ffff8, 0x04700000) to space 64K, 0% used [0x04700000, 0x04700000, 0x04710000) tenured generation total 1408K, used 726K [0x04b50000, 0x04cb0000, 0x08670000) the space 1408K, 51% used [0x04b50000, 0x04c05b98, 0x04c05c00, 0x04cb0000) compacting perm gen total 8192K, used 3120K [0x08670000, 0x08e70000, 0x0c670000) the space 8192K, 38% used [0x08670000, 0x0897c130, 0x0897c200, 0x08e70000) No shared spaces configured. Dynamic libraries: 0x00400000 - 0x006f9000 C:\Programme\PostgreSQL\8.1\bin\postgres.exe 0x77880000 - 0x77902000 C:\WINNT\system32\ntdll.dll 0x79350000 - 0x793b5000 C:\WINNT\system32\ADVAPI32.DLL 0x77e70000 - 0x77f30000 C:\WINNT\system32\KERNEL32.dll 0x77d20000 - 0x77d98000 C:\WINNT\system32\RPCRT4.dll 0x1c000000 - 0x1c006000 C:\Programme\PostgreSQL\8.1\bin\comerr32.dll 0x78000000 - 0x78045000 C:\WINNT\system32\MSVCRT.dll 0x77e00000 - 0x77e69000 C:\WINNT\system32\USER32.dll 0x77f40000 - 0x77f7f000 C:\WINNT\system32\GDI32.dll 0x10000000 - 0x10106000 C:\Programme\PostgreSQL\8.1\bin\libeay32.dll 0x74fc0000 - 0x74fc9000 C:\WINNT\system32\WSOCK32.dll 0x74fa0000 - 0x74fb4000 C:\WINNT\system32\WS2_32.DLL 0x74f90000 - 0x74f98000 C:\WINNT\system32\WS2HELP.DLL 0x00c00000 - 0x00c0d000 C:\Programme\PostgreSQL\8.1\bin\libintl-2.dll 0x00c10000 - 0x00ceb000 C:\Programme\PostgreSQL\8.1\bin\libiconv-2.dll 0x00cf0000 - 0x00d71000 C:\Programme\PostgreSQL\8.1\bin\krb5_32.dll 0x719b0000 - 0x719b8000 C:\WINNT\system32\SHFOLDER.DLL 0x00d80000 - 0x00db2000 C:\Programme\PostgreSQL\8.1\bin\ssleay32.dll 0x74f40000 - 0x74f5e000 C:\WINNT\system32\msafd.dll 0x74f80000 - 0x74f87000 C:\WINNT\System32\wshtcpip.dll 0x6dd00000 - 0x6dedd000 C:\Programme\PostgreSQL\8.1\lib\libpljava.dll 0x6d640000 - 0x6d7c9000 C:\Programme\Java\jre1.5.0_04\bin\client\jvm.dll 0x77540000 - 0x77571000 C:\WINNT\system32\WINMM.dll 0x6d280000 - 0x6d288000 C:\Programme\Java\jre1.5.0_04\bin\hpi.dll 0x68f30000 - 0x68f3b000 C:\WINNT\system32\PSAPI.DLL 0x6d610000 - 0x6d61c000 C:\Programme\Java\jre1.5.0_04\bin\verify.dll 0x6d300000 - 0x6d31d000 C:\Programme\Java\jre1.5.0_04\bin\java.dll 0x6d630000 - 0x6d63f000 C:\Programme\Java\jre1.5.0_04\bin\zip.dll VM Arguments: jvm_args: -Dsqlj.defaultconnection=jdbc:default:connection vfprintf -Xrs java_command: Environment Variables: CLASSPATH=e:\sybase\ASEP\3pclass.zip;e:\sybase\ASEP\monclass.zip; PATH=e:\Programme\sybase\JS-12_5\bin;e:\Programme\sybase\OCS-12_5\lib3p;e:\Programme\sybase\OCS-12_5\dll;e:\Programme\sybase\OCS-12_5\bin;c:\winnt\system32;E:\Programme\philips\speechpearl\bin;e:\sybase\ASEP;e:\sybase\OCS-12_0\dll;e:\sybase\OCS-12_0\bin;E:\Programme\philips\shared\bin;E:\Programme\philips\speechdetector\bin;C:\philips\speechpearl\bin;C:\philips\speechpearl\server\bin;e:\programme\philips\speechpearl\server\bin;e:\programme\philips\snmpagent\bin;C:\Programme\GNU\WinCvs 1.2;C:\Programme\Java\jre1.5.0_04\bin;C:\Programme\Java\jre1.5.0_04\bin\client;C:\Programme\Microsoft SQL Server\90\Tools\binn\;E:\Programme\Sun\jwsdp-2.0\jaxrpc\bin;E:\Programme\Sun\jwsdp-2.0\jwsdp-shared\bin;E:\Programme\Microsoft Visual Studio 8\SDK\v2.0\Bin;C:\WINNT\Microsoft.NET\Framework\v2.0.50727;C:\Programme\Java\jdk1.5.0_03\bin USERNAME=postgres OS=Windows_NT PROCESSOR_IDENTIFIER=x86 Family 6 Model 8 Stepping 10, GenuineIntel --------------- S Y S T E M --------------- OS: Windows 2000 Build 2195 Service Pack 4 CPU:total 1 family 6, cmov, cx8, fxsr, mmx, sse Memory: 4k page, physical 522736k(136896k free), swap 1276844k(939860k free) vm_info: Java HotSpot(TM) Client VM (1.5.0_04-b05) for windows-x86, built on Jun 3 2005 02:10:41 by "java_re" with MS VC++ 6.0 Maybe this helps... ______________________________________________________________ Verschicken Sie romantische, coole und witzige Bilder per SMS! Jetzt bei WEB.DE FreeMail: http://f.web.de/?mc=021193