Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 4 of 4 total |
Write lock error #10227 |
Wed, Sep 19 2007 12:22 PM | Permanent Link |
"Jose Eduardo Helminsky" | Tim
I have a huge table (1.5Gb) with almost 8M records. I´ve made a test with DBSYS applying the following SQL statement: update hlan set sal=0,san=0 Both fields "sal" and "san" are not indexed and does not belong to any index and are BCD fields. After some period the app fires a write lock error (#10227). There is no transaction involved and I copy this table to another machine and repeat the process with the same problem (to isolate hardware problems). I have already repaired the table and the problem still happen. Scenario Windows XP (1Gb RAM/100Gb HD): Without network Local DB access DBISAM 4.22 Build 4 Eduardo |
Wed, Sep 19 2007 1:32 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Eduardo,
<< Both fields "sal" and "san" are not indexed and does not belong to any index and are BCD fields. After some period the app fires a write lock error (#10227). There is no transaction involved and I copy this table to another machine and repeat the process with the same problem (to isolate hardware problems). I have already repaired the table and the problem still happen. >> It could be one of these issues: http://www.elevatesoft.com/scripts/incident.dll?action=viewrep&category=dbisam&release=4.22&type=f&incident=2156 http://www.elevatesoft.com/scripts/incident.dll?action=viewrep&category=dbisam&release=4.22&type=f&incident=2142 http://www.elevatesoft.com/scripts/incident.dll?action=viewrep&category=dbisam&release=4.22&type=f&incident=2141 -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Sep 19 2007 5:44 PM | Permanent Link |
"Jose Eduardo Helminsky" | Tim
I have to upgrade my DBISAM to last v4 build, but I have to ask you how stable is the last version ? Is there any pending issues ? Will be a next v4 build soon ? Eduardo |
Thu, Sep 20 2007 2:05 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Eduardo,
<< I have to upgrade my DBISAM to last v4 build, but I have to ask you how stable is the last version ? Is there any pending issues ? Will be a next v4 build soon ? >> It looks like I will be doing a new build in the next day or so, but the only really notable issue existing with 4.25 Build 6 is the remote encryption/RemoteReadSize issue: http://www.elevatesoft.com/scripts/newsgrp.dll?action=openmsg&group=12&msg=6442&page=1#msg6442 -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |