hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sunil Kumar (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-9005) HiveSever2 error with "Illegal Operation state transition from CLOSED to ERROR"
Date Mon, 13 Apr 2015 12:04:12 GMT

    [ 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)

Mime
View raw message