[Spacewalk-list] Spacewalk 2.0 UI shows repo cache continually in-progress

[Burnett, Robert Mark]

My question to the list, is how to remove a queued repodata task to taskomatic.  I seems I have a task stuck in the queue and it is unable to rebuild the repo cache, until this task is removed or completes but it never does complete.

Spacewalk 2.0 is Oracle's build but with embedded PostgresSQL 8.4 DB which Oracle doesn't support.
Spacewalk  Web UI shows channel no last build and channel repo cache build "in-progress"  but it never finishes.
Checked /var/log/rhn/rhn_taskomatic_daemon.log... shows below every single minute.

INFO   | jvm 3    | 2015/01/16 22:21:00 | 2015-01-16 22:21:00,043 [DefaultQuartzScheduler_Worker-9] INFO  com.redhat.rhn.taskomatic.task.ChannelRepodata - In the queue: 1
INFO   | jvm 3    | 2015/01/16 22:22:00 | 2015-01-16 22:22:00,042 [DefaultQuartzScheduler_Worker-3] INFO  com.redhat.rhn.taskomatic.task.ChannelRepodata - In the queue: 1
INFO   | jvm 3    | 2015/01/16 22:23:00 | 2015-01-16 22:23:00,078 [DefaultQuartzScheduler_Worker-8] INFO  com.redhat.rhn.taskomatic.task.ChannelRepodata - In the queue: 1
INFO   | jvm 3    | 2015/01/16 22:24:00 | 2015-01-16 22:24:00,043 [DefaultQuartzScheduler_Worker-7] INFO  com.redhat.rhn.taskomatic.task.ChannelRepodata - In the queue: 1


I see in the log where the task is queued ...

INFO   | jvm 1    | 2015/01/15 16:13:33 | 2015-01-15 16:13:33,010 [Thread-53] INFO  com.redhat.rhn.taskomatic.task.repomd.RepositoryWriter - Generating new repository metadata for channel 'oraclelinux6-x86_64'(sha256) 23357 packages, 1644 errata

But I never see a corresponding log entry (like the following) where it finished like this one... actually this is last one I can find in looking back in the logs, so this has been broken for some time.
INFO   | jvm 1    | 2014/12/12 04:19:14 | 2014-12-12 04:19:14,612 [Thread-6912] INFO  com.redhat.rhn.taskomatic.task.repomd.RepositoryWriter - Repository metadata generation for 'oraclelinux6-x86_64' finished in 142 seconds

Please help, how do I access psql and safely remove this queued task, so I can rebuild the repo cache?

Thank you for any support or advice you can provide.

Robert Burnett



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