[Spacewalk-list] Taskomatic error

[John Hodrien]

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