Hi,
I have been trying to get an application that utilizes SQLite to run on our
system, but according to the application developers it fails because SQLite
is incompatible with NFS and thus cannot work on NFS-mounted volumes.
Attempts at locating this bug in the SQLite database has been futile,
> SVN seems to be a standard shell extension which doesn't use low level
> drivers. It looks like it gets notification from Explorer and examines
> files that change. You see the same kinds of things happening when you
> try to delete media files in Windows when the shell's trying to
> examine
> The fix is very simple - uninstall the SVN software which causes the
> problem. I would imagine that Sqlite is not the only piece of software
> which expects to have exclusive access to its journals.
Well, I am the programmer in this case not the user :) Of course this would
fix the problem on
SVN seems to be a standard shell extension which doesn't use low level
drivers. It looks like it gets notification from Explorer and examines
files that change. You see the same kinds of things happening when you
try to delete media files in Windows when the shell's trying to
examine the contents
Thank you, DJ
My Apache is installed in Windows XP( run on NTFS file system). I think the
user setting in the way as you said would be only available in Windows
2000/2003. I did try to create a new user in the XP , but have nothing to
set the account right except andministrator or normal user.
The fix is very simple - uninstall the SVN software which causes the
problem. I would imagine that Sqlite is not the only piece of software
which expects to have exclusive access to its journals.
Sqlite can be changed for Windows so that it can live with other
processes messing with its
[EMAIL PROTECTED] wrote:
> "Costas Stergiou" <[EMAIL PROTECTED]> wrote:
> > Can someone propose a reasonable workaround until this issue is fixed?
>
> I'll try to get a candidate fix in tonight.
See http://www.sqlite.org/cvstrac/chngview?cn=3200 for the fix.
If you do not have the ability to
"Roger Binns" <[EMAIL PROTECTED]> wrote:
>
> It may be worth considering a solution for all operating
> systems. I don't know if anyone has tracked how well
> Spotlight (Mac) or Beagle (Linux) work with SQLite files.
>
The problem seem to be two-fold:
* Attempting to delete journal files
"Costas Stergiou" <[EMAIL PROTECTED]> wrote:
> Can someone propose a reasonable workaround until this issue is fixed?
I'll try to get a candidate fix in tonight. Dave Dyer has sent
me patches to an older version of SQLite that address the problems.
I can use that as a basis for updating the
> The obvious quick fix is to retry these file operations that must
> succeed,...
Can some windows programmers suggest patches to os_win.c to
implement this.
Subversion had the same issues for the same reasons. I'd suggest
a similar solution and parameters:
Can someone propose a reasonable workaround until this issue is fixed?
Is "synchronous=off" really a solution? Or there is a failure 'behind' the
scenes' that is just overlooked?
Not really knowing how difficult it is to overcome this issue (and just
trying to add an 'objective' opinion), I could
Dave Dyer <[EMAIL PROTECTED]> wrote:
> >
> >I think this is a very reasonable assumption.
>
> It's a lot easier to drive if you assume you're the only
> car on the road.
>
I think a more apt analogy is that it is easier to
drive when the stearing wheel is not jerked out of
your hand at random
no
On 04/06/06, Dave Dyer <[EMAIL PROTECTED]> wrote:
>
>I think this is a very reasonable assumption.
It's a lot easier to drive if you assume you're the only
car on the road.
>
>I think this is a very reasonable assumption.
It's a lot easier to drive if you assume you're the only
car on the road.
Dave Dyer <[EMAIL PROTECTED]> wrote:
>
> The real problem is that sqlite assumes it "owns" the temporary
> transaction file that it created, and can do anything it wants with it;
> for example read, rename, or delete it.
I think this is a very reasonable assumption.
> Any other process which
I encountered this problem and agree with most of the diagnosis.
The real problem is that sqlite assumes it "owns" the temporary
transaction file that it created, and can do anything it wants with it;
for example read, rename, or delete it. Any other process which
gets it's hooks into the
"A. Pagaltzis" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> for those who havenât noticed, a video of a 45-min talk by
> Dr. Hipp about SQLite that he gave at Google has been posted on
> Google Video:
>
> http://video.google.com/videoplay?docid=-5160435487953918649
>
> Not much nitty-gritty, but a
>
> If you continue to use the SVN software a work-around to try and bypass
> the race condition would be to retry the sqlite3_open after a short
> pause when you intercept a CANTOPEN status.
> JS
>
What is interesting here is that this error can happen at random moments
(e.g during an insert,
I don't know enough about Sqlite internals to understand how these two
processes clash and why SYNCHRONOUS=OFF makes a difference but would say
that logic indicates that it is the SVN which is behaving badly as it
should be transparent to all applications, particularly ones like Sqlite
which
thanks a lot,Eduardo.
i can't access your ftp now.
but i can access google video by a proxy(alought it's not very stable) now.
look, i can see the slides now:)
what is sqlite
who is using sqlite
how is sqlite useful
what makes sqlite different
what general ... can be learned from the sqlite
* Joe Wilson <[EMAIL PROTECTED]> [2006-06-04 17:55]:
> In the video DRH mentioned that he plans to work on random
> access of BLOBs.
I found the part where he talks about the test suite and how
static typing hides mistakes very cool. (Enough so that I intend
to transcribe those.)
His mention of
In the video DRH mentioned that he plans to work on random access of BLOBs.
--- "A. Pagaltzis" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> for those who havenât noticed, a video of a 45-min talk by
> Dr. Hipp about SQLite that he gave at Google has been posted on
> Google Video:
>
>
I have downloaded the videos, in divx and flash video (.avi and
.flv). Make a ftp to inno.zapto.org, login:'imcs'
password:'' (without password)
Hello John,
I think I managed to trace the error (with the hint of Richard).
It is related to the Tortoise SVN client that I have installed on my PC.
This software includes a low level driver that intercepts all file accesses
and creates overlay icons on the windows explorer to show the status
works fine for me, obviously as it says, it is not yet available in your
country, I live in the UK and it works here.
On 04/06/06, imcs ee <[EMAIL PROTECTED]> wrote:
the url returns
"
Currently, the playback feature of Google Video isn't available in your
country.
We hope to make this
"Costas Stergiou" <[EMAIL PROTECTED]> wrote:
>
> I lately came upon a very strange error that occurs at random times.
These kinds of problems are sometimes caused by virus scanners.
Try turning off your virus scanner and see if the problem goes
away.
--
D. Richard Hipp <[EMAIL PROTECTED]>
If your close is not returning an error then the finalize is OK.
Are you using a local or network drive? Any other information about
your configuration? Can you open the file which gave the CANTOPEN
message using some other program?
When you make SYNCHRONOUS=OFF you stop Sqlite from
27 matches
Mail list logo