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

[Jan Pazdziora]

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