ambari-issues 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-17941) Ambari upgrade reports error upgrading view tables - possibly not an error but confusing
Date Thu, 28 Jul 2016 13:37:20 GMT

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

Hadoop QA commented on AMBARI-17941:
------------------------------------

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

    {color:red}-1 patch{color}.  Top-level trunk compilation may be broken.

Console output: https://builds.apache.org/job/Ambari-trunk-test-patch/8205//console

This message is automatically generated.

> Ambari upgrade reports error upgrading view tables - possibly not an error but confusing
> ----------------------------------------------------------------------------------------
>
>                 Key: AMBARI-17941
>                 URL: https://issues.apache.org/jira/browse/AMBARI-17941
>             Project: Ambari
>          Issue Type: Bug
>          Components: ambari-upgrade, ambari-views
>    Affects Versions: 2.4.0
>            Reporter: Nitiraj Singh Rathore
>            Assignee: Nitiraj Singh Rathore
>             Fix For: 2.4.0
>
>         Attachments: AMBARI-17941_branch-2.4.patch
>
>
> STR:
> Install Ambari-2.2.2
> Install HDP-2.4 with all default services
> Upgrade to Ambari-2.4.0
> ambari-server upgrade command reports error but does not fail.
> 27 Jul 2016 01:48:29,726 ERROR [main] ClusterImpl:2858 - No service found for config
types '[cluster-env]', service config version not created
> 27 Jul 2016 01:48:29,731  INFO [main] UpgradeCatalog240:486 - updateSequenceForView called.
> 27 Jul 2016 01:48:29,738  INFO [main] UpgradeCatalog240:490 - Received view Entities
: [org.apache.ambari.server.orm.entities.ViewEntityEntity@4dbcc843, org.apache.ambari.server.orm.entities.ViewEntityEntity@381ae831,
org.apache.ambari.server.orm.entities.ViewEntityEntity@c7118188, org.apache.ambari.server.orm.entities.ViewEntityEntity@c0854374,
org.apache.ambari.server.orm.entities.ViewEntityEntity@24696698, org.apache.ambari.server.orm.entities.ViewEntityEntity@7431ce43],
length : 6
> 27 Jul 2016 01:48:29,738  INFO [main] UpgradeCatalog240:496 - Working with viewEntity
: org.apache.ambari.server.orm.entities.ViewEntityEntity@4dbcc843 : HIVE{1.0.0}org.apache.ambari.server.orm.entities.ViewInstanceEntity@ba5b1521
> 27 Jul 2016 01:48:29,739  INFO [main] UpgradeCatalog240:502 - executing max query string
select ds_id from ds_savedquery_3
> 27 Jul 2016 01:48:29,750 ERROR [main] UpgradeCatalog240:526 - Error --> can be ignored.
> javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence
Services - 2.6.2.v20151217-774c696): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "ds_savedquery_3"
does not exist
>   Position: 19
> Error Code: 0
> Call: select ds_id from ds_savedquery_3
> Query: DataReadQuery(sql="select ds_id from ds_savedquery_3")
> 	at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:382)
> 	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260)
> 	at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:473)
> 	at org.apache.ambari.server.upgrade.UpgradeCatalog240.updateSequenceForView(UpgradeCatalog240.java:504)
> 	at org.apache.ambari.server.upgrade.UpgradeCatalog240.executeDMLUpdates(UpgradeCatalog240.java:399)
> 	at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeData(AbstractUpgradeCatalog.java:897)
> 	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:234)
> 	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:353)
> Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.2.v20151217-774c696):
org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "ds_savedquery_3"
does not exist
>   Position: 19
> Error Code: 0
> Call: select ds_id from ds_savedquery_3
> Query: DataReadQuery(sql="select ds_id from ds_savedquery_3")
> 	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1620)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:676)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
> 	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055)
> 	at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:306)
> 	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
> 	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
> 	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299)
> 	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:281)
> 	at org.eclipse.persistence.queries.DataReadQuery.executeNonCursor(DataReadQuery.java:197)
> 	at org.eclipse.persistence.queries.DataReadQuery.executeDatabaseQuery(DataReadQuery.java:152)
> 	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
> 	at org.eclipse.persistence.queries.DataReadQuery.execute(DataReadQuery.java:137)
> 	at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)
> 	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
> 	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
> 	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
> 	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
> 	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
> 	... 6 more
> Caused by: org.postgresql.util.PSQLException: ERROR: relation "ds_savedquery_3" does
not exist
>   Position: 19
> 	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:417)
> 	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1009)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644)
> 	... 23 more
> 27 Jul 2016 01:48:29,754  INFO [main] UpgradeCatalog240:496 - Working with viewEntity
: org.apache.ambari.server.orm.entities.ViewEntityEntity@381ae831 : HIVE{1.0.0}org.apache.ambari.server.orm.entities.ViewInstanceEntity@ba5b1521
> 27 Jul 2016 01:48:29,754  INFO [main] UpgradeCatalog240:502 - executing max query string
select ds_id from ds_testbean_2
> 27 Jul 2016 01:48:29,757 ERROR [main] UpgradeCatalog240:526 - Error --> can be ignored.
> javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence
Services - 2.6.2.v20151217-774c696): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "ds_testbean_2"
does not exist
>   Position: 19
> Error Code: 0
> Call: select ds_id from ds_testbean_2
> Query: DataReadQuery(sql="select ds_id from ds_testbean_2")
> 	at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:382)
> 	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260)
> 	at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:473)
> 	at org.apache.ambari.server.upgrade.UpgradeCatalog240.updateSequenceForView(UpgradeCatalog240.java:504)
> 	at org.apache.ambari.server.upgrade.UpgradeCatalog240.executeDMLUpdates(UpgradeCatalog240.java:399)
> 	at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeData(AbstractUpgradeCatalog.java:897)
> 	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:234)
> 	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:353)
> Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.2.v20151217-774c696):
org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "ds_testbean_2"
does not exist
>   Position: 19
> Error Code: 0
> Call: select ds_id from ds_testbean_2
> Query: DataReadQuery(sql="select ds_id from ds_testbean_2")
> 	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1620)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:676)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
> 	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055)
> 	at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:306)
> 	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
> 	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
> 	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299)
> 	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:281)
> 	at org.eclipse.persistence.queries.DataReadQuery.executeNonCursor(DataReadQuery.java:197)
> 	at org.eclipse.persistence.queries.DataReadQuery.executeDatabaseQuery(DataReadQuery.java:152)
> 	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
> 	at org.eclipse.persistence.queries.DataReadQuery.execute(DataReadQuery.java:137)
> 	at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)
> 	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
> 	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
> 	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
> 	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
> 	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
> 	... 6 more
> Caused by: org.postgresql.util.PSQLException: ERROR: relation "ds_testbean_2" does not
exist
>   Position: 19
> 	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:417)
> 	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1009)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644)
> 	... 23 more
> 27 Jul 2016 01:48:29,757  INFO [main] UpgradeCatalog240:496 - Working with viewEntity
: org.apache.ambari.server.orm.entities.ViewEntityEntity@c7118188 : HIVE{1.0.0}org.apache.ambari.server.orm.entities.ViewInstanceEntity@ba5b1521
> 27 Jul 2016 01:48:29,757  INFO [main] UpgradeCatalog240:502 - executing max query string
select ds_id from ds_udf_5
> 27 Jul 2016 01:48:29,771 ERROR [main] UpgradeCatalog240:526 - Error --> can be ignored.
> javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence
Services - 2.6.2.v20151217-774c696): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "ds_udf_5" does
not exist
>   Position: 19
> Error Code: 0
> Call: select ds_id from ds_udf_5
> Query: DataReadQuery(sql="select ds_id from ds_udf_5")
> 	at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:382)
> 	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260)
> 	at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:473)
> 	at org.apache.ambari.server.upgrade.UpgradeCatalog240.updateSequenceForView(UpgradeCatalog240.java:504)
> 	at org.apache.ambari.server.upgrade.UpgradeCatalog240.executeDMLUpdates(UpgradeCatalog240.java:399)
> 	at org.apache.ambari.server.upgrade.AbstractUpgradeCatalog.upgradeData(AbstractUpgradeCatalog.java:897)
> 	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.executeDMLUpdates(SchemaUpgradeHelper.java:234)
> 	at org.apache.ambari.server.upgrade.SchemaUpgradeHelper.main(SchemaUpgradeHelper.java:353)
> Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.2.v20151217-774c696):
org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "ds_udf_5" does
not exist
>   Position: 19
> Error Code: 0
> Call: select ds_id from ds_udf_5
> Query: DataReadQuery(sql="select ds_id from ds_udf_5")
> 	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:340)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1620)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:676)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:560)
> 	at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:2055)
> 	at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:306)
> 	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:242)
> 	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:228)
> 	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelectCall(DatasourceCallQueryMechanism.java:299)
> 	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeSelect(DatasourceCallQueryMechanism.java:281)
> 	at org.eclipse.persistence.queries.DataReadQuery.executeNonCursor(DataReadQuery.java:197)
> 	at org.eclipse.persistence.queries.DataReadQuery.executeDatabaseQuery(DataReadQuery.java:152)
> 	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:904)
> 	at org.eclipse.persistence.queries.DataReadQuery.execute(DataReadQuery.java:137)
> 	at org.eclipse.persistence.queries.DatabaseQuery.executeInUnitOfWork(DatabaseQuery.java:803)
> 	at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.internalExecuteQuery(UnitOfWorkImpl.java:2896)
> 	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1857)
> 	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1839)
> 	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1804)
> 	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:258)
> 	... 6 more
> Caused by: org.postgresql.util.PSQLException: ERROR: relation "ds_udf_5" does not exist
>   Position: 19
> 	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:417)
> 	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeSelect(DatabaseAccessor.java:1009)
> 	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:644)
> 	... 23 more
> 27 Jul 2016 01:48:29,774  INFO [main] UpgradeCatalog240:496 - Working with viewEntity
: org.apache.ambari.server.orm.entities.ViewEntityEntity@c0854374 : HIVE{1.0.0}org.apache.ambari.server.orm.entities.ViewInstanceEntity@ba5b1521
> 27 Jul 2016 01:48:29,774  INFO [main] UpgradeCatalog240:502 - executing max query string
select ds_id from ds_jobimpl_6
> 27 Jul 2016 01:48:29,782 ERROR [main] UpgradeCatalog240:526 - Error --> can be ignored.
> javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence
Services - 2.6.2.v20151217-774c696): org.eclipse.persistence.exceptions.DatabaseException
> Internal Exception: org.postgresql.util.PSQLException: ERROR: relation "ds_jobimpl_6"
does not exist
>   Position: 19
> Error Code: 0
> Call: select ds_id from ds_jobimpl_6
> Query: DataReadQuery(sql="select ds_id from ds_jobimpl_6")
> 	at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:382)
> 	at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:260)
> 	at org.eclipse.persistence.internal



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

Mime
View raw message