• Type: Bug
• Resolution: Cannot Reproduce
• Priority: Medium (View bug fix roadmap)
• Fix Version/s: None
• Affects Version/s: 8.5.0, 8.13.0
• Component/s: Environment - Database
• Labels:

  • platform
  • testival

[JRASERVER-72246] Postgres upgrade on AWS RDS Jira can't find tables

Artur Gniadzik made changes - 30/Jul/2021 11:14 AM

Resolution		New: Cannot Reproduce [ 5 ]
Status	Original: Gathering Impact [ 12072 ]	New: Closed [ 6 ]

Artur Gniadzik made changes - 28/Jul/2021 7:22 AM

Description

Original: h3. 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. h3. Steps to Reproduce  # Connect to postgres sever (psql)  # connect to jira database by \c <jiradb>  # list out schemas \dn+ h3. Expected Results  # rdsadmin user has access privileges {code:java}                           List of schemas   Name | Owner | Access privileges | Description --------+----------+----------------------+------------------------  public | rdsadmin | rdsadmin=UC/rdsadmin+| standard public schema         | | =UC/rdsadmin | (1 row) {code} h3. Actual Results  # access privileges are lost. {code:java}     List of schemas   Name | Owner | Access privileges | Description --------+----------+-------------------+------------------------  public | rdsadmin | | standard public schema (1 row) {code} h3. Workaround Grant schema access to confluence user. {code:java} confluence=> ALTER SCHEMA public OWNER to <jira_db_user>; ALTER SCHEMA confluence=> GRANT ALL ON SCHEMA public TO <jira_db_user>; GRANT {code}

New: h3. 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. h3. Steps to Reproduce  # Connect to postgres sever (psql)  # connect to jira database by \c <jiradb>  # list out schemas \dn+ h3. Expected Results  # rdsadmin user has access privileges {code:java}                           List of schemas   Name | Owner | Access privileges | Description --------+----------+----------------------+------------------------  public | rdsadmin | rdsadmin=UC/rdsadmin+| standard public schema         | | =UC/rdsadmin | (1 row) {code} h3. Actual Results  # access privileges are lost. {code:java}     List of schemas   Name | Owner | Access privileges | Description --------+----------+-------------------+------------------------  public | rdsadmin | | standard public schema (1 row) {code} h3. Workaround Grant schema access to confluence user. {code:java} confluence=> ALTER SCHEMA public OWNER to <jira_db_user>; ALTER SCHEMA confluence=> GRANT ALL ON SCHEMA public TO <jira_db_user>; GRANT {code}

SET Analytics Bot made changes - 15/Jun/2021 12:33 AM

UIS

Original: 8

New: 7

Bugfix Automation Bot made changes - 28/Apr/2021 11:00 PM

Support reference count

Original: 2

New: 1

Artur Gniadzik made changes - 28/Apr/2021 7:51 AM

Remote Link

Original: This issue links to "Page (Confluence)" [ 543352 ]

SET Analytics Bot made changes - 25/Apr/2021 12:15 AM

UIS

Original: 1

New: 8

SET Analytics Bot made changes - 24/Apr/2021 12:33 AM

UIS

New: 1

Bugfix Automation Bot made changes - 22/Apr/2021 11:30 PM

Support reference count

Original: 1

New: 2

Artur Gniadzik made changes - 16/Apr/2021 10:22 AM

Status

Original: Needs Triage [ 10030 ]

New: Gathering Impact [ 12072 ]

Artur Gniadzik made changes - 14/Apr/2021 10:11 AM

Remote Link

New: This issue links to "Page (Confluence)" [ 543352 ]

Load more older history items