Database went down for a minute or so, now jira won't start. Please help.

[Deleted user]

Here are the logs from the current state of jira: 

Currently getting back 521 errors and 502 errors when accessing my jira instance through my cloudflare managed subdomain. 

Do you have any other ideas on what might be going on? 

Thanks. 

[Deleted user]

I'm not sure why, but everything is now working :/ 

[Deleted user]

Also no need to worry too much, this is going to be a public jira in the near future for a public nonprofit org. 

[Vickey Palzor Lepcha]

Good to know David

[Vickey Palzor Lepcha]

But you better remove that IP image :p

[Vickey Palzor Lepcha]

does your server.xml have ajp connection enabled ?

and your proxy server needs to have ajp connection configs too.

[Vickey Palzor Lepcha]

And delete all these informations here Adam - has all your IPs of your organization.

[Vickey Palzor Lepcha]

I think you are having proxy issue not JIRA issue.

[Vickey Palzor Lepcha]

Try this

its up and running

[Vickey Palzor Lepcha]

Did you try restarting " WITHOUT " plugins ?

[Deleted user]

How do i do that? 

[Vickey Palzor Lepcha]

Just rename your installed plugins folder and try a restart .

[Deleted user]

Just to be clear which folder is this exactly? 

[Vickey Palzor Lepcha]

Should look something like this ;

........../application-data/jira/plugins/installed-plugins/

Just change the name of the directory installed-plugins and restart

[Deleted user]

That didn't work. JIRA recreated the directory :/

[Vickey Palzor Lepcha]

Can you attach the log message from the section where it validates the Database connectivity ?

[Deleted user]

I don't know a lot about jira so i might need you to be more specific. 

in the folder '/var/atlassian/application-data/jira/log' there's two files. 

-rw-r----- 1 jira jira 262937 Apr 27 20:12 atlassian-jira.log
-rw-r----- 1 jira jira 127 Apr 27 20:12 atlassian-jira-security.log

Is db auth going to be in one of those?

Are there any other logs that jira writes to? 

which one and why? 

Thanks for your help. 

[Vickey Palzor Lepcha]

atlassian-jira.log   attach the whole log here if you can.

When you do a start - it check connectivity between jira and db , you can see it in the log.

[Deleted user]

These are the only errors I see

```

[root@ip-172-31-15-206 log]# cat ./* | grep -i 'error'
2018-04-27 20:11:33,939 localhost-startStop-1 ERROR [webwork.config.DefaultConfiguration] Skipping configuration for class 'com.atlassian.jira.config.webwork.JiraPluginsConfiguration'
2018-04-27 20:11:33,967 localhost-startStop-1 ERROR [webwork.config.DefaultConfiguration] Skipping configuration for class 'com.atlassian.jira.config.webwork.JiraPluginsConfiguration'
jira.projectkey.warning : admin.errors.must.specify.unique.project.key
[root@ip-172-31-15-206 log]#

```

[Vickey Palzor Lepcha]

You can also check /atlassian/jira/log/catalina.out for log message

[Deleted user]

I'll attach the whole log one second 

[Deleted user]

REMOVED LINK 

Security log interestingly implies that it works. it only says  this: 

cat atlassian-jira-security.log 16:30:30
2018-04-27 20:12:12,839 JIRA-Bootstrap JIRA 7.7.1 build: 77002 started. You can now access JIRA through your web browser.

[Vickey Palzor Lepcha]

I don't see any issues in the log - some are known exceptions that can be ignored.

What error do you see on the browser as you try to access jira ?

[Deleted user]

edited and removed

[Vickey Palzor Lepcha]

This issue below - rectify it too , it should not be related to your issue here, but good to rectify it as it causes issues later.

2018-04-27 20:12:12,419 JIRA-Bootstrap WARN [c.a.jira.health.HealthChecks] Your database is using an unsupported collation
2018-04-27 20:12:12,419 JIRA-Bootstrap WARN [c.a.jira.health.HealthChecks] Your postgres72 database is currently using an unsupported collation: en_US.UTF-8. You should change this to a supported collation: - POSIX.UTF-8

[Deleted user]

How do I change the collation of an existing db? 

the jira docs just say to create a new database : / 

Edit: it looks like you can't change the collation of the db. But either way if you don't think this is the problem what else could it be? 

[Vickey Palzor Lepcha]

Is there any way you can bypass cloudfare and directly try and access jira ? ip and port ?

[Deleted user]

yes, I can access the ip directly but it fails. 

/etc/httpd/conf/httpd.conf

```
<VirtualHost *:80>
ProxyPreserveHost On
ProxyRequests Off
ProxyPass / http://localhost:8080/
ProxyPassReverse / http://localhost:8080/
</VirtualHost>

```

[Deleted user]

how strange 

it looks like it works when i access 8080, but the forwarding broke. 

[Nic Brough -Adaptavist-]

There's nothing worrying in that log, could you try the application log as well?

<jira-home>/logs/atlassian-jira.log

[Deleted user]

Well what seems to happen is the logging just hangs there, so i have no idea what to look for outside of that. 

Sure, here's the contents of the file : `/var/atlassian/application-data/jira/log/atlassian-jira.log`. 

 EDIT: removed 

[Deleted user]

it keeps looking for a link to hipchat which has never been used anywhere on or near this instance of jira. 

[Nic Brough -Adaptavist-]

Hmm.  Well, there's no errors in there to say why it's not running either.  How long have you given it to start up?

[Deleted user]

Two weeks 

[Deleted user]

 I've reset it and restarted it multiple times. 

I have no idea what the problem is. 

I asked this question here: https://community.atlassian.com/t5/Jira-questions/SQL-server-went-down-unexpectedly-now-JIRA-won-t-start/qaq-p/771775#M249803

But that didn't lead to anything conclusive either.