[Bug 867887] New: devel:languages:python:Factory/python: test failures with SQLite 3.8.4
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=867887 https://bugzilla.novell.com/show_bug.cgi?id=867887#c0 Summary: devel:languages:python:Factory/python: test failures with SQLite 3.8.4 Classification: openSUSE Product: openSUSE.org Version: unspecified Platform: All OS/Version: openSUSE 13.2 Status: NEW Severity: Normal Priority: P5 - None Component: 3rd party software AssignedTo: jmatejek@suse.com ReportedBy: Andreas.Stieger@gmx.de QAContact: opensuse-communityscreening@forge.provo.novell.com Found By: Community User Blocker: --- Hello, Python and python3 in factory fail with SQLite 3.8.4 (3.8.4.1) https://build.opensuse.org/request/show/225584 test_sqlite fails with the below: [ 296s] test_sqlite [ 296s] /home/abuild/rpmbuild/BUILD/Python-2.7.6/Lib/sqlite3/test/dbapi.py:656: DeprecationWarning: buffer() not supported in 3.x [ 296s] b = sqlite.Binary(chr(0) + "'") [ 296s] /home/abuild/rpmbuild/BUILD/Python-2.7.6/Lib/sqlite3/test/types.py:70: DeprecationWarning: buffer() not supported in 3.x [ 296s] val = buffer("Guglhupf") [ 296s] /home/abuild/rpmbuild/BUILD/Python-2.7.6/Lib/sqlite3/test/types.py:234: DeprecationWarning: buffer() not supported in 3.x [ 296s] val = buffer("Guglhupf") [ 296s] /home/abuild/rpmbuild/BUILD/Python-2.7.6/Lib/sqlite3/test/types.py:350: DeprecationWarning: buffer() not supported in 3.x [ 296s] result = self.con.execute('select ? as "x [bin]"', (buffer(zlib.compress(testdata)),)).fetchone()[0] [ 296s] /home/abuild/rpmbuild/BUILD/Python-2.7.6/Lib/sqlite3/test/userfunctions.py:39: DeprecationWarning: buffer() not supported in 3.x [ 296s] return buffer("blob") [ 296s] /home/abuild/rpmbuild/BUILD/Python-2.7.6/Lib/sqlite3/test/userfunctions.py:206: DeprecationWarning: buffer() not supported in 3.x [ 296s] self.assertEqual(val, buffer("blob")) [ 296s] /home/abuild/rpmbuild/BUILD/Python-2.7.6/Lib/sqlite3/test/userfunctions.py:249: DeprecationWarning: buffer() not supported in 3.x [ 296s] cur.execute("select isblob(?)", (buffer("blob"),)) [ 296s] /home/abuild/rpmbuild/BUILD/Python-2.7.6/Lib/sqlite3/test/userfunctions.py:273: DeprecationWarning: buffer() not supported in 3.x [ 296s] ("foo", 5, 3.14, None, buffer("blob"),)) [ 296s] /home/abuild/rpmbuild/BUILD/Python-2.7.6/Lib/sqlite3/test/userfunctions.py:365: DeprecationWarning: buffer() not supported in 3.x [ 296s] cur.execute("select checkType('blob', ?)", (buffer("blob"),)) [ 296s] test test_sqlite failed -- Traceback (most recent call last): [ 296s] File "/home/abuild/rpmbuild/BUILD/Python-2.7.6/Lib/sqlite3/test/hooks.py", line 165, in CheckOpcodeCount [ 296s] self.assertTrue(first_count > second_count) [ 296s] AssertionError: False is not true Could you have a look at that? -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=867887
https://bugzilla.novell.com/show_bug.cgi?id=867887#c
Jan Matejek
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=867887
https://bugzilla.novell.com/show_bug.cgi?id=867887#c1
Jan Matejek
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=867887
https://bugzilla.novell.com/show_bug.cgi?id=867887#c2
--- Comment #2 from Andreas Stieger
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=867887
https://bugzilla.novell.com/show_bug.cgi?id=867887#c3
--- Comment #3 from Andreas Stieger
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=867887
https://bugzilla.novell.com/show_bug.cgi?id=867887#c4
--- Comment #4 from Andreas Stieger
throwing back at you ;)
Many thanks for the research on the Python test. http://hg.python.org/cpython/file/2.7/Lib/sqlite3/test/hooks.py#l165 I attached a C program to this issue demonstrate the SQLite behaviour as you said you didn't know the API much.
if this behavior is intentional, or if you think that this is somehow python's fault (i didn't try to reproduce in plain C, because i don't know sqlite's C API), feel free to reassign back to me
cpython developers say that none of their build bots build on SQLite 3.8.4 yet so this was not noticed. Reported upstream: http://bugs.python.org/issue20901 I *believe* this is simply a side effect of optimisations on the SQLite side. I asked them for clarification as well. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=867887
https://bugzilla.novell.com/show_bug.cgi?id=867887#c5
Andreas Stieger
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=867887
https://bugzilla.novell.com/show_bug.cgi?id=867887#c
Jan Matejek
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=867887
https://bugzilla.novell.com/show_bug.cgi?id=867887#c6
--- Comment #6 from Andreas Stieger
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=867887
https://bugzilla.novell.com/show_bug.cgi?id=867887#c7
Jan Matejek
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=867887
https://bugzilla.novell.com/show_bug.cgi?id=867887#c8
--- Comment #8 from Bernhard Wiedemann
participants (1)
-
bugzilla_noreply@novell.com