Description of problem: Taskomatic fails to generate repodata for [EL5|EL6] Base Channels. Version-Release number of selected component (if applicable): Satellite 550 How reproducible: 100% Steps to Reproduce: 1. satellite-sync -c rhel-x86_64-server-5 -c rhel-x86_64-server-6 2. After "satellite-sync' process is done in a several hours/days check if the repodata is generated. Actual results: 1. WebIU - In Progress 2. In /var/cache/rhn/repodata/ # date Wed Aug 29 08:49:53 EDT 2012 /var/cache/rhn/repodata/rhel-x86_64-server-5: total 12 -rw-r--r--. 1 root root 10 Aug 28 15:57 filelists.xml.gz.new -rw-r--r--. 1 root root 10 Aug 28 15:57 other.xml.gz.new -rw-r--r--. 1 root root 10 Aug 28 15:57 primary.xml.gz.new /var/cache/rhn/repodata/rhel-x86_64-server-6: total 12 -rw-r--r--. 1 root root 10 Aug 28 15:57 filelists.xml.gz.new -rw-r--r--. 1 root root 10 Aug 28 15:57 other.xml.gz.new -rw-r--r--. 1 root root 10 Aug 28 15:57 primary.xml.gz.new Additional info: For all Taskomatic logs please see Attachement. -bash-4.1$ db-control report Tablespace Size Used Avail Use% DATA_TBS 7.8G 3.3G 4.4G 43% SYSAUX 500M 76.8M 423.1M 15% SYSTEM 400M 284.1M 115.8M 71% TEMP_TBS 1000M 0B 1000M 0% UNDO_TBS 1000M 353.6M 646.3M 35% USERS 128M 64K 127.9M 0% #less /var/log/rhn/rhn_taskomatic_daemon.log INFO | jvm 1 | 2012/08/28 16:01:08 | java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP_TBS INFO | jvm 1 | 2012/08/28 16:01:08 | INFO | jvm 1 | 2012/08/28 16:01:08 | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) INFO | jvm 1 | 2012/08/28 16:01:08 | at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676) INFO | jvm 1 | 2012/08/28 16:01:08 | at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:602) INFO | jvm 1 | 2012/08/28 16:01:08 | at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:571) INFO | jvm 1 | 2012/08/28 16:01:08 | at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049) INFO | jvm 1 | 2012/08/28 16:01:08 | at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154) INFO | jvm 1 | 2012/08/28 16:01:08 | at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370) INFO | jvm 1 | 2012/08/28 16:01:08 | at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3415) INFO | jvm 1 | 2012/08/28 16:01:08 | at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:50) INFO | jvm 1 | 2012/08/28 16:01:08 | at com.redhat.rhn.taskomatic.task.repomd.PackageCapabilityIterator.<init>(PackageCapabilityIterator.java:78)
Created attachment 607909 [details] Taskomatic Logs
Does regenerating the statistics (db-control gather-stats) and possibly restarting taskomatic fix the issue?
Created attachment 610201 [details] Sat 541 Taskomatic Daemon Log
Syncing of single: - rhel-x86_64-server-6 channel # grep finished /var/log/rhn/rhn_taskomatic_daemon.log Repository metadata generation for 'rhel-x86_64-server-6' finished in 1954 seconds - rhel-x86_64-server-5 channel (14034 packages, 140 errata) repodata generation fails with: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP_TBS
Default TEMP size has increased to 2GB for new databases. Spacewalk master: commit d0fa4b8949cda9d2102f4de2ac0a6de6e4f0e95a 852757 - create 2GB TEMP by default SATELLITE-5.5: commit 6f553735d19d524ee8a9756766359e046e82a01d 852757 - create 2GB TEMP by default
This issue is resolved with the release of RHN Satellite 5.5. As of September 20th 2012, RHN Satellite 5.5 has been generally available. Release Notes and other 5.5 documentation can be found here: https://access.redhat.com/knowledge/docs/Red_Hat_Network_Satellite/ The associated Errata for the 5.5 release are: 5.5 Satellite GA Errata - http://rhn.redhat.com/errata/RHEA-2012-1296.html 5.5 Upgrade Errata - http://rhn.redhat.com/errata/RHEA-2012-1298.html 5.5 RHN Proxy GA Errata - http://rhn.redhat.com/errata/RHEA-2012-1297.html 5.5 RHN Tools GA Errata - http://rhn.redhat.com/errata/RHEA-2012-1299.html Regards, Clifford - Engineering Manager, Satellite