ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hadoop QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMBARI-14994) CLUSTER.MANAGE_CONFIG_GROUPS not present in table 'roleauthorization' error during upgrade from 2.2.1 to 2.4.0
Date Thu, 11 Feb 2016 04:53:18 GMT

    [ https://issues.apache.org/jira/browse/AMBARI-14994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15142250#comment-15142250
] 

Hadoop QA commented on AMBARI-14994:
------------------------------------

{color:red}-1 overall{color}.  Here are the results of testing the latest attachment 
  http://issues.apache.org/jira/secure/attachment/12787316/AMBARI-14994_trunk_01.patch
  against trunk revision .

    {color:green}+1 @author{color}.  The patch does not contain any @author tags.

    {color:red}-1 tests included{color}.  The patch doesn't appear to include any new or modified
tests.
                        Please justify why no new tests are needed for this patch.
                        Also please list what manual steps were performed to verify this patch.

    {color:green}+1 javac{color}.  The applied patch does not increase the total number of
javac compiler warnings.

    {color:green}+1 release audit{color}.  The applied patch does not increase the total number
of release audit warnings.

    {color:green}+1 core tests{color}.  The patch passed unit tests in ambari-server.

Test results: https://builds.apache.org/job/Ambari-trunk-test-patch/5306//testReport/
Console output: https://builds.apache.org/job/Ambari-trunk-test-patch/5306//console

This message is automatically generated.

> CLUSTER.MANAGE_CONFIG_GROUPS not present in table 'roleauthorization' error during upgrade
from 2.2.1 to 2.4.0
> --------------------------------------------------------------------------------------------------------------
>
>                 Key: AMBARI-14994
>                 URL: https://issues.apache.org/jira/browse/AMBARI-14994
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-server
>    Affects Versions: 2.2.0, 2.2.1
>            Reporter: Robert Levas
>            Assignee: Robert Levas
>            Priority: Critical
>             Fix For: 2.4.0
>
>         Attachments: AMBARI-14994_trunk_01.patch
>
>
> While attempting to upgrade from Ambari 2.2.x to Ambari 2.4.0, the following error is
encountered:
> {noformat}
> Upgrading database schema
> Error output from schema upgrade command:
> Exception in thread "main" org.apache.ambari.server.AmbariException: ERROR: insert or
update on table "permission_roleauthorization" violates foreign key constraint "fk_permission_roleauth_aid"
>   Detail: Key (authorization_id)=(CLUSTER.MANAGE_CONFIG_GROUPS) is not present in table
"roleauthorization".
> 	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:233)
> 	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:307)
> Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "permission_roleauthorization"
violates foreign key constraint "fk_permission_roleauth_aid"
>   Detail: Key (authorization_id)=(CLUSTER.MANAGE_CONFIG_GROUPS) is not present in table
"roleauthorization".
> 	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
> 	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
> 	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
> 	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
> 	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
> 	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:331)
> 	at org.apache.ambari.server.orm.DBAccessorImpl.insertRow(DBAccessorImpl.java:635)
> 	at org.apache.ambari.server.upgrade.UpgradeCatalog230.createPermissionRoleAuthorizationMap(UpgradeCatalog230.java:317)
> 	at org.apache.ambari.server.upgrade.UpgradeCatalog230.executeDMLUpdates(UpgradeCatalog230.java:129)
> 	at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeData(AbstractUpgradeCatalog.java:659)
> 	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:230)
> 	... 1 more
> {noformat}
> *Solution*
> Add the missing record during the upgrade process (which should have be added, but apparently
accidentally left out)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message