2014-07-24 02:41:10.333 ERROR nova.api.openstack [req-fada9cb0-dc8f-4df2-9091-63fa8cd122bb SecurityGroupsTestAdminXML-1229086057 SecurityGroupsTestAdminXML-905056083] Caught error: (OperationalError) (1213, 'Deadlock found when trying to get lock; try restarting transaction') 'SELECT quota_usages.created_at AS quota_usages_created_at, quota_usages.updated_at AS quota_usages_updated_at, quota_usages.deleted_at AS quota_usages_deleted_at, quota_usages.deleted AS quota_usages_deleted, quota_usages.id AS quota_usages_id, quota_usages.project_id AS quota_usages_project_id, quota_usages.user_id AS quota_usages_user_id, quota_usages.resource AS quota_usages_resource, quota_usages.in_use AS quota_usages_in_use, quota_usages.reserved AS quota_usages_reserved, quota_usages.until_refresh AS quota_usages_until_refresh \nFROM quota_usages \nWHERE quota_usages.deleted = %s AND quota_usages.project_id = %s FOR UPDATE' (0, '6ef984821ac44a64b42a9f8a30e6a08b')
looks like some db deadlock is ocurring
2014-07-24 02:41:10.333 ERROR nova.api.openstack [req-fada9cb0- dc8f-4df2- 9091-63fa8cd122 bb SecurityGroupsT estAdminXML- 1229086057 SecurityGroupsT estAdminXML- 905056083] Caught error: (OperationalError) (1213, 'Deadlock found when trying to get lock; try restarting transaction') 'SELECT quota_usages. created_ at AS quota_usages_ created_ at, quota_usages. updated_ at AS quota_usages_ updated_ at, quota_usages. deleted_ at AS quota_usages_ deleted_ at, quota_usages. deleted AS quota_usages_ deleted, quota_usages.id AS quota_usages_id, quota_usages. project_ id AS quota_usages_ project_ id, quota_usages. user_id AS quota_usages_ user_id, quota_usages. resource AS quota_usages_ resource, quota_usages.in_use AS quota_usages_ in_use, quota_usages. reserved AS quota_usages_ reserved, quota_usages. until_refresh AS quota_usages_ until_refresh \nFROM quota_usages \nWHERE quota_usages. deleted = %s AND quota_usages. project_ id = %s FOR UPDATE' (0, '6ef984821ac44a 64b42a9f8a30e6a 08b')