Issue

• sporadic unique constraint violations logged in /var/log/rhn/rhn_taskomatic_daemon.log after satellite-sync or packages pushed into channel:

INFO   | jvm 1    | 2013/06/19 06:03:00 | 2013-06-19 06:03:00,558 [Thread-138437] ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing cached statement sql: insert into rhnPackageRepodata (package_id)
INFO   | jvm 1    | 2013/06/19 06:03:00 |               (select cp.package_id as id from rhnChannelPackage cp left join rhnPackageRepoData rd on cp.package_id = rd.package_id
INFO   | jvm 1    | 2013/06/19 06:03:00 |                       where cp.channel_id = ?
INFO   | jvm 1    | 2013/06/19 06:03:00 |                         and rd.package_id is null)
INFO   | jvm 1    | 2013/06/19 06:03:00 | com.redhat.rhn.common.db.ConstraintViolationException: ORA-00001: unique constraint (RHNSAT.RHNPACKAGEREPODATA_PK) violated
INFO   | jvm 1    | 2013/06/19 06:03:00 |
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:75)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:141)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:455)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:431)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at com.redhat.rhn.common.db.datasource.CachedStatement.executeUpdate(CachedStatement.java:271)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at com.redhat.rhn.common.db.datasource.WriteMode.executeUpdate(WriteMode.java:33)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at com.redhat.rhn.manager.rhnpackage.PackageManager.createRepoEntrys(PackageManager.java:1198)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at com.redhat.rhn.taskomatic.task.repomd.RpmRepositoryWriter.writeRepomdFiles(RpmRepositoryWriter.java:91)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at com.redhat.rhn.taskomatic.task.repomd.ChannelRepodataWorker.run(ChannelRepodataWorker.java:104)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:761)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at java.lang.Thread.run(Thread.java:736)
INFO   | jvm 1    | 2013/06/19 06:03:00 | Caused by:
INFO   | jvm 1    | 2013/06/19 06:03:00 | java.sql.SQLException: ORA-00001: unique constraint (RHNSAT.RHNPACKAGEREPODATA_PK) violated
INFO   | jvm 1    | 2013/06/19 06:03:00 |
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:571)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at oracle.jdbc.driver.T2CPreparedStatement.executeForRows(T2CPreparedStatement.java:764)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:138)
INFO   | jvm 1    | 2013/06/19 06:03:00 |       ... 9 more