[Spacewalk-list] Taskomatic error

[Jan Pazdziora]

On Tue, Sep 20, 2011 at 10:11:35AM +0100, John Hodrien wrote:
> 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?

Bug, fixed recently by

	http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=d51fb288da2226782ed18452dc766cb3256a19a2

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat