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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
