Project

General

Profile

Actions

Bug #22952

closed

Account for different datetime format in Suse errata

Added by Jake Callahan about 6 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
High
Assignee:
Category:
Errata Management
Target version:
Difficulty:
easy
Triaged:
Fixed in Releases:
Found in Releases:

Description

Suse uses a different datetime format than what Katello currently expects. Instead of a formatted data and time, they use seconds since Epoch. This is preventing Katello from correctly parsing the date, leading to a blank entry.

Further, it looks like the issue happens during or before the values are stored in the katello_errata table.
id | uuid | errata_id | created_at | updated_at | issued | updated | errata_type | severity |
1 | 003a57f6-48e7-4752-aa07-7c62ac288d17 | openSUSE-2017-1284 | 2018-03-19 13:54:40.547011 | 2018-03-19 13:54:40.552124 | | | recommended | moderate |

Example: <issued date="1519129773" />

Suse's documentation on their updateinfo metadata: https://en.opensuse.org/openSUSE:Standards_Rpm_Metadata_UpdateInfo

Verification steps:
1. Sync a suse repository that contains errata.
- http://download.opensuse.org/update/openSUSE-stable/
2. Check that the issued and updated dates (if applicable) show up correctly in the UI/CLI/API

Actions #1

Updated by Justin Sherrill about 6 years ago

  • Target version set to 245
  • translation missing: en.field_release set to 284
  • Difficulty set to easy
Actions #2

Updated by John Mitsch about 6 years ago

  • Assignee set to John Mitsch
Actions #3

Updated by The Foreman Bot about 6 years ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/Katello/katello/pull/7255 added
Actions #4

Updated by John Mitsch about 6 years ago

  • translation missing: en.field_release changed from 284 to 352
Actions #5

Updated by John Mitsch almost 6 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions

Also available in: Atom PDF