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

lama--- via Postfix-users <[email protected]>
Newsgroups gmane.mail.postfix.user
Message-ID <[email protected]>
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]: match_string: 
mydestination: example.com ~? localhost
Aug  9 05:33:37 example postfix/trivial-rewrite[20042]: 
match_list_match: example.com: no match
Aug  9 05:33:37 example postfix/trivial-rewrite[20042]: match_string: 
virtual_alias_domains: example.com ~? 
sqlite:/etc/postfix/sqlite-alias-vmaps.cf(0,lock|utf8_request)
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?


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?

Could someone point me in the right direction? There doesn't seem to be 
a way to tell Postfix not to do that.

Kind regards,

Alex
_______________________________________________
Postfix-users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.