Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread DBISAM Engine Error 10226
Thu, Jan 12 2006 3:24 AMPermanent Link

Shaun Wallace
Hi,

We have been having an issue for the last two weeks where we on a regular basis get either error 10229 or 10226.

This occurs when issuing a 'SELECT' on a table.

We have tried upgrading from 4.20 b3 to 4.22 b3 but it hasn't helped. Our application works in a client/server style where we have clients connecting
to a remote server which performs functions. Part of this requires the server to find out which database to connect to. We have this database
connection info stored in a DBISAM table and once read we direct the queries to the DB Server (ORACLE/SQL). So DBISAM is used as an internal
database for storing menu info, user info etc BUT the main queries run off different database servers.

If we let our application run over the course of a day we often come up with error 10229.

If we connect and push the server a little bit (querying the menu structure in DBISAM tables of 8 different clients simultaneously) then we get error
10226.

We can't seem to replicate it at will but can get it to occur within about an hour of running. The table we get error 10226 on is only being used for
reads and has no updates to it at all.

The only way to get rid of the error after it occurs is to end task the server app and restart it.

Do you have any suggestions as to how to avoid the error or try track down the exact cause of the error?

Regards
Shaun Wallace
Thu, Jan 12 2006 11:34 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Shaun,

<< We have been having an issue for the last two weeks where we on a regular
basis get either error 10229 or 10226. >>

Are the applications that are accessing the database server multi-threaded ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Image