It's all about the answers!

Ask a question

Tablespace CCMTEMP increases without end


Olivier BERDAH (1144) | asked Dec 05 '12, 3:32 a.m.

Hello All,

Although,

1) after a RTC restart

{

gbsuser@sa9lrtcd01:/home/gbsuser > sudo su -
[root@sa9lrtcd01 ~]# su - webadmin
[webadmin@sa9lrtcd01 ~]$ cd /exploit/scripts/appli/was/
[webadmin@sa9lrtcd01 was]$ stopCLMServer.sh
ADMU0116I: Tool information is being logged in file
           /opt/WebSphere/profiles/safranCLMNode/logs/CLMServer/stopServer.log
ADMU0128I: Starting tool with the safranCLMNode profile
ADMU3100I: Reading configuration for server: CLMServer
ADMU3201I: Server stop request issued. Waiting for stop status.
ADMU4000I: Server CLMServer stop completed.

[webadmin@sa9lrtcd01 was]$ startCLMServer.sh
ADMU0116I: Tool information is being logged in file
           /opt/WebSphere/profiles/safranCLMNode/logs/CLMServer/startServer.log
ADMU0128I: Starting tool with the safranCLMNode profile
ADMU3100I: Reading configuration for server: CLMServer
ADMU3200I: Server launched. Waiting for initialization status.
ADMU3000I: Server CLMServer open for e-business; process id is 3255
}

2) And increase of the CLMD.CCMTEMP,

 ==> The Tablespace CLMD.CCMTEMP continue increases without end, until the tablespace reach 100% used.

_______________________________________________________________________________________________

JBE gives that indications :

2012-12-04 10:31:47 [Jazz build engine] Exception occurred in build loop: CRJAZ0368I A SQL query failed to execute properly on the server.

stmt = with ctx as (select CONTEXT_UUID as ctx_uuid from CCM.REPOSITORY_CONTEXT_MEMBERS where MEMBER_UUID in('_8lNyYNwSEd2pIJ5QVwgQGg', '_sIo661fiEeGMdZJM5V60sA') union (select '_sIo661fiEeGMdZJM5V60sA' from dual )) select t1.ITEM_ID, t1.STATE_ID from (select * from CCM.BUILD_BUILD_RESULT r1 where r1.CONTEXT_ID in(select ctx_uuid from ctx)) t1 left outer join CCM.BUILD_BUILD_RESULT_BUILD_RQSTS j1 on (t1.ITEM_ID = j1.JZ_PARENT_ID) left outer join (select * from CCM.BUILD_BUILD_REQUEST r1 where r1.CONTEXT_ID in(select ctx_uuid from ctx)) t2 on (j1.ITEM_ID = t2.ITEM_ID) where ((t1.BUILD_STATE = ?) and (t2.HANDLER_ITEM_ID = ?)) order by t1.BUILD_START_TIME desc

com.ibm.team.repository.common.InternalRepositoryException: CRJAZ0368I A SQL query failed to execute properly on the server.

stmt = with ctx as (select CONTEXT_UUID as ctx_uuid from CCM.REPOSITORY_CONTEXT_MEMBERS where MEMBER_UUID in('_8lNyYNwSEd2pIJ5QVwgQGg', '_sIo661fiEeGMdZJM5V60sA') union (select '_sIo661fiEeGMdZJM5V60sA' from dual )) select t1.ITEM_ID, t1.STATE_ID from (select * from CCM.BUILD_BUILD_RESULT r1 where r1.CONTEXT_ID in(select ctx_uuid from ctx)) t1 left outer join CCM.BUILD_BUILD_RESULT_BUILD_RQSTS j1 on (t1.ITEM_ID = j1.JZ_PARENT_ID) left outer join (select * from CCM.BUILD_BUILD_REQUEST r1 where r1.CONTEXT_ID in(select ctx_uuid from ctx)) t2 on (j1.ITEM_ID = t2.ITEM_ID) where ((t1.BUILD_STATE = ?) and (t2.HANDLER_ITEM_ID = ?)) order by t1.BUILD_START_TIME desc

Caused by: java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace CCMTEMP

Someone can help us, please.

Thanks in advance.

Mobylette

olivier.berdah@fr.ibm.com

One answer



permanent link
Olivier BERDAH (1144) | answered Dec 06 '12, 11:28 a.m.
  The problem was fixed with :
1. 
SQL> select PROFILE from dba_users where USERNAME='CCM';

PROFILE
------------------------------
DEFAULT


SQL> select RESOURCE_NAME, LIMIT, PROFILE from dba_profiles where RESOURCE_NAME='IDLE_TIME' and PROFILE='DEFAULT';

RESOURCE_NAME                    LIMIT
-------------------------------- ----------------------------------------
PROFILE
------------------------------
IDLE_TIME                        60
DEFAULT

SQL> ALTER PROFILE DEFAULT LIMIT idle_time 60;

Profile altered.

SQL> show parameter resource_limit

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
resource_limit                       boolean     FALSE

SQL> show parameter resource_limit

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
resource_limit                       boolean     FALSE
SQL> alter system set resource_limit=true scope=both;

System altered.

SQL> show parameter resource_limit

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
resource_limit                       boolean     TRUE

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.