Icon View Incident Report

Serious Serious
Reported By: Raul Sinimae
Reported On: 12/14/2020
For: Version 4.49 Build 4
# 4825 Corrupted Indexes Can Cause an AV During SELECT Queries

A table with index issues is hard to dupe so i have been testing some other things to make sure our software handles various errors OK.

I ran into a DBSRVR throwing an access violation when querying a table with known index issue.

Table verify reports "Indexes do not match record data and are invalid"

Table is "bad" but when i run a simple query i get DBSRVR reporting an AV

DBISAM Engine Error # 11279 An unknown error ('Access violation at address 0000000000987D2F in module 'DBSRVR.EXE'. Read of address FFFFFFFFFFFFFE20') occurred with the connection to the database server at '127.0.0.1', please check the server log. Module:TSSCDM. Method:OpenDbQuery. Detail:select * from SMSG_ARCHIVE_MESSAGE_PARTICIPANT where HASYNC_MODIFIED >= '2020-12-08 11:03:58.551 PM' ORDER by HASYNC_MODIFIED

DBSRVR log showed this

12/14/2020 10:38:58 AM [ERROR] Engine error [Access violation at address 0000000000987D2F in module 'dbsrvr.exe'. Read of address FFFFFFFFFFFFFE20] Additional info [select * from SMSG_ARCHIVE_MESSAGE_PARTICIPANT where HASYNC_MODIFIED >= '2020-12-08 11:03:58.551 PM' ORDER by HASYNC_MODI [Client Version: 4.49 User Name: admin Address: 127.0.0.1 Encrypted: No Request: REQUEST_EXECUTESTMT Thread: 1268 Session: 2]


Resolution Resolution
Fixed Problem on 12/16/2020 in version 4.49 build 5


Products Affected Products Affected
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