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

[Andreas Hasenack]

Can you please clarify the error in the [test plan]? I suppose at some point you will get something like 
"'<' not supported between instances of 'datetime.datetime' and 'NoneType'"? Just so that someone following the test plan knows what to expect.

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