[HIVE-14227] Investigate invalid SessionHandle and invalid OperationHandle

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.0.0
• Component/s: HiveServer2
• Assignee: Aihua Xu
• Reporter: Aihua Xu
• Created: 13/Jul/16 14:34
• Updated: 27/Jul/16 14:25

Description

There are the following warnings.

WARN  org.apache.hive.service.cli.thrift.ThriftCLIService: [HiveServer2-Handler-Pool: Thread-55]: Error executing statement:
org.apache.hive.service.cli.HiveSQLException: Invalid SessionHandle: SessionHandle [1bc00251-64e9-4a95-acb7-a7f53f773528]
        at org.apache.hive.service.cli.session.SessionManager.getSession(SessionManager.java:318)
        at org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:258)
        at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:506)
        at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1313)
        at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1298)
        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)

WARN  org.apache.hive.service.cli.thrift.ThriftCLIService: [HiveServer2-Handler-Pool: Thread-1060]: Error closing operation:
org.apache.hive.service.cli.HiveSQLException: Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=13d930dd-316c-4c09-9f44-fee5f483e73d]
        at org.apache.hive.service.cli.operation.OperationManager.getOperation(OperationManager.java:185)
        at org.apache.hive.service.cli.CLIService.closeOperation(CLIService.java:408)
        at org.apache.hive.service.cli.thrift.ThriftCLIService.CloseOperation(ThriftCLIService.java:664)
        at org.apache.hive.service.cli.thrift.TCLIService$Processor$CloseOperation.getResult(TCLIService.java:1513)
        at org.apache.hive.service.cli.thrift.TCLIService$Processor$CloseOperation.getResult(TCLIService.java:1498)
        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
        at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)

Issue Links

• relates to: HIVE-13415 Decouple Sessions from thrift binary transport
• relates to: HIVE-11485 Session close should not close async SQL operations
• links to: Code review

Sub-Tasks

• Add some logging info for session and operation management: Resolved
• Change OperationManager to serve each session and make it threadsafe: Patch Available