View Incident Report

Serious

Reported By: Arnd Baranowski
Reported On: 6/15/2007
For: Version 1.04 Build 2

# 2378 DELETE or UPDATE Statements that Affect a Large Number of Rows Can Cause Fatal System Crash

I did a "Delete from table" on a 5.000.000 table (Field1 a number (Integer) and primary constraint, Field2 an address (Varchar30)) and during this process my system went down with a blue screen. When it came back 2.500.000 records where deleted and the rest was still in.

Comments

The issue was that the DELETE and UPDATE statements were obtaining row locks, but not releasing them, resulting in the lock space consuming all available address space for the process before the DELETE could complete. The row locks should have been released when the DELETE flushed its deleted rows to disk during the exeuction of the statement.

Resolution

Fixed Problem on 6/16/2007 in version 1.04 build 3

Products Affected

ElevateDB Additional Software and Utilities
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap