Re: Mysterious lockout in
- From: "Dan Freeman" <spam@xxxxxxxxxxxxx>
- Date: Thu, 12 Jan 2006 08:43:56 -0800
There is no type of lock that will persist after a reboot.
You say your queries run fine from another machine so that would point to
something environmental. A query that "never returns" is often the sign of a
cartesian join, but since they ran on another machine that isn't a likely
suspect.
What is different about these machines? Something environmental is causing
this.
Dan
roger@xxxxxxxxxxxxxx wrote:
> I am getting locked out by something but I don't know what.
>
> I am running an ODBC query on a Foxpro db (a bunch of dbf files with
> the MS VFP ODBC driver pointing at the directory). The db is a 3rd
> party package and I am running my own SELECTs on several of the
> tables. The 3rd party application is shut down.
>
> One of the SELECTS never returns, as if it is waiting for a lock to
> come free. I have rebooted the db machine, shut down all the other
> machines in sight (they access this db as well) and still it locks. I
> copied the whole thing to another machine, set up a different data
> source and ran my SELECTs and they all work fine there (they take
> under a minute). This tells me it isn't a file corruption.
>
> So something on that db machine seems to be holding a lock on the dbf
> files and it survives a reboot. There is nothing else running on the
> db machine. It has WinXP installed and the ODBC driver version is
> 6.01.8630.01.
>
> Any ideas? I'm thinking there is some service that 'remembers' locks
> after a reboot, but that doesn't seem likely. They run MacAffee and I
> tried it with that stopped. Still locking.
.
- References:
- Mysterious lockout in
- From: roger
- Mysterious lockout in
- Prev by Date: Re: SQL LIKE problem
- Next by Date: RE: Mysterious lockout in
- Previous by thread: Mysterious lockout in
- Next by thread: RE: Mysterious lockout in
- Index(es):
Relevant Pages
|
|
