Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-41985

Support for Amazon Aurora Database

XMLWordPrintable

    • 44
    • 21
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for JIRA Server including Data Center.
      This request to also covers ONLY Aurora deployments, for Aurora Serverless see JRASERVER-41985

      Amazon is using a MySQL and Postgres compatible database servers, called Aurora, for use in the AWS. It would be great if we can have support for this database, which according to Amazon, is designed to be compatible with MySQL 5.6 and postgres 9.6+

      For clarification, on Jira 8.4, support for Aurora PostgreSQL was added. There's an open feature request to add support for MySQL:

      (JRASERVER-72376) Support for Amazon Aurora Database for MySQL

          Form Name

            [JRASERVER-41985] Support for Amazon Aurora Database

            Filipi Lima made changes -
            Description Original: {panel:bgColor=#e7f4fa}
              *NOTE:* This suggestion is for *JIRA Server including Data Center*.
            This request to also covers ONLY Aurora deployments, for Aurora Serverless see [JRASERVER-41985|https://jira.atlassian.com/browse/JRASERVER-69623]
            {panel}

            Amazon is using a MySQL and Postgres compatible database servers, called Aurora, for use in the AWS. It would be great if we can have support for this database, which according to Amazon, is designed to be compatible with MySQL 5.6 and postgres 9.6+

            		New: {panel:bgColor=#e7f4fa}
              *NOTE:* This suggestion is for *JIRA Server including Data Center*.
            This request to also covers ONLY Aurora deployments, for Aurora Serverless see [JRASERVER-41985|https://jira.atlassian.com/browse/JRASERVER-69623]
            {panel}

            Amazon is using a MySQL and Postgres compatible database servers, called Aurora, for use in the AWS. It would be great if we can have support for this database, which according to Amazon, is designed to be compatible with MySQL 5.6 and postgres 9.6+

            {panel:bgColor=#e7f4fa}For clarification, on Jira 8.4, support for Aurora PostgreSQL was added. There's an open feature request to add support for MySQL:

            [(JRASERVER-72376) Support for Amazon Aurora Database for MySQL|https://jira.atlassian.com/browse/JRASERVER-72376]
            {panel}
            Carlos Vigier (Inactive) made changes -
            Comment [ A comment with security level 'atlassian-staff' was removed. ]
            Krystian Brazulewicz made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 508119 ]

            Colin McDermott_GLiNTECH added a comment -

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

            Colin McDermott_GLiNTECH added a comment - Logged  https://jira.atlassian.com/browse/JRASERVER-71055  specifically on the AURORA_VERSION() issue. 
            Colin McDermott_GLiNTECH made changes -
            Link New: This issue was cloned as JRASERVER-71055 [ JRASERVER-71055 ]
            Kasia Derenda made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 463624 ]

            Milen Kostadinov added a comment - - edited

            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

            Milen Kostadinov added a comment - - edited 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

            Tadas added a comment - - edited

            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.

            Tadas added a comment - - edited 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.

            Tadas added a comment -

            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...

            Tadas added a comment - 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...
            Mila made changes -
            Labels Original: affects-server New: affects-server data-center-specific

              sking@atlassian.com steve
              aquadrospetry Andre Quadros Petry (Inactive)
              Votes:
              125 Vote for this issue
              Watchers:
              114 Start watching this issue

                Created:
                Updated:
                Resolved: