-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I am using sqlite 3.7.3 and have noticed the following behavior (which cause me some headaches).
My DB is owned by a different user (www) and I as root insert some data. Using pragma journal=delete, the journal file gets created as whoever starts updating it first, then the ownership doesn't change (that's ok). Using wal, the owner of the shared memory and wal file is that of the current user. (meaning if root updates the db, www will never be allowed to access the wal while the root process runs). Am I right to assume that wal files not only get truncated but also deleted? It seems to me that creating the journals should always have a chown to the owner of the db? (this would work for root, but not for others on *nix - I understand that!) But at least it could be the journal files get created with the same rw-perms as the db and if uid==0 then also with the same user-id. Are there any suggestions on how to make this workable? cheers thilo bash-4.1# ls -lnd tst.db* . drwxr-xr-x 11 1002 1000 3584 Feb 20 17:17 . - -rw-rw-rw- 1 1002 0 38586368 Feb 20 17:17 tst.db - -rw-r--r-- 1 0 1000 32768 Feb 20 17:17 tst.db-shm - -rw-r--r-- 1 0 1000 2128 Feb 20 17:17 tst.db-wal -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk1hPvAACgkQrfkjR68QUaeqIwCffKg8hJDxswjiFnR1W+1ahS0Q ma0Anjn+U2nNQzhukvxT5sL47/fuw4qT =YrLC -----END PGP SIGNATURE-----
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
