I've just upgraded Jira from 5.1.5 to 6.1.5, and I'm now facing many exceptions related to database and DVCS connector plugin.
When I open an issue in an Agile board, it requires much time to display details (~5-10 seconds), mysqld process is eating much CPU, and I get this exception in Jira log
[rapid.issue.thirdpartytabs.ThirdPartyTabModelFactory] Unable to load third party tab for com.atlassian.jira.plugins.jira-bitbucket-connector-plugin:dvcs-commits-greenhopper-tab java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'is not null and `ISSUE_KEY` is not null order by `RAW_NODE`, `NODE`, `ID` ASC' at line 1 at com.atlassian.jira.plugins.dvcs.activeobjects.v3.To_12_SplitUpChangesetsMigrator.upgrade(To_12_SplitUpChangesetsMigrator.java:360)
I also get the same exception in admin page addons/manage DVCS account.
https://answers.atlassian.com/questions/217745/support-for-dvcs-connector-on-jira-6-1is saying that we can use DVCS integration without the need of the DVCS connector plugin. Should I uninstall DVCS connector plugin?
I've deleted the DB tables used by the plugin, this has fixed the problem but also deleted my DVCS account in Jira.
Unfortunately, I was then unable to recreate this account, possibly because of the issue described in https://answers.atlassian.com/questions/220514/unable-to-connect-github-organization-to-jira-using-dvcs-connector
As this problem is also fixed in version 1.4.3 of the plugin, I applied the second option you provided and run an manual upload of the version 1.4.3 of the plugin. I can now successfully recreate the DVCS account in Jira, and there is no more exceptions, so my problem seems to be fixed.
Thanks for your help.
BTW, I think Jira should ASAP bundle version 1.4.3 of the DVCS connector plugin.
See how to use Jira on the go! Demo Den Episode 5 is here: meet Jira Mobile with Jira Product Manager Rayen Magpantay. Demo Den is in our monthly series where a Jira PM demonstrates...
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