Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

[closed] Jazz SCM being too slow

hi,

after a 4 months, it is now taking my team (3/4 developers) in average 2 to 5mins to deliver change-sets to our main stream as opposed to 2/5 seconds.

And sometimes we are even having errors like:
<i:a4cf4e4c0f> Deliver Failed
Transaction rollback
Lock Details:
SQL: select ce.ITEM_ID from SCM.COMPONENT_ENTRY ce where
(ce.WORKSPACE_ITEM_ID=&quot;_rM3YMLSOEd2a4aLeUTwOHQ' and...
...
SQL Exception #1
SQL Message: A lock could not be obtained within the time requested
SQL State 40XL1
Error Code: 30000 </i:a4cf4e4c0f>

We have checked the Jazz server and its hard disk usage is still 50% of full capacity.

Do you have any ideas to improve this performance issue? Any work around?

Many thanks.
Marc

0 votes


The question has been closed for the following reason: "Problem is not reproducible or outdated" by daviddl Oct 10 '17, 2:39 p.m.


One answer

Permanent link
after a 4 months, it is now taking my team (3/4 developers) in average 2
to 5mins to deliver change-sets to our main stream as opposed to 2/5
seconds.

And sometimes we are even having errors like: Deliver Failed
Transaction rollback
Lock Details:
SQL: select ce.ITEM_ID from SCM.COMPONENT_ENTRY ce where
(ce.WORKSPACE_ITEM_ID=&quot;_rM3YMLSOEd2a4aLeUTwOHQ' and... ..
SQL Exception #1
SQL Message: A lock could not be obtained within the time requested SQL
State 40XL1
Error Code: 30000

We have checked the Jazz server and its hard disk usage is still 50% of
full capacity.

Do you have any ideas to improve this performance issue? Any work
around?

This error means that your operation was waiting for another operation
that was being performed on the same stream and timed out. If you can
post a snapshot of all the operations running on the server at the time
it will give us a better understanding of what the problem might be.

- Dmitry

0 votes

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 1,202

Question asked: Nov 18 '08, 12:54 p.m.

Question was seen: 7,221 times

Last updated: Oct 10 '17, 2:39 p.m.

Confirmation Cancel Confirm