You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by lei liu <li...@gmail.com> on 2010/11/03 10:04:15 UTC

When I create one table, hive throw one Exception

When I create one table, hive throw below Exception:

2010-11-03 09:42:02,939 ERROR exec.DDLTask
(SessionState.java:printError(277)) - FAILED: Error in metadata:
java.lang.RuntimeExcepti
on: commitTransaction was called but openTransactionCalls = 0. This probably
indicates that there are unbalanced calls to openTransa
ction/commitTransaction
org.apache.hadoop.hive.ql.metadata.HiveException:
java.lang.RuntimeException: commitTransaction was called but
openTransactionCalls
= 0. This probably indicates that there are unbalanced calls to
openTransaction/commitTransaction
        at
org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:400)
        at
org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:2126)
        at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:166)
        at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:107)
        at
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:55)
        at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:633)
        at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:506)
        at org.apache.hadoop.hive.ql.Driver.run(Driver.java:384)
        at
org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:115)
        at
org.apache.hadoop.hive.service.ThriftHive$Processor$execute.process(ThriftHive.java:378)
        at
org.apache.hadoop.hive.service.ThriftHive$Processor.process(ThriftHive.java:366)
        at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:252)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
        at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.RuntimeException: commitTransaction was called but
openTransactionCalls = 0. This probably indicates that there
 are unbalanced calls to openTransaction/commitTransaction
        at
org.apache.hadoop.hive.metastore.ObjectStore.commitTransaction(ObjectStore.java:250)
        at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_core(HiveMetaStore.java:794)
        at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.access$600(HiveMetaStore.java:79)
        at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler$13.run(HiveMetaStore.java:815)
        at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler$13.run(HiveMetaStore.java:812)
        at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.executeWithRetry(HiveMetaStore.java:234)
        at
org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table(HiveMetaStore.java:812)
        at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:279)
        at
org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:394)
        ... 14 more

What is reason result to the Exception?

LiuLei

Thanks.

Re: When I create one table, hive throw one Exception

Posted by 김영우 <wa...@gmail.com>.
Hi LiuLei,

I believe you should check out HIVE-1760 (
https://issues.apache.org/jira/browse/HIVE-1760)

Hope this helps.


- Youngwoo

2010/11/3 lei liu <li...@gmail.com>

> When I create one table, hive throw below Exception:
>
> 2010-11-03 09:42:02,939 ERROR exec.DDLTask
> (SessionState.java:printError(277)) - FAILED: Error in metadata:
> java.lang.RuntimeExcepti
> on: commitTransaction was called but openTransactionCalls = 0. This
> probably indicates that there are unbalanced calls to openTransa
> ction/commitTransaction
> org.apache.hadoop.hive.ql.metadata.HiveException:
> java.lang.RuntimeException: commitTransaction was called but
> openTransactionCalls
> = 0. This probably indicates that there are unbalanced calls to
> openTransaction/commitTransaction
>         at
> org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:400)
>         at
> org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:2126)
>         at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:166)
>         at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:107)
>         at
> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:55)
>         at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:633)
>         at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:506)
>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:384)
>         at
> org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:115)
>         at
> org.apache.hadoop.hive.service.ThriftHive$Processor$execute.process(ThriftHive.java:378)
>         at
> org.apache.hadoop.hive.service.ThriftHive$Processor.process(ThriftHive.java:366)
>         at
> org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:252)
>         at
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
>         at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
>         at java.lang.Thread.run(Thread.java:619)
> Caused by: java.lang.RuntimeException: commitTransaction was called but
> openTransactionCalls = 0. This probably indicates that there
>  are unbalanced calls to openTransaction/commitTransaction
>         at
> org.apache.hadoop.hive.metastore.ObjectStore.commitTransaction(ObjectStore.java:250)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_core(HiveMetaStore.java:794)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.access$600(HiveMetaStore.java:79)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler$13.run(HiveMetaStore.java:815)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler$13.run(HiveMetaStore.java:812)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.executeWithRetry(HiveMetaStore.java:234)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table(HiveMetaStore.java:812)
>         at
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:279)
>         at
> org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:394)
>         ... 14 more
>
> What is reason result to the Exception?
>
> LiuLei
>
> Thanks.
>
>