Aw: Re: sqlite defect

[fger555@gmx.de]

Von: "Warren Young" <warren@etr-usa.com>
>> But since 3.7.17-3 I cannot read my databases any more
>> "unable to open datase file".
>Without a test case, debugging this will amount to testing guesses.

It was with several different files, Mozilla sqlite bookmark database,
and with SVN downloads (could not checkout any more).
I saw this on several different machines, WinXP and Win7.
Maybe the SVN problem was with the downgraded version, because SVN
was not compatible with this one.

> My first guess: try setting the new CYGWIN_SQLITE_LOCKING environment
>variable to "posix". That can fix it if you are trying to use two or
>more Cygwin SQLite based programs to access a single database file.

Thanks. That's it. With this setting it works.
Why isn't it the default?

There was no concurrent access, just a single query with Cygwin.
But I copied the mozilla places.sqlite bookmarks file to a backup directory
first and wanted to extract the Links to a simple ASCII style.
Does the sqlite file contain a locking flag inside? With the old version
I never had a problem to access the files.

Im not so familiar with sqlite, but I'm happy now that it works again.
Thanks for your help!