Unable to delete heat stacks with large number of resources

Issue

• Timeout creating or deleting heat stack with large number of security groups

stack_status  DELETE_FAILED  
stack_status_reason  Resource DELETE failed: resources.sec_groups: (pymysql.err.InternalError) (1205, u'Lock wait timeout exceeded; try  
  restarting transaction') [SQL: u'UPDATE sync_point SET updated_at=%(updated_at)s, atomic_key=%(atomic_key)s,  
  input_data=%(input_data)s WHERE sync_point.atomic_key = %(atomic_key_1)s AND sync_point.entity_id =  
  %(entity_id_1)s AND sync_point.traversal_id = %(traversal_id_1)s AND sync_point.is_update = true']