when I try to run JIRA i got the error,
JIRA failed to establish a connection to your database.
This could be because:
how could i resolve that issue, it stopped all of sudden :(
@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?
@Brant Schroeder Thank you for your prompt response. following are the details,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I followed the steps and got the attached responses.
please guide and suggest
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
These errors generally mean that your database is corrupt. I would be looking for the backups, rather than trying to repair it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have following question if you please address
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Nope, the "in use" message means you've still got something connected to it, possibly a process that's hanging over because it's got messed up by the corruption.
Again, the "fix" is to go back to a backup. You could try to rescue it, but h2 databases tend to fail catastrphically, and it's rare that you'll be able to rescue it (and when you can, you'll have lost data)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
got it @Nic Brough -Adaptavist-
please guide and share your expert's opinion;
please any other step will be a great help for me to follow will be much appreciated
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, a clean re-install will not have any of your old data in it.
If you re-install the same version of Jira, then yes, you should be able to import the entire thing from the backup, assuming you are talking about the xml export (that runs regularly by default). If you're talking about some other backup you've taken, then, no, I don't know because you haven't told us what the backup is
You might be able to restore just those files to recover your old data, assuming your backup is an identical copy of the files from a time when it was working
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.