On 7/24/2013 02:33, Jan Nijtmans wrote:
     SQLITE_CANTOPEN: os_win.c:34063: (3)
winOpen(/var/tmp/etilqs_FoaHNBQa56cVGrh\etilqs_PXfZEjH5dBl8Cm5) - The
system cannot find the path specified.

I'm not sure whether this is a SQLite 3.7.17 thing or if it is due to one of the build option changes in recent versions of Cygwin SQLite. All I know is that it seems to be a new thing.

As you can see from the error, SQLite is generating a temp file name with backslashes in it. This is purely wrong on Windows, whether running under Cygwin or not.

I haven't bothered looking any deeper into it than that. I hope it just gets fixed for me in .18. If not, I may have to hack around it in my next release of Cygwin SQLite.

In the meantime, some people have had luck setting the new environment variable CYGWIN_SQLITE_LOCKING=posix. This means Cygwin SQLite won't interoperate well with Windows native SQLite, but if you don't need that, I believe it will bypass this problematic tmp file name generation.

Just wait on the Cygwin64 people to bring out a new Sqlite package with
the same fixes already done in Cygwin32.

Um, it's the same people.  Me. :)

Both packages are generated from the same source, with the same build options. If they behave differently, it's likely because the SQLite code is doing something wrong with an ifdef, or because Cygwin itself behaves differently.
fossil-users mailing list

Reply via email to