Hi,

one of our customers has a lot of "10225 Cannot read lock the table xxx"
errors
it occurs mostly about 19.00h on their workstations. they have a network but
dbisam is running as a peer-to-peer an not with the dbisam server.
version 4.29 build 1
they have a server-pc.

I 've googled this error and somewhere I read that this problem has to do
with the windows version ( SBS 2003 ?? )
in that conversation the solution was there by removign the server-pc (
windows SBS 2003 ? ), but with our customer that's no option.

does anyone has more info about this problem ?

kind regards

Erik

Erik


First question is what happens around 19:00 on their network - automated backup or anything?

Roy Lambert [Team Elevate]

Hi Roy,

it's not exactly at 19.00 , but around that time: could be around about
18.30 to 19.30, but it happens every day

(the backup is running at night, they have customers until about 22.30)


Erik

"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
news:1062BA1A-1A9A-4FAA-BAE6-F8A11EEFDDD9@news.elevatesoft.com...
> Erik
>
>
> First question is what happens around 19:00 on their network - automated
> backup or anything?
>
> Roy Lambert [Team Elevate]
>

Erik

If it happens every day in that time slot there must be something happening otherwise it would be more random in nature. It doesn't have to be a backup it could be an automated anti-virus scan of the disk causing everything to lock.

Roy Lambert [Team Elevate]

Erik,

<< it's not exactly at 19.00 , but around that time: could be around about
18.30 to 19.30, but it happens every day >>

Are you running a native DBISAM backup at that time ?  If so, then make sure
to run it from the machine where the database resides in order to ensure
that it takes the least amount of time as possible to complete the backup.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy and Tim,

there is a tape backup and our application does not use de DBIsam backup
function.
I agree that **something** must be problemmaker.

I mentioned the google action, where I have seen a forum-question and answer
where the Windows server software was involved. That's why I've posted this
question on this dbisam forum, hoping someone has heard of it...



Erik
( please forgive my bad english )


"Erik B" <bellaard@wega.nl> schreef in bericht
news:334E7616-E297-487E-AC66-33E399F13F4B@news.elevatesoft.com...
>
> Hi Roy,
>
> it's not exactly at 19.00 , but around that time: could be around about
> 18.30 to 19.30, but it happens every day
>
> (the backup is running at night, they have customers until about 22.30)
>
>
> Erik
>
> "Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
> news:1062BA1A-1A9A-4FAA-BAE6-F8A11EEFDDD9@news.elevatesoft.com...
>> Erik
>>
>>
>> First question is what happens around 19:00 on their network - automated
>> backup or anything?
>>
>> Roy Lambert [Team Elevate]
>>
>

Erik

>there is a tape backup and our application does not use de DBIsam backup
>function.
>I agree that **something** must be problemmaker.
>
>I mentioned the google action, where I have seen a forum-question and answer
>where the Windows server software was involved. That's why I've posted this
>question on this dbisam forum, hoping someone has heard of it...

If its because of the Windows server software it must still be doing something during that time slot otherwise it would happen more randomly.

Are you able to look at the list of services and scheduled jobs? If so can you compare with another machine to see what if anything is different?

Roy Lambert [Team Elevate]

Hi Roy,

Yes, I will try to look at the services en scheduled jobs.

But, of course : time is money and if there are known issues it's easier
( read : cheaper;  I'm from The Netherlands : w're famous in this )

regards

Erik

"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
news:BE0C53F0-1976-4E40-A5A0-E553F41BD584@news.elevatesoft.com...
> Erik
>
>>there is a tape backup and our application does not use de DBIsam backup
>>function.
>>I agree that **something** must be problemmaker.
>>
>>I mentioned the google action, where I have seen a forum-question and
>>answer
>>where the Windows server software was involved. That's why I've posted
>>this
>>question on this dbisam forum, hoping someone has heard of it...
>
> If its because of the Windows server software it must still be doing
> something during that time slot otherwise it would happen more randomly.
>
> Are you able to look at the list of services and scheduled jobs? If so can
> you compare with another machine to see what if anything is different?
>
> Roy Lambert [Team Elevate]

Erik

>But, of course : time is money and if there are known issues it's easier
>( read : cheaper; I'm from The Netherlands : w're famous in this )

I'm from Yorkshire - we're better !

Roy Lambert [Team Elevate]

Erik,

<< there is a tape backup and our application does not use de DBIsam backup
function. I agree that **something** must be problemmaker. >>

You wouldn't get a "read lock error on table xxx" error if the problem is
being caused by an external software component or the OS.  The read locks
are completely a DBISAM construct.  If there was an external backup/OS
issue, you would see an error like "OS error - access denied" or something
similar.

--
Tim Young
Elevate Software
www.elevatesoft.com