-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
None
-
Affects Version/s: 6.14.3, 7.0.1
-
Component/s: Server - Installer / Setup
-
Environment:
Confluence 7.0.1 beta2
Oracle 12c Docker
-
2
-
Severity 3 - Minor
-
0
Steps
- Installed Confluence 7.0.1-beta2
- Checked atlassian-confluence.log
What happened...
Saw this logged:
atlassian-confluence.log
2019-08-27 23:12:06,728 WARN [SiteSummaryCalculator:thread-1] [liquibase.snapshot.JdbcDatabaseSnapshot$CachingDatabaseMetaData] warn Liquibase needs to access the DBA_RECYCLEBIN table so we can automatically handle the case where constraints are deleted and restored. Since Oracle doesn't properly restore the original table names referenced in the constraint, we use the information from the DBA_RECYCLEBIN to automatically correct this issue. The user you used to connect to the database (CONF5100U) needs to have "SELECT ON SYS.DBA_RECYCLEBIN" permissions set before we can perform this operation. Please run the following SQL to set the appropriate permissions, and try running the command again. GRANT SELECT ON SYS.DBA_RECYCLEBIN TO CONF5100U; -- changeSet: META-INF/db-changelog/5-attachment-migration-version.xml::5-attachment-migration-version-drop-index::MPT | databaseChangeLog: META-INF/db-changelog/master.xml
What should have happened...
From Setting up Confluence with Oracle / https://confluence.atlassian.com/doc/database-setup-for-oracle-173821.html:
create user <user> identified by <password> default tablespace <tablespace_name> quota unlimited on <tablespace_name>; grant connect to <user>; grant resource to <user>; grant create table to <user>; grant create sequence to <user>; grant create trigger to <user>;
does this mean since we've bundled migration agent, we need to update our Confluence/Oracle role grant requirements to include:
GRANT SELECT ON SYS.DBA_RECYCLEBIN TO <user>
System Impact:
Unknown and unassessed - leaving it up to the Migration team for assessment. Just reporting the Log Warning 
Reporter: Eric Lam
E-mail: hlam@atlassian.com