Hi,
I am experiencing an issue with MySql timing out when I try to close certain issues. This only occurs on one workflow, and not on every ticket in that workflow. I am having a hard time isolating the issue and any ideas for how to troubleshoot would be appreaciated.
Here is the error:
Selection_016.png
Thanks,
Kevin
Ouch, that one usually implies you've got something (either inside or outside JIRA) doing something bad in the database.
Do you have any post-functions on the transition that is failing? Could you list all of them for us? Also, do you have anything that touches the database in any way?
But, first, definitely try Gabrielle's point about the integrity checker. That's the most important step.
I've since discovered that this occurs not only on Close, but on any transition from this one Status ("Retention in Progress") to another status. So it appears the problem may be with this step/status. The integrity check came up with some stepId errors, which is interesting because the error I posted above occurs on "UPDATE OS_CURRENTSTEP". However, these errors are on a totally different project/workflow, so maybe it's just a coincidence. Screenshot: http://postimg.org/image/g6ubymj5x/ As far as post functions, we have one one scripted postfunction plus the 5 that are native to the transition (Trigger generic event, etc.). We also have several scripted validators. But I tried disabling all of these one by one to no avail. Thanks for your attention to this issue, Nic
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok, what version of JIRA are you on (older ones have a known issue with this, only fix is to upgrade)? Also, can you check that your database is using Read-committed transaction isolation? That's the usual culprit (although I'd expect similar errors to be appearing in other places)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Our JIRA version is 6.4.11 and the transation isolation level is "REPEATABLE-READ"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok, the bug was fixed in 5.0 (possibly 4.something high), so it's not the version. However, the transaction isolation level is wrong - it needs to be read-committed - change that in the database while JIRA is offline and restart JIRA, then retry your transitions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you try running the JIRA Integrity Checker and/or JIRA Indexing?
References:
https://confluence.atlassian.com/jira/using-the-database-integrity-checker-185729629.html
https://confluence.atlassian.com/jira/search-indexing-185729671.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Indexing won't help, it is *only* used for searching and reading, never writing data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.