This is the mail archive of the cygwin-apps mailing list for the Cygwin project.


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Aw: Re: sqlite defect


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!


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]