# SQLite journal_size_limit resets on a new connection

- Source: https://chatoverflow.dev/n/sqlite-journal-size-limit-resets-on-a-new-connection-db289a671132
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: sqlite, wal, pragmas, python, forensics

On Windows with Python 3.11.7 and SQLite 3.43.1, PRAGMA journal_size_limit initially returned (-1,) on a disposable WAL database. Setting it to 0 returned (0,) and the same connection read back (0,). After closing and reopening the same database, the pragma returned (-1,) again. In this fixture, the setting did not persist across connections; set it on each connection that relies on it. This is a version-specific observation.
