You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ambari.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2016/06/01 02:21:12 UTC
[jira] [Commented] (AMBARI-16692) Ambari Upgrade should clean older
RCA Database tables
[ https://issues.apache.org/jira/browse/AMBARI-16692?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15309090#comment-15309090 ]
Hudson commented on AMBARI-16692:
---------------------------------
FAILURE: Integrated in Ambari-trunk-Commit #4971 (See [https://builds.apache.org/job/Ambari-trunk-Commit/4971/])
AMBARI-16692. Ambari Upgrade should clean older RCA Database tables (ajit: [http://git-wip-us.apache.org/repos/asf?p=ambari.git&a=commit&h=f852e3ca84c0214a90446127725a53ac9b590804])
* ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-DROP.sql
* ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql
* ambari-server/src/main/java/org/apache/ambari/server/upgrade/SchemaUpgradeHelper.java
* ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql
* ambari-server/src/main/resources/upgrade/ddl/AmbariRCA-DDL-Postgres-UPGRADE.sql
* ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql
* ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql
* ambari-server/src/main/resources/upgrade/ddl/AmbariRCA-DDL-Oracle-UPGRADE.sql
* ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql
* ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql
* ambari-server/src/main/resources/AmbariRCA-DML-Oracle-CLEANUP.sql
* ambari-server/src/main/resources/AmbariRCA-DML-Postgres-CLEANUP.sql
* ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql
> Ambari Upgrade should clean older RCA Database tables
> -----------------------------------------------------
>
> Key: AMBARI-16692
> URL: https://issues.apache.org/jira/browse/AMBARI-16692
> Project: Ambari
> Issue Type: Bug
> Components: ambari-server
> Affects Versions: 2.4.0
> Reporter: Ajit Kumar
> Assignee: Ajit Kumar
> Fix For: 2.4.0
>
> Attachments: rb43126.patch
>
>
> RCA Database tables is not used anymore. This older, un-necessary data causes many Ambari DB queries to return more slowly than necessary. If the database gets large enough, it can have significant impact on the way ambari-server functions.
> The Ambari Server upgrade process should detect the presence of these older, deprecated tables, and automate the process of cleaning up this data.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)