Hi,
We have started to see issues (c40+ a day) where the 'From' and 'To' Status values are the same.
This appears to the end user as though the transition has failed but the issue actually has been updated. To resolve the issue the user has to re-transition it back and forth through the workflow.
Can anyone offer any advice on what is causing this to happen?
status.png
Thanks
I was going to post that KB article next - hope it helps
yes, found this https://confluence.atlassian.com/display/JIRAKB/Deadlock+when+running+JIRA+with+SQL+Server and was looking into other possibilities..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Are you running on SQL Server?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SQL Exception while executing the following:SELECT ID, issueid, AUTHOR, CREATED FROM dbo.changegroup WHERE issueid IN (?) ORDER BY CREATED ASC, ID ASC (Transaction (Process ID 283) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Do you see anything in your logs at the time when these transitions happened?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No, all transitions are to different Statuses.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Do you have a transition from "In Progress" to "In Progress"?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.