You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Sunil Kumar (JIRA)" <ji...@apache.org> on 2015/04/13 14:04:12 UTC
[jira] [Commented] (HIVE-9005) HiveSever2 error with "Illegal
Operation state transition from CLOSED to ERROR"
[ https://issues.apache.org/jira/browse/HIVE-9005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14492321#comment-14492321 ]
Sunil Kumar commented on HIVE-9005:
-----------------------------------
Hi,
we are getting below error on HIve 1.0.0. for log running query through JDBC client. While Same query get executed successfully from the beeline. Can please let me know the reason??
2015-04-13 11:32:41,622 INFO [HiveServer2-Background-Pool: Thread-42]: ql.Driver (SessionState.java:printInfo(824)) - MapReduce Jobs Launched:
2015-04-13 11:32:41,622 INFO [HiveServer2-Background-Pool: Thread-42]: ql.Driver (SessionState.java:printInfo(824)) - Stage-Stage-1: Map: 100 Reduce: 1 Cumulative CPU: 288.74 sec HDFS Read: 162865697 HDFS Write: 127 SUCCESS
2015-04-13 11:32:41,622 INFO [HiveServer2-Background-Pool: Thread-42]: ql.Driver (SessionState.java:printInfo(824)) - Stage-Stage-4: Map: 100 Reduce: 1 Cumulative CPU: 291.33 sec HDFS Read: 162865697 HDFS Write: 127 SUCCESS
2015-04-13 11:32:41,623 INFO [HiveServer2-Background-Pool: Thread-42]: ql.Driver (SessionState.java:printInfo(824)) - Stage-Stage-7: Map: 100 Reduce: 1 Cumulative CPU: 290.74 sec HDFS Read: 162865697 HDFS Write: 127 SUCCESS
2015-04-13 11:32:41,623 INFO [HiveServer2-Background-Pool: Thread-42]: ql.Driver (SessionState.java:printInfo(824)) - Stage-Stage-9: Map: 100 Reduce: 1 Cumulative CPU: 294.8 sec HDFS Read: 162865697 HDFS Write: 127 SUCCESS
2015-04-13 11:32:41,623 INFO [HiveServer2-Background-Pool: Thread-42]: ql.Driver (SessionState.java:printInfo(824)) - Stage-Stage-10: Map: 100 Reduce: 1 Cumulative CPU: 71.42 sec HDFS Read: 37431861 HDFS Write: 0 FAIL
2015-04-13 11:32:41,623 INFO [HiveServer2-Background-Pool: Thread-42]: ql.Driver (SessionState.java:printInfo(824)) - Total MapReduce CPU Time Spent: 20 minutes 37 seconds 30 msec
2015-04-13 11:32:41,623 INFO [HiveServer2-Background-Pool: Thread-42]: log.PerfLogger (PerfLogger.java:PerfLogBegin(108)) - <PERFLOG method=releaseLocks from=org.apache.hadoop.hive.ql.Driver>
2015-04-13 11:32:41,623 INFO [HiveServer2-Background-Pool: Thread-42]: log.PerfLogger (PerfLogger.java:PerfLogEnd(135)) - </PERFLOG method=releaseLocks start=1428904961623 end=1428904961623 duration=0 from=org.apache.hadoop.hive.ql.Driver>
2015-04-13 11:32:41,657 ERROR [HiveServer2-Background-Pool: Thread-42]: operation.Operation (SQLOperation.java:run(199)) - Error running hive query:
org.apache.hive.service.cli.HiveSQLException: Illegal Operation state transition from CLOSED to ERROR
at org.apache.hive.service.cli.OperationState.validateTransition(OperationState.java:91)
at org.apache.hive.service.cli.OperationState.validateTransition(OperationState.java:97)
at org.apache.hive.service.cli.operation.Operation.setState(Operation.java:125)
at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:157)
at org.apache.hive.service.cli.operation.SQLOperation.access$100(SQLOperation.java:69)
at org.apache.hive.service.cli.operation.SQLOperation$1$1.run(SQLOperation.java:196)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
at org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:536)
at org.apache.hive.service.cli.operation.SQLOperation$1.run(SQLOperation.java:208)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
> HiveSever2 error with "Illegal Operation state transition from CLOSED to ERROR"
> -------------------------------------------------------------------------------
>
> Key: HIVE-9005
> URL: https://issues.apache.org/jira/browse/HIVE-9005
> Project: Hive
> Issue Type: Bug
> Affects Versions: 0.13.1
> Reporter: Binglin Chang
> Attachments: HIVE-9005.1.patch
>
>
> {noformat}
> 2014-12-02 11:25:40,855 WARN [HiveServer2-Background-Pool: Thread-17]: ql.Driver (DriverContext.java:shutdown(137)) - Shutting down task : Stage-1:MAPRED
> 2014-12-02 11:25:41,898 INFO [HiveServer2-Background-Pool: Thread-30]: exec.Task (SessionState.java:printInfo(536)) - Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0
> 2014-12-02 11:25:41,942 WARN [HiveServer2-Background-Pool: Thread-30]: mapreduce.Counters (AbstractCounters.java:getGroup(234)) - Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead
> 2014-12-02 11:25:41,942 INFO [HiveServer2-Background-Pool: Thread-30]: exec.Task (SessionState.java:printInfo(536)) - 2014-12-02 11:25:41,939 Stage-1 map = 0%, reduce = 0%
> 2014-12-02 11:25:41,945 WARN [HiveServer2-Background-Pool: Thread-30]: mapreduce.Counters (AbstractCounters.java:getGroup(234)) - Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead
> 2014-12-02 11:25:41,952 ERROR [HiveServer2-Background-Pool: Thread-30]: exec.Task (SessionState.java:printError(545)) - Ended Job = job_1413717733669_207982 with errors
> 2014-12-02 11:25:41,954 ERROR [Thread-39]: exec.Task (SessionState.java:printError(545)) - Error during job, obtaining debugging information...
> 2014-12-02 11:25:41,957 ERROR [HiveServer2-Background-Pool: Thread-30]: ql.Driver (SessionState.java:printError(545)) - FAILED: Operation cancelled
> 2014-12-02 11:25:41,957 INFO [HiveServer2-Background-Pool: Thread-30]: ql.Driver (SessionState.java:printInfo(536)) - MapReduce Jobs Launched:
> 2014-12-02 11:25:41,960 WARN [HiveServer2-Background-Pool: Thread-30]: mapreduce.Counters (AbstractCounters.java:getGroup(234)) - Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead
> 2014-12-02 11:25:41,961 INFO [HiveServer2-Background-Pool: Thread-30]: ql.Driver (SessionState.java:printInfo(536)) - Stage-Stage-1: HDFS Read: 0 HDFS Write: 0 FAIL
> 2014-12-02 11:25:41,961 INFO [HiveServer2-Background-Pool: Thread-30]: ql.Driver (SessionState.java:printInfo(536)) - Total MapReduce CPU Time Spent: 0 msec
> 2014-12-02 11:25:41,965 ERROR [HiveServer2-Background-Pool: Thread-30]: operation.Operation (SQLOperation.java:run(205)) - Error running hive query:
> org.apache.hive.service.cli.HiveSQLException: Illegal Operation state transition from CLOSED to ERROR
> at org.apache.hive.service.cli.OperationState.validateTransition(OperationState.java:91)
> at org.apache.hive.service.cli.OperationState.validateTransition(OperationState.java:97)
> at org.apache.hive.service.cli.operation.Operation.setState(Operation.java:116)
> at org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:161)
> at org.apache.hive.service.cli.operation.SQLOperation.access$000(SQLOperation.java:71)
> at org.apache.hive.service.cli.operation.SQLOperation$1$1.run(SQLOperation.java:202)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:396)
> at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1589)
> at org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:504)
> at org.apache.hive.service.cli.operation.SQLOperation$1.run(SQLOperation.java:215)
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
> at java.util.concurrent.FutureTask.run(FutureTask.java:138)
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> at java.lang.Thread.run(Thread.java:662)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)