Hello,
I'm trying to compile SQLite on a GNU/Linux system for use in an NFS
environment. The NFS server doesn't support locks via fcntl(), i.e.:
access("/homedir//.mozilla/firefox/51jxlyk4.default/places.sqlite", F_OK) = 0
stat("/homedir//.mozilla/firefox/51jxlyk4.default/places.sqlite",
{st_mode=S_IFREG|0644, st_size=0, ...}) = 0
open("/homedir//.mozilla/firefox/51jxlyk4.default/places.sqlite",
O_RDWR|O_CREAT, 0644) = 42
fcntl(42, F_GETFD) = 0
fcntl(42, F_SETFD, FD_CLOEXEC) = 0
fstat(42, {st_mode=S_IFREG|0644, st_size=0, ...}) = 0
lseek(42, 0, SEEK_SET) = 0
read(42, "", 100) = 0
fcntl(42, F_SETLK, {type=F_RDLCK, whence=SEEK_SET, start=1073741824, len=1}) =
-1 ENOLCK (No locks available)
However, sqlite chooses "unix" as default locking method rendering
Firefox useless.
I found out that hardcoding "unix-none" into the openDatabase function
makes it work.
Hence I suspect it's sqlite's fault to not choose a working locking
style such as "unix-none" by itself.
FWIW: I thought I'd give one of the locking styles documented on
<http://www.sqlite.org/compile.html> a try, namely No locking or
dot-file locking.
However, compiling with -DSQLITE_ENABLE_LOCKING_STYLE fails:
gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\"
-DPACKAGE_VERSION=\"3.7.8\" "-DPACKAGE_STRING=\"sqlite 3.7.8\""
-DPACKAGE_BUGREPORT=\"http://www.sqlite.org\"; -DPACKAGE_URL=\"\"
-DPACKAGE=\"sqlite\" -DVERSION=\"3.7.8\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1
-DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1
-DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1
-DHAVE_DLFCN_H=1 -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1
-DHAVE_GMTIME_R=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1
-DHAVE_READLINE=1 -DHAVE_POSIX_FALLOCATE=1 -I.@am__isrc@ -D_REENTRANT=1
-DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE
-DSQLITE_ENABLE_LOCKING_STYLE -MT sqlite3.lo -MD -MP -MF .deps/sqlite3.Tpo -c
sqlite3.c -fPIC -DPIC -o .libs/sqlite3.o
sqlite3.c: In function 'unixOpen':
sqlite3.c:29685:26: error: 'fsInfo' undeclared (first use in this function)
sqlite3.c:29685:26: note: each undeclared identifier is reported only once for
each function it appears in
sqlite3.c:29698:35: error: 'MNT_LOCAL' undeclared (first use in this function)
mv -f .deps/shell.Tpo .deps/shell.Po
make: *** [sqlite3.lo] Error 1
Cheers,
Tobi
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
