Icon View Incident Report

Serious Serious
Reported By: Jason Southwell
Reported On: 8/19/2015
For: Version 2.19 Build 3
# 4245 ElevateDB Server Contains Race Condition During Logging of Connection Errors

We have customized our elevate server such that when it is launched, it runs an external registration app that runs a set of scripts to ensure that our UDFs are registered on all known databases. These scripts take about 10 seconds to run if the UDFs need to be registered and exit very quickly if there is no work to do.

We have one customer site however where we have a substantial problem with Elevate. On this server, 8 out of 10 times that we start Elevate, these scripts take 10 minutes or more to run. the other two times they finish quickly. When the scripts take 10 minutes to run, we know the database will be causing us tons of performance problems, including strange disconnects that hang around keeping locks on the system. If the initial scripts run quickly, we have no issues all day at that site.


Comments Comments
The problem would happen after a restart of the EDB Server, during which several automated clients would try to reconnect in a rapid burst and fail due to the sessions being gone. It was while logging these session reconnection errors that the race condition would cause memory issues and de-stabilize the EDB Server until it was restarted again.


Resolution Resolution
Fixed Problem on 9/10/2015 in version 2.20 build 1


Products Affected Products Affected
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 PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image