select query while inserting data bug

[Dimitar Misev]

If a select query is executed while ingesting data, the ingestion fails with a database error (SQLite backend).

[Dimitar Misev]

This happens because the SQLite database is locked by another process, and unfortunately it doesn't queue concurrent queries from multiple processes (this only works for threads).

I submit a patch that sets a timeout of 60 seconds, internally SQLite retries the query with exponential backoff until it's either unlocked from other processes or 60 seconds pass.

[Peter Baumann]

so after timeout the requesting rasserver will get informed and throw an exception? I am not familiar enough to understand how an application would get feedback on a failed db update.

[Dimitar Misev]

Yes exactly, it will just return after the timeout saying "database is locked".