event type creation may fail due to a race condtion

[John Herndon]

when event_type or trait_types are created in the sqlalchemy implementation of the storage driver, a race condition exists where one thread could create the event/trait type while another thread is looking it up. The solution may be to catch an exception and try to load the definition from the database.

[shubham chitranshi (chitranshi-shubham)]

Hello Pradeep, Can you tell me how far did you go with this ??
any kind of heads up is appreciated ..!!

[gordon chung (chungg)]

hi shubham, you'll want to do something similar to this: https://github.com/openstack/ceilometer/blob/master/ceilometer/storage/impl_sqlalchemy.py#L242-L262

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/289787
Committed: https://git.openstack.org/cgit/openstack/ceilometer/commit/?id=6f2d7cbc076c6964062d2199aa3dfd4b9064e28d
Submitter: Jenkins
Branch: master

commit 6f2d7cbc076c6964062d2199aa3dfd4b9064e28d
Author: Edwin Zhai <email address hidden>
Date: Tue Mar 8 08:25:15 2016 +0000

    Fix event_type creationg failure due to race condition

    Race condition exists when 2 threads try to create same event_type, so
    need detect it and load the event_type again.

    Change-Id: If3439817cfbfef90daeb5975338909f8312864c4
    Closes-Bug: #1254800

[Doug Hellmann (doug-hellmann)]

This issue was fixed in the openstack/ceilometer 6.0.0.0rc1 release candidate.