Continuing to see 'ORA-01652: unable to extend temp segment by 128 in tablespace TEMP_TBS' in rhn_taskomatic_daemon.log even after increasing temp tablespace
Issue
- Even after increasing the size of TEMP_TBS a number of times (as per this article), these errors are continuing to be seen in rhn_taskomatic_daemon.log:
INFO | jvm 1 | 2012/12/18 08:28:00 | 2012-12-18 08:28:00,667 [Thread-58] INFO com.redhat.rhn.taskomatic.task.repomd.RepositoryWriter - Generating new repository metadata for channel 'dev-up-serv-5-64-bit'(sha1) 717 packages, 8 errata
INFO | jvm 1 | 2012/12/18 08:28:39 | 2012-12-18 08:28:39,886 [Thread-59] ERROR com.redhat.rhn.taskomatic.task.repomd.PackageCapabilityIterator - SQLexception
INFO | jvm 1 | 2012/12/18 08:28:39 | java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP_TBS
- The size of the temp tablespace was increased according to this article:
https://access.redhat.com/knowledge/articles/290263
echo 'select count(*) * 0.0001 as "temp size (MB)" from rhnPackageCapability;' | sqlplus -S $(spacewalk-cfg-get default_db)
temp size (MB)
--------------
1287.2956
- TEMP_TBS was increased to 1.3G but the problem continued. It was then increased to 3G but the problem is still occurring.
Environment
- RHN Satellite 5.5
- rhn-schema-version 5.5.0.15-1.el5sat
- satellite-schema-5.5.0.13-1.el6sat.noarch
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.