gate-mistral-devstack-dsvm-kombu-nv job failing

[Sharat Sharma]

The gate-mistral-devstack-dsvm-kombu-nv job is failing:

Captured traceback:
~~~~~~~~~~~~~~~~~~~
     Traceback (most recent call last):
       File "/opt/stack/new/mistral/mistral_tempest_tests/tests/api/v2/test_actions.py", line 332, in test_update_action
         self.assertEqual(act_created_at.split(".")[0], updated_act_created_at)
       File "/usr/local/lib/python2.7/dist-packages/testtools/testcase.py", line 411, in assertEqual
         self.assertThat(observed, matcher, message)
       File "/usr/local/lib/python2.7/dist-packages/testtools/testcase.py", line 498, in assertThat
         raise mismatch_error
     testtools.matchers._impl.MismatchError: u'2016-11-25 13:54:44' != u'2016-11-25 13:54:45'

Need to fix this.

[Dawid Deja (dawid-deja-0)]

I found the root cause. Example return from action-create:

16397215-8ef9-46f0-8c72-b54389221230 | greeting | False | name | This action says 'Hello' | hello | 2016-11-30 15:09:46.598605 | None

And how it is stored in DB?

+---------------------+------------+----------+
| created_at | updated_at | name |
+---------------------+------------+----------+
| 2016-11-30 15:09:47 | NULL | greeting |
+---------------------+------------+----------+

And I was able to reproduce it using standard oslo (not kombu driver). Fix is on it's way.

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/406143
Committed: https://git.openstack.org/cgit/openstack/mistral/commit/?id=a5be14f2fee59622b104b7797a449e21f4319978
Submitter: Jenkins
Branch: master

commit a5be14f2fee59622b104b7797a449e21f4319978
Author: Dawid Deja <email address hidden>
Date: Fri Dec 2 11:14:17 2016 +0100

    Fix for failing kombu gate

    Mysql is rounding the microseconds to one second,
    which leads to time inconsistency beetwen what
    is returned to cllient and what is stored in the DB.
    This patch changes the behaviour, so that no mircoseconds
    gets genereated.

    Closes-bug: 1644881

    Change-Id: I514c1d5154b3c658ec74c88b800d2a3ded1fdad9

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/mistral 4.0.0.0b2 development milestone.