[Spacewalk-list] Need help troubleshooting spacewalk-repo-sync

[Ron Helzer]

Hello fellow Spacewalk users,



I’m having some trouble synchronizing channels and have exhausted all
troubleshooting efforts I can think of.



Background:

  - Spacewalk 2.1 on CentOS 5.10 i386 which has been upgraded through every
Spacewalk release since, probably, version 0.2.

  - Was on Oracle XE, but performance and other minor issues motivated
migrating to Postgresql.

  - Postgresql migration went smoothly and everything works, except…



Problem:

  - spacewalk-repo-sync runs flawlessly for small repositories. CentOS 5
updates, Spacewalk client tools, VMware tools all sync correctly.

  - Larger repositories (such as the CentOS base and spacewalk server
repos) partially sync, but never fully sync.



For example, ` spacewalk-repo-sync --channel spacewalk-i386 --type yum`
says:



   Packages in repo:               221

   Packages already synced:        132

   Packages to sync:                89



It runs to completion with no errors and appears to sync the remaining 89
packages, but if I run the same sync again there are still 89 packages left
to sync. The base channels “Packages to sync” numbers are much higher (2453
of 2789 for CentOS 5 i386 base).



What I’ve tried:

  - Deleted all packages in the effected channels and re-sync; no change.

  - Deleted and re-created the channels; no change.

  - Tuned Postgresql (`pgtune --type=web -c 600`, enabled autovacuum) ; no
change.

  - Tried to sync from local .iso rather than remote repository; no change.

  - spacewalk-data-fsck with various options (`-r` deletes the packages
from the disk, and spacewalk-repo-sync will re-download them, but they
still don’t make it into the database)

  - Numerous restarts of taskomatic, Spacewalk, Postgresql etc. to no avail…



I’ve poured through logs, but do not see any indication of where the
problem lies.



Any hints or assistance would be greatly appreciated, as I would rather not
have to start from scratch with this particular Spacewalk installation.



Regards,


- Ron -
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140502/e1342ae0/attachment.htm>