[issue29003] sqlite3: can't run VACUUM on Python 3.6

[Berker Peksag]

Berker Peksag added the comment:

Thanks for trying pre-release versions of Python 3.6, Ma Lin. This has already 
been reported in issue 28518 so I'm closing this as a duplicate.

--
resolution:  -> duplicate
stage:  -> resolved
status: open -> closed
superseder:  -> execute("begin immediate") throwing OperationalError

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue29003] sqlite3: can't run VACUUM on Python 3.6

[Ned Deily]

Changes by Ned Deily :


--
keywords: +3.6regression
nosy: +berker.peksag, ghaering

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[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 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com