[HIVE-6953] All CompactorTest failing with Table/View 'NEXT_TXN_ID' does not exist

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.13.0
• Component/s: Query Processor
• Assignee: Alan Gates
• Reporter: Amareshwari Sriramadasu
• Created: 22/Apr/14 12:37
• Updated: 01/Oct/19 22:06
• Resolved: 28/Apr/14 07:10

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.omalley or someone else help me solve this. Do i have to set anything?

Issue Links

• is duplicated by: HIVE-6877 TestOrcRawRecordMerger is deleting test.tmp.dir