Jira System Restore is failing

[mikeboiko]

Hi,

I'm trying to perform a full system restore on Jira. I followed all the official instruction, but get this error after restore:

There was a problem restoring ActiveObjects data for the <unknown plugin> plugin. Caught exception with following message: REFERENCES command denied to user 'mike'@'localhost' for table 'AO_154E16_TRELLO_CONFIGS'. Please check the log for details.

I think the error is related to the Trello plugin I was trialing on my old Jira instance. I don't care about that plugin anymore, I just want to restore all my data.

Can you please help?

Thanks,

Mike

[mikeboiko · Accepted solution]

I was able to find the answer in the following post:

https://confluence.atlassian.com/jirakb/com-mysql-jdbc-exceptions-jdbc4-mysqlsyntaxerrorexception-references-command-denied-to-user-872266070.html

It seems pretty self straightforward in retrospect, but the REFERNCES permission wasn't granted to my jira user. I ran the following mysql command:

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on <JIRADB>.* TO '<USERNAME>'@'<JIRA_SERVER_HOSTNAME>' IDENTIFIED BY '<PASSWORD>'; 

[Ryan Kearney]

Plugins make permanent schema changes to the ActiveObjects table when they are installed. In order for you to restore your site properly, you must install that plugin again. Preferably the same version of the plugin you used on the site when you did the trial. 

[mikeboiko]

Thanks for the quick reply Ryan. I was able to get it working again without having the plugin installed. Please see my solution below.