JIRA 8.6 and PostGRESQL 10

Plato Duck January 4, 2020

Hello Experts!  This is a new install onto a CentOS 7 on-prem box which is also running PostGRESQL 10.  JIRA running in the foreground starts and runs as far as letting me configure a database, and the last thing it logs is this:

2020-01-04 01:00:41,314-0800 http-nio-8080-exec-14 INFO anonymous 60x12x1 18i03gs 192.168.1.107 /secure/SetupDatabase.jspa [c.a.j.config.database.SystemDatabaseConfigurationLoader] Storing database configuration in /home/atlassian/application-data/jira/dbconfig.xml
2020-01-04 01:00:41,676-0800 http-nio-8080-exec-14 INFO anonymous 60x12x1 18i03gs 192.168.1.107 /secure/SetupDatabase.jspa [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from /home/atlassian/application-data/jira/dbconfig.xml
2020-01-04 01:00:41,680-0800 http-nio-8080-exec-14 INFO anonymous 60x12x1 18i03gs 192.168.1.107 /secure/SetupDatabase.jspa [c.a.j.config.database.DatabaseConfigHandler] Trying to get encrypted password from xml and decrypt it
2020-01-04 01:00:41,683-0800 http-nio-8080-exec-14 INFO anonymous 60x12x1 18i03gs 192.168.1.107 /secure/SetupDatabase.jspa [c.a.j.config.database.DatabaseConfigHandler] Database password decryption not performed.
2020-01-04 01:00:42,138-0800 http-nio-8080-exec-14 INFO anonymous 60x12x1 18i03gs 192.168.1.107 /secure/SetupDatabase.jspa [c.a.jira.startup.DatabaseChecklistLauncher] JIRA database startup checks completed successfully.

The database check passes, but when proceeding onto what I hoped would be LDAP config, I get a 500 error that suggests I contact Support with this info:

Technical details
Log's referral number: 1f3564ae-a30a-4f8a-b771-2f2943f660bc

Cause
Referer URL: http://192.168.1.2:8080/secure/SetupDatabase!default.jspa

com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM jira.propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? (ERROR: relation "jira.propertyentry" does not exist
Position: 68)
com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM jira.propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? (ERROR: relation "jira.propertyentry" does not exist
Position: 68)

1 answer

1 accepted

0 votes
Answer accepted
Johan Soetens _Dumblefy_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 4, 2020

Hi,

here are a few possible things you could verify:

  • are you using the correct PostgreSQL JDBC driver?
  • did you create the database with correct collation and gave sufficient permissions to the db user?

Jira Server 8.6 - Supported platforms

Connecting Jira applications to PostgreSQL

Plato Duck January 4, 2020

Nailed it!  Apparently installing postgresql-jdbc isn't enough; you have to add it to /atlassian-jira/WEB-INF/lib just like the docs say.  Thank you for reading!

Suggest an answer

Log in or Sign up to answer