It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

MySQLSyntaxErrorException in DVCS connector after upgrading Jira to 6.1

Maxime Lemanissier Jan 13, 2014

Hi,

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'm using the version 1.4.2.12 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,
Maxime

1 answer

1 accepted

0 votes
Answer accepted
Tiago Comasseto Jan 13, 2014

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.

Cheers

Maxime Lemanissier Jan 13, 2014

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 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.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in Jira Software

Demo Den Ep. 5: Meet Jira Mobile

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...

315 views 1 10
Join discussion

Community Events

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

Events near you