Icon View Incident Report

Serious Serious
Reported By: Reijo Pitkanen
Reported On: 7/11/2012
For: Version 4.33 Build 2
# 3565 DBISAM Database Server Can Raise #11279 Error After More than 4096 Query Executions

Something has changed to wrong direction between DBIsam Engine versions 4.32 and 4.33. I have build my own database server sometime ago with dbisam version 4.30. and its has been working very well.

Now when I build the very same server with dbisam 4.33, I am getting following error message to the client:

DBISAM Engine Error # 11279 An unknown error ('Handle objects container capacity (512) exceeded') occurred with the connection to the database server at '127.0.0.1', please check the server log.



“DBISAM Engine Error # 11279 An unknown error ('Handle objects container capacity (4096) exceeded') occurred with the connection to the database server at '127.0.0.1', please check the server log.”

It takes some time before the error occurs, something like half an hour. There is only one client and the server load is quite low.


Comments Comments
The problem was caused by the DBISAM Database Server not releasing cursor handles after a query has been executed, closed, and then un-prepared. After a bit of time, the number of cursor handles allocated exceeds the internal 4096 cursor handle limit. This was introduced in the 64-bit server architecture changes in 4.33 B1.


Resolution Resolution
Fixed Problem on 7/12/2012 in version 4.33 build 3


Products Affected Products Affected
DBISAM Additional Software and Utilities
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard
DBISAM ODBC Standard with Source
DBISAM ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image