My new install with Postgres 11.6 is failing?

[Devtech83]

On setup, I get to the Create database screen and fill out the details. It successfully connects with Postgres 11.6.

But when clicking Next, it gives an error with is unrecoverable even upon restart:

com.opensymphony.module.propertyset.PropertyImplementationException: SQL Exception while executing the following:SELECT ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype FROM public.propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? (ERROR: relation "public.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 public.propertyentry WHERE ENTITY_NAME=? AND ENTITY_ID=? (ERROR: relation "public.propertyentry" does not exist
      Position: 68)

[Daniel Ebers · Accepted solution]

Hi,

what me worries is the error message about a missing relation within database.
While it is hard to tell why this is the case I'd recommend to double checkthe PostgreSQL database according to setup guide.

As PostgreSQL 11.6 is some of the newer versions supported with Jira (Service Desk) an additional try could be to use a slightly older PostgreSQL version. This, of course, is just try & error from here as PostgreSQL 11 is listed on supported platforms and should work just fine.

Cheers,
Daniel

[Devtech83]

Yes and older version did the trick, very odd.