Icon View Incident Report

Serious Serious
Reported By: Jose Eduardo Helminsky
Reported On: 4/19/2006
For: Version 4.23 Build 2
# 2186 Executing a Live Query Using a Different Database in the SELECT FROM Clause Causes AV

This message I've been seeing almost once or twice a day. It start with a #11279 error in client side and dbsrvr log shows the message:

Access violation at address 00402A17 in module 'DBSRVR.EXE'. Read of address FFFFFFE7



   with Session do
   begin
   RemoteAddress := '127.0.0.1';
   SessionType := stRemote;
   RemoteUser := 'admin';
   RemotePassword := 'DBAdmin';
   RemotePing := True;
   SessionName := 'SS';
   LockProtocol := lpOptimistic;
   ForceBufferFlush := False;
   Active := True;
   end;

   with Database do
   begin
   Connected := False;
   SessionName := 'Test';
   DatabaseName := 'Test';
   RemoteDataBase := 'Test';
   Connected := True;
   end;

   with Q do
   begin
   SessionName := 'Test';
   DatabaseName := 'Test';
   RequestLive := True;
   Sql.Text := 'select * from "Temp\Customer"';
   Open;
   end;

   with T2 do
      begin
      SessionName := 'Test';
      DatabaseName := 'Temp';
      Tablename := 'biolife';
      T2.Open; // <-- HERE the Access Violation occurs
with #11279 error at server side
      end;



Comments Comments
The AV was caused on a table open on the same database as that used in the SELECT statement that specifically referenced the same previously-unopened database. This bug requires that both the client application and the database server be updated to version 4.24 in order to fix the problem due to the fact that an update to a remote session call was required on both the client and server ends.


Resolution Resolution
Fixed Problem on 4/21/2006 in version 4.24 build 1


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 VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source

Image