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

[Brandon Johnson]

> 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
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:56)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:45)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:118)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:511)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at com.redhat.rhn.manager.errata.cache.ErrataCacheManager.updateErrataAndPackageCacheForChannel(ErrataCacheManager.java:403)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at com.redhat.rhn.manager.errata.cache.UpdateErrataCacheCommand.updateErrataCacheForChannel(UpdateErrataCacheCommand.java:180)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at com.redhat.rhn.taskomatic.task.errata.ErrataCacheWorker.run(ErrataCacheWorker.java:77)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:761)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at java.lang.Thread.run(Thread.java:636)
INFO   | jvm 1    | 2011/10/24 12:00:00 | Caused by: org.postgresql.util.PSQLException: 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
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:360)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2417)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:115)
INFO   | jvm 1    | 2011/10/24 12:00:00 | 	... 7 more

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