[Bug 1524387] Please test proposed package

[James Page]

Hello Steven, or anyone else affected,

Accepted heat into liberty-proposed. The package will build now and be
available in the Ubuntu Cloud Archive in a few hours, and then in the
-proposed repository.

Please help us by testing this new package. To enable the -proposed
repository:

  sudo add-apt-repository cloud-archive:liberty-proposed
  sudo apt-get update

Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug,
mentioning the version of the package you tested, and change the tag
from verification-liberty-needed to verification-liberty-done. If it
does not fix the bug for you, please add a comment stating that, and
change the tag to verification-liberty-failed. In either case, details
of your testing will help us make a better decision.

Further information regarding the verification process can be found at
https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in
advance!

** Changed in: cloud-archive/liberty
       Status: In Progress => Fix Committed

** Tags added: verification-liberty-needed

-- 
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to Ubuntu Cloud Archive.
https://bugs.launchpad.net/bugs/1524387

Title:
  heat-manage purge_deleted broken

Status in Ubuntu Cloud Archive:
  Invalid
Status in Ubuntu Cloud Archive liberty series:
  Fix Committed
Status in heat:
  Fix Released
Status in heat kilo series:
  Fix Released

Bug description:
  I'm seeing this, reverting the fix for bug #1506079 appears to fix it
  - I'm seeing this on CentOS7 and Fedora 21 mariadb.

  
  2015-12-09 15:19:36.682 ERROR oslo_db.sqlalchemy.exc_filters [-] DBAPIError exception wrapped from (pymysql.err.InternalError) (1093, u"Table 'raw_template' is specified twice, both as a target for 'DELETE' and as a separate source for data") [SQL: u'DELETE FROM raw_template WHERE raw_template.id IN (SELECT raw_template.id \nFROM raw_template LEFT OUTER JOIN stack ON stack.prev_raw_template_id = raw_template.id OR stack.raw_template_id = raw_template.id \nWHERE stack.id IS NULL)']
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters     context)
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters     cursor.execute(statement, parameters)
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 146, in execute
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters     result = self._query(query)
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/site-packages/pymysql/cursors.py", line 296, in _query
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters     conn.query(q)
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 781, in query
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 942, in _read_query_result
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters     result.read()
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1138, in read
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters     first_packet = self.connection._read_packet()
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 906, in _read_packet
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters     packet.check_error()
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 367, in check_error
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters     err.raise_mysql_exception(self._data)
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 120, in raise_mysql_exception
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters     _check_mysql_exception(errinfo)
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 115, in _check_mysql_exception
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters     raise InternalError(errno, errorvalue)
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters InternalError: (1093, u"Table 'raw_template' is specified twice, both as a target for 'DELETE' and as a separate source for data")
  2015-12-09 15:19:36.682 TRACE oslo_db.sqlalchemy.exc_filters 
  ERROR: (pymysql.err.InternalError) (1093, u"Table 'raw_template' is specified twice, both as a target for 'DELETE' and as a separate source for data") [SQL: u'DELETE FROM raw_template WHERE raw_template.id IN (SELECT raw_template.id \nFROM raw_template LEFT OUTER JOIN stack ON stack.prev_raw_template_id = raw_template.id OR stack.raw_template_id = raw_template.id \nWHERE stack.id IS NULL)']

To manage notifications about this bug go to:
https://bugs.launchpad.net/cloud-archive/+bug/1524387/+subscriptions