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.<br><br>When running spacewalk-repo-sync I received <br><br><div style="margin-left: 40px;">
1/749 : dbus-c++-0.5.0-0.10.20090203git13281b3.1.el6-0.i686<br>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<br>
...<br>749/749 : kacst-qurn-fonts-2.0-7.el6-0.noarch<br>Could not find object [<spacewalk.server.importlib.importLib.IncompletePackage instance; attributes={..}] in table rhnPackage<br>Repo file:///var/www/mrepo/rhel-server-6.1-i386/RPMS.os/ has 0 errata.<br>
Sync complete<br></div><br>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. <br>
<br><div style="margin-left: 40px;">spaceschema=# SELECT *<br>FROM rhnPackage<br>WHERE evr_id = 5864;<br> 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<br>
| header_sig | copyright | cookie | last_modified | created | modified | header_start | header_end<br>
------+--------+---------+--------+-----------------+---------------+-------------+--------------------------------------------------------+-------------------------------+--------------+--------------+-----------------------------+---------------------+---------------+-------------+---------------+----------------+--------+------------------------------------------------------------------------------------------------------------<br>
------------------------------------------------------------------------------+------------+-----------+--------+------------------------+-------------------------------+-------------------------------+--------------+------------<br>
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 | <a href="http://hs20-bc2-5.build.redhat.com" target="_blank">hs20-bc2-5.build.redhat.com</a> | 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<br>
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<br>
(1 row)<br></div><br>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.<br><br>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?<br>