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='[email protected]' AND
> active = '1'': database is locked?
