Upgrade Error

[Parvaneh Zand]

Hi everyone,

Upgrading Jira 8.17 to 9.8, we encounter this error:

2023-11-12  JIRA-Bootstrap ERROR [c.a.jira.startup.ComponentContainerLauncher] A fatal error occurred during initialisation. JIRA has been locked.
com.atlassian.jira.InfrastructureException: Error occurred while initializing component 'com.atlassian.jira.plugin.JiraPluginPersistentStateStore'.

Caused by: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT pluginkey, pluginenabled FROM pluginstate WHERE (pluginkey LIKE ? ) (ORA-00904: "PLUGINKEYIKE": invalid identifier)

2023-11-12  JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] We couldn't start JIRA
2023-11-12  JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] An error occurred while trying to start JIRA. We can't give you any more detail right now, we suggest checking the logs for more detail and contacting our support team.

All of the plugins are disabled. How to fix this error?

[Ivan Belis]

We encountered the same problem when upgrading from 8 to 9.12.2.

Tried a number of different things, disabling plugins , reverting plugins to older versions, clearing plugin cache ...but none of those helped.

After rolling back and upgrading to the 9.0.0 we do not have the problem.
We do want to go to the latest LTS (9.12) but this is preventing us.

[Sue Bridges]

Hi,

It's some sort of data error that Atlassian are not about to look at with Server version.  This is only a small Jira database so goodness knows what is causing it, no non standard functionality.  I was on 9.4.0 upgrading to 9.12.1 when I had this.  As it was on the same Server, after all my backups, including a Jira export, like you getting nowhere, in the end I uninstalled Jira 9.4.0.  I then installed a new 9.12.1 and then imported in the Jira export data and moved in the attachments etc.  That sorted it.  However, as I use this DB as a test bed for upgrades, I was not left with a warm feeling for my main next upgrade.

My other Jira database, also on 9.4.0 and much busier, interestingly upgraded just fine to 9.12.2 though (selected that release as it had just come out).  BTW I don't usually go for the latest release (last time I could not upgrade to the latest 9.4.2 due to some error so I chose 9.4.0 which worked...).

I HATE Jira upgrades - they should be easy, but they are rarely without problems, hence not always selecting the latest release.  This may be my last one though :)

Interestingly, I have a BUG with the Logging and Profiling that Atlassian have been able to duplicate for me.  As part of this upgrade process investigations, I noticed that I have a growing $JIRA_HOME\log\automation-jira-performance.csv file.  It's very obvious as the DB usage is so slight, and despite following Support's instructions I cannot stop from growing.  I don't use Automation on this DB and I do not want/need this file at all.  I'll await the outcome on that...

Hope this helps.

Sue

[Ivan Belis]

Thanks for your answer.

I am now sticking to version 9.4.15, that does not seem to have the problem.

The upgrade process was indeed far from ideal, a lot of troubles with the plugins - especially with the bigpicture plugin.  The plugin forced me to update to a lower version of bigpicture (for database updates i guess) but that was only supported by a lower version of Jira.  I had to restore and restart the process two times but now i seem to have a working scenario.  Bigpicture did 2 times a database upgrade and each of them took a long time - more than an hour (but i did not time it). 

All this was in our sandbox environment, keeping my fingers crossed for the production environment that is planned next week. I have not a lot of confidence in the process to be honest.

It is the last upgrade of server we are performing and i would have liked to land on the latest version considering the upcoming cloud migration.  

Regards,
Ivan

[Sue Bridges]

Plugins do seem to be an issue, though I do not have bigpicture (only Automation and Outlook).  Sounds interestingly, but they've removed the Marketplace so can't look at it!

Apart from security, the only new feature I benefit from in 9.12.x is the ability to Add comment anywhere in an issue.  Best of luck with the upgrade and future Cloud.

Regards

Sue

[Craig Nodwell]

Hi @Parvaneh Zand have you checked the logs?  If there is nothing obvious there then you should probably follow the suggestion of logging a support ticket.

[Sue Bridges]

Hi I am having the same issue from 9.4.0 to 9.12.1.  What was your solution please?

[Sanjen Bariki]

Hi @Parvaneh Zand ,

Welcome to Atlassian community!

Could you please confirm, Which data base you are using ..?

Have you tried to start the jira after clearing the plugin cache ..?

• .bundled-plugins 
• .osgi-plugins

Regards,

SB