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.