[Spacewalk-list] Spacewalk 1.5 clients returning 404 when doing yum update/install

[Michael Morgan]

Sorry to dig up an old thread but I just started seeing the same 404's on my
1.5 clients. Was there ever a confirmed resolution to this issue? The proposed
patch seems to have fixed the taskomatic errors but I still cannot install or
upgrade packages on any of my clients.

This install has been working mostly trouble free for months, I've verified the
packages exist in the exact path that generates a 404, and I do not have any
AVC denials logged. Any help would be appreciated.

On Mon, Oct 24, 2011 at 11:09:03PM +0200, Jan Pazdziora wrote:
> On Mon, Oct 24, 2011 at 11:55:58AM -0600, Brandon Johnson wrote:
> > > Did this ever work on your installation? Are there any AVC denials?
> > 
> > Yes it has worked on this installation.  None that I can see in the logs.
> > 
> > 
> > I just noticed this in the taskomatic log:
> > 
> > INFO   | jvm 1    | 2011/10/24 12:00:00 | 2011-10-24 12:00:00,096 [DefaultQuartzScheduler_Worker-4] INFO  com.redhat.rhn.taskomatic.task.ErrataCacheTask - In the queue: 1
> > INFO   | jvm 1    | 2011/10/24 12:00:00 | 2011-10-24 12:00:00,530 [Thread-80] ERROR com.redhat.rhn.manager.errata.cache.UpdateErrataCacheCommand - Problem updating cache for servers in channel
> > INFO   | jvm 1    | 2011/10/24 12:00:00 | com.redhat.rhn.common.db.WrappedSQLException: ERROR: relation "old_packages" already exists
> > INFO   | jvm 1    | 2011/10/24 12:00:00 |   Where: SQL statement "create temp table old_packages ( errata_id numeric, package_id numeric ) on commit drop"
> > INFO   | jvm 1    | 2011/10/24 12:00:00 | PL/pgSQL function "update_needed_cache" line 7 at SQL statement
> > INFO   | jvm 1    | 2011/10/24 12:00:00 | SQL statement "SELECT  rhn_server.update_needed_cache( $1 )"
> > INFO   | jvm 1    | 2011/10/24 12:00:00 | PL/pgSQL function "update_needed_cache" line 12 at PERFORM
> 
> This issue was fixed in Spacewalk master with commit
> d51fb288da2226782ed18452dc766cb3256a19a2.
> 
> You might want to apply
> 
> 	http://git.fedorahosted.org/git/?p=spacewalk.git;a=blob;f=schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/085-rhn_server.pkb.sql.postgresql;h=cedb4b97450d04585ccbd528ca132f699bf24043;hb=d51fb288da2226782ed18452dc766cb3256a19a2
> 
> to your database schema.
> 
> -- 
> Jan Pazdziora
> Principal Software Engineer, Satellite Engineering, Red Hat
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list

--
Michael Morgan
Network Technician, DCANet