Spacewalk 1.5 Postgres Taskomatic reports errors:
INFO | jvm 1 | 2011/09/20 09:32:01 | 2011-09-20 09:32:01,138 [DefaultQuartzScheduler_Worker-5] INFO com.redhat.rhn.taskomatic.task.ChannelRepodata - In the queue: 1 INFO | jvm 1 | 2011/09/20 09:32:01 | 2011-09-20 09:32:01,271 [Thread-5576] INFO com.redhat.rhn.taskomatic.task.repomd.RepositoryWriter - File Modified Date:2011-09-20 09:24:13 BST INFO | jvm 1 | 2011/09/20 09:32:01 | 2011-09-20 09:32:01,271 [Thread-5576] INFO com.redhat.rhn.taskomatic.task.repomd.RepositoryWriter - Channel Modified Date:2011-09-20 09:31:40 BST INFO | jvm 1 | 2011/09/20 09:32:01 | 2011-09-20 09:32:01,380 [Thread-5576] INFO com.redhat.rhn.taskomatic.task.repomd.RepositoryWriter - Generating new repository metadata for channel 'centos-6-engineering'(sha1) 136 packages, 0 errata INFO | jvm 1 | 2011/09/20 09:32:06 | 2011-09-20 09:32:06,169 [Thread-5576] INFO com.redhat.rhn.taskomatic.task.repomd.RepositoryWriter - Repository metadata generation for 'centos-6-engineering' finished in 4 seconds INFO | jvm 1 | 2011/09/20 09:40:00 | 2011-09-20 09:40:00,242 [DefaultQuartzScheduler_Worker-7] INFO com.redhat.rhn.taskomatic.task.ErrataCacheTask - In the queue: 1 INFO | jvm 1 | 2011/09/20 09:40:00 | 2011-09-20 09:40:00,520 [Thread-5606] ERROR com.redhat.rhn.manager.errata.cache.UpdateErrataCacheCommand - Problem updating cache for servers in channel INFO | jvm 1 | 2011/09/20 09:40:00 | com.redhat.rhn.common.db.WrappedSQLException: ERROR: relation "old_packages" already exists INFO | jvm 1 | 2011/09/20 09:40:00 | Where: SQL statement "create temp table old_packages ( errata_id numeric, package_id numeric ) on commit drop" INFO | jvm 1 | 2011/09/20 09:40:00 | PL/pgSQL function "update_needed_cache" line 7 at SQL statement INFO | jvm 1 | 2011/09/20 09:40:00 | SQL statement "SELECT rhn_server.update_needed_cache( $1 )" INFO | jvm 1 | 2011/09/20 09:40:00 | PL/pgSQL function "update_needed_cache" line 12 at PERFORM INFO | jvm 1 | 2011/09/20 09:40:00 | at com.redhat.rhn.common.translation.SqlExceptionTranslator.postgreSqlException(SqlExceptionTranslator.java:56) INFO | jvm 1 | 2011/09/20 09:40:00 | at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:45) INFO | jvm 1 | 2011/09/20 09:40:00 | at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:118) INFO | jvm 1 | 2011/09/20 09:40:00 | at com.redhat.rhn.common.db.datasource.CachedStatement.executeCallable(CachedStatement.java:511) INFO | jvm 1 | 2011/09/20 09:40:00 | at com.redhat.rhn.common.db.datasource.CallableMode.execute(CallableMode.java:34) INFO | jvm 1 | 2011/09/20 09:40:00 | at com.redhat.rhn.manager.errata.cache.ErrataCacheManager.updateErrataAndPackageCacheForChannel(ErrataCacheManager.java:403) INFO | jvm 1 | 2011/09/20 09:40:00 | at com.redhat.rhn.manager.errata.cache.UpdateErrataCacheCommand.updateErrataCacheForChannel(UpdateErrataCacheCommand.java:180) INFO | jvm 1 | 2011/09/20 09:40:00 | at com.redhat.rhn.taskomatic.task.errata.ErrataCacheWorker.run(ErrataCacheWorker.java:77) INFO | jvm 1 | 2011/09/20 09:40:00 | at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:761) INFO | jvm 1 | 2011/09/20 09:40:00 | at java.lang.Thread.run(Thread.java:636) INFO | jvm 1 | 2011/09/20 09:40:00 | Caused by: org.postgresql.util.PSQLException: ERROR: relation "old_packages" already exists INFO | jvm 1 | 2011/09/20 09:40:00 | Where: SQL statement "create temp table old_packages ( errata_id numeric, package_id numeric ) on commit drop" INFO | jvm 1 | 2011/09/20 09:40:00 | PL/pgSQL function "update_needed_cache" line 7 at SQL statement INFO | jvm 1 | 2011/09/20 09:40:00 | SQL statement "SELECT rhn_server.update_needed_cache( $1 )" INFO | jvm 1 | 2011/09/20 09:40:00 | PL/pgSQL function "update_needed_cache" line 12 at PERFORM INFO | jvm 1 | 2011/09/20 09:40:00 | at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) INFO | jvm 1 | 2011/09/20 09:40:00 | at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) INFO | jvm 1 | 2011/09/20 09:40:00 | at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) INFO | jvm 1 | 2011/09/20 09:40:00 | at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) INFO | jvm 1 | 2011/09/20 09:40:00 | at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) INFO | jvm 1 | 2011/09/20 09:40:00 | at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:360) INFO | jvm 1 | 2011/09/20 09:40:00 | at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.execute(NewProxyCallableStatement.java:2417) INFO | jvm 1 | 2011/09/20 09:40:00 | at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:115) INFO | jvm 1 | 2011/09/20 09:40:00 | ... 7 more Anything to worry about or is this just noise? jh _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
