Jira failed to start

[Lynda Lopez]

My Jira Software instance on docker failed to run, after I disabled a few system plugins.

I'm using the built-in database backend.

Here's the log output:

System plugins failed to start: We haven't been able to start all the required system plugins

We couldn't start the following plugins:

• Jira Projects Plugin (com.atlassian.jira.jira-projects-plugin)
• Atlassian OAuth Consumer Plugin (com.atlassian.oauth.consumer)
• Atlassian Navigation Links Plugin (com.atlassian.plugins.atlassian-nav-links-plugin)
• Atlassian Jira - Plugins - Project Config Plugin (com.atlassian.jira.jira-project-config-plugin)
• Applinks - Plugin - Core (com.atlassian.applinks.applinks-plugin)
• Atlassian OAuth Service Provider Plugin (com.atlassian.oauth.serviceprovider)
• Embedded Gadgets Plugin (com.atlassian.gadgets.embedded)
• Gadget Directory Plugin (com.atlassian.gadgets.directory)
• Atlassian Jira - Plugins - Gadgets Plugin (com.atlassian.jira.gadgets)
• Atlassian Jira - Plugins - Global Issue Navigator (com.atlassian.jira.jira-issue-nav-plugin)
• Atlassian JIRA - Plugins - Quick Edit Plugin (com.atlassian.jira.jira-quick-edit-plugin)
• Atlassian Jira - Plugins - REST Plugin (com.atlassian.jira.rest)
• Opensocial Plugin (com.atlassian.gadgets.opensocial)
• Atlassian Jira - Plugins - OAuth Consumer SPI (com.atlassian.jira.oauth.consumer)
• Gadget Dashboard Plugin (com.atlassian.gadgets.dashboard)
• Static Assets (CDN) Plugin (com.atlassian.plugins.static-assets-url)

What should I do to restore the database? 

[Adrian Stephen]

Hi @Lynda Lopez 

You may try enabling the plugins from the database, by following the steps from this page

• https://confluence.atlassian.com/jirakb/jira-startup-fails-with-message-that-required-plugins-are-not-started-254738702.html

Regards,
Adrian Stephen

[Lynda Lopez]

How and where should I even execute whose queries?

I'm running this on Docker on Debian.

I've tried the H2 database tool to modify the database but it doesn't work.

[Lynda Lopez]

When I run the "SELECT * FROM pluginstate where pluginenabled = 'false';" in the H2 console on h2db.mv.db which was found in database/h2db.mv.db, it gives me the following error:

Table "PLUGINSTATE" not found; SQL statement:
SELECT * FROM pluginstate where pluginenabled = 'false' [42102-200] 42S02/42102

[Lynda Lopez]

@Adrian Stephen Would you please help me?

[Adrian Stephen]

Hi @Lynda Lopez 

In order to run queries on the H2 database, Jira needs to be shut down first. 

Please follow the steps here to access the database correctly:

• https://confluence.atlassian.com/jirakb/access-the-h2-embedded-database-in-jira-server-776818136.html

[Adrian Stephen]

I also suggest moving to an external database such as PostgreSQL which is free.