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

Details

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              71b5538b1829 Colin McDermott_GLiNTECH
              Votes:
              102 Vote for this issue
              Watchers:
              69 Start watching this issue

              Dates

                Created:
                Updated: