Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Upgreade to 8.21.0 problem

I did upgreade and I have problem, I do not know how to fix it ?:

 

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.)


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

2 answers

1 vote
Dirk Ronsmans Community Leader Jan 11, 2022

Hi @Paweł Popławski ,

Easiest way to fix this is to look at your backup dbconfig.xml and copy that back to your directory.

In the current config you have it set up with the H2 database, is this intended or are you using PostgreSQL or MSSQL or... ?

I have no Idea. I do not know. Someone else installed it.

Ola @Paweł Popławski ,

Could you send me log folder from <installation path>/logs & <application data path>/log also dbconfig.xml. 

send via https://www.file.io/

let me check for you 

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>h2</database-type>
<schema-name>PUBLIC</schema-name>
<jdbc-datasource>
<url>jdbc:h2:file:C:\Program Files\Atlassian\Application Data\Jira/database/h2db</url>
<driver-class>org.h2.Driver</driver-class>
<username>sa</username>
<password></password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
</jdbc-datasource>
</jira-database-config>

For me it looks like default config. But it is also like magic for me :|.

Hmm okay, but i'm not sure only dbconfig.xml. Could you @Paweł Popławski  share more log files as we said before. Because we want to see which one something error we could tackle ?

windows OS G:\atlassian\jira\log and G:\atlassian\application-data\jira\logs. compress 1 folder log and 1 folder logs into zip file and send to me. 

if you're use linux 

/opt/atlassian/jira/log and /var/atlassian/jira/logs. compress into zip file and send to me. 

it depends where you installed jira path @Paweł Popławski 

Is there no sensitive data saved of my system ?

May you @Paweł Popławski repeat again to send that file because temporary file.io has been deleted? 

it's ok, it's safe DeepinScreenshot_select-area_20220112065321.png

Thanks @Paweł Popławski , let's take a look in your logs says ;

11-Jan-2022 08:15:42.402 WARNING [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [ROOT] registered the JDBC driver [org.h2.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

11-Jan-2022 08:15:42.465 SEVERE [localhost-startStop-2] org.apache.catalina.loader.WebappClassLoaderBase.checkThreadLocalMapForLeaks The web application [ROOT] created a ThreadLocal with key of type [webwork.action.ActionContext$1] (value [webwork.action.ActionContext$1@167a1999]) and a value of type [webwork.action.ActionContext] (value [webwork.action.ActionContext@26225e03]) but failed to remove it when the web application was stopped. Threads are going to be renewed over time to try and avoid a probable memory leak.

Looks like your DB is not config correctly, 

https://community.atlassian.com/t5/Confluence-questions/Error-in-confluence-crash-and-problem-to-start/qaq-p/1168626

https://confluence.atlassian.com/confkb/connections-could-not-be-acquired-from-the-underlying-database-104825087.html

Is this Jira production or development ? because we cannot recommend the user use the H2 database. You should move into another database like Oracle, PostgreSQL, or SQL Server.  

How can I go to old version from backup ?

This article may help you @Paweł Popławski  https://confluence.atlassian.com/adminjiraserver/rolling-back-a-jira-application-upgrade-938846960.html

In my personal experience, I will replace my snapshot Jira virtual server backup like a bread sandwich. it's pretty simple 

Bread and sandwich is not working:

 

We couldn't start the following plugins:

  • Jira Projects Plugin (com.atlassian.jira.jira-projects-plugin)
  • Atlassian OAuth Consumer Plugin (com.atlassian.oauth.consumer)
  • Atlassian Navigation Links Plugin (com.atlassian.plugins.atlassian-nav-links-plugin)
  • Atlassian Jira - Plugins - OAuth Service Provider SPI (com.atlassian.jira.oauth.serviceprovider)
  • Atlassian Jira - Plugins - Project Config Plugin (com.atlassian.jira.jira-project-config-plugin)
  • Applinks - Plugin - Core (com.atlassian.applinks.applinks-plugin)
  • Atlassian OAuth Service Provider Plugin (com.atlassian.oauth.serviceprovider)
  • Embedded Gadgets Plugin (com.atlassian.gadgets.embedded)
  • Gadget Directory Plugin (com.atlassian.gadgets.directory)
  • Atlassian Jira - Plugins - Gadgets Plugin (com.atlassian.jira.gadgets)
  • Atlassian Jira - Plugins - Global Issue Navigator (com.atlassian.jira.jira-issue-nav-plugin)
  • Atlassian Pretty URLs Plugin (com.atlassian.prettyurls.atlassian-pretty-urls-plugin)
  • Atlassian JIRA - Plugins - Quick Edit Plugin (com.atlassian.jira.jira-quick-edit-plugin)
  • Atlassian REST - Module Types (com.atlassian.plugins.rest.atlassian-rest-module)
  • Atlassian Jira - Plugins - REST Plugin (com.atlassian.jira.rest)
  • Opensocial Plugin (com.atlassian.gadgets.opensocial)
  • atlassian-servlet-plugin (com.atlassian.web.atlassian-servlet-plugin)
  • Atlassian Jira - Plugins - Look And Feel Logo Upload Plugin (com.atlassian.jira.lookandfeel)
  • Gadget Spec Publisher Plugin (com.atlassian.gadgets.publisher)
  • Atlassian Jira - Plugins - OAuth Consumer SPI (com.atlassian.jira.oauth.consumer)
  • Atlassian Jira - Plugins - SAL Plugin (com.atlassian.sal.jira)
  • Gadget Dashboard Plugin (com.atlassian.gadgets.dashboard)
  • Static Assets (CDN) Plugin (com.atlassian.plugins.static-assets-url)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS
Community showcase
Published in Jira

Do you use Jira Cloud with Microsoft Teams?

Hi, Jira users! Do you use Jira alongside Microsoft Teams? We want to hear how you’ve used the power of Jira Cloud and Microsoft Teams (via the Jira Cloud for Microsoft Teams app) to achieve a team...

144 views 2 5
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you