dbc.execute('VACUUM') error

[SanaRinomi]

I get the following error:
Traceback (most recent call last): File "C:\Users\amelia\Desktop\tf2idb.py", line 228, in <module> main() File "C:\Users\amelia\Desktop\tf2idb.py", line 224, in main dbc.execute('VACUUM') sqlite3.OperationalError: cannot VACUUM from within a transaction

[fakuivan]

What version of python are you using? (python -V)

[Zolika1351]

Same here using Python 3.6.1, also accidentally tried to use 2.7.10 because I have both installed and got the same error.

[James76931]

Can confirm. Getting this issue on my end also.

[FlaminSarge]

That is really odd; I get no trouble on 3.5.3 and 2.7.10 with the VACUUM operation, but I do get the issue on 3.6.1.

Looks like this is why ghaering/pysqlite#109

[FlaminSarge]

Also https://bugs.python.org/issue28518

[FlaminSarge]

(Simple fix would be to move the db.commit() line above the VACUUM line, probably. Might need to add another commit line, I'm not sure).