MySQLSyntaxErrorException in DVCS connector after upgrading Jira to 6.1


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(

I also get the same exception in admin page addons/manage DVCS account. saying that we can use DVCS integration without the need of the DVCS connector plugin. Should I uninstall DVCS connector plugin?

I'm using the version of the DVCS connector. The latest one seems to be 1.4.3, and it includes a fix for "migration for MySQL" which could fit to my problem.
But Jira add-on manager does not allow me to do this upgrade (and actually, DVCS connector has now migrated to "system plugin", not in "user-installed" anymore).
Should I do a manual upgrade to 1.4.3 ?
Thanks for your help,

1 answer

1 accepted

0 votes
Answer accepted

Hi Maxime,

We saw some issues with DVCS plugin after upgrade in the past and for most cases the instructions of this KB solves the issue. As for version 1.4.3, you can safely upload the new version as in this page.


Hi Tiago,

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

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.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 14, 2019 in Jira

Updates to give you visibility into what's coming in Jira Server and Data Center

Hello, Community! My name is Gosia and I'm a Product Manager on Jira Server and Data Center here at Atlassian. Since 2002 when we launched our public issue tracker, jira.atlass...

588 views 1 15
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you