[New-bugs-announce] [issue29003] sqlite3: can't run VACUUM on Python 3.6

[Ma Lin]

New submission from Ma Lin:

I'm using Python 3.6.0 RC2.
When I try to run VACUUM command, an exception raised:

conn.execute('begin')  # <- remove this line get the same result
conn.execute('VACUUM')

sqlite3.OperationalError: cannot VACUUM from within a transaction

On Python 3.5, everything is fine.
Attached file cant_vacuum.py is the full example code.

----------
related issue: #10740 sqlite3 module breaks transactions and potentially corrupts data

R. David Murray said in #10740 about this issue:
It is an unexpected change in behavior and is therefore probably a bug.  It will work if you set isolation_level=None.  Because of that I don't think it is a release critical bug, though one could wish we'd discovered it earlier.

----------
components: Library (Lib)
files: cannot_vacuum.py
messages: 283532
nosy: Ma Lin
priority: normal
severity: normal
status: open
title: sqlite3: can't run VACUUM on Python 3.6
type: behavior
versions: Python 3.6, Python 3.7
Added file: http://bugs.python.org/file45950/cannot_vacuum.py

_______________________________________
Python tracker <report at bugs.python.org>
<http://bugs.python.org/issue29003>
_______________________________________