Dear all, I am running postfix 3.3 and recently migrated all my virtual domains from MySQL to Sqlite for performance reasons. So far, everything works fine however up to 5-8 times a day, I am seeing an error message in my mail.log saying that the Sqlite 3 database may be locked. Here is an example:
-- Jan 10 18:00:42 waldfest postfix/smtpd[88198]: connect from spring-chicken-bi.twitter.com[199.16.156.174] Jan 10 18:00:43 waldfest postfix/smtpd[88198]: Anonymous TLS connection established from spring-chicken-bi.twitter.com[199.16.156.174]: TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits) Jan 10 18:00:45 waldfest postgrey[656]: action=pass, reason=client AWL, client_name=spring-chicken-bi.twitter.com, client_address=199.16.156.174, sender=n0541a68f73-b84c2c7eb58d4ba4a17c4affd751c95c-presse===freizeitpark-erlebnis...@bounce.twitter.com, recipient=pre...@freizeitpark-erlebnis.de Jan 10 18:00:45 waldfest postfix/smtpd[88198]: 3D13F5076C7: client=spring-chicken-bi.twitter.com[199.16.156.174] Jan 10 18:00:45 waldfest postfix/cleanup[88252]: warning: dict_sqlite_lookup: /etc/postfix/sqlite_virtual_alias_maps.cf: SQL step failed for query 'SELECT goto FROM alias WHERE address='pre...@freizeitpark-erlebnis.de' AND active = '1'': database is locked? Jan 10 18:00:45 waldfest postfix/cleanup[88252]: fatal: dict_sqlite_lookup: /etc/postfix/sqlite_virtual_alias_maps.cf: SQL finalize failed for query 'SELECT goto FROM alias WHERE address='pre...@freizeitpark-erlebnis.de' AND active = '1'': database is locked? Jan 10 18:00:45 waldfest dovecot: imap(tho...@tfalkenberg.com): Logged out in=291 out=2593 Jan 10 18:00:46 waldfest postfix/smtpd[88198]: warning: cannot send milters to service public/cleanup socket Jan 10 18:00:46 waldfest postfix/master[54589]: warning: process /usr/libexec/postfix/cleanup pid 88252 exit status 1 Jan 10 18:00:46 waldfest postfix/smtpd[88198]: too many errors after END-OF-MESSAGE from spring-chicken-bi.twitter.com[199.16.156.174] Jan 10 18:00:47 waldfest postfix/cleanup[88290]: 438125076C8: message-id=<20180110170047.43812507...@waldfest.wolfgarten.com> -- I find this quite odd as the abovementioned SQL query just works fine. I tried to search Google for the error („database is locked?“), however I am unable to find any information on this matter. Also apart from these messages everything works fine and the server handles thousands of emails correctly per day. Any idea on how to troubleshoot this? Thank you. Best regards Sebastian
