Logged https://jira.atlassian.com/browse/JRASERVER-71055 specifically on the AURORA_VERSION() issue. 

Just for info (accidentally found it), we use these:

• Jira Server 8.4.1 (Win Server 2012)

• PostgreSQL 9.6.12 on x86_64-pc-mingw64, compiled by gcc.exe (Rev5, Built by MSYS2 project) 4.9.2, 64-bit

  2019-11-07 14:08:43 GMT [1232]: [1-1] user=jira,db=jira,app=[unknown],client=127.0.0.1 ERROR:  function aurora_version() does not exist at character 8
  2019-11-07 14:08:43 GMT [1232]: [2-1] user=jira,db=jira,app=[unknown],client=127.0.0.1 HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
  2019-11-07 14:08:43 GMT [1232]: [3-1] user=jira,db=jira,app=[unknown],client=127.0.0.1 STATEMENT:  select AURORA_VERSION() as aurora_version
  

Ping @sking@atlassian.com , our DBA tried to silence errors by creating aurora_version() that returns nothing, and now we have warning in Jira that the use Aurora and we need Datacenter license...

Pelase consider checking SELECT version(), as it might have "Aurora" string in there, instead of creating errors in the logs.

Looks like this introduces this error messag in PostgreSQL logs regurarly:

2019-10-18 11:10:12 EEST PostgreSQL JDBC Driver jiradb jira_user 127.0.0.1 ERROR: function aurora_version() does not exist at character 8
2019-10-18 11:10:12 EEST PostgreSQL JDBC Driver jiradb jira_user 127.0.0.1 HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2019-10-18 11:10:12 EEST PostgreSQL JDBC Driver jiradb jira_user 127.0.0.1 STATEMENT: select AURORA_VERSION() as aurora_version
2019-10-18 11:12:13 EEST PostgreSQL JDBC Driver jiradb jira_user 127.0.0.1 ERROR: function aurora_version() does not exist at character 8
2019-10-18 11:12:13 EEST PostgreSQL JDBC Driver jiradb jira_user 127.0.0.1 HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2019-10-18 11:12:13 EEST PostgreSQL JDBC Driver jiradb jira_user 127.0.0.1 STATEMENT: select AURORA_VERSION() as aurora_version

There was no such issue on 8.3.x.

I've wanted to create new issue, but Atlassian suggest to only ask community question...

As a company we are moving towards Amazon Aurora, It would be great to have this feature in both versions  Server and DataCenter.

I read it like confluence will only be supported in DataCenter why not server?

It is a database engine, is your codebase really that different between versions, 

At Summit in Las Vegas there was a slide during the keynote that support for Aurora was coming soon to data center. Can someone from Atlassian confirm the target version?

I need this!

Since there is no comment from anyone from Atlassian yet I opened a support issue. This is the core of their response:

We cant assure that using Jira with an unofficial database as Amazon Aurora with will work fine since we didn't test the applications on it.

Most of the time it'll work for some period of time and then broke after some add-on update or even a minor application update, we can't predict all the scenarios that might impact on it.

The dilemma is not that JIRA will not work, is that if you encounter any issues that may be database related, we can't offer support on this since it's something that wasn't tested fully by our dev team.

The suggestion is to test it using a staging environment and decides if it's a good option keep using it or chooses any other supported database outlined in the Supported Platforms page.

This is not what I wanted but it is what I expected.

For the time being I'll continue to use standard MySQL.

Oops, my bad. I had that link in my docs and didn't check the version - still they are very picky in their supported versions, so if they don't write Aurora - they are not supporting it.

That document you refer to is for Jira 7.1 but we use 7.8.x which from the below document is supported.

https://confluence.atlassian.com/adminjiraserver076/supported-platforms-945110772.html

Here is the compatibility information from Atlassian:

• https://confluence.atlassian.com/adminjiraserver071/supported-platforms-802592168.html

They are very precise in which version of which DBMS is supported, particularly PostgreSQL 9.6 is not listed.

Ok. so we tested migration from native MySQL 5.6 to Aurora Postgresql 9.6 and as it looks like it is working. I know that AWS Postgresql RDS is supported. What about Aurora as it is just a wrapper?

From the documentation of Aurora:

"Amazon Aurora is designed to be compatible with MySQL and with PostgreSQL, so that existing applications and tools can run without requiring modification."

https://aws.amazon.com/rds/aurora/details/?nc1=h_ls

So technically, Atlassian products should work well on Aurora.

The problem is not that JIRA will not work, I'm pretty sure it does. The problem is that if you encounter any issues, Atlassian will bail out and tell you that Aurora is not supported and you're on your own - does not matter if the problem would occur on MySQL or PostgreSQL as well. That is why we need official support.

Just adding my voice to those requesting this.  We'd love to use Aurora as well please.

 From the documentation of Aurora:

"Amazon Aurora is designed to be compatible with MySQL and with PostgreSQL, so that existing applications and tools can run without requiring modification."

https://aws.amazon.com/rds/aurora/details/?nc1=h_ls

So technically, Atlassian products should work well on Aurora.

Current Aurora compatibility is with PostgreSQL versions 9.6.6 or 9.6.3 too.

Hoping that will help in having Atlassian support it.

https://aws.amazon.com/rds/aurora/

The current status is: unsupported.

What is the current status with the support model for Aurora?

With yesterdays announcement of Amazon Aurora Serverless with dynamic scaling - this really needs to be supported...... 

According to AWS, it is compatible, has anyone actually tried to get it working - and it didn't?

Any update on this ticket?

I've been waiting as well.  With the popularity of RDS Aurora for MySQL this is something Atlassian has to start looking into.  

Now Amazon announced Aurora for Postgres.  That will be another people will start looking at.  

Any updates Atlassian?

Any update on this? 

Hello, We are currently running Jira on MySQL and we ran into troubles when testing with MariaDB. Since Amazon Aurora is clustered and cheaper, we would like to use it.
Does Atlassian plan to support Aurora anytime soon, PLS?
Is there any known issue when using Confluence or Jira with Aurora, PLS?
Cheers, Robin

Aurora DB support would be awesome! I hear more and more people asking this question if Jira and Confluence will support Aurora DB.
Can't wait until this is officially supported!

Is there anything in the pipeline in Atlassian to support this?