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
fossil-users mailing list