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 <[email protected]>
<http://bugs.python.org/issue29003>
_______________________________________
_______________________________________________
Python-bugs-list mailing list
Unsubscribe:
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
