Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Error 10249
Tue, Jul 11 2006 1:23 AMPermanent 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 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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

Image