This is the mail archive of the
cygwin-apps
mailing list for the Cygwin project.
Aw: Re: sqlite defect
- From: fger555 at gmx dot de
- To: "Cygwin Apps List" <cygwin-apps at cygwin dot com>
- Date: Thu, 18 Jul 2013 01:15:48 +0200 (CEST)
- Subject: Aw: Re: sqlite defect
- References: <trinity-fdc5a0b5-6dcf-4fc0-9370-dd32a75fe928-1373654994500 at 3capp-gmx-bs47>, <51E703FB dot 1010300 at etr-usa dot com>
- Sensitivity: Normal
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!