Oops - An error has occurred. 500 Sorry, we had some technical problems during your last operation

Question

Hello.
I'm trying to set up a Jira Service desk on an Azure Ubuntu 18.04 VM connecting to a postgres database in Azure. The setup goes well up until I connect Jira to the database. I test the connection before clicking next, and the test returns okay. When I press next to connect to the database, the whole thing crashes with the following log(see comment)

I haven't been able to find any answers online. Please advice

Matias Dall Rasmussen · Answer

Hello Alexis.
We are using a Postgres Azure Database. I just got it to work. I created a new database in on the postgres server, and edited the dbconfig.xml and replaced the DBname with the new one, and then restarted jira. I don't really understand why it works, since it's the exact same database, just called 03 instead of 02.

Alexis Robert · Answer

Hi @Matias Dall Rasmussen,

are you using a Postgres Azure Database or did you install PostgreSQL on a VM ? I think the Postgres Azure Database is not yet supported by Atlassian, as per this ticket on Atlassian support site.

However, Azure SQL Server is officialy supported so you can use this instead as a database server.

Let me know if you have any questions,

--Alexis

Matias Dall Rasmussen · Answer

If I refresh the page, it returns that the database is locked, furthermore I'm unable to configure the settings again