Today Jira sopped working

[Paweł Popławski]

In the morning as I get to work and turn on Jira server, I did not have my Jira. Jira wanted to start new like new installation and all old data is lost.

All plications on server works correct except Jira!

What can I do ?

[Paweł Popławski · Accepted solution]

Hi, I do not know what should I look in log files.

Actually I have backup every day but never try to restore it in Win 2019 Server. I try to do that but does not work :/. And only Jira is not working all others works just fine.

Lets go back to question what should I find in logs ?

[Pramodh M]

In the log directory, inspect atlassian-jira.log

Please see the log and see for any unforeseen changes from the last time you were able to access the server.

If you don't find anything, check the database if it's working fine (Also check dbconfig.xml file - connection with database)

If that also fails you can restore the server using the below guide

https://confluence.atlassian.com/adminjiraserver/restoring-data-from-an-xml-backup-938847707.html

Thanks,
Pramodh

[Pramodh M · Accepted solution]

From the log, I can't say anything! If you can attach the file I can inspect

It's best to restore the instance from your export directory, you will have all the data restored

Remember to restore the data in the attachments directory too

[Paweł Popławski]

Is it possible that I do not have newer export files, this is catalog Program Files\Atlassian\Application Data\Jira\export (newest is 2021.01.31):

[Paweł Popławski]

Sorry I have, just names was different.

[Paweł Popławski]

Jira stopped working after upgreade.

I did upgreade from 8.7 to 8.21.0.

Now I have comminicate that:

Database: JIRA couldn't connect to your database

[Paweł Popławski]

XML looks like this:

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>h2</database-type>
<schema-name>PUBLIC</schema-name>
<jdbc-datasource>
<url>jdbc:h2:file:C:\Program Files\Atlassian\Application Data\Jira/database/h2db</url>
<driver-class>org.h2.Driver</driver-class>
<username>sa</username>
<password></password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
</jdbc-datasource>
</jira-database-config>

[Paweł Popławski]

last log looks like this just before I tried to connect Jira:

2021-02-14 17:29:41,230+0100 Caesium-1-3 INFO ServiceRunner [c.a.j.p.h.service.ping.RefreshConnectionStatusJobHandler] Running RefreshConnectionStatusJobHandler...
2021-02-14 17:29:43,965+0100 Caesium-1-4 INFO ServiceRunner [c.a.j.p.h.service.connect.InstallGlancesJobHandler] Running InstallGlancesJobHandler...
2021-02-14 17:29:43,965+0100 Caesium-1-4 INFO ServiceRunner [c.a.j.p.h.service.connect.InstallGlancesJobHandler] There is no link to Hipchat, no need to install glances.
2021-02-14 17:33:10,329+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 17:38:10,312+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 17:43:10,326+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 17:48:10,320+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 17:53:10,308+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 17:58:10,316+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 18:03:10,309+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 18:08:10,310+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 18:13:10,313+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 18:18:10,309+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 18:23:10,300+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 18:28:10,293+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 18:29:41,243+0100 Caesium-1-2 INFO ServiceRunner [c.a.j.p.h.service.ping.RefreshConnectionStatusJobHandler] Running RefreshConnectionStatusJobHandler...
2021-02-14 18:29:44,196+0100 Caesium-1-3 INFO ServiceRunner [c.a.j.p.h.service.connect.InstallGlancesJobHandler] Running InstallGlancesJobHandler...
2021-02-14 18:29:44,196+0100 Caesium-1-3 INFO ServiceRunner [c.a.j.p.h.service.connect.InstallGlancesJobHandler] There is no link to Hipchat, no need to install glances.
2021-02-14 18:33:10,298+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 18:38:10,298+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 18:43:10,299+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 18:48:10,296+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 18:53:10,292+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 18:58:10,281+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 19:03:10,280+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 19:08:10,291+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-14 19:13:10,278+0100 plugin-transaction-0 INFO [c.a.jira.plugin.PluginTransactionListener] [plugin-transaction] numberStartEvents:577, numberEndEvents:577, numberSendEvents:366, numberEventsInTransactions:11806, numberOfPluginEnableEvents:272
2021-02-15 05:28:41,990+0100 localhost-startStop-1 INFO [c.a.jira.startup.JiraHomeStartupCheck] The jira.home directory 'C:\Program Files\Atlassian\Application Data\Jira' is validated and locked for exclusive use by this instance.
2021-02-15 05:28:42,334+0100 localhost-startStop-1 WARN [o.a.catalina.util.SessionIdGeneratorBase] Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [328] milliseconds.
2021-02-15 05:28:42,365+0100 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger]

[Pramodh M]

Hi @Paweł Popławski 

Check the log files in the Home directory.

Do you have any backup data kept, you can think of restoring it if you have lost.

Thanks,
Pramodh