Icon View Incident Report

Serious Serious
Reported By: Ralf Bieber [EDV Dienstleistungen Ralf B
Reported On: 9/23/2012
For: Version 4.33 Build 4
# 3626 SELECT Statements that Experience Errors During Preparation Can Cause AV During Session Close

C/S: SQL-Script with a error in the where clause for integer, largeint, .. can on the database server raise an exception . With the result, that never can remove this session. The record is also locked.

Base Version 4.33: Original dbsys, dbsrvr, Debug-Version

1. run the script

CREATE TABLE IF NOT EXISTS Test
(I INTEGER,
F FLOAT,
L LARGEINT);

INSERT INTO Test VALUES (1, 1.1, 1);
INSERT INTO Test VALUES (2, 2.2, 2);

SELECT * FROM Test where I='';

2. error

---------------------------
DBSys - Error
---------------------------
An error has occurred in the current SQL statement and the error message is: 

DBISAM Engine Error # 11949 SQL parsing error - Expected NULL, Boolean, SmallInt, Word, AutoInc, Integer, LargeInt, Currency, Float, or BCD expression but instead found '' in SELECT SQL statement at line 9, column 28

3. close dbsys
4. open srvadmin
5. The Session is nerver 'auto remove'.

6. Manuell ==> remove the Session:
---------------------------
DBAdmin - Error
---------------------------
DBISAM Engine Error # 11279 An unknown error ('Cannot lock the session (ID: 2)') occurred with the connection to the database server at '192.168.141.60', please check the server log


23.09.2012 19:32:25 Starting admin server on all addresses and port 12006 [Server Version: 4,33]
23.09.2012 19:32:25 Starting server on all addresses and port 12005 [Server Version: 4,33]
23.09.2012 19:32:30 Admin connection accepted [Client Version: 4,33 User Name:  Address: 192.168.141.60 Encrypted: Yes Thread: 1600 Session: 1]
23.09.2012 19:32:36 Admin login [Client Version: 4,33 User Name: Admin Address: 192.168.141.60 Encrypted: Yes Thread: 1600 Session: 1]
23.09.2012 19:32:46 Connection accepted [Client Version: 4,33 User Name:  Address: 192.168.141.60 Encrypted: No Thread: 3320 Session: 2]
23.09.2012 19:32:51 Login [Client Version: 4,33 User Name: Admin Address: 192.168.141.60 Encrypted: No Thread: 3320 Session: 2]
23.09.2012 19:33:17 [ERROR] Engine error [DBISAM Engine Error # 11949 SQL parsing error - Expected NULL, Boolean, SmallInt, Word, AutoInc, Integer, LargeInt, Currency, Float, or BCD expression but instead found '' in SELECT SQL statement at line 9, column 28] [Client Version: 4,33 User Name: SELECT * FROM Test where I=''
 Address: 192.168.141.60 Encrypted: No Request: REQUEST_PREPARESTMT Thread: 3320 Session: 2]
23.09.2012 19:33:17 [ERROR] Engine error [Access violation at address 00581FF5 in module 'dbsrvr.exe'. Read of address 00000004] [Client Version: 4,33 User Name:  Address: 192.168.141.60 Encrypted: No Request: REQUEST_FREESTMT Thread: 3320 Session: 2]
23.09.2012 19:33:22 Connection closed [Client Version: 4,33 User Name: Admin Address: 192.168.141.60 Encrypted: No Thread: 3320 Session: 2]
23.09.2012 19:33:22 Logout [Client Version: 4,33 User Name: Admin Address: 192.168.141.60 Encrypted: No Thread: 3320 Session: 2]
23.09.2012 19:33:22 [ERROR] Internal error removing session [Access violation at address 00531FE3 in module 'dbsrvr.exe'. Read of address 00000008] [Client Version: 0,00 User Name: Admin Address: 192.168.141.60 Encrypted: No Thread: 3320 Session: 2]
23.09.2012 19:34:16 [ERROR] Engine error [Cannot lock the session (ID: 2)] [Client Version: 4,33 User Name: Admin Address: 192.168.141.60 Encrypted: Yes Request: REQUEST_REMOVESESSION Thread: 1600 Session: 1]



Comments Comments
This was introduced during the server architecture switch in 4.33 to support 64-bit usage.


Resolution Resolution
Fixed Problem on 10/1/2012 in version 4.34 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 ODBC Trial
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image