-----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

Reply via email to