Hi,

One of our customers reported lock-up of our software when they try to work with our software(DBISAM database) on LAN using DBISAM server.
They just add records to database with blob field(size vary from 500kb till 5mb) and this error appears when they do it from different PC at the same time.

Could you advice where can be a problem?

p.s. They have sent a log below.
Regards,
Tomas

2/20/2008 2:25:31 PM Re-connection accepted [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: No Thread: 1248 Session:
17438728]
2/20/2008 2:30:07 PM Admin connection closed [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: Yes Thread: 3552 Session:
17596424]
2/20/2008 2:32:02 PM Re-connection accepted [Client Version: 4.25 User
Name: eric Address: 192.168.15.38 Encrypted: No Thread: 3072 Session:
17573896]
2/20/2008 2:33:24 PM Admin re-connection accepted [Client Version: 4.25
User Name: Phil Address: 192.168.42.20 Encrypted: Yes Thread: 3552
Session: 17596424]
2/20/2008 2:34:23 PM Connection closed [Client Version: 4.25 User Name:
Phil Address: 192.168.42.20 Encrypted: No Thread: 1248 Session:
17438728]
2/20/2008 2:34:23 PM Re-connection accepted [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: No Thread: 1656 Session:
17438728]
2/20/2008 2:35:56 PM [ERROR] Engine error [Engine Error # 10242 Cannot
unlock the table or record in the table 'Topic'] [Client Version: 4.25
User Name: Phil Address: 192.168.42.20 Encrypted: No Request:
REQUEST_CANCELRECORD Thread: 1656 Session: 17438728]
2/20/2008 2:36:11 PM [ERROR] Engine error [Engine Error # 10242 Cannot
unlock the table or record in the table 'Topic'] [Client Version: 4.25
User Name: Phil Address: 192.168.42.20 Encrypted: No Request:
REQUEST_CANCELRECORD Thread: 1656 Session: 17438728]
2/20/2008 2:36:16 PM [ERROR] Engine error [Engine Error # 10242 Cannot
unlock the table or record in the table 'Topic'] [Client Version: 4.25
User Name: Phil Address: 192.168.42.20 Encrypted: No Request:
REQUEST_CANCELRECORD Thread: 1656 Session: 17438728]
2/20/2008 2:36:36 PM Connection closed [Client Version: 4.25 User Name:
Phil Address: 192.168.42.20 Encrypted: No Thread: 1656 Session:
17438728]
2/20/2008 2:36:47 PM Connection accepted [Client Version: 4.25 User
Name:  Address: 192.168.42.20 Encrypted: No Thread: 1248 Session:
17790984]
2/20/2008 2:36:47 PM Login [Client Version: 4.25 User Name: Phil
Address: 192.168.42.20 Encrypted: No Thread: 1248 Session: 17790984]
2/20/2008 2:38:26 PM Admin connection closed [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: Yes Thread: 3552 Session:
17596424]
2/20/2008 2:45:15 PM Admin re-connection accepted [Client Version: 4.25
User Name: Phil Address: 192.168.42.20 Encrypted: Yes Thread: 3552
Session: 17596424]
2/20/2008 2:48:49 PM Connection closed [Client Version: 4.25 User Name:
eric Address: 192.168.15.38 Encrypted: No Thread: 3072 Session:
17573896]
2/20/2008 2:50:32 PM Admin connection closed [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: Yes Thread: 3552 Session:
17596424]
2/20/2008 2:52:47 PM Connection closed [Client Version: 4.25 User Name:
Phil Address: 192.168.42.20 Encrypted: No Thread: 1248 Session:
17790984]
2/20/2008 2:55:08 PM Re-connection accepted [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: No Thread: 1248 Session:
17790984]
2/20/2008 3:01:07 PM Connection closed [Client Version: 4.25 User Name:
Phil Address: 192.168.42.20 Encrypted: No Thread: 1248 Session:
17790984]
2/20/2008 3:02:56 PM Admin re-connection accepted [Client Version: 4.25
User Name: Phil Address: 192.168.42.20 Encrypted: Yes Thread: 3552
Session: 17596424]
2/20/2008 3:03:36 PM Re-connection accepted [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: No Thread: 1248 Session:
17790984]
2/20/2008 3:07:58 PM Admin connection closed [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: Yes Thread: 3552 Session:
17596424]
2/20/2008 3:12:27 PM Re-connection accepted [Client Version: 4.25 User
Name: eric Address: 192.168.15.38 Encrypted: No Thread: 3072 Session:
17573896]
2/20/2008 3:13:58 PM Admin re-connection accepted [Client Version: 4.25
User Name: Phil Address: 192.168.42.20 Encrypted: Yes Thread: 3552
Session: 17596424]
2/20/2008 3:18:26 PM Connection closed [Client Version: 4.25 User Name:
eric Address: 192.168.15.38 Encrypted: No Thread: 3072 Session:
17573896]
2/20/2008 3:20:24 PM Connection accepted [Client Version: 4.25 User
Name:  Address: 192.168.42.20 Encrypted: No Thread: 3668 Session:
17770504]
2/20/2008 3:20:24 PM Login [Client Version: 4.25 User Name: Phil
Address: 192.168.42.20 Encrypted: No Thread: 3668 Session: 17770504]
2/20/2008 3:21:38 PM [ERROR] Engine error [Engine Error # 10229
Transaction cannot lock the database 'Mc-Mc'] [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: No Request:
REQUEST_STARTTRANS Thread: 1248 Session: 17790984]
2/20/2008 3:21:38 PM Connection closed [Client Version: 4.25 User Name:
Phil Address: 192.168.42.20 Encrypted: No Thread: 1248 Session:
17790984]
2/20/2008 3:21:38 PM Re-connection accepted [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: No Thread: 3072 Session:
17790984]
2/20/2008 3:21:38 PM Connection closed [Client Version: 4.25 User Name:
Phil Address: 192.168.42.20 Encrypted: No Thread: 3072 Session:
17790984]
2/20/2008 3:21:38 PM Re-connection accepted [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: No Thread: 3264 Session:
17790984]
2/20/2008 3:21:38 PM Connection closed [Client Version: 4.25 User Name:
Phil Address: 192.168.42.20 Encrypted: No Thread: 3264 Session:
17790984]
2/20/2008 3:21:38 PM Re-connection accepted [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: No Thread: 1656 Session:
17790984]
2/20/2008 3:21:38 PM Connection closed [Client Version: 4.25 User Name:
Phil Address: 192.168.42.20 Encrypted: No Thread: 1656 Session:
17790984]
2/20/2008 3:21:38 PM Re-connection accepted [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: No Thread: 3412 Session:
17790984]
2/20/2008 3:21:38 PM Connection closed [Client Version: 4.25 User Name:
Phil Address: 192.168.42.20 Encrypted: No Thread: 3412 Session:
17790984]
2/20/2008 3:21:38 PM Re-connection accepted [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: No Thread: 3472 Session:
17790984]
2/20/2008 3:21:38 PM Connection closed [Client Version: 4.25 User Name:
Phil Address: 192.168.42.20 Encrypted: No Thread: 3472 Session:
17790984]
2/20/2008 3:22:22 PM Admin connection closed [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: Yes Thread: 3552 Session:
17596424]
2/20/2008 3:23:39 PM Admin connection accepted [Client Version: 4.25
User Name:  Address: 63.238.75.56 Encrypted: Yes Thread: 3552 Session:
17741832]
2/20/2008 3:23:44 PM Admin login [Client Version: 4.25 User Name: Phil
Address: 63.238.75.56 Encrypted: Yes Thread: 3552 Session: 17741832]
2/20/2008 3:24:24 PM Logout [Client Version: 4.25 User Name: Phil
Address: 63.238.75.56 Encrypted: Yes Thread: 3552 Session: 17741832]
2/20/2008 3:24:24 PM Admin connection closed [Client Version: 4.25 User
Name:  Address: 63.238.75.56 Encrypted: Yes Thread: 3552 Session: 0]
2/20/2008 3:24:50 PM Stopping server on address 63.238.75.56 and port
12005 [Server Version: 4.25]
2/20/2008 3:26:20 PM Starting admin server on address 63.238.75.56 and
port 12006 [Server Version: 4.25]
2/20/2008 3:26:20 PM Starting server on address 63.238.75.56 and port
12005 [Server Version: 4.25]
2/20/2008 3:26:33 PM Admin connection accepted [Client Version: 4.25
User Name:  Address: 63.238.75.56 Encrypted: Yes Thread: 2396 Session:
17438728]
2/20/2008 3:26:39 PM Admin login [Client Version: 4.25 User Name: Phil
Address: 63.238.75.56 Encrypted: Yes Thread: 2396 Session: 17438728]
2/20/2008 3:26:47 PM Connection accepted [Client Version: 4.25 User
Name:  Address: 192.168.42.20 Encrypted: No Thread: 932 Session:
17436680]
2/20/2008 3:26:47 PM Login [Client Version: 4.25 User Name: Phil
Address: 192.168.42.20 Encrypted: No Thread: 932 Session: 17436680]
2/20/2008 3:31:28 PM Connection accepted [Client Version: 4.25 User
Name:  Address: 192.168.15.38 Encrypted: No Thread: 2724 Session:
17457160]
2/20/2008 3:31:28 PM Login [Client Version: 4.25 User Name: eric
Address: 192.168.15.38 Encrypted: No Thread: 2724 Session: 17457160]
2/20/2008 3:31:41 PM Admin connection closed [Client Version: 4.25 User
Name: Phil Address: 63.238.75.56 Encrypted: Yes Thread: 2396 Session:
17438728]
2/20/2008 3:36:43 PM Connection closed [Client Version: 4.25 User Name:
eric Address: 192.168.15.38 Encrypted: No Thread: 2724 Session:
17457160]
2/20/2008 3:42:25 PM Re-connection accepted [Client Version: 4.25 User
Name: eric Address: 192.168.15.38 Encrypted: No Thread: 2724 Session:
17457160]
2/20/2008 3:44:13 PM Admin re-connection accepted [Client Version: 4.25
User Name: Phil Address: 63.238.75.56 Encrypted: Yes Thread: 2396
Session: 17438728]
2/20/2008 3:44:54 PM Connection closed [Client Version: 4.25 User Name:
Phil Address: 192.168.42.20 Encrypted: No Thread: 932 Session:
17436680]
2/20/2008 3:44:54 PM Re-connection accepted [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: No Thread: 3456 Session:
17436680]
2/20/2008 3:44:54 PM Connection closed [Client Version: 4.25 User Name:
Phil Address: 192.168.42.20 Encrypted: No Thread: 3456 Session:
17436680]
2/20/2008 3:45:36 PM Re-connection accepted [Client Version: 4.25 User
Name: Phil Address: 192.168.42.20 Encrypted: No Thread: 932 Session:
17436680]
2/20/2008 3:45:39 PM [ERROR] Engine error [Engine Error # 10242 Cannot
unlock the table or record in the table 'Topic'] [Client Version: 4.25
User Name: Phil Address: 192.168.42.20 Encrypted: No Request:
REQUEST_MODIFYRECORD Thread: 932 Session: 17436680]
2/20/2008 3:47:24 PM [ERROR] Engine error [Engine Error # 10242 Cannot
unlock the table or record in the table 'Topic'] [Client Version: 4.25
User Name: Phil Address: 192.168.42.20 Encrypted: No Request:
REQUEST_MODIFYRECORD Thread: 932 Session: 17436680]
2/20/2008 3:49:08 PM [ERROR] Engine error [Engine Error # 10242 Cannot
unlock the table or record in the table 'Topic'] [Client Version: 4.25
User Name: Phil Address: 192.168.42.20 Encrypted: No Request:
REQUEST_CANCELRECORD Thread: 932 Session: 17436680]
2/20/2008 3:49:23 PM [ERROR] Engine error [Engine Error # 10242 Cannot
unlock the table or record in the table 'Topic'] [Client Version: 4.25
User Name: Phil Address: 192.168.42.20 Encrypted: No Request:
REQUEST_MODIFYRECORD Thread: 932 Session: 17436680]
2/20/2008 3:49:37 PM Connection closed [Client Version: 4.25 User Name:
Phil Address: 192.168.42.20 Encrypted: No Thread: 932 Session:
17436680]

Tomas,

<< One of our customers reported lock-up of our software when they try to
work with our software(DBISAM database) on LAN using DBISAM server.  They
just add records to database with blob field(size vary from 500kb till 5mb)
and this error appears when they do it from different PC at the same time.
>>

You cannot have two concurrent transactions running at the same time with
DBISAM, so one has to wait for the other.  If it has to wait too long, it
will get a lock error.   See here for more information:

http://www.elevatesoft.com/scripts/manual.dll?action=mantopic&id=dbisam4&product=d&version=7&category=1&topic=12

specifically, "Locking During a Transaction".

--
Tim Young
Elevate Software
www.elevatesoft.com