nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Database: JIRA couldn't connect to your database

Nouman Aziz

when I try to run JIRA i got the error,

Database: JIRA couldn't connect to your database

JIRA failed to establish a connection to your database.
This could be because:

Your database isn't running
The configuration of your dbconfig.xml file is incorrect (user, password, or database URL etc.)
There is a network issue between JIRA and your database (e.g. firewall, database doesn't allow remote access etc.)

how could i resolve that issue, it stopped all of sudden Database JIRA error.png

Accepted answers

All comments

Brant Schroeder

@Nouman Aziz can you provide some additional information? Is this a new install? Is the DB on the same server? Is the DB running? Is there a firewall that could be preventing connectivity? Have you made any changes recently?

Nouman Aziz

@Brant Schroeder Thank you for your prompt response. following are the details,

it's not the new install
DB is embedded H2
how can I check that DB is running or not
there is no issue with the firewall connectivity
no, I didn't make any changes.

JIRA was working perfectly fine till Friday. when I try to access it on Monday, I got the below error

Database: JIRA couldn't connect to your database. I am also attaching the log file.

2021-12-14 10:57:13,074+0500 JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] JIRA couldn't connect to your database
2021-12-14 10:57:13,074+0500 JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] JIRA failed to establish a connection to your database.
This could be because:
- Your database isn't running
- The configuration of your dbconfig.xml file is incorrect (user, password, or database URL etc.)
- There is a network issue between JIRA and your database (e.g. firewall, database doesn't allow remote access etc.)

There are several other solutions you can try, review our documentation and see what works for you.

2021-12-14 10:57:13,105+0500 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger] Running JIRA startup checks.
2021-12-14 10:57:13,105+0500 JIRA-Bootstrap FATAL [c.a.jira.startup.JiraStartupLogger] Startup check failed. JIRA will be locked.
2021-12-14 10:57:13,413+0500 JIRA-Bootstrap INFO [c.a.jira.startup.LauncherContextListener] Memory Usage:
---------------------------------------------------------------------------------
Heap memory : Used: 57 MiB. Committed: 367 MiB. Max: 2031 MiB
Non-heap memory : Used: 40 MiB. Committed: 63 MiB. Max: 1536 MiB
---------------------------------------------------------------------------------
TOTAL : Used: 96 MiB. Committed: 429 MiB. Max: 3567 MiB
---------------------------------------------------------------------------------
2021-12-14 10:58:27,843+0500 http-nio-8080-exec-1 WARN anonymous 658x1x1 - 10.28.13.7 /secure/Dashboard.jspa [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.filters.encoding.enforcer.excluded.mimes' from database. Using default
2021-12-14 10:58:27,999+0500 http-nio-8080-exec-1 WARN anonymous 658x1x1 - 10.28.13.7 /secure/Dashboard.jspa [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.filters.encoding.enforcer.excluded.paths' from database. Using default

Brant Schroeder

@Nouman Aziz

The H2 database is for testing only so hopefully this is not a production instance. If it is a production instance I would suggest migrating to a supported DB. The H2 database since it is a file system can become corrupt. Can you make sure you can connect to the H2 database - https://confluence.atlassian.com/jirakb/access-the-h2-embedded-database-in-jira-server-776818136.html

If you can connect you might just need to make sure the connection string is correct and restart Jira. If you cannot connect, hopefully you have a backup you can restore from.

Nouman Aziz

@Brant Schroeder

I followed the steps and got the attached responses.

on the first attempt when trying to connect the h2 database I got Java.lang error. see attached
when I try to connect on the second attempt then got the error: Database may be already in use. see attached

please guide and suggest JIRA-Java error.png DAtabase already in use.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-software

jira-software-server

atl-gruland