OperationalError: cannot change into wal mode from within a transaction

[simonw]

I'm getting this error when running:

sqlite-utils enable-wal beta.db

OperationalError: cannot change into wal mode from within a transaction

I'm worried that maybe that's because of this new code from #152:

sqlite-utils/sqlite_utils/db.py

Lines 128 to 129 in deb2eb0

	if recursive_triggers:
	self.execute("PRAGMA recursive_triggers=on;")

[simonw]

Running this against the same file works:

$ sqlite3 beta.db 
SQLite version 3.31.1 2020-01-27 19:55:54
Enter ".help" for usage hints.
sqlite> PRAGMA journal_mode=wal;
wal

[simonw]

This is already covered in the tests though:

sqlite-utils/tests/test_cli.py

Lines 1300 to 1328 in deb2eb0

	def test_enable_wal():
	runner = CliRunner()
	dbs = ["test.db", "test2.db"]
	with runner.isolated_filesystem():
	for dbname in dbs:
	db = Database(dbname)
	db["t"].create({"pk": int}, pk="pk")
	assert db.journal_mode == "delete"
	result = runner.invoke(cli.cli, ["enable-wal"] + dbs)
	assert 0 == result.exit_code
	for dbname in dbs:
	db = Database(dbname)
	assert db.journal_mode == "wal"
	def test_disable_wal():
	runner = CliRunner()
	dbs = ["test.db", "test2.db"]
	with runner.isolated_filesystem():
	for dbname in dbs:
	db = Database(dbname)
	db["t"].create({"pk": int}, pk="pk")
	db.enable_wal()
	assert db.journal_mode == "wal"
	result = runner.invoke(cli.cli, ["disable-wal"] + dbs)
	assert 0 == result.exit_code
	for dbname in dbs:
	db = Database(dbname)
	assert db.journal_mode == "delete"