504 Gateway Time-out after restarting postgresql

[Ficky_syahreza]

I got my 504 Gateway Time-out after restarting postgresql on my droplet digital ocean.
I stop the service and then run the command : tail -f /opt/atlassian/jira/logs/catalina.out then back to start my jira /etc/init.d/jira start .
I get a log like this:

28-Mar-2020 21:03:58.641 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.5.32
28-Mar-2020 21:03:58.642 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Jun 20 2018 19:50:35 UTC
28-Mar-2020 21:03:58.642 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.5.32.0
28-Mar-2020 21:03:58.642 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Linux
28-Mar-2020 21:03:58.643 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 4.15.0-91-generic
28-Mar-2020 21:03:58.643 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
28-Mar-2020 21:03:58.643 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: /opt/atlassian/jira/jre
28-Mar-2020 21:03:58.643 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_181-b13
28-Mar-2020 21:03:58.643 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
28-Mar-2020 21:03:58.643 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: /opt/atlassian/jira
28-Mar-2020 21:03:58.644 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: /opt/atlassian/jira
28-Mar-2020 21:03:58.644 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/opt/atlassian/jira/conf/logging.properties
28-Mar-2020 21:03:58.644 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
28-Mar-2020 21:03:58.644 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms384m
28-Mar-2020 21:03:58.644 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx2048m
28-Mar-2020 21:03:58.645 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:InitialCodeCacheSize=32m
28-Mar-2020 21:03:58.645 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:ReservedCodeCacheSize=512m
28-Mar-2020 21:03:58.645 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -javaagent:/opt/atlassian/jira/atlassian-agent.jar
28-Mar-2020 21:03:58.645 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.awt.headless=true
28-Mar-2020 21:03:58.645 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Datlassian.standalone=JIRA
28-Mar-2020 21:03:58.645 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER=true
28-Mar-2020 21:03:58.645 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dmail.mime.decodeparameters=true
28-Mar-2020 21:03:58.645 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.dom4j.factory=com.atlassian.core.xml.InterningDocumentFactory
28-Mar-2020 21:03:58.646 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:-OmitStackTraceInFastThrow
28-Mar-2020 21:03:58.646 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.locale.providers=COMPAT
28-Mar-2020 21:03:58.646 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Datlassian.plugins.startup.options=
28-Mar-2020 21:03:58.646 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
28-Mar-2020 21:03:58.646 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
28-Mar-2020 21:03:58.646 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027
28-Mar-2020 21:03:58.646 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xloggc:/opt/atlassian/jira/logs/atlassian-jira-gc-%t.log
28-Mar-2020 21:03:58.646 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+UseGCLogFileRotation
28-Mar-2020 21:03:58.646 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:NumberOfGCLogFiles=5
28-Mar-2020 21:03:58.647 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:GCLogFileSize=20M
28-Mar-2020 21:03:58.647 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+PrintGCDetails
28-Mar-2020 21:03:58.647 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+PrintGCDateStamps
28-Mar-2020 21:03:58.647 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+PrintGCTimeStamps
28-Mar-2020 21:03:58.647 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+PrintGCCause
28-Mar-2020 21:03:58.647 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
28-Mar-2020 21:03:58.647 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/opt/atlassian/jira
28-Mar-2020 21:03:58.648 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=/opt/atlassian/jira
28-Mar-2020 21:03:58.648 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=/opt/atlassian/jira/temp
28-Mar-2020 21:03:58.648 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib]
28-Mar-2020 21:03:58.872 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
28-Mar-2020 21:03:58.881 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8081"]
28-Mar-2020 21:03:58.882 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 676 ms
28-Mar-2020 21:03:58.894 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
28-Mar-2020 21:03:58.895 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.32
2020-03-28 21:04:02,873 localhost-startStop-1 INFO [c.a.jira.startup.JiraHomeStartupCheck] The jira.home directory '/var/atlassian/application-data/jira' is validated and locked for exclusive use by this instance.
2020-03-28 21:04:02,955 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger] 
 ****************
JIRA starting...
****************

2020-03-28 21:04:03,047 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger] 

___ Environment _____________________________

JIRA Build : 8.0.0#800007-sha1:b1ea48b1170e88fff48488fb6d451a50948b5f19
Build Date : Sat Feb 09 00:00:00 WIB 2019
JIRA Installation Type : Standalone
Application Server : Apache Tomcat/8.5.32 - Servlet API 3.1
Java Version : 1.8.0_181 - Oracle Corporation
Current Working Directory : /opt/atlassian/jira/bin
Maximum Allowable Memory : 1820MB
Total Memory : 912MB
Free Memory : 829MB
Used Memory : 83MB
Memory Pool: Code Cache : Code Cache: init = 33554432(32768K) used = 9312960(9094K) committed = 33554432(32768K) max = 536870912(524288K)
Memory Pool: Metaspace : Metaspace: init = 0(0K) used = 22850064(22314K) committed = 23592960(23040K) max = -1(-1K)
Memory Pool: Compressed Class Space : Compressed Class Space: init = 0(0K) used = 2640728(2578K) committed = 2883584(2816K) max = 1073741824(1048576K)
Memory Pool: PS Eden Space : PS Eden Space: init = 100663296(98304K) used = 52684736(51449K) committed = 659030016(643584K) max = 659030016(643584K)
Memory Pool: PS Survivor Space : PS Survivor Space: init = 16777216(16384K) used = 0(0K) committed = 28835840(28160K) max = 28835840(28160K)
Memory Pool: PS Old Gen : PS Old Gen: init = 268435456(262144K) used = 33934984(33139K) committed = 268435456(262144K) max = 1431830528(1398272K)
JVM Input Arguments : -Djava.util.logging.config.file=/opt/atlassian/jira/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Xms384m -Xmx2048m -XX:InitialCodeCacheSize=32m -XX:ReservedCodeCacheSize=512m -javaagent:/opt/atlassian/jira/atlassian-agent.jar -Djava.awt.headless=true -Datlassian.standalone=JIRA -Dorg.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER=true -Dmail.mime.decodeparameters=true -Dorg.dom4j.factory=com.atlassian.core.xml.InterningDocumentFactory -XX:-OmitStackTraceInFastThrow -Djava.locale.providers=COMPAT -Datlassian.plugins.startup.options= -Djdk.tls.ephemeralDHKeySize=2048 -Djava.protocol.handler.pkgs=org.apache.catalina.webresources -Dorg.apache.catalina.security.SecurityListener.UMASK=0027 -Xloggc:/opt/atlassian/jira/logs/atlassian-jira-gc-%t.log -XX:+UseGCLogFileRotation -XX:NumberOfGCLogFiles=5 -XX:GCLogFileSize=20M -XX:+PrintGCDetails -XX:+PrintGCDateStamps -XX:+PrintGCTimeStamps -XX:+PrintGCCause -Dignore.endorsed.dirs= -Dcatalina.base=/opt/atlassian/jira -Dcatalina.home=/opt/atlassian/jira -Djava.io.tmpdir=/opt/atlassian/jira/temp
Java Compatibility Information : JIRA version = 8.0.0, Java Version = 1.8.0_181
 
___ Java System Properties _________________

atlassian.plugins.startup.options : 
atlassian.standalone : JIRA
awt.toolkit : sun.awt.X11.XToolkit
catalina.base : /opt/atlassian/jira
catalina.home : /opt/atlassian/jira
catalina.useNaming : true
common.loader : "${catalina.base}/lib",
"${catalina.base}/lib/*.jar",
"${catalina.home}/lib",
"${catalina.home}/lib/*.jar"
file.encoding : UTF-8
file.encoding.pkg : sun.io
ignore.endorsed.dirs : 
java.awt.graphicsenv : sun.awt.X11GraphicsEnvironment
java.awt.headless : true
java.awt.printerjob : sun.print.PSPrinterJob
java.class.version : 52.0
java.home : /opt/atlassian/jira/jre
java.io.tmpdir : /opt/atlassian/jira/temp
java.locale.providers : COMPAT
java.naming.factory.initial : org.apache.naming.java.javaURLContextFactory
java.naming.factory.url.pkgs : org.apache.naming
java.protocol.handler.pkgs : org.apache.catalina.webresources
java.runtime.name : Java(TM) SE Runtime Environment
java.runtime.version : 1.8.0_181-b13
java.specification.name : Java Platform API Specification
java.specification.vendor : Oracle Corporation
java.specification.version : 1.8
java.util.concurrent.ForkJoinPool.common.threadFactory : org.apache.catalina.startup.SafeForkJoinWorkerThreadFactory
java.util.logging.config.file : /opt/atlassian/jira/conf/logging.properties
java.util.logging.manager : org.apache.juli.ClassLoaderLogManager
java.vendor : Oracle Corporation
java.vendor.url : http://java.oracle.com/
java.vendor.url.bug : http://bugreport.sun.com/bugreport/
java.version : 1.8.0_181
java.vm.info : mixed mode
java.vm.name : Java HotSpot(TM) 64-Bit Server VM
java.vm.specification.name : Java Virtual Machine Specification
java.vm.specification.vendor : Oracle Corporation
java.vm.specification.version : 1.8
java.vm.vendor : Oracle Corporation
java.vm.version : 25.181-b13
jdk.tls.ephemeralDHKeySize : 2048
mail.mime.decodeparameters : true
org.apache.catalina.security.SecurityListener.UMASK : 0027
org.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER : true
org.dom4j.factory : com.atlassian.core.xml.InterningDocumentFactory
os.arch : amd64
os.name : Linux
os.version : 4.15.0-91-generic
package.access : sun.,
org.apache.catalina.,
org.apache.coyote.,
org.apache.jasper.,
org.apache.tomcat.
package.definition : sun.,
java.,
org.apache.catalina.,
org.apache.coyote.,
org.apache.jasper.,
org.apache.naming.,
org.apache.tomcat.
server.loader : 
shared.loader : 
sun.arch.data.model : 64
sun.boot.library.path : /opt/atlassian/jira/jre/lib/amd64
sun.cpu.endian : little
sun.cpu.isalist : 
sun.io.unicode.encoding : UnicodeLittle
sun.java.command : org.apache.catalina.startup.Bootstrap start
sun.java.launcher : SUN_STANDARD
sun.jnu.encoding : UTF-8
sun.management.compiler : HotSpot 64-Bit Tiered Compilers
sun.os.patch.level : unknown
tomcat.util.buf.StringCache.byte.enabled : true
tomcat.util.scan.StandardJarScanFilter.jarsToScan : log4j-web*.jar,
log4j-taglib*.jar,
log4javascript*.jar,
slf4j-taglib*.jar
tomcat.util.scan.StandardJarScanFilter.jarsToSkip : bootstrap.jar,
commons-daemon.jar,
tomcat-juli.jar,
annotations-api.jar,
el-api.jar,
jsp-api.jar,
servlet-api.jar,
websocket-api.jar,
jaspic-api.jar,
catalina.jar,
catalina-ant.jar,
catalina-ha.jar,
catalina-storeconfig.jar,
catalina-tribes.jar,
jasper.jar,
jasper-el.jar,
ecj-*.jar,
tomcat-api.jar,
tomcat-util.jar,
tomcat-util-scan.jar,
tomcat-coyote.jar,
tomcat-dbcp.jar,
tomcat-jni.jar,
tomcat-websocket.jar,
tomcat-i18n-en.jar,
tomcat-i18n-es.jar,
tomcat-i18n-fr.jar,
tomcat-i18n-ja.jar,
tomcat-juli-adapters.jar,
catalina-jmx-remote.jar,
catalina-ws.jar,
tomcat-jdbc.jar,
tools.jar,
commons-beanutils*.jar,
commons-codec*.jar,
commons-collections*.jar,
commons-dbcp*.jar,
commons-digester*.jar,
commons-fileupload*.jar,
commons-httpclient*.jar,
commons-io*.jar,
commons-lang*.jar,
commons-logging*.jar,
commons-math*.jar,
commons-pool*.jar,
jstl.jar,
taglibs-standard-spec-*.jar,
geronimo-spec-jaxrpc*.jar,
wsdl4j*.jar,
ant.jar,
ant-junit*.jar,
aspectj*.jar,
jmx.jar,
h2*.jar,
hibernate*.jar,
httpclient*.jar,
jmx-tools.jar,
jta*.jar,
log4j*.jar,
mail*.jar,
slf4j*.jar,
xercesImpl.jar,
xmlParserAPIs.jar,
xml-apis.jar,
junit.jar,
junit-*.jar,
hamcrest-*.jar,
easymock-*.jar,
cglib-*.jar,
objenesis-*.jar,
ant-launcher.jar,
cobertura-*.jar,
asm-*.jar,
dom4j-*.jar,
icu4j-*.jar,
jaxen-*.jar,
jdom-*.jar,
jetty-*.jar,
oro-*.jar,
servlet-api-*.jar,
tagsoup-*.jar,
xmlParserAPIs-*.jar,
xom-*.jar
user.dir : /opt/atlassian/jira/bin
user.home : /home/jira
user.language : en
user.name : jira
user.timezone : Asia/Jakarta
2020-03-28 21:04:03,296 JIRA-Bootstrap INFO [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from /var/atlassian/application-data/jira/dbconfig.xml
2020-03-28 21:04:03,606 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger] Running JIRA startup checks.
2020-03-28 21:04:03,607 JIRA-Bootstrap FATAL [c.a.jira.startup.JiraStartupLogger] Startup check failed. JIRA will be locked.
2020-03-28 21:04:03,674 JIRA-Bootstrap INFO [c.a.jira.startup.LauncherContextListener]

 Memory Usage:
---------------------------------------------------------------------------------
Heap memory : Used: 183 MiB. Committed: 912 MiB. Max: 2022 MiB
Non-heap memory : Used: 39 MiB. Committed: 63 MiB. Max: 1536 MiB
---------------------------------------------------------------------------------
TOTAL : Used: 222 MiB. Committed: 975 MiB. Max: 3558 MiB
---------------------------------------------------------------------------------
28-Mar-2020 21:06:59.918 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
28-Mar-2020 21:06:59.925 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
28-Mar-2020 21:06:59.948 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8081"]
28-Mar-2020 21:06:59.948 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
28-Mar-2020 21:06:59.955 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 181072 ms 

then I followed a post about the same error to do this : You should delete the file $JIRA_HOME/.jira-home.lock and the directory $JIRA_HOME/plugins/.osgi-plugins/felix, then start as the Jira user.

But it doesn't produce anything. do you have another solution?

[Gonchik Tsymzhitov]

Hi! 

Restart the jira and clean caches. 

and check the connectivity of postgresql