SQLite Forum

Database WAL snapshot
I have an open database connection, and am opening a second connection to the same database. I need those connections to see the same data, so I'm trying to use the "sqlite3_snapshot_get" functionality.

However, it's not working for me. Could someone help point out what I'm doing wrong?
My process:

 - The database is in WAL mode, and there are no open connections to it (so no "-shm" and "-wal" files)
 - Open database connection 1 read-only
 - Start a transaction on connection 1, and read some things
 - (In another process) write some new data to the database
 - As expected, the "-shm" and "-wal" files exist, and connection 1 cannot see the changes made (if I actually do some queries, which I do not do in this reproduction)
 - Open database connection 2 read-only
 - Call `sqlite3_snapshot_get(connection1, "main", &snapshot)`
 - This returns SQLITE_ERROR

Based on the [documentation](https://www.sqlite.org/c3ref/snapshot_get.html) however, I expected this to return SQLITE_OK and a snapshot:

 - The database is not in autocommit mode (I have an open transaction)
 - Schema "main" is in WAL mode
 - There is no write transaction open on connection 1 (there is no open write transaction at all)
 - The WAL file has a written transaction

Thus, I am unable to apply such a snapshot to connection 2.