.commit() versus .execute('COMMIT')
dcharno <[email protected]>
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
I upgraded code on a system running pysqlite 2.3.4 and sqlite 3.4.2 and
then started getting database locked errors. After a bit of debugging I
found that my transaction wasn't committing, although I don't see any
exceptions or errors. I changed the call to commit() with
.execute('COMMIT') and the problem disappeared.
I need to upgrade pysqlite and sqlite, but I'm wondering if this was/is
a known issue.