Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Reported for Version 4.33 » View Incident Report |
Serious |
Reported By: Ralf Bieber [EDV Dienstleistungen Ralf B Reported On: 9/23/2012 For: Version 4.33 Build 4 |
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]
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |