[Bug 2019175] Re: [SRU] Fix None comparison when sorting by `updated_at`

[Andreas Hasenack]

Hello Andreas, or anyone else affected,

Accepted heat into focal-proposed. The package will build now and be
available at https://launchpad.net/ubuntu/+source/heat/1:14.2.0-0ubuntu2
in a few hours, and then in the -proposed repository.

Please help us by testing this new package.  See
https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how
to enable and use -proposed.  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, what testing has been
performed on the package and change the tag from verification-needed-
focal to verification-done-focal. If it does not fix the bug for you,
please add a comment stating that, and change the tag to verification-
failed-focal. In either case, without details of your testing we will
not be able to proceed.

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

N.B. The updated package will be released to -updates after the bug(s)
fixed by this package have been verified and the package has been in
-proposed for a minimum of 7 days.

** Changed in: heat (Ubuntu Focal)
       Status: New => Fix Committed

** Tags added: verification-needed verification-needed-focal

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

Title:
  [SRU] Fix None comparison when sorting by `updated_at`

Status in Ubuntu Cloud Archive:
  Fix Released
Status in Ubuntu Cloud Archive ussuri series:
  In Progress
Status in Ubuntu Cloud Archive victoria series:
  Fix Committed
Status in Ubuntu Cloud Archive wallaby series:
  Fix Released
Status in Ubuntu Cloud Archive xena series:
  Fix Released
Status in Ubuntu Cloud Archive yoga series:
  Fix Released
Status in Ubuntu Cloud Archive zed series:
  Fix Released
Status in heat package in Ubuntu:
  Fix Released
Status in heat source package in Focal:
  Fix Committed

Bug description:
  StoryBoard link: https://storyboard.openstack.org/#!/story/2009653

  [Impact]

  If resource candidates were never updated before then their `updated_at` value in the db remain `None`.
  This prevents future resource updates when any of of the resources in db has been replaced without being updated before.

  [Test Plan]

  A. Reproducer steps:
    1. create a project and nova instances using > 1 vcpus in that project
    2. create a stack with a OS::Nova::Quota resource managing the project's quotas
    3. change the vcpu quota to an invalid value (i.e. 0) and update the stack three times
    4. set a valid quota and update the stack again

  B. Install the package with fix
  C. Re-run the reproducer steps again
  D. Confirm that resource updates (can repeat several times as well) is either successful or fails with a different message for another reason

  [Where problems could occur]

  If the `created_at` value happens to `None` as well for some reason then this will end up failing in the same manner.
  Newer OpenStack versions already contain this fix and released packages (Wallaby, Yoga, and Zed) work as expected.

  [Other info]

  The fix was backported to Ussuri after the last release of Heat (14.2).
  Upstream PR: https://review.opendev.org/c/openstack/heat/+/837697

  This was impacting a user who is using Ussuri. Latest releases already contain the fix in the following packages:
  Wallaby: heat_16.1.0-0ubuntu1~cloud0
  Yoga: heat_18.0.0-0ubuntu1.2~cloud0
  Zed: heat_19.0.0-0ubuntu1.2~cloud0

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