fatal error after database migration from jira internal server to postgresql

[RDovi]

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. 

[Boris Berenberg - Atlas Authority]

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

[RDovi]

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 - Atlas Authority]

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

[RDovi]

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.

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

[RDovi]

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

[RDovi]

...

[Boris Berenberg - Atlas Authority]

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

[RDovi]

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.

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

[RDovi]

no

[RDovi]

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.
 

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 - Atlas Authority]

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 - Atlas Authority]

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

[RDovi]

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 - Atlas Authority]

No, those are stored on disk.

[RDovi]

Ok!

Just restored from backup and all is working!

Migration to postgreSQL server complete!

Thank you Boris Berenberg!