EDB 1.09 b4

A customer is having a problem with my multi-user (non c/s) app. It
takes very long to start (up to 5 minutes). Checking the
EDBConfig.EDBLog file there are several messages stating:

Cannot lock the database MyDB for exclusive access

I got their data and it is quite snappy here on the network. Any ideas
as to why they would be having problems? They claim its not their
antivirus as it was shut down during testing.

Michael


Have you got any code which requires exclusive access? EG creating tables etc

Roy Lambert [Team Elevate]

On Wed, 11 Feb 2009 07:29:25 +0000, Roy Lambert
<roy.lambert@skynet.co.uk> wrote:

>Michael
>
>
>Have you got any code which requires exclusive access? EG creating tables etc

All I do is to change the config path if it is incorrect. However this
path should be fine as their data was upgraded from DBISAM to EDB and
the correct path would have been set then.

Michael,

<< A customer is having a problem with my multi-user (non c/s) app. It takes
very long to start (up to 5 minutes). Checking the EDBConfig.EDBLog file
there are several messages stating:

Cannot lock the database MyDB for exclusive access

I got their data and it is quite snappy here on the network. Any ideas as
to why they would be having problems? They claim its not their antivirus as
it was shut down during testing. >>

Are you trying to drop or alter any databases when your application starts
up ?   Those are the only two operations that will try to exclusively lock a
database.

--
Tim Young
Elevate Software
www.elevatesoft.com

On Wed, 11 Feb 2009 17:48:32 -0500, "Tim Young [Elevate Software]"
<timyoung@elevatesoft.com> wrote:

>Michael,
>
><< A customer is having a problem with my multi-user (non c/s) app. It takes
>very long to start (up to 5 minutes). Checking the EDBConfig.EDBLog file
>there are several messages stating:
>
> Cannot lock the database MyDB for exclusive access
>
> I got their data and it is quite snappy here on the network. Any ideas as
>to why they would be having problems? They claim its not their antivirus as
>it was shut down during testing. >>
>
>Are you trying to drop or alter any databases when your application starts
>up ?   Those are the only two operations that will try to exclusively lock a
>database.

I change the config path if it is incorrect. I think this is the
problem. If the upgrade is done on the machine hosting the data a
local path will be written to the config file. If the software is
started on this machine as well, any other machines starting the
software will try to change the path to the correct mapped or UNC path
but will get the lock error. Sound right?

Michael,

<< I change the config path if it is incorrect. I think this is the problem.
If the upgrade is done on the machine hosting the data a local path will be
written to the config file. If the software is started on this machine as
well, any other machines starting the software will try to change the path
to the correct mapped or UNC path but will get the lock error. Sound right?
>>

No, not really.  Changing the configuration path is a code-only operation,
and does not involve ElevateDB performing any locking, etc.   Changing the
path of a database, however, does require an exclusive lock on the database
(ALTER DATABASE).

--
Tim Young
Elevate Software
www.elevatesoft.com