Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-21113

AURORA_VERSION check on non aurora database logged error every hour

XMLWordPrintable

      Symptom

      Since Jira 8.4.0 having support for Aurora, Jira is causing errors on database logging side for AURORA_VERSION() check every hour.

      This does not have an impact on the application but can fill database logging if the database is not Postgres Aurora on AWS.

      Steps to reproduce

      1. Install Jira 8.4+
      2. Use any database that is not Postgres Aurora
      3. Check logging on database side.

      Expected results

      No logging about Aurora

      Actual results

      Error -

      ERROR: function aurora_version() does not exist at character 8
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

      or

      'AURORA_VERSION' is not a recognized built-in function name

      This is thrown by SQL that is run every hour -

      select AURORA_VERSION() as aurora_version;

      Workaround

      none at this time, the error message can be ignored. 
      Suppression can only be done on database side for now.

          Form Name

            [JSWSERVER-21113] AURORA_VERSION check on non aurora database logged error every hour

            SET Analytics Bot made changes -
            UIS Original: 5 New: 6
            SET Analytics Bot made changes -
            UIS Original: 11 New: 5
            SET Analytics Bot made changes -
            UIS Original: 12 New: 11
            SET Analytics Bot made changes -
            UIS Original: 11 New: 12
            SET Analytics Bot made changes -
            UIS Original: 6 New: 11
            SET Analytics Bot made changes -
            UIS Original: 5 New: 6
            SET Analytics Bot made changes -
            UIS Original: 11 New: 5
            SET Analytics Bot made changes -
            UIS Original: 10 New: 11
            SET Analytics Bot made changes -
            Support reference count Original: 10 New: 11
            SET Analytics Bot made changes -
            UIS Original: 5 New: 10

              Unassigned Unassigned
              71b5538b1829 Colin McDermott_GLiNTECH
              Affected customers:
              104 This affects my team
              Watchers:
              70 Start watching this issue

                Created:
                Updated: