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