Icon View Incident Report

Serious Serious
Reported By: Jeff Dunlop
Reported On: 12/10/2009
For: Version 2.03 Build 6
# 3118 Trying to Reconnect a Remote Session After a Timeout Event Causes Server to Not Respond to Connects

How to hang the ElevateDB Server using the ElevateDB Manager:

1) Start a query that can't finish in a reasonable time
2) Wait for the client to timeout and ask to disconnect
3) The query continues to run on the server
4) Nobody else can connect

Comments Comments
The problem was caused by a situation whereby the remote session was trying to reconnect to the server session that was currently executing the runaway query. The remote session would wait on a critical section that protects access to the server session. However, during this time it was also holding an server-level critical section used to protect access to all sessions on the server. This higher-level critical section was what was blocking access by other sessions.

Resolution Resolution
Fixed Problem on 12/12/2009 in version 2.03 build 7

Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial