Unable to delete heat stacks with large number of resources

Solution Verified - Updated -

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

Environment

  • Red Hat OpenStack Platform 10.0

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In