Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-72246

Postgres upgrade on AWS RDS Jira can't find tables

    XMLWordPrintable

    Details

      Description

      Issue Summary

      This ticket is used to track a bug on RDS - after Postgres 10 upgrade, Jira may fail to start.

      https://dba.stackexchange.com/questions/237359/aws-rds-postgresql-master-user-lost-all-privileges-after-upgrading-from-v9-6

      When ugprading to Postgres 10 on AWS RDS, Jira can't start.
      It's because after upgrade, public schema lost access privileges.

      Steps to Reproduce

      1. Connect to postgres sever (psql)
      2. connect to jira database by \c <jiradb>
      3. list out schemas \dn+

      Expected Results

      1. rdsadmin user has access privileges
                                List of schemas
        Name  |  Owner   |  Access privileges   |      Description
      --------+----------+----------------------+------------------------
       public | rdsadmin | rdsadmin=UC/rdsadmin+| standard public schema
              |          | =UC/rdsadmin         |
      (1 row)
      

      Actual Results

      1. access privileges are lost.
            List of schemas
          Name  |  Owner   | Access privileges |      Description
        --------+----------+-------------------+------------------------
         public | rdsadmin |                   | standard public schema
        (1 row)
        

      Workaround

      Grant schema access to confluence user.

      confluence=> ALTER SCHEMA public OWNER to <jira_db_user>;
      ALTER SCHEMA
      confluence=> GRANT ALL ON SCHEMA public TO <jira_db_user>;
      GRANT
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              emarghidan Eduard M
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: