> 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
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
