Getting the 500 error for JIRA application after the reboot

Question

Hello Team, Our enterprise server is hosted on AWS EC2 and connected with another Postgress DB server. We had outage of AWS services, after rebooting the services from JIRA , application is not coming up properly and showing the error as below description The server encountered an internal error that prevented it from fulfilling this request. exception org.ofbiz.core.util.GeneralRuntimeException: Could not determine database type. (The connection attempt failed.) org.ofbiz.core.entity.config.DatasourceInfo.getDatabaseTypeFromJDBCConnection(DatasourceInfo.java:409) org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:831) org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:730) org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:150) org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:901) org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:879) org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:848) com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.findPropertyEntry(OFBizPropertySet.java:298) com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.exists(OFBizPropertySet.java:170) com.atlassian.jira.propertyset.JiraCachingPropertySet.exists(JiraCachingPropertySet.java:744) com.atlassian.jira.propertyset.BootstrapOfBizPropertyEntryStore.getEntry(BootstrapOfBizPropertyEntryStore.java:62) com.atlassian.jira.propertyset.CachingOfBizPropertySet.get(CachingOfBizPropertySet.java:202) com.opensymphony.module.propertyset.AbstractPropertySet.getString(AbstractPropertySet.java:305) com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:272) com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getString(ApplicationPropertiesImpl.java:57) com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getEncoding(ApplicationPropertiesImpl.java:138) com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getContentType(ApplicationPropertiesImpl.java:162) com.atlassian.jira.web.filters.JiraEncodingFilter.getContentType(JiraEncodingFilter.java:59) com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:39) com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:49) com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:79) com.atlassian.jira.web.filters.MultipartBoundaryCheckFilter.doFilter(MultipartBoundaryCheckFilter.java:41) com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:87) com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:61) com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:121) com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:92) com.atlassian.jira.web.filters.gzip.JiraGzipFilter.doFilter(JiraGzipFilter.java:56) root cause org.postgresql.util.PSQLException: The connection attempt failed. org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:150) org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:125) org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:30) org.postgresql.jdbc3g.AbstractJdbc3gConnection.(AbstractJdbc3gConnection.java:22) org.postgresql.jdbc4.AbstractJdbc4Connection.(AbstractJdbc4Connection.java:30) org.postgresql.jdbc4.Jdbc4Connection.(Jdbc4Connection.java:24) org.postgresql.Driver.makeConnection(Driver.java:393) org.postgresql.Driver.connect(Driver.java:267) java.sql.DriverManager.getConnection(DriverManager.java:664) java.sql.DriverManager.getConnection(DriverManager.java:247) org.ofbiz.core.entity.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:87) org.ofbiz.core.entity.transaction.JNDIFactory.getConnection(JNDIFactory.java:146) org.ofbiz.core.entity.TransactionFactory.getConnection(TransactionFactory.java:136) org.ofbiz.core.entity.ConnectionFactory.getConnection(ConnectionFactory.java:59) org.ofbiz.core.entity.config.DatasourceInfo.getDatabaseTypeFromJDBCConnection(DatasourceInfo.java:402) org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:831) org.ofbiz.core.entity.GenericDAO.selectByAnd(GenericDAO.java:730) org.ofbiz.core.entity.GenericHelperDAO.findByAnd(GenericHelperDAO.java:150) org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:901) org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:879) org.ofbiz.core.entity.GenericDelegator.findByAnd(GenericDelegator.java:848) com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.findPropertyEntry(OFBizPropertySet.java:298) com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.exists(OFBizPropertySet.java:170) com.atlassian.jira.propertyset.JiraCachingPropertySet.exists(JiraCachingPropertySet.java:744) com.atlassian.jira.propertyset.BootstrapOfBizPropertyEntryStore.getEntry(BootstrapOfBizPropertyEntryStore.java:62) com.atlassian.jira.propertyset.CachingOfBizPropertySet.get(CachingOfBizPropertySet.java:202) com.opensymphony.module.propertyset.AbstractPropertySet.getString(AbstractPropertySet.java:305) com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:272) com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getString(ApplicationPropertiesImpl.java:57) com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getEncoding(ApplicationPropertiesImpl.java:138) com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getContentType(ApplicationPropertiesImpl.java:162) com.atlassian.jira.web.filters.JiraEncodingFilter.getContentType(JiraEncodingFilter.java:59) com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:39) com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter(PathMatchingEncodingFilter.java:49) com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter(JiraStartupChecklistFilter.java:79) com.atlassian.jira.web.filters.MultipartBoundaryCheckFilter.doFilter(MultipartBoundaryCheckFilter.java:41) com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter(ChainedFilterStepRunner.java:87) com.atlassian.jira.web.filters.JiraFirstFilter.doFilter(JiraFirstFilter.java:61) com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:121) com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:92) com.atlassian.jira.web.filters.gzip.JiraGzipFilter.doFilter(JiraGzipFilter.java:56)

Carlos Garcia Navarro · Answer

Hello @Thota Viswanath ,

Welcome to the Community! Did you confirm that the DB is up and running?

This article may be helpful: https://confluence.atlassian.com/jirakb/jira-throws-http-status-500-error-with-generalruntimeexception-could-not-determine-database-type-646251812.html