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:
Deliver Failed
Transaction rollback
Lock Details:
SQL: select ce.ITEM_ID from SCM.COMPONENT_ENTRY ce where
(ce.WORKSPACE_ITEM_ID="_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?
Many thanks.
Marc
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:
Transaction rollback
Lock Details:
SQL: select ce.ITEM_ID from SCM.COMPONENT_ENTRY ce where
(ce.WORKSPACE_ITEM_ID="_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?
Many thanks.
Marc
One answer
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="_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