Edgewall Software
Modify

Opened 2 weeks ago

Last modified 2 days ago

#12951 new defect

2 failures in unit tests with SQLite on Debian jessie

Reported by: Jun Omae Owned by:
Priority: normal Milestone: 1.0.17
Component: query system Version:
Severity: normal Keywords: sqlite
Cc:
Release Notes:
API Changes:

Description

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

Attachments (0)

Change History (3)

comment:1 Changed 2 weeks ago by Jun Omae

Reproduced it with circleci/python:2.7 on docker.

comment:2 Changed 3 days ago by 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.

comment:3 Changed 2 days ago by Jun Omae

Keywords: sqlite added
Summary: 2 failures in unit tests with SQLite on CircleCI2 failures in unit tests with SQLite on Debian jessie

Modify Ticket

Change Properties
Set your email in Preferences
Action
as new The ticket will remain with no owner.
The ticket will be disowned.
as The resolution will be set.
The owner will be changed from (none) to anonymous.

Add Comment


E-mail address and name can be saved in the Preferences .

 
Note: See TracTickets for help on using tickets.