-
Suggestion
-
Resolution: Fixed
-
680
-
33
-
-
JIRA is currently (at least in 7.4.3) bundling Postgres JDBC driver lib/postgresql-9.1-903.jdbc4-atlassian-hosted.jar.
This does not work with Postgres 10. JIRA throws dozens of stacktraces on startup:
JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger] JIRA pre-database startup checks completed successfully. JIRA-Bootstrap INFO [o.o.c.entity.jdbc.DatabaseUtil] Database Product Name is PostgreSQL JIRA-Bootstrap INFO [o.o.c.entity.jdbc.DatabaseUtil] Database Product Version is 10beta3 JIRA-Bootstrap INFO [o.o.c.entity.jdbc.DatabaseUtil] Database Driver Name is PostgreSQL Native Driver JIRA-Bootstrap INFO [o.o.c.entity.jdbc.DatabaseUtil] Database Driver Version is PostgreSQL 9.1 JDBC4 (build 903) JIRA-Bootstrap WARN [o.o.c.entity.jdbc.DatabaseUtil] Entity "Action" has no table in the database JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] Could not create table "public.jiraaction" JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following: CREATE TABLE public.jiraaction (ID NUMERIC(18,0) NOT NULL, issueid NUMERIC(18,0), AUTHOR VARCHAR(255), actiontype VARCHAR(255), actionlevel VARCHAR(255), rolelevel NUMERIC(18,0), actionbody TEXT, CREATED TIMESTAMPTZ, UPDATEAUTHOR VARCHAR(255), UPDATED TIMESTAMPTZ, actionnum NUMERIC(18,0), CONSTRAINT PK_jiraaction PRIMARY KEY (ID)) Error was: org.postgresql.util.PSQLException: ERROR: relation "jiraaction" already exists JIRA-Bootstrap WARN [o.o.c.entity.jdbc.DatabaseUtil] Entity "Application" has no table in the database JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] Could not create table "public.cwd_application" JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following: CREATE TABLE public.cwd_application (ID NUMERIC(18,0) NOT NULL, application_name VARCHAR(255), lower_application_name VARCHAR(255), created_date TIMESTAMPTZ, updated_date TIMESTAMPTZ, active NUMERIC(9,0), description VARCHAR(255), application_type VARCHAR(255), credential VARCHAR(255), CONSTRAINT PK_cwd_application PRIMARY KEY (ID)) Error was: org.postgresql.util.PSQLException: ERROR: relation "cwd_application" already exists JIRA-Bootstrap WARN [o.o.c.entity.jdbc.DatabaseUtil] Entity "ApplicationUser" has no table in the database JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] Could not create table "public.app_user" JIRA-Bootstrap ERROR [o.o.c.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
Upgrading the JDBC jar to postgresql-42.1.4.jar fixes this. Confluence already bundles this version.
See also CONFSERVER-52715.
- is duplicated by
-
- Closed
- is related to
-
- Closed
- relates to
-
- Closed
-
- Closed
-
- Closed
-
GHS-162187 Loading...
-
- mentioned in
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- resolves
-
-
-
-
-
- Wiki Page
-
| Form Name | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
[JRASERVER-65910] Add PostgreSQL 10 as a supported platform for Jira
Just a note that Jira Software 8.5.4 is now available with PostgreSQL 10 support.
In the previous update we've announced that PostgreSQL 10 support is available starting from Jira 8.6 and Jira Service Desk 4.6. In the meantime, in Jira 8.7 we've added support for PostgreSQL 11.
With this update I'm happy to let you know that PostgreSQL 10 support will soon be available in 8.5.4, the upcoming version of the Enterprise Release stream.
Katarzyna Derenda
Product Manager, Jira Server and Data Center
@bromoserwfm PostgreSQL major versions before version 10 included the second decimal point, but that convention was changed in version 10 and going forward. All 9.6.x releases are compatible with one another but introduce incompatibilities with 9.5.x. All 10.x releases are compatible with one another but introduce incompatibilities with 9.6.x.
The major versions are thus as follows:
- 13
- 12
- 11
- 10
- 9.6
- 9.5
- 9.4
- 9.3
- ...and so on.
You specified minor versions when discussing support for Postgres 9, but the release notes simply say Postgres 10 is supported - does this mean all 10.x variants will work out of the box with Jira 8.6?
🎶 'tis the season to be jolly... fa la la la laaaa... la la la laa. 🎶
mmohr thanks, we cannot commit to a specific date, but the team is just about to start working on backporting. I will post an update on this suggestion when the target 8.5.x version is known and will add it to the "Fixed in Version/s" field for this suggestion.
Great news, with which minor 8.5 Release or better when could we await PostreSQL 10 Support in Jira 8.5?
Is there a timer schedule for that we can plan, because we are currently in the middle of or migration project to Jira data center and it would be great if we could directly switch to current PostgreSQL Version while upgrading and migrating.
But I can see re-indexing is very slow