Consultor Eletrônico



Kbase P128950: _SQLSRV2 processes crash intermittently when handling heavy loads and multiple connections
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   3/17/2008
Status: Unverified

FACT(s) (Environment):

OpenEdge 10.1B 64-bit
OpenEdge 10.1B03 64-bit Service Pack
IBM AIX POWER 5.2 64-bit
IBM AIX POWER 5.3 64-bit
Linux x86 64-bit

SYMPTOM(s):

_SQLSRV2 processes crash intermittently

Multiple user connections occur simultaneously

Database can be shutdown by the death of the server

Client can see error:

Error: [DataDirect][OpenEdge JDBC Driver]A server crash is likely.. (8933)

SQLExplorer.exceptions trace shows:

Exception at <date/time>: java.sql.SQLException
Message (throw): ### Connect stack trace. ###
Message (excp): [DataDirect][OpenEdge JDBC Driver]A server crash is likely.
Stack Trace:
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver]A server crash is likely.
at com.ddtek.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.ddtek.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientRequest.headerSwapOut(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientLoginRequest.attachToServer(Unknown Source)
at com.ddtek.jdbc.openedge.client.OpenEdgeClientLoginRequest.submitRequest(Unknown Source)
at com.ddtek.jdbc.openedge.OpenEdgeImplConnection.open(Unknown Source)
at com.ddtek.jdbc.base.BaseConnection.connect(Unknown Source)
at com.ddtek.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)
at com.ddtek.jdbc.base.BaseConnection.open(Unknown Source)
at com.ddtek.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:559)
at java.sql.DriverManager.getConnection(DriverManager.java:189)
at com.progress.sql.explorer.SQLConnectServer.call(SQLConnectServer.java:37)
at com.progress.common.rmiregistry.TryIt.run(TryIt.java:186)

Dead server is reported in the database log file

BROKER detects death of server <pid>. (1153)

Auditing is enabled on the database

Auditing errors are reported in the database log file

Failed to get record from table in .<function> (13594)

Failed to get record <record> from table <table> in audEventPolicyLoad. (13594)

Stack trace from _SQLSRV2 reads:

dbut_stcomp
cacheEntryFind
audEventPolicyLoad
cacheLoad

CAUSE:

Bug# OE00163101

FIX:

Upgrade to 10.1C or later