[jira] [Comment Edited] (HIVE-6953) All CompactorTest failing with Table/View 'NEXT_TXN_ID' does not exist

["Amareshwari Sriramadasu (JIRA)" <ji...@apache.org>]

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

Amareshwari Sriramadasu edited comment on HIVE-6953 at 4/24/14 5:47 AM:
------------------------------------------------------------------------

Also, there are some tests failing randomly because they fail to create path in /user/hive/warehouse

For ex: org.apache.hadoop.hive.ql.io.TestSymlinkTextInputFormat failed with following errors
{noformat}
log4j:ERROR Could not read configuration file from URL [file:/<hive-path>/ql/target/tmp/conf/hive-log4j.properties].
java.io.FileNotFoundException: /<hive-path>/ql/target/tmp/conf/hive-log4j.properties (No such file or directory)
....

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:file:/user/hive/warehouse/text_symlink_text is not a directory or unable to create one)
{noformat}

So, most probably something is getting cleaned-up. But I could not find where to start.

Can someone help me to find the root cause? Where can i start to look at it.  


was (Author: amareshwari):
Also, there are some tests failing randomly because they fail to create path in /user/hive/warehouse

For ex: org.apache.hadoop.hive.ql.io.TestSymlinkTextInputFormat failed with following errors
{noformat}
log4j:ERROR Could not read configuration file from URL [file:/<hive-path>/ql/target/tmp/conf/hive-log4j.properties].
java.io.FileNotFoundException: /<hive-path>/ql/target/tmp/conf/hive-log4j.properties (No such file or directory)
....

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:file:/user/hive/warehouse/text_symlink_text is not a directory or unable to create one)
{noformat}

So, most probably something is getting cleaned-up. But I could find where to start.

Can someone help me to find the root cause? Where can i start to look at it.  

> All CompactorTest failing with Table/View 'NEXT_TXN_ID' does not exist
> ----------------------------------------------------------------------
>
>                 Key: HIVE-6953
>                 URL: https://issues.apache.org/jira/browse/HIVE-6953
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.13.0
>            Reporter: Amareshwari Sriramadasu
>            Assignee: Alan Gates
>         Attachments: TEST-org.apache.hadoop.hive.ql.txn.compactor.TestCleaner.xml, TEST-org.apache.hadoop.hive.ql.txn.compactor.TestInitiator.xml, TEST-org.apache.hadoop.hive.ql.txn.compactor.TestWorker.xml, nohup.out.gz
>
>
> When I'm running all tests through the command 'mvn clean install -Phadoop-1', all CompactorTest classes TestInitiator, TestWorker, TestCleaner fail with following exception :
> {noformat}
> 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)
> {noformat}
> 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?



--
This message was sent by Atlassian JIRA
(v6.2#6252)