[issue37539] CheckCommitCursorReset regression sqlite3 test fails with old sqlite3

[Berker Peksag]

Berker Peksag  added the comment:

Thank you for the report and for the patch!

The minimum supported SQLite 3 version in Python 3 is 3.7.2 as declared at 
https://github.com/python/cpython/blob/9f37872e307734666a7169f7be6e3370d3068282/setup.py#L1364
 

While it's still 3.0.8 in Python 2.7 
(https://github.com/python/cpython/blob/249706c1fbce04125d81bd9993e6c010ae30f8e4/setup.py#L1175),
 I think we can live without the patch as Python 2.7 is now officially dead.

Of course, we can still apply it if one of our 2.7 buildbots were failing due 
to an ancient version of SQLite 3.

--
resolution:  -> wont fix
stage:  -> resolved
status: open -> closed
type:  -> behavior
versions:  -Python 3.8, Python 3.9

___
Python tracker 

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

[issue37539] CheckCommitCursorReset regression sqlite3 test fails with old sqlite3

[Matej Cepl]

Matej Cepl  added the comment:

Fix for this situations (and we are talking about sqlite3 3.6.4, which is truly 
archaeological excavation) skip particular test.

--
keywords: +patch
Added file: https://bugs.python.org/file48833/avoid-sqlite-race.patch

___
Python tracker 

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

[issue37539] CheckCommitCursorReset regression sqlite3 test fails with old sqlite3

[Karthikeyan Singaravelan]

Change by Karthikeyan Singaravelan :


--
nosy: +berker.peksag

___
Python tracker 

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

[issue37539] CheckCommitCursorReset regression sqlite3 test fails with old sqlite3

[Matej Cepl]

New submission from Matej Cepl :

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 

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