[Spacewalk-list] Problems with Spacewalk and Oracle Linux repo sync/updates

[faris at gmx.us]

Yes, that bug looks like to be the issue. I applied this patch as well and now it works. It might be necessary for at least 1 package to be synced to the channel (either new/updated or by first deleting an existing package) for it to be correctly/fully synced. Web UI error also went away as expected.
To sum up - these are the 2 patches needed:
http://git.fedorahosted.org/cgit/spacewalk.git/commit/?id=39088b67a5f28d5f0ecb8a2a2fc959db815f2098
http://git.fedorahosted.org/cgit/spacewalk.git/commit/?id=9d9fffa018e46233baf02e3b35ef7cc63337a7ed
Thanks to Michael and Milan for the solution.
  
faris at gmx.us wrote:
% I applied the patch (thanks for the speedy fix) and re-ran the sync. This time I receive:
% ===
% #> spacewalk-repo-sync --channel channel-oel6-latest-64
% Repo URL: http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/
% Packages in repo: 18319
% No new packages to sync.
% Repo http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/ has comps file comps.xml.
% Repo http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/ has 1006 errata.
% ERROR: null value in column "product" violates not-null constraint
% Sync completed.
% Total time: 0:14:48
% ===
% echo $? after this returned 0.
% 
% I think that the web UI error is directly related to the "main" problem with sync. Even when I try to yum upgrade from the Oracle Linux clients manually, it appears that the client does not see any updated packages, although there are some visible in the web UI. Looks like the sync happens only partially.

This is most likely bug https://bugzilla.redhat.com/show_bug.cgi?id=860860
which has been fixed in spacewalk-backend-1.9.1-1.

If you want to fix your spacewalk 1.8 you may safely apply patch
http://git.fedorahosted.org/cgit/spacewalk.git/commit/?id=9d9fffa018e46233baf02e3b35ef7cc63337a7ed

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list