Comment 1 for bug 1348178

Revision history for this message
Christopher Yeoh (cyeoh-0) wrote :

looks like some db deadlock is ocurring

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')