From: davenport.marion at yahoo.com (Marion Davenport) Date: Sun, 6 Jan 2008 17:44:22 -0800 (PST) Subject: [Pljava-dev] server closed the connection unexpectedly errors Message-ID: <97004.59340.qm@web45702.mail.sp1.yahoo.com> Hi there I have the occasional "server closed the connection unexpected" errors on a WinXp (about half the time) when I run pljava functions that make an http request to retrieve a web page. This happens on a localhost. Any thoughts? Thank you. This is the exception I'm getting from jdbc Exception in thread "main" org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. at org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:369) at org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:258) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:337) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:236) at database.jenainterface.UseJndiDataSource.main(UseJndiDataSource.java:37) Caused by: java.net.SocketException: Connection reset at java.net.SocketInputStream.read(Unknown Source) at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:135) at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:104) at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:73) at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:255) at org.postgresql.core.v2.QueryExecutorImpl.processResults(QueryExecutorImpl.java:408) at org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:364) ... 5 more and pgAdmin error server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. Below is the hs_err_pid file # # An unexpected error has been detected by HotSpot Virtual Machine: # # Internal Error (53484152454432554E54494D450E43505001A3), pid=5624, tid=4212 # # Java VM: Java HotSpot(TM) Client VM (1.5.0_06-b05 mixed mode) --------------- T H R E A D --------------- Current thread (0x013c1998): JavaThread "main" [_thread_in_Java, id=4212] Stack: [0x00700000,0x00b00000), sp=0x00afc744, free space=4081k Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code) V [jvm.dll+0x11d540] V [jvm.dll+0x62c36] V [jvm.dll+0xf15b5] V [jvm.dll+0xd7cfe] V [jvm.dll+0xd9324] V [jvm.dll+0x8447a] V [jvm.dll+0x8ad33] C [libpljava.dll+0x40a8] C [libpljava.dll+0x49dd] C [libpljava.dll+0x4a22] C [libpljava.dll+0x267a] C [libpljava.dll+0x24c6] C [postgres.exe+0xc0a68] C [postgres.exe+0xc4442] C [postgres.exe+0xce200] C [postgres.exe+0xbf5d0] C [postgres.exe+0xbe406] C [postgres.exe+0x147ed2] C [postgres.exe+0x1484ba] C [postgres.exe+0x1446fa] C [postgres.exe+0x14618b] C [postgres.exe+0x11f3ea] C [postgres.exe+0xdd66f] C [postgres.exe+0x11e7] C [postgres.exe+0x1238] C [kernel32.dll+0x16fd7] --------------- P R O C E S S --------------- Java Threads: ( => current thread ) 0x024bc880 JavaThread "Low Memory Detector" daemon [_thread_blocked, id=5064] 0x024bb618 JavaThread "CompilerThread0" daemon [_thread_blocked, id=4876] 0x0140a538 JavaThread "Finalizer" daemon [_thread_blocked, id=4644] 0x014090a0 JavaThread "Reference Handler" daemon [_thread_blocked, id=4596] =>0x013c1998 JavaThread "main" [_thread_in_Java, id=4212] Other Threads: 0x01405008 VMThread [id=5904] 0x024bdb90 WatcherThread [id=5800] VM state:not at safepoint (normal execution) VM Mutex/Monitor currently owned by a thread: None Heap def new generation total 576K, used 218K [0x04640000, 0x046e0000, 0x04b20000) eden space 512K, 30% used [0x04640000, 0x04666858, 0x046c0000) from space 64K, 100% used [0x046c0000, 0x046d0000, 0x046d0000) to space 64K, 0% used [0x046d0000, 0x046d0000, 0x046e0000) tenured generation total 1408K, used 159K [0x04b20000, 0x04c80000, 0x08640000) the space 1408K, 11% used [0x04b20000, 0x04b47f58, 0x04b48000, 0x04c80000) compacting perm gen total 8192K, used 2743K [0x08640000, 0x08e40000, 0x0c640000) the space 8192K, 33% used [0x08640000, 0x088edd08, 0x088ede00, 0x08e40000) No shared spaces configured. Dynamic libraries: 0x00400000 - 0x006fe000 C:\Program Files\PostgreSQL\8.1\bin\postgres.exe 0x7c900000 - 0x7c9b0000 C:\WINDOWS\system32\ntdll.dll 0x7c800000 - 0x7c8f5000 C:\WINDOWS\system32\kernel32.dll 0x77dd0000 - 0x77e6b000 C:\WINDOWS\system32\ADVAPI32.DLL 0x77e70000 - 0x77f01000 C:\WINDOWS\system32\RPCRT4.dll 0x1c000000 - 0x1c006000 C:\Program Files\PostgreSQL\8.1\bin\comerr32.dll 0x77c10000 - 0x77c68000 C:\WINDOWS\system32\MSVCRT.dll 0x7e410000 - 0x7e4a0000 C:\WINDOWS\system32\USER32.dll 0x77f10000 - 0x77f57000 C:\WINDOWS\system32\GDI32.dll 0x10000000 - 0x10107000 C:\Program Files\PostgreSQL\8.1\bin\libeay32.dll 0x71ad0000 - 0x71ad9000 C:\WINDOWS\system32\WSOCK32.dll 0x71ab0000 - 0x71ac7000 C:\WINDOWS\system32\WS2_32.dll 0x71aa0000 - 0x71aa8000 C:\WINDOWS\system32\WS2HELP.dll 0x00220000 - 0x0022d000 C:\Program Files\PostgreSQL\8.1\bin\libintl-2.dll 0x00230000 - 0x0030b000 C:\Program Files\PostgreSQL\8.1\bin\libiconv-2.dll 0x00310000 - 0x00391000 C:\Program Files\PostgreSQL\8.1\bin\krb5_32.dll 0x76780000 - 0x76789000 C:\WINDOWS\system32\SHFOLDER.DLL 0x003a0000 - 0x003d1000 C:\Program Files\PostgreSQL\8.1\bin\ssleay32.dll 0x76390000 - 0x763ad000 C:\WINDOWS\system32\IMM32.DLL 0x00d80000 - 0x00de3000 C:\WINDOWS\system32\wxvault.dll 0x76bf0000 - 0x76bfb000 C:\WINDOWS\system32\PSAPI.DLL 0x71b20000 - 0x71b32000 C:\WINDOWS\system32\MPR.dll 0x77c00000 - 0x77c08000 C:\WINDOWS\system32\VERSION.dll 0x77f60000 - 0x77fd6000 C:\WINDOWS\system32\SHLWAPI.dll 0x00df0000 - 0x00df5000 C:\WINDOWS\system32\detoured.dll 0x7c9c0000 - 0x7d1d7000 C:\WINDOWS\system32\SHELL32.dll 0x773d0000 - 0x774d3000 C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2982_x-ww_ac3f9c03\comctl32.dll 0x5d090000 - 0x5d12a000 C:\WINDOWS\system32\comctl32.dll 0x71a50000 - 0x71a8f000 C:\WINDOWS\system32\mswsock.dll 0x662b0000 - 0x66308000 C:\WINDOWS\system32\hnetcfg.dll 0x71a90000 - 0x71a98000 C:\WINDOWS\System32\wshtcpip.dll 0x6dd00000 - 0x6dedd000 C:\Program Files\PostgreSQL\8.1\lib\libpljava.dll 0x6d670000 - 0x6d804000 C:\Program Files\Java\jre1.5.0_06\bin\client\jvm.dll 0x76b40000 - 0x76b6d000 C:\WINDOWS\system32\WINMM.dll 0x6d280000 - 0x6d288000 C:\Program Files\Java\jre1.5.0_06\bin\hpi.dll 0x6d640000 - 0x6d64c000 C:\Program Files\Java\jre1.5.0_06\bin\verify.dll 0x6d300000 - 0x6d31d000 C:\Program Files\Java\jre1.5.0_06\bin\java.dll 0x6d660000 - 0x6d66f000 C:\Program Files\Java\jre1.5.0_06\bin\zip.dll VM Arguments: jvm_args: -Dsqlj.defaultconnection=jdbc:default:connection vfprintf -Xrs java_command: Launcher Type: generic Environment Variables: JAVA_HOME=C:\Sun\SDK\jdk CLASSPATH=.;C:\Program Files\Java\jre1.5.0_06\lib\ext\QTJava.zip PATH=C:\Program Files\MiKTeX 2.5\miktex\bin;"C:\Program Files\MIT\Shared Files";C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Wave Systems Corp\Dell Preboot Manager\Access Client\v5\;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Java\jre1.5.0_06\bin;C:\Program Files\Java\jre1.5.0_06\bin\client;C:\Program Files\PostgreSQL\8.1\bin\pg_ctl.exe;C:\Program Files\PostgreSQL\8.1\bin;C:\Program Files\Kerberos\;C:\Sun\SDK\jdk\bin;C:\Program Files\QuickTime\QTSystem\;C:\Program Files\Common Files\GTK\2.0\bin USERNAME=postgres OS=Windows_NT PROCESSOR_IDENTIFIER=x86 Family 6 Model 14 Stepping 8, GenuineIntel --------------- S Y S T E M --------------- OS: Windows XP Build 2600 Service Pack 2 CPU:total 2 family 6, cmov, cx8, fxsr, mmx, sse, sse2, ht Memory: 4k page, physical 1038448k(254036k free), swap 2499592k(1654616k free) vm_info: Java HotSpot(TM) Client VM (1.5.0_06-b05) for windows-x86, built on Nov 10 2005 11:12:14 by "java_re" with MS VC++ 6.0 ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs -------------- next part -------------- An HTML attachment was scrubbed... URL: