Database timeout fix doesn''t quite work

Aman_Nanner · February 7, 2003, 2:53pm

Almost there…but not quite.

This is what is printed to the console when I tried to log into the server the morning after leaving it running overnight…

2/7/03 9:43 AM <?xml version="1.0" encoding="UTF-8" ?><stream:stream to=“catreus” xmlns=“jabber:client” x

mlns:stream=“http://etherx.jabber.org/streams”>

2/7/03 9:43 AM <stream:stream xmlns=‘‘jabber:client’’ xmlns:stream=‘‘http://etherx.jabber.org/streams’’ from=

‘‘catreus’’ id=‘‘8e6f9595’’>

2/7/03 9:43 AM <iq xmlns=“jabber:client” type=‘‘get’’ id=‘‘id_10028’’><username

cbartlett

2/7/03 9:43 AM <iq xmlns=“jabber:client” type=‘‘set’’ id=‘‘id_10030’’><username

cbartlettpasswordHome</que ry>

2/7/03 9:43 AM cba

rtlett

An unexpected exception has been detected in native code outside the VM.

Unexpected Signal : EXCEPTION_ACCESS_VIOLATION occurred at PC=0x619155C4

Function=[Unknown.]

Library=C:\Oracle\Ora92\bin\orantcp9.dll

NOTE: We are unable to locate the function name symbol for the error

just occurred. Please refer to release documentation for possible

reason and solutions.

Current Java thread:

at oracle.jdbc.oci8.OCIDBAccess.do_execute(Native Method)

at oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java:1246)

locked <02A2FB00> (a oracle.jdbc.oci8.OCIDBAccess)

at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2488)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:28 32)

at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatemen t.java:608)

locked <02A547B0> (a oracle.jdbc.driver.OraclePreparedStatement)
locked <02A2FBC0> (a oracle.jdbc.driver.OracleConnection)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement .java:536)

locked <02A547B0> (a oracle.jdbc.driver.OraclePreparedStatement)
locked <02A2FBC0> (a oracle.jdbc.driver.OracleConnection)

at com.jivesoftware.xmpp.auth.spi.DbAuthFactory.createAuthToken(DbAuthFactory.java :80)

at com.jivesoftware.xmpp.auth.AuthFactory.getAuthToken(AuthFactory.java:96)

at com.jivesoftware.xmpp.handler.IQAuthHandler.handleIQ(IQAuthHandler.java:104)

locked <02F7D090> (a com.jivesoftware.xmpp.handler.IQAuthHandler)

at com.jivesoftware.xmpp.spi.IQHandler.handleMessages(IQHandler.java:43)

at com.jivesoftware.xmpp.spi.BasicChannel$ChannelWorker.run(BasicChannel.java:335)

Dynamic libraries:

0x00400000 - 0x00406000 C:\WINNT\system32\java.exe

0x77F80000 - 0x77FFB000 C:\WINNT\System32\ntdll.dll

0x77DB0000 - 0x77E0D000 C:\WINNT\system32\ADVAPI32.dll

0x77E80000 - 0x77F36000 C:\WINNT\system32\KERNEL32.DLL

0x77D30000 - 0x77DA1000 C:\WINNT\system32\RPCRT4.DLL

0x78000000 - 0x78046000 C:\WINNT\system32\MSVCRT.dll

0x6D330000 - 0x6D45C000 C:\JBuilder8\jdk1.4\jre\bin\client\jvm.dll

0x77E10000 - 0x77E75000 C:\WINNT\system32\USER32.dll

0x77F40000 - 0x77F7C000 C:\WINNT\system32\GDI32.DLL

0x77570000 - 0x775A0000 C:\WINNT\system32\WINMM.dll

0x6D1D0000 - 0x6D1D7000 C:\JBuilder8\jdk1.4\jre\bin\hpi.dll

0x6D300000 - 0x6D30D000 C:\JBuilder8\jdk1.4\jre\bin\verify.dll

0x6D210000 - 0x6D229000 C:\JBuilder8\jdk1.4\jre\bin\java.dll

0x6D320000 - 0x6D32D000 C:\JBuilder8\jdk1.4\jre\bin\zip.dll

0x6D2D0000 - 0x6D2DE000 C:\JBuilder8\jdk1.4\jre\bin\net.dll

0x75050000 - 0x75058000 C:\WINNT\system32\WSOCK32.dll

0x75030000 - 0x75043000 C:\WINNT\system32\WS2_32.DLL

0x75020000 - 0x75028000 C:\WINNT\system32\WS2HELP.DLL

0x74FD0000 - 0x74FED000 C:\WINNT\system32\msafd.dll

0x75010000 - 0x75017000 C:\WINNT\System32\wshtcpip.dll

0x7CA00000 - 0x7CA23000 C:\WINNT\system32\rsaenh.dll

0x77A50000 - 0x77B45000 C:\WINNT\system32\ole32.dll

0x77C10000 - 0x77C6E000 C:\WINNT\system32\USERENV.dll

0x77440000 - 0x774B7000 C:\WINNT\system32\CRYPT32.dll

0x77430000 - 0x77440000 C:\WINNT\system32\MSASN1.DLL

0x782F0000 - 0x78536000 C:\WINNT\system32\shell32.dll

0x70BD0000 - 0x70C1C000 C:\WINNT\system32\SHLWAPI.DLL

0x716F0000 - 0x7177A000 C:\WINNT\system32\COMCTL32.DLL

0x75170000 - 0x751BF000 C:\WINNT\system32\netapi32.dll

0x77BE0000 - 0x77BEF000 C:\WINNT\system32\SECUR32.DLL

0x751C0000 - 0x751C6000 C:\WINNT\system32\NETRAP.DLL

0x75150000 - 0x75160000 C:\WINNT\system32\SAMLIB.DLL

0x77950000 - 0x7797A000 C:\WINNT\system32\WLDAP32.DLL

0x77980000 - 0x779A4000 C:\WINNT\system32\DNSAPI.DLL

0x782C0000 - 0x782CC000 C:\WINNT\System32\rnr20.dll

0x77340000 - 0x77353000 C:\WINNT\system32\iphlpapi.dll

0x77520000 - 0x77525000 C:\WINNT\system32\ICMP.DLL

0x77320000 - 0x77337000 C:\WINNT\system32\MPRAPI.DLL

0x779B0000 - 0x77A4B000 C:\WINNT\system32\OLEAUT32.DLL

0x773B0000 - 0x773DE000 C:\WINNT\system32\ACTIVEDS.DLL

0x77380000 - 0x773A2000 C:\WINNT\system32\ADSLDPC.DLL

0x77830000 - 0x7783E000 C:\WINNT\system32\RTUTILS.DLL

0x77880000 - 0x7790D000 C:\WINNT\system32\SETUPAPI.DLL

0x774E0000 - 0x77512000 C:\WINNT\system32\RASAPI32.DLL

0x774C0000 - 0x774D1000 C:\WINNT\system32\RASMAN.DLL

0x77530000 - 0x77552000 C:\WINNT\system32\TAPI32.DLL

0x77360000 - 0x77379000 C:\WINNT\system32\DHCPCSVC.DLL

0x777E0000 - 0x777E8000 C:\WINNT\System32\winrnr.dll

0x777F0000 - 0x777F5000 C:\WINNT\system32\rasadhlp.dll

0x62F00000 - 0x62F0F000 C:\oracle\Ora92\bin\ocijdbc9.dll

0x610A0000 - 0x6113F000 C:\Oracle\Ora92\bin\oracore9.dll

0x612A0000 - 0x61319000 C:\Oracle\Ora92\bin\oranls9.dll

0x613A0000 - 0x613B1000 C:\Oracle\Ora92\bin\oraunls9.dll

0x60600000 - 0x6078F000 C:\Oracle\Ora92\bin\oraclient9.dll

0x60800000 - 0x60806000 C:\Oracle\Ora92\bin\oravsn9.dll

0x60500000 - 0x60590000 C:\Oracle\Ora92\bin\oracommon9.dll

0x0BFF0000 - 0x0C26F000 C:\Oracle\Ora92\bin\orageneric9.dll

0x62FC0000 - 0x6303D000 C:\Oracle\Ora92\bin\oraxml9.dll

0x780A0000 - 0x780B2000 C:\WINNT\system32\MSVCIRT.dll

0x630F0000 - 0x63117000 C:\Oracle\Ora92\bin\oraxsd9.dll

0x615A0000 - 0x61629000 C:\Oracle\Ora92\bin\orannzsbb9.dll

0x61480000 - 0x61535000 C:\Oracle\Ora92\bin\oran9.dll

0x61400000 - 0x6142C000 C:\Oracle\Ora92\bin\oranl9.dll

0x61960000 - 0x61972000 C:\Oracle\Ora92\bin\oranldap9.dll

0x62000000 - 0x62024000 C:\Oracle\Ora92\bin\oraldapclnt9.dll

0x616B0000 - 0x616C7000 C:\Oracle\Ora92\bin\orancrypt9.dll

0x62300000 - 0x6233E000 C:\Oracle\Ora92\bin\ORATRACE9.dll

0x61730000 - 0x61766000 C:\Oracle\Ora92\bin\oranro9.dll

0x617C0000 - 0x617C6000 C:\Oracle\Ora92\bin\oranhost9.dll

0x617D0000 - 0x617D6000 C:\Oracle\Ora92\bin\oranoname9.dll

0x616A0000 - 0x616A6000 C:\Oracle\Ora92\bin\orancds9.dll

0x61820000 - 0x61827000 C:\Oracle\Ora92\bin\orantns9.dll

0x64000000 - 0x64007000 C:\Oracle\Ora92\bin\oranms.dll

0x64020000 - 0x64030000 C:\Oracle\Ora92\bin\oranmsp.dll

0x60A00000 - 0x60D14000 C:\Oracle\Ora92\bin\orapls9.dll

0x62500000 - 0x62507000 C:\Oracle\Ora92\bin\oraslax9.dll

0x61350000 - 0x61360000 C:\Oracle\Ora92\bin\orasnls9.dll

0x60810000 - 0x60816000 C:\Oracle\Ora92\bin\orawtc9.dll

0x62600000 - 0x62676000 C:\Oracle\Ora92\bin\orasql9.dll

0x61910000 - 0x6191C000 C:\Oracle\Ora92\bin\orantcp9.dll

0x61890000 - 0x6189D000 C:\Oracle\Ora92\bin\orannts9.dll

0x75500000 - 0x75504000 C:\WINNT\system32\security.dll

0x782D0000 - 0x782EE000 C:\WINNT\system32\msv1_0.dll

0x77920000 - 0x77943000 C:\WINNT\system32\imagehlp.dll

0x72A00000 - 0x72A2D000 C:\WINNT\system32\DBGHELP.dll

0x690A0000 - 0x690AB000 C:\WINNT\system32\PSAPI.DLL

Local Time = Fri Feb 07 09:43:31 2003

Elapsed Time = 61284

The exception above was detected in native code outside the VM

Java VM: Java HotSpot™ Client VM (1.4.1-b21 mixed mode)

An error report file has been saved as hs_err_pid2860.log.
Please refer to the file for further information.

The log file that the output refers to just contains the previous output itself.

For whoever is fixing this part of the code, you might want to try setting the database connection timeout to something really low (like 30 seconds or something) so that you’'ll be able to test your fix.

Thanks,

Aman

matt · February 7, 2003, 4:16pm

I’‘d recommend using the thin JDBC drivers rather than the OCI ones. The OCI drivers seem to have huge numbers of bugs and don’'t provide any advantages over the thin drivers. The 9.0 or the 9.2 thin drivers seem to be the best.

Regards,

Matt