Icehouse failing with libsqlite >= 3.8.2

[Chuck Short]

======================================================================
FAIL: nova.tests.virt.docker.test_driver.DockerDriverTestCase.test_create_container_wrong_image
tags: worker-1
----------------------------------------------------------------------
Empty attachments:
  pythonlogging:''
  stdout

stderr: {{{
/tmp/buildd/nova-2014.1~b1+master/nova/openstack/common/db/sqlalchemy/session.py:480: DeprecationWarning: BaseException.message has been deprecated as of Python 2.6
  m = _DUP_KEY_RE_DB[engine_name].match(integrity_error.message)
}}}

Traceback (most recent call last):
  File "/tmp/buildd/nova-2014.1~b1+master/nova/tests/virt/docker/test_driver.py", line 184, in test_create_container_wrong_image
    image_info)
  File "/usr/lib/python2.7/dist-packages/testtools/testcase.py", line 394, in assertRaises
    self.assertThat(our_callable, matcher)
  File "/usr/lib/python2.7/dist-packages/testtools/testcase.py", line 406, in assertThat
    mismatch = matcher.match(matchee)
  File "/usr/lib/python2.7/dist-packages/testtools/matchers/_exception.py", line 99, in match
    mismatch = self.exception_matcher.match(exc_info)
  File "/usr/lib/python2.7/dist-packages/testtools/matchers/_higherorder.py", line 61, in match
    mismatch = matcher.match(matchee)
  File "/usr/lib/python2.7/dist-packages/testtools/testcase.py", line 386, in match
    reraise(*matchee)
  File "/usr/lib/python2.7/dist-packages/testtools/matchers/_exception.py", line 92, in match
    result = matchee()
  File "/usr/lib/python2.7/dist-packages/testtools/testcase.py", line 883, in __call__
    return self._callable_object(*self._args, **self._kwargs)
  File "/tmp/buildd/nova-2014.1~b1+master/nova/tests/virt/docker/test_driver.py", line 147, in test_create_container
    instance_href = utils.get_test_instance()
  File "/tmp/buildd/nova-2014.1~b1+master/nova/tests/utils.py", line 78, in get_test_instance
    flavor = get_test_flavor(context)
  File "/tmp/buildd/nova-2014.1~b1+master/nova/tests/utils.py", line 67, in get_test_flavor
    flavor_ref = nova.db.flavor_create(context, test_flavor)
  File "/tmp/buildd/nova-2014.1~b1+master/nova/db/api.py", line 1419, in flavor_create
    return IMPL.flavor_create(context, values, projects=projects)
  File "/tmp/buildd/nova-2014.1~b1+master/nova/db/sqlalchemy/api.py", line 112, in wrapper
    return f(*args, **kwargs)
  File "/tmp/buildd/nova-2014.1~b1+master/nova/db/sqlalchemy/api.py", line 4219, in flavor_create
    raise db_exc.DBError(e)
DBError: (IntegrityError) UNIQUE constraint failed: instance_types.flavorid, instance_types.deleted u'INSERT INTO instance_types (created_at, updated_at, deleted_at, deleted, name, memory_mb, vcpus, root_gb, ephemeral_gb, flavorid, swap, rxtx_factor, vcpu_weight, disabled, is_public) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' ('2014-01-14 14:46:19.926082', None, None, 0, 'kinda.big', 2048, 4, 40, 80, 'someid', 1024, 1.0, None, 0, 1)
======================================================================

[Roman Podoliaka (rpodolyaka)]

This should be fixed by https://review.openstack.org/#/c/57493/

[Chuck Short (zulcss)]

Hey Roman,

I have that patch applied but it still fails.

chuck

[Roman Podoliaka (rpodolyaka)]

libsqlite version 3.8.2 changed the format of error messages (http://repo.or.cz/w/sqlite.git/commit/6b889b7f5759b998436b8c05848b8706cc4e62ac). We should update the common DB code in oslo to parse unique constraint errors correctly.