Sebastian Wolfgarten: > 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:
So what is locking the database? The query as shown does not attempt to modify the database. Note that the query fails immediately, there is no attempt to wait for a lock to be released. Wietse > 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]: 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?