Dear all, What are the circumstances leading to:
int status = sqlite3_wal_checkpoint_v2(conn, "main", SQLITE_CHECKPOINT_PASSIVE, 0, 0); returning SQLITE_LOCKED immediately? It looks like that the simple fact of having a select statement prepared, then ran, but not yet finalized, on that same connection, induces the SQLITE_LOCKED return. I can get it to go away by simply finalizing the last statement before trying checkpoint. I just did not expected LOCKED to be returned. Reading https://www.sqlite.org/c3ref/wal_checkpoint_v2.html I expected to get SQLITE_BUSY. My misunderstanding probably. I have no problem with that, I'm merely gathering knowledge of how to best use it. -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/o=m
