fatal error after database migration from jira internal server to postgresql

Hi,

I attempted to migrate form the Jira 7.3.6 starter internal database to a postgreSQL as described here:

https://confluence.atlassian.com/adminjiraserver071/switching-databases-802592192.html#Switchingdatabases-differenttype

I followed all steps including updating the JBDC driver to match the postgreSQL revision 9.5 supported by Jira and get the following fatal error message...

I am new to Jira and have not debugged an issue like this and would greatly appreciate guidance navigating the logs the error message refers to. 

Jira_fatal_error.jpg

 

 

 

2 answers

1 vote
Boris Berenberg Community Champion Sep 18, 2017

You will need to look in your JIRA logs for the exact error message. It will be in the <installdir>/log/catalina.out file.

This is what is in that directory, no catalina.out file

09/18/2017  04:43 PM           478,459 access_log.2017-09-18
09/18/2017  03:56 PM            92,447 catalina.2017-09-18.log
09/18/2017  03:56 PM             3,659 commons-daemon.2017-09-18.log
09/18/2017  03:56 PM            87,666 jirasoftware150917151933-stderr.2017-09-18.log
09/18/2017  03:56 PM         7,588,669 jirasoftware150917151933-stdout.2017-09-18.log

Boris Berenberg Community Champion Sep 18, 2017

look at jirasoftware150917151933-stdout.2017-09-18.log and look for DB related errors.

Hi Boris,

First, thank you for your support, it is greatly appreciated.

I ran the Jira 7.3.6 installer which made the driver repairs listed in the attached image file and restarted the application which still results in a fatal error.

Jira_Database_Driver_Error.jpg

The following error appears several times throughout the jirasoftware150917151933-stdout.2017-09-19.log logfile...

---------------------------------------------------------------------------------

Caused by: java.sql.SQLException: No suitable driver
 at org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2151)
 ... 37 more
2017-09-19 08:35:31,448 JIRA-Bootstrap ERROR      [o.o.c.entity.jdbc.DatabaseUtil] Unable to establish a connection with the database... Error was:java.sql.SQLException: No suitable driver found for jdbc:postgresql://https://SPDASHLAND:4470:5433/JIRA_DB
2017-09-19 08:35:31,448 JIRA-Bootstrap ERROR      [o.o.c.entity.jdbc.DatabaseUtil] Could not get table name information from the database, aborting.
2017-09-19 08:35:31,448 JIRA-Bootstrap WARN      [o.a.commons.dbcp2.BasicDataSource] Failed to complete JMX registration
javax.management.InstanceAlreadyExistsException: com.atlassian.jira:name=BasicDataSource

---------------------------------------------------------------------------------

I have 2 postgreSQL server versions running, revs 9.5 and 9.6. I added postgreSQL rev 9.5 since it was not clear that Jira SW 7.3.6 was compatible with postgreSQL 9.6  as it is not listed in the following support URL:

https://confluence.atlassian.com/adminjiraserver073/supported-platforms-861253018.html#Supportedplatforms-postgresnote

An additional complication surrounding postgreSQL changes to their JBDC driver revision numbering...

https://jdbc.postgresql.org/download.html

Thank you for your help

Hi Boris,
First, thank you for your support, it is greatly appreciated.
I ran the Jira 7.3.6 installer which made the driver repairs listed in the attached image file and restarted the application which still results in a fatal error.
 Jira_Database_Driver_Error.jpg
The following error appears several times throughout the jirasoftware150917151933-stdout.2017-09-19.log logfile...
---------------------------------------------------------------------------------
Caused by: java.sql.SQLException: No suitable driver
 at org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2151)
 ... 37 more
2017-09-19 08:35:31,448 JIRA-Bootstrap ERROR      [o.o.c.entity.jdbc.DatabaseUtil] Unable to establish a connection with the database... Error was:java.sql.SQLException: No suitable driver found for jdbc:postgresql://https://SPDASHLAND:4470:5433/JIRA_DB
2017-09-19 08:35:31,448 JIRA-Bootstrap ERROR      [o.o.c.entity.jdbc.DatabaseUtil] Could not get table name information from the database, aborting.
2017-09-19 08:35:31,448 JIRA-Bootstrap WARN      [o.a.commons.dbcp2.BasicDataSource] Failed to complete JMX registration
javax.management.InstanceAlreadyExistsException: com.atlassian.jira:name=BasicDataSource
---------------------------------------------------------------------------------
I have 2 postgreSQL server versions running, revs 9.5 and 9.6. I added postgreSQL rev 9.5 since it was not clear that Jira SW 7.3.6 was compatible with postgreSQL 9.6  as it is not listed in the following support URL:
https://confluence.atlassian.com/adminjiraserver073/supported-platforms-861253018.html#Supportedplatforms-postgresnote
An additional complication surrounding postgreSQL changes to their JBDC driver revision numbering...
https://jdbc.postgresql.org/download.html
Thank you for your help

Boris Berenberg Community Champion Sep 19, 2017

Did you mean to delete the contents of this post? I got the email notification for your first comment.

Hi Boris,

First, thank you for your support, it is greatly appreciated.

I ran the Jira 7.3.6 installer which made the driver repairs listed in the attached image file and restarted the application which still results in a fatal error.

Jira_Database_Driver_Error.jpg

The following error appears several times throughout the jirasoftware150917151933-stdout.2017-09-19.log logfile...

---------------------------------------------------------------------------------

Caused by: java.sql.SQLException: No suitable driver
 at org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2151)
 ... 37 more
2017-09-19 08:35:31,448 JIRA-Bootstrap ERROR      [o.o.c.entity.jdbc.DatabaseUtil] Unable to establish a connection with the database... Error was:java.sql.SQLException: No suitable driver found for jdbc:postgresql://https://SPDASHLAND:4470:5433/JIRA_DB
2017-09-19 08:35:31,448 JIRA-Bootstrap ERROR      [o.o.c.entity.jdbc.DatabaseUtil] Could not get table name information from the database, aborting.
2017-09-19 08:35:31,448 JIRA-Bootstrap WARN      [o.a.commons.dbcp2.BasicDataSource] Failed to complete JMX registration
javax.management.InstanceAlreadyExistsException: com.atlassian.jira:name=BasicDataSource

---------------------------------------------------------------------------------

I have 2 postgreSQL server versions running, revs 9.5 and 9.6. I added postgreSQL rev 9.5 since it was not clear that Jira SW 7.3.6 was compatible with postgreSQL 9.6  as it is not listed in the following support URL:

https://confluence.atlassian.com/adminjiraserver073/supported-platforms-861253018.html#Supportedplatforms-postgresnote

An additional complication surrounding postgreSQL changes to their JBDC driver revision numbering...

https://jdbc.postgresql.org/download.html

Thank you for your help

Hi Boris,
First, thank you for your support, it is greatly appreciated.
I ran the Jira 7.3.6 installer which made the driver repairs listed in the attached image file and restarted the application which still results in a fatal error.
 

Jira_Database_Driver_Error.jpg


The following error appears several times throughout the jirasoftware150917151933-stdout.2017-09-19.log logfile...
---------------------------------------------------------------------------------
Caused by: java.sql.SQLException: No suitable driver
 at org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:2151)
 ... 37 more
2017-09-19 08:35:31,448 JIRA-Bootstrap ERROR      [o.o.c.entity.jdbc.DatabaseUtil] Unable to establish a connection with the database... Error was:java.sql.SQLException: No suitable driver found for jdbc:postgresql://https://SPDASHLAND:4470:5433/JIRA_DB
2017-09-19 08:35:31,448 JIRA-Bootstrap ERROR      [o.o.c.entity.jdbc.DatabaseUtil] Could not get table name information from the database, aborting.
2017-09-19 08:35:31,448 JIRA-Bootstrap WARN      [o.a.commons.dbcp2.BasicDataSource] Failed to complete JMX registration
javax.management.InstanceAlreadyExistsException: com.atlassian.jira:name=BasicDataSource
---------------------------------------------------------------------------------
I have 2 postgreSQL server versions running, revs 9.5 and 9.6. I added postgreSQL rev 9.5 since it was not clear that Jira SW 7.3.6 was compatible with postgreSQL 9.6  as it is not listed in the following support URL:
https://confluence.atlassian.com/adminjiraserver073/supported-platforms-861253018.html#Supportedplatforms-postgresnote
An additional complication surrounding postgreSQL changes to their JBDC driver revision numbering...
https://jdbc.postgresql.org/download.html
Thank you for your help

Ok well based on the emails I got, it looks like you still have the wrong driver. 9.6 is not supported until JIRA 7.4. You should use the latest driver found at: https://jdbc.postgresql.org/download/postgresql-42.1.4.jar if you're on JDK8, and https://jdbc.postgresql.org/download/postgresql-42.1.4.jre7.jar if you're on JDK7.

Boris Berenberg Community Champion Sep 19, 2017

Derp, thats not right. Your Postgres URL is wrong: "postgresql://https://SPDASHLAND:4470:5433/JIRA_DB"

It looked funny to me but I wasn't sure if the extra text was required as the <install dir>bin\config.bat GUI generated that URL.

Ok, I fixed and now we are connecting to the postgreSQL database and Jira Software is coming up as a new install.

THANK YOU!

Stupid question alert...

I backed up Jira SW prior as required. If I now restore from that backup, will the database server settings revert back to the previous ??

Boris Berenberg Community Champion Sep 19, 2017

No, those are stored on disk.

Ok!

Just restored from backup and all is working!

Migration to postgreSQL server complete!

Thank you Boris Berenberg!

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published May 21, 2018 in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

1,209 views 10 18
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you