Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-6953

All CompactorTest failing with Table/View 'NEXT_TXN_ID' does not exist

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 0.13.0
    • Fix Version/s: None
    • Component/s: Query Processor
    • Labels:
      None

      Description

      When I'm running all tests through the command 'mvn clean install -Phadoop-1', all CompactorTest classes TestInitiator, TestWorker, TestCleaner fail with following exception :

      org.apache.hadoop.hive.metastore.api.MetaException: Unable to select from transaction database java.sql.SQLSyntaxErrorException: Table/View 'NEXT_TXN_ID' does not exist.
              at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
              at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
              at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
              at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
      
      ....
      Caused by: java.sql.SQLException: Table/View 'NEXT_TXN_ID' does not exist.
              at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
              at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
      
      

      This is happening on branch-0.13. Has anyone faced this problem?

      Owen O'Malley or someone else help me solve this. Do i have to set anything?

        Attachments

        1. TEST-org.apache.hadoop.hive.ql.txn.compactor.TestCleaner.xml
          74 kB
          Jaideep Dhok
        2. TEST-org.apache.hadoop.hive.ql.txn.compactor.TestWorker.xml
          113 kB
          Jaideep Dhok
        3. TEST-org.apache.hadoop.hive.ql.txn.compactor.TestInitiator.xml
          171 kB
          Amareshwari Sriramadasu
        4. nohup.out.gz
          19 kB
          Amareshwari Sriramadasu

          Issue Links

            Activity

              People

              • Assignee:
                alangates Alan Gates
                Reporter:
                amareshwari Amareshwari Sriramadasu
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: