[Spacewalk-list] Could not find object IncompletePackage in table rhnPackage

[john miller]

I believe I have partial package records in the database that are keeping
me from adding packages. I believe this is a result of a failed rhn-push.

When running spacewalk-repo-sync I received

1/749 : dbus-c++-0.5.0-0.10.20090203git13281b3.1.el6-0.i686
Could not find object
[<spacewalk.server.importlib.importLib.IncompletePackage instance;
attributes={'package_size': None, 'package_arch_id': 104, 'name':
'dbus-c++', 'checksum_list': None, 'md5sum': None, 'org_id': '1', 'epoch':
'', 'checksums': {'sha256':
'b28266c522816ffdfcef565fd51b00de757273fd913f16cebedeb4db106a8b88'},
'channels': {118: 'rhel6-dev-updates-i386'}, 'nevra_id': 12728,
'package_id': None, 'last_modified': None, 'name_id': 7109, 'version':
'0.5.0', 'checksum':
'b28266c522816ffdfcef565fd51b00de757273fd913f16cebedeb4db106a8b88',
'release': '0.10.20090203git13281b3.1.el6', 'checksum_type': 'sha256',
'arch': 'i686', 'evr_id': 5864, 'checksum_id': 820849}] in table rhnPackage
...
749/749 : kacst-qurn-fonts-2.0-7.el6-0.noarch
Could not find object
[<spacewalk.server.importlib.importLib.IncompletePackage instance;
attributes={..}] in table rhnPackage
Repo file:///var/www/mrepo/rhel-server-6.1-i386/RPMS.os/ has 0 errata.
Sync complete

The packages were not listed in the web gui channels->manage software
channels->manage software packages. The packages did appear in the
rhnPackage table though.

spaceschema=# SELECT *
FROM rhnPackage
WHERE evr_id = 5864;
  id  | org_id | name_id | evr_id | package_arch_id | package_group |
rpm_version |                      description
|            summary            | package_size | payload_size |
build_host          |     build_time      | source_rpm_id | checksum_id
|    vendor     | payload_format | compat
|
path

| header_sig | copyright | cookie |     last_modified      |
created            |           modified            | header_start |
header_end
------+--------+---------+--------+-----------------+---------------+-------------+--------------------------------------------------------+-------------------------------+--------------+--------------+-----------------------------+---------------------+---------------+-------------+---------------+----------------+--------+------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------+------------+-----------+--------+------------------------+-------------------------------+-------------------------------+--------------+------------
 7209 |        |    7109 |   5864 |             104 |             8 |
4.7.1       | Native C++ bindings for D-Bus for use in C++ programs. |
Native C++ bindings for D-Bus |       110776 |       315464 |
hs20-bc2-5.build.redhat.com | 2009-12-08 14:54:40 |          4372 |
820849 | Red Hat, Inc. | cpio           |      0 |
redhat/NULL/b28/dbus-c++/0.5.0-0.10.20090203git13281b3.1.el6/i686/b28266c522816ffdfcef565fd51b00de757273fd9
13f16cebedeb4db106a8b88/dbus-c++-0.5.0-0.10.20090203git13281b3.1.el6.i686.rpm
|            | LGPLv2+   |        | 2011-11-23 07:51:06-06 | 2011-11-23
07:51:06.317076-06 | 2011-11-23 07:51:06.317076-06 |         1384 |
6520
(1 row)

some of the data in rhnPackage did not line up with the error messages
returned by spacewalk-repo-sync. namely package_size, org_id, and
last_modified.

I have deleted the channels and ran spacewalk-data-fsck but the data
remains in the rhnPackage table. Is there a cleanup script or a way to
remove the records so the repo-sync can complete?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20111129/4ecfd2b6/attachment.htm>