The documentation <a href="https://www.sqlite.org/pragma.html#pragma_wal_checkpoint" r

Cannot read result row of pragma wal_checkpoint about go-sqlite3 HOT 4 CLOSED

CyrusJavan commented on June 12, 2024

Cannot read result row of pragma wal_checkpoint

from go-sqlite3.

Comments (4)

rittneje commented on June 12, 2024

Please share a complete reproducible example, including which version of this library you are using.

from go-sqlite3.

otoolep commented on June 12, 2024

FWIW, I use this functionality heavily in rqlite, and I get non-zero values back for the scan. In other words, it seems to work fine for me.

Here is me running a hacked up unit test from rqlite:

$ git diff
diff --git a/db/db.go b/db/db.go
index 6135ff90..75fc0b96 100644
--- a/db/db.go
+++ b/db/db.go
@@ -398,6 +398,7 @@ func (db *DB) CheckpointWithTimeout(mode CheckpointMode, dur time.Duration) (err
        if err := db.rwDB.QueryRow(checkpointPRAGMAs[mode]).Scan(&ok, &nPages, &nMoved); err != nil {
                return fmt.Errorf("error checkpointing WAL: %s", err.Error())
        }
+       fmt.Println("checkpointed", nPages, "pages", nMoved, "moved")
        stats.Add(numCheckpointedPages, int64(nPages))
        stats.Add(numCheckpointedMoves, int64(nMoved))
        if ok != 0 {
$ go test -run Test_DBSums
checkpointed 3 pages 3 moved
PASS
ok  	github.com/rqlite/rqlite/v8/db	0.048s
~/repos/rqlite/src/github.com/rqlite/rqlite/db (master)$

from go-sqlite3.

CyrusJavan commented on June 12, 2024

Nevermind, I could not reproduce in an isolated environment. My theory is that SQLite is doing an automatic checkpoint already once all the inflight transactions are finished. That is why the manual checkpoint returns all zeroes.

from go-sqlite3.

otoolep commented on June 12, 2024

Easy enough to validate, disable automatic checkpoints as rqlite does.

from go-sqlite3.

Recommend Projects