2 failures in unit tests with SQLite on Debian jessie

[Jun Omae]

See ​https://circleci.com/workflow-run/cd61f5a3-5201-4f93-97c5-3b52bcdc201c.

Unit tests with SQLite has 2 failures but the tests with PostgreSQL and MySQL pass on CircleCI.

Python: /home/circleci/venv/bin/python

  Package        Version
  -------------------------------------------------------
  Python       : 2.7.14 (default, Sep 18 2017, 20:47:33) 
               : [GCC 4.9.2]
  Setuptools   : 36.6.0
  Genshi       : 0.7 (with speedups)
  Babel        : 2.5.1
  sqlite3      : 2.6.0 (3.8.7.1)
  PySqlite     : not installed
  MySQLdb      : 1.2.5
  Psycopg2     : 2.7.3.2 (dt dec pq3 ext lo64)
  SVN bindings : not installed
  Mercurial    : not installed
  Pygments     : 2.2.0
  Textile      : 2.3.16
  Pytz         : 2017.3
  ConfigObj    : 5.0.6
  Docutils     : 0.14
  Twill        : 0.9
  LXML         : 4.1.1
  coverage     : not installed
  figleaf      : not installed

Variables:
  PATH=/home/circleci/venv/bin:/usr/local/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
  PYTHONPATH=.
  TRAC_TEST_DB_URI=
  server-options= -p 8000  -r -e 

External dependencies:
  Git version: git version 2.1.4
  Subversion version: 1.8.10

...

======================================================================
FAIL: test_all_ordered_by_version (trac.ticket.tests.query.QueryTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/home/circleci/project/trac/ticket/tests/query.py", line 211, in test_all_ordered_by_version
    [t['version'] for t in tickets])
AssertionError: Lists differ: ['1.0', '2.0', '0.0', '0.0', '... != [u'0.0', u'0.0', u'version1', ...

First differing element 0:
'1.0'
u'0.0'

- ['1.0', '2.0', '0.0', '0.0', 'version1', 'version1', '', '', '', '']
?  ^^^^^^^^^^^^^^

+ [u'0.0', u'0.0', u'version1', u'version1', u'1.0', u'2.0', '', '', '', '']
?  ^       +       +            +            ++++++++++++++++


======================================================================
FAIL: test_all_ordered_by_version_desc (trac.ticket.tests.query.QueryTestCase)
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/home/circleci/project/trac/ticket/tests/query.py", line 226, in test_all_ordered_by_version_desc
    [t['version'] for t in tickets])
AssertionError: Lists differ: ['', '', '', '', 'version1', '... != ['', '', '', '', u'2.0', u'1.0...

First differing element 4:
'version1'
u'2.0'

- ['', '', '', '', 'version1', 'version1', '0.0', '0.0', '2.0', '1.0']
?                                                      --------------

+ ['', '', '', '', u'2.0', u'1.0', u'version1', u'version1', u'0.0', u'0.0']
?                  +++++++++++++++++            +            +       +


----------------------------------------------------------------------
Ran 1724 tests in 78.155s

FAILED (failures=2)
Makefile:377: recipe for target 'unit-test' failed
make: *** [unit-test] Error 1
Exited with code 2

[Jun Omae]

Reproduced it with circleci/python:2.7 on docker.

[Jun Omae]

I guess SQLite 3.8.7 and 3.8.7.1 have something wrong.

pysqlite 2.6.0 with SQLite 3.8.6	passed
pysqlite 2.6.0 with SQLite 3.8.7	2 failures
pysqlite 2.6.0 with SQLite 3.8.7.1	2 failures
pysqlite 2.6.0 with SQLite 3.8.7.2	passed

Also, reproduced it with Debian jessie which ​SQLite package on Debian jessie (old stable) is 3.8.7.1 on Docker.

[Jun Omae]

That's an issue in SQLite 3.8.7 and 3.8.7.1. No way to avoid the issue….

[Ryan J Ollos]

If there's nothing to be done, I'm going to go ahead and close the ticket.