Uploaded image for project: 'Ambari'
  1. Ambari
  2. AMBARI-17941

Ambari upgrade reports error upgrading view tables - possibly not an error but confusing

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.4.0
    • Fix Version/s: 2.4.0
    • Labels:
      None

      Description

      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

        Attachments

        1. AMBARI-17941_branch-2.4.patch
          1 kB
          Nitiraj Singh Rathore

          Issue Links

            Activity

              People

              • Assignee:
                nitiraj.rathore Nitiraj Singh Rathore
                Reporter:
                nitiraj.rathore Nitiraj Singh Rathore
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: