hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Logan Hardy (JIRA)" <>
Subject [jira] [Commented] (HIVE-4996) unbalanced calls to openTransaction/commitTransaction
Date Mon, 19 Aug 2013 20:21:51 GMT


Logan Hardy commented on HIVE-4996:

Thanks for your reply Teddy. I have a hive script that drops then
re-creates a couple of tables. I assumed that it was the "drop table if
exists" steps but upon further investigation at least in the latest
instance it was the last step that failed.  *--uber_responsemapping*

[root@ALLEG-P-H0001 exec_etl-wf]# cat drop_uber_tables.q
DROP TABLE if exists ${hivedbname}.uber_responsemapping;
DROP TABLE if exists ${hivedbname}.ubermap;

Create table ${hivedbname}.ubermap (
ubermapid int,
id int,
value string,
surveyid int,
uberindex int,
uberbit bigint,
modifieddate string)
Partitioned by (Maptype int )
Clustered by (id ) into 20 BUCKETS;

*Create Table ${hivedbname}.uber_responsemapping (*
*id int, *
*responseid int, *
*respondentid int, *
*answerid int, *
*scaleid int, *
*responserank int, *
*respondentstate int, *
*modifieddatetime string, *
*value string, *
*answerweight int,*
*answerdatatype string,*
*dataaction string)*
*Partitioned by (surveyid int)*
*Clustered by (respondentid) into 50 BUCKETS;*

> unbalanced calls to openTransaction/commitTransaction
> -----------------------------------------------------
>                 Key: HIVE-4996
>                 URL:
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>    Affects Versions: 0.10.0
>         Environment: hiveserver1  Java HotSpot(TM) 64-Bit Server VM (build 20.6-b01,
mixed mode)
>            Reporter: wangfeng
>            Priority: Critical
>              Labels: hive, metastore
>   Original Estimate: 504h
>  Remaining Estimate: 504h
> when we used hiveserver1 based on hive-0.10.0, we found the Exception thrown.It was:
> FAILED: Error in metadata: MetaException(message:java.lang.RuntimeException: commitTransaction
was called but openTransactionCalls = 0. This probably indicates that the
> re are unbalanced calls to openTransaction/commitTransaction)
> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
> help

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message