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

Solution Verified - Updated -

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
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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content