Tablespace CCMTEMP increases without end
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
One answer