cannot VACUUM from within a transaction

[qgib]

Author Name: Arjan Mossel (Arjan Mossel)
Original Redmine Issue: 18079
Affected QGIS version: master
Redmine category:db_manager

---

In the current version of QGIS 2.99 it is not possible to run VACUUM on a SQLite database. Error:

"cannot VACUUM from within a transaction"

Related:
https://bugs.python.org/issue28518
ghaering/pysqlite#109 with a workaround

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

How do you trigger this error in QGIS? I've been unable to reproduce.

---

• status_id was changed from Open to Feedback

[qgib]

Author Name: Arjan Mossel (Arjan Mossel)

---

I installed QGIS 2.99 (alongside 2.18) via osgeo4w-setup-x86_64.exe, on Windows 7. Currently at b6ad920 (updated yesterday).

I can reproduce it by doing "New SpatiaLite layer", creating a new database with a table with just a text field. Then opening this database in the Database Manager and doing "Run Vacuum" results in a popup with "cannot VACUUM from within a transaction".

---

• status_id was changed from Feedback to Open

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

• regression was changed from 0 to 1

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

Confirmed on Windows

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

PR #6338

---

• status_id was changed from Open to In Progress
• pull_request_patch_supplied was changed from 0 to 1

[qgib]

Author Name: Nyall Dawson (@nyalldawson)

---

Applied in changeset 838bde3.

---

• status_id was changed from In Progress to Closed
• done_ratio was changed from 0 to 100

[qgib]

Author Name: Giovanni Manghi (@gioman)

---

• resolution was changed from to fixed/implemented