[Pljava-dev] server closed the connection unexpectedly errors

From: davenport(dot)marion at yahoo(dot)com (Marion Davenport)
To:
Subject: [Pljava-dev] server closed the connection unexpectedly errors
Date: 2008-01-07 01:44:22
Message-ID: 97004.59340.qm@web45702.mail.sp1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

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: <unknown>
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: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20080106/f7340a2d/attachment.html>

Browse pljava-dev by date

  From Date Subject
Next Message Jan Ischebeck 2008-01-10 22:40:51 Pl/Java broken since Postgresql 8.3-rc1
Previous Message Lucas Madar 2008-01-05 09:57:44 [Pljava-dev] ResultSetHandle and TupleDesc reference leak?