Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 3 of 3 total |
Error 10249 |
Tue, Jul 11 2006 1:23 AM | Permanent Link |
Jaweed Saleem | Hi All,
We are running Delphi 5 with DBISAM 3.30. Recently we had a client that had a few tables not updated and this seemed to be due to an error 10249. This error is not in the error reference on your website. We haven't had this problem with anyone else and it doesn't happen all the time. I've posted an extract from the server log for that day. My questions are, what is this error exactly? what kinds of things can cause it and what can I do to minimise future occurrences of this? 8/07/2006 7:29:30 PM Engine error - DBISAM Engine Error # 10249 General lock failure with the table 'Availabl' [Address: 192.168.16.31 Version: 3.30 Request: REQUEST_PREPARESTMT Thread: 596 Session: 46064960] 8/07/2006 7:29:39 PM Re-connection accepted [Address: 192.168.16.31 Version: 3.30 Request: REQUEST_RECONNECT Thread: 3824 Session: 20578328] 8/07/2006 7:34:39 PM Connection closed [Address: 192.168.16.31 Version: 3.30 Thread: 3824 Session: 20578328] 8/07/2006 7:36:34 PM Re-connection accepted [Address: 192.168.16.20 Version: 3.30 Request: REQUEST_RECONNECT Thread: 3824 Session: 42037644] 8/07/2006 7:36:34 PM Engine error - DBISAM Engine Error # 8708 Record has been changed or deleted by another user, session, or table cursor in the table 'STAFF' [Address: 192.168.16.20 Version: 3.30 Request: REQUEST_GETCURRECORD Thread: 3824 Session: 42038/07/2006 7:36:34 PM Re-connection accepted [Address: 192.168.16.20 Version: 3.30 Request: REQUEST_RECONNECT Thread: 3848 Session: 38184288] 8/07/2006 7:36:34 PM Logout for user favour [Address: 192.168.16.20 Version: 3.30 Request: REQUEST_LOGOUT Thread: 3824 Session: 42037644] 8/07/2006 7:36:34 PM Logout for user favour [Address: 192.168.16.20 Version: 3.30 Request: REQUEST_LOGOUT Thread: 3848 Session: 38184288] 8/07/2006 7:36:34 PM Connection closed [Address: 192.168.16.20 Version: 3.30 Thread: 3824 Session: 0] 8/07/2006 7:36:34 PM Connection closed [Address: 192.168.16.20 Version: 3.30 Thread: 3848 Session: 0] 8/07/2006 7:38:33 PM Engine error - DBISAM Engine Error # 10249 General lock failure with the table 'Availabl' [Address: 192.168.16.31 Version: 3.30 Request: REQUEST_PREPARESTMT Thread: 596 Session: 46064960] 8/07/2006 7:38:41 PM Re-connection accepted [Address: 192.168.16.31 Version: 3.30 Request: REQUEST_RECONNECT Thread: 3824 Session: 20578328] 8/07/2006 7:43:41 PM Connection closed [Address: 192.168.16.31 Version: 3.30 Thread: 3824 Session: 20578328] 8/07/2006 7:47:36 PM Engine error - DBISAM Engine Error # 10249 General lock failure with the table 'Availabl' [Address: 192.168.16.31 Version: 3.30 Request: REQUEST_PREPARESTMT Thread: 596 Session: 46064960] 8/07/2006 7:47:45 PM Re-connection accepted [Address: 192.168.16.31 Version: 3.30 Request: REQUEST_RECONNECT Thread: 3824 Session: 20578328] 8/07/2006 7:53:09 PM Connection closed [Address: 192.168.16.31 Version: 3.30 Thread: 3824 Session: 20578328] 8/07/2006 7:57:40 PM Engine error - DBISAM Engine Error # 10249 General lock failure with the table 'Availabl' [Address: 192.168.16.31 Version: 3.30 Request: REQUEST_PREPARESTMT Thread: 596 Session: 46064960] 8/07/2006 7:57:49 PM Re-connection accepted [Address: 192.168.16.31 Version: 3.30 Request: REQUEST_RECONNECT Thread: 3824 Session: 20578328] 8/07/2006 8:06:08 PM Connection closed [Address: 192.168.16.31 Version: 3.30 Thread: 3824 Session: 20578328] 8/07/2006 8:10:00 PM Engine error - DBISAM Engine Error # 10249 General lock failure with the table 'Availabl' [Address: 192.168.16.31 Version: 3.30 Request: REQUEST_PREPARESTMT Thread: 596 Session: 46064960] Thanks in advance |
Tue, Jul 11 2006 6:11 AM | Permanent Link |
"Jose Eduardo Helminsky" | Jaweed
The error #10249 General Lock Failure is typically fired when a transaction still active for long time (may be a dead lock) or waiting for user input. Eduardo |
Tue, Jul 11 2006 2:00 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Jaweed,
<< We are running Delphi 5 with DBISAM 3.30. Recently we had a client that had a few tables not updated and this seemed to be due to an error 10249. This error is not in the error reference on your website. We haven't had this problem with anyone else and it doesn't happen all the time. I've posted an extract from the server log for that day. My questions are, what is this error exactly? what kinds of things can cause it and what can I do to minimise future occurrences of this? >> Eduardo is correct - it can be caused by transactions that are outstanding for too long waiting on user input, etc. or by dead-locked transactions. Under 3.x it is possible for transactions to deadlock, whereas under 4.x it is not. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |