Error being logged by Android: database is locked

[djp952]

Error being logged by Android: database is locked

[djp952]

So far this appears to be a performance issue on the Android emulators only, but I only have one physical Android device to test on. I also see "disk I/O" errors on the emulator which lead to the same result - database queries that fail. This makes more sense than "database is locked" anyway -- SQLite is using WAL mode, which uses a secondary transaction log file. The solution on Android may be to implement a retry mechanism, but I would prefer to find the root cause why this happens first; I would expect SQLite to handle the slow storage better than it seems to.

[djp952]

Root cause appears to have been the introduction of a connection pool for the SQLite database without cleaning up the steps and order of operations used when opening a new connection. Database schema and static table data were being reinitialized unnecessarily but more importantly ensuring that the database is set for WAL and setting up the busy handler was being done after these initialization tasks. These changes appear to have resolved the problem.