[New-bugs-announce] [issue37539] CheckCommitCursorReset regression sqlite3 test fails with old sqlite3

[Matej Cepl]

New submission from Matej Cepl <mcepl at cepl.eu>:

When building Python 2.7.16 on very old SUSE Enterprise Linux (SLE-11), with gcc 4.3, sqlite3 3.6.4, CheckCommitCursorReset fails with:

test test_sqlite failed -- Traceback (most recent call last):
  File "/usr/src/packages/BUILD/Python-2.7.16/Lib/sqlite3/test/regression.py", line 338, in CheckCommitCursorReset
    con.commit()
OperationalError: cannot commit transaction - SQL statements in progress

It seems to me the problem is that the select from https://github.com/python/cpython/blob/master/Lib/sqlite3/test/regression.py#L353 is still open, while we run con.commit(). It should be probably better to store output of that enumerate somewhere and work on that variable instead.

----------
components: Library (Lib)
files: log.txt
messages: 347606
nosy: mcepl
priority: normal
severity: normal
status: open
title: CheckCommitCursorReset regression sqlite3 test fails with old sqlite3
versions: Python 2.7, Python 3.8, Python 3.9
Added file: https://bugs.python.org/file48465/log.txt

_______________________________________
Python tracker <report at bugs.python.org>
<https://bugs.python.org/issue37539>
_______________________________________