On 25 Apr 2016, at 1:33pm, Mark Foley <mfoley at novatec-inc.com> wrote:

> I am using sqlite3 3.7.17 on Linux Slackware64 14.1. I use the sqlite3 
> command every 10 minutes to query several Thunderbird calendar databases. 
> Occasionally, I
> have a message, "Error: database is locked"; understandable since Thunderbird
> is occasionally updating its database.

You may get a better result by adding a timeout before your SELECT:

PRAGMA busy_timeout=5000;SELECT <whatever>

This allows SQLite to retry the operation for up to 5 seconds before it gives 
up and returns the above error.

Simon.

Reply via email to