[pfx] Re: fatal: dict_sqlite_lookup: [...] SQL prepare failed: attempt to write a readonly database?

lama--- via Postfix-users:
> Hi,
> 
> since I've upgraded from 3.10.11 to 3.10.12 (running Alpine) I've 
> encountered the following type of log messages a few times a day. 
> trivial-rewrite is running with -v and I replaced my actual domain with 
> example.com:
> 
> 
> Aug  9 05:33:37 example postfix/trivial-rewrite[20042]: 
> dict_sqlite_lookup: /etc/postfix/sqlite-alias-vmaps.cf: Searching with 
> query SELECT destination FROM aliases WHERE alias='example.com'
> Aug  9 05:33:37 example postfix/trivial-rewrite[20042]: fatal: 
> dict_sqlite_lookup: /etc/postfix/sqlite-alias-vmaps.cf: SQL prepare 
> failed: attempt to write a readonly database?

I can assure you that Postfix does not a few times a day suddenly
decide to write to the database.
 
> Here is the content of /etc/postfix/sqlite-alias-vmaps.cf
> 
> dbpath = /etc/postfix/mail.sqlite
> expansion_limit = 1
> query = SELECT destination FROM aliases WHERE alias='%s'
> 
> The SQLite file can not be written to by the user Postfix runs as, but 
> this hasn't been a problem before as it is only used for looking up 
> maps. It seems to me that it wants to lock the file before doing that now?

Maybe the SQLite ***LIBRARY*** has changed? Postfix hasn't.

	Wietse
_______________________________________________
Postfix-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]