test_tranformer unit test fails with ModelNotFoundError: InstanceServiceStatus Not Found

[Thierry Carrez]

py26 unit tests randomly failed with:

2014-10-10 08:03:52.131 | ======================================================================
2014-10-10 08:03:52.132 | FAIL: mgmt.test_models.TestNotificationTransformer.test_tranformer
2014-10-10 08:03:52.132 | tags: worker-7
2014-10-10 08:03:52.132 | ----------------------------------------------------------------------
2014-10-10 08:03:52.133 | Traceback (most recent call last):
2014-10-10 08:03:52.133 | File "/home/jenkins/workspace/gate-trove-python26/trove/tests/unittests/mgmt/test_models.py", line 121, in test_tranformer
2014-10-10 08:03:52.133 | context=self.context)()
2014-10-10 08:03:52.134 | File "trove/extensions/mgmt/instances/models.py", line 223, in __call__
2014-10-10 08:03:52.134 | instance_id=db_info.id)
2014-10-10 08:03:52.134 | File "trove/db/models.py", line 99, in find_by
2014-10-10 08:03:52.135 | {"s_name": cls.__name__})
2014-10-10 08:03:52.135 | ModelNotFoundError: InstanceServiceStatus Not Found

http://logs.openstack.org/41/127441/1/check/gate-trove-python26/5da28bc/console.html

[Nikhil Manchanda (slicknik)]

Seems intermittent. Need to investigate what's going on here.

[Nikhil Manchanda (slicknik)]

Haven't had a chance to look into this yet -- moving to kilo-2.

[Matt Riedemann (mriedem)]

http://logstash.openstack.org/#eyJzZWFyY2giOiJtZXNzYWdlOlwiTW9kZWxOb3RGb3VuZEVycm9yOiBJbnN0YW5jZVNlcnZpY2VTdGF0dXMgTm90IEZvdW5kXCIgQU5EIHRhZ3M6XCJjb25zb2xlXCIgQU5EIGJ1aWxkX25hbWU6XCJnYXRlLXRyb3ZlLXB5dGhvbjI3XCIiLCJmaWVsZHMiOltdLCJvZmZzZXQiOjAsInRpbWVmcmFtZSI6IjYwNDgwMCIsImdyYXBobW9kZSI6ImNvdW50IiwidGltZSI6eyJ1c2VyX2ludGVydmFsIjowfSwic3RhbXAiOjE0MTg4Mjc5OTYwMzIsIm1vZGUiOiIiLCJhbmFseXplX2ZpZWxkIjoiIn0=

9 hits in the last 7 days, check and gate, all failures.

[Matt Riedemann (mriedem)]

e-r query patch: https://review.openstack.org/#/c/142468/

[Ihar Hrachyshka (ihar-hrachyshka)]

Failed in Juno too: http://logs.openstack.org/periodic-stableperiodic-trove-python26-juno/d9a8539/testr_results.html.gz

[Amrith Kumar (amrith)]

Yes, this is an annoying failure.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/169602

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/169602
Committed: https://git.openstack.org/cgit/openstack/trove/commit/?id=80f898d3ba16d5c644447dbacf3a1bad6eaa6488
Submitter: Jenkins
Branch: master

commit 80f898d3ba16d5c644447dbacf3a1bad6eaa6488
Author: Nikhil Manchanda <email address hidden>
Date: Tue Mar 31 20:23:08 2015 -0700

    Fixed NotificationTransformer to handle missing InstanceServiceStatus

    Fixed NotificationTransformer to not send exists notifications for
    new Trove instances which do not have an InstanceServiceStatus
    created for them yet. The notifications for these instances will
    eventually be sent during the next iteration of the scheduled task.

    Change-Id: I002ab89f8c7715310f1890a34967c8172a5d96ef
    Closes-Bug: 1379729

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/juno
Review: https://review.openstack.org/171579

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/171579
Committed: https://git.openstack.org/cgit/openstack/trove/commit/?id=ef23c6ec9f7f932c2a95c70526297c32362b36a7
Submitter: Jenkins
Branch: stable/juno

commit ef23c6ec9f7f932c2a95c70526297c32362b36a7
Author: Nikhil Manchanda <email address hidden>
Date: Tue Mar 31 20:23:08 2015 -0700

    Fixed NotificationTransformer to handle missing InstanceServiceStatus

    Fixed NotificationTransformer to not send exists notifications for
    new Trove instances which do not have an InstanceServiceStatus
    created for them yet. The notifications for these instances will
    eventually be sent during the next iteration of the scheduled task.

    Change-Id: I002ab89f8c7715310f1890a34967c8172a5d96ef
    Closes-Bug: 1379729
    (cherry picked from commit 80f898d3ba16d5c644447dbacf3a1bad6eaa6488)