After Upgrade to JIRA 8.13.2, I keep facing the below error. It's pop out when the transaction is made. Without any special condition and happen randomly.
Please let me know, any information is needed to overview this issue.
Thanks in advance.
Not sure, but can check this KB article, as it relates to the error message shown in your screenshot: https://confluence.atlassian.com/jirakb/jira-mysql-usage-fails-with-error-java-sql-batchupdateexception-lock-wait-timeout-exceeded-224396239.html
Hi @Yew Teng Ui
which type of database are you using? Which version are you currently on for the database?
So, you mean that the workflow is perfectly find (no troubling conditions/validators) but you are assuming it must be backend (database) related?
At least I can confirm the Jira version is compatible with the database version you are using :)
Is there probably anything more detailed visible from atlassian-jira.log of your instance?
Apart from that (this is just a guess, though without any evidence) it indeed looks like an error that is being given back from database itself ("Lock wait timeout exceeded").
Did you make sure for the database the settings are like they are described in documentation:
Sometime the hinge is only on a small detail.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events