Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread 11279 and 10258
Tue, Aug 1 2006 1:24 PMPermanent Link

Michael Binette
I have a customer who is getting a ton of 10258 (Cannot lock record in
the table) and also some 11279 (An unknown error has occured on the
server).

They have had to stop and restart the DBISAM server and then go back
into the application.  This is happening at least 4 or 5 times a day and
started to get this bad 3 weeks ago.  It did not coincide with any
update of our software and we have over 5,000 other customers using it
without this issue.

The table that it can't lock isn't even a busy table.  It basically gets
read and written to once when the program opens and that is about it.

They also had some very strange activity in Task Manager.  The DBISAM
server would cause the CPU to go to around 50% for a good minute, then
spike to 100% for at least a minute, and then drop down to a normal
pattern.

All computers are running Windows XP SP2 and the are using the Pc-Cillin
virus software.  I have already excluded the data directory from Pc-
Cillin.

Any suggestions on what to look for?

--
Thanks,
Michael Binette
Wed, Aug 2 2006 1:57 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Michael,

<< They also had some very strange activity in Task Manager.  The DBISAM
server would cause the CPU to go to around 50% for a good minute, then spike
to 100% for at least a minute, and then drop down to a normal pattern.

All computers are running Windows XP SP2 and the are using the Pc-Cillin
virus software.  I have already excluded the data directory from Pc- Cillin.

Any suggestions on what to look for? >>

Is the server machine an actual server machine, like an HP Proliant, etc. ?
Or is it a normal PC ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Aug 7 2006 12:06 PMPermanent Link

Michael Binette
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in
news:5E023B12-CBBD-4BE1-9D30-9621407241FE@news.elevatesoft.com:

> Michael,
>
> << They also had some very strange activity in Task Manager.  The
> DBISAM server would cause the CPU to go to around 50% for a good
> minute, then spike to 100% for at least a minute, and then drop down
> to a normal pattern.
>
>  All computers are running Windows XP SP2 and the are using the
>  Pc-Cillin
> virus software.  I have already excluded the data directory from Pc-
> Cillin.
>
>  Any suggestions on what to look for? >>
>
> Is the server machine an actual server machine, like an HP Proliant,
> etc. ? Or is it a normal PC ?
>

It is a normal PC.  They use it off and on during the day but have
stayed off of it recently to see if it made a difference.
Mon, Aug 7 2006 2:35 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Michael,

<< It is a normal PC.  They use it off and on during the day but have stayed
off of it recently to see if it made a difference. >>

I would definitely do a thorough check of the PC for any "helpful" utilities
that might interfere with the database server.  AV software, firewalls, etc.
Also, have them check to see if they have any suspicious-looking processes
in the task manager that might be trojans or spyware.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Aug 8 2006 2:05 PMPermanent Link

Michael Binette
>
> I would definitely do a thorough check of the PC for any "helpful"
> utilities that might interfere with the database server.  AV software,
> firewalls, etc. Also, have them check to see if they have any
> suspicious-looking processes in the task manager that might be trojans
> or spyware.
>

Does setting a table or query to ReadOnly help with performance or
concurrency at all?
Wed, Aug 9 2006 2:15 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Michael,

<< Does setting a table or query to ReadOnly help with performance or
concurrency at all? >>

No, the ReadOnly setting for the table and query components is just an
end-user construct.  It doesn't mean that the tables are necessarily being
read or accessed in that mode.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image