Bug 627149 - system.listPackages fails when install time is null
Summary: system.listPackages fails when install time is null
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Upgrades
Version: 540
Hardware: All
OS: Linux
Target Milestone: ---
Assignee: Tomas Lestach
QA Contact: Šimon Lukašík
Whiteboard: Fixed in the 5.4.0 Release - GA'd 201...
Depends On:
Blocks: sat540-upgrades
TreeView+ depends on / blocked
Reported: 2010-08-25 08:26 UTC by Tomas Lestach
Modified: 2010-10-28 15:04 UTC (History)
4 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Last Closed: 2010-10-28 15:04:00 UTC
Target Upstream Version:

Attachments (Terms of Use)

Description Tomas Lestach 2010-08-25 08:26:35 UTC
Description of problem:
provide an upgrade script for rpm installation dates

There's an upgrade script that adds the installtime column to the rhnServerPackage table, but no script that would set the installtime to a not null value for already registered clients.
null installtime values can cause troubles to API call system.listPackages, since xmlrpc cannot pass null values.

Version-Release number of selected component (if applicable):
upgrade from sat530 to sat540

Additional info:
suggested script:
UPDATE rhnServerPackage SET installtime = created WHERE installtime IS null;

Comment 1 Tomas Lestach 2010-08-25 08:36:04 UTC
upgrade script added into spacewalk/schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2 directory

spacewalk.git: 376771d95de9c620f925b3938f27662389301c44

Comment 2 Tomas Lestach 2010-08-30 11:24:43 UTC
Agreed on satellite-devel that it's better not to include a null installtime item, than to set some value to the DB via an upgrade script

spacewalk.git: c122bd485b19c27b3338af682bbf50798bfef5f6

Comment 4 Šimon Lukašík 2010-10-06 14:16:18 UTC
Changing to VERIFIED:

Test procedure:
- Register clients to sat530, upgrade to sat540
- Api call should not return key 'installtime' within the dict
- Webui should report "not specified"
- rhn-profile sync
- should return item 'installtime' within the dict
- webui should report same dates
- Registered clients with older rhnlib into sat540
- rest is the same as per 1)
3) Behaviour and documentation matches
4) Dates seems to be correct

Verified against:

Special thanks to Martin.

Comment 5 Clifford Perry 2010-10-28 15:04:00 UTC
The 5.4.0 RHN Satellite and RHN Proxy release has occurred. This issue has been resolved with this release. 

RHEA-2010:0801 - RHN Satellite Server 5.4.0 Upgrade

RHEA-2010:0803 - RHN Tools enhancement update

RHEA-2010:0802 - RHN Proxy Server 5.4.0 bug fix update

RHEA-2010:0800 - RHN Satellite Server 5.4.0

Docs are available:



Note You need to log in before you can comment on or make changes to this bug.