hivecontex释放mysql连接_通过beeline连接到hive时，自动关闭连接了

这个server2的log

... 41 more

2016-05-05 08:36:02,911 WARN  [main]: hive.metastore (HiveMetaStoreClient.java:open(439)) - set_ugi() not successful, Likely cause: new client talking to old server. Continuing without it.

org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out

at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:129)

at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86)

at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:429)

at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:318)

at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:219)

at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69)

at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_set_ugi(ThriftHiveMetastore.java:3633)

at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.set_ugi(ThriftHiveMetastore.java:3619)

at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:431)

at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.reconnect(HiveMetaStoreClient.java:309)

at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:89)

at com.sun.proxy.$Proxy10.getAllFunctions(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.apache.hadoop.hive.metastore.HiveMetaStoreClient$SynchronizedHandler.invoke(HiveMetaStoreClient.java:1910)

at com.sun.proxy.$Proxy10.getAllFunctions(Unknown Source)

at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3123)

at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:205)

at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:192)

at org.apache.hadoop.hive.ql.metadata.Hive.(Hive.java:302)

at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:263)

at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:238)

at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:493)

at org.apache.hive.service.cli.CLIService.applyAuthorizationConfigPolicy(CLIService.java:124)

at org.apache.hive.service.cli.CLIService.init(CLIService.java:111)

at org.apache.hive.service.CompositeService.init(CompositeService.java:59)

at org.apache.hive.service.server.HiveServer2.init(HiveServer2.java:92)

at org.apache.hive.service.server.HiveServer2.startHiveServer2(HiveServer2.java:309)

at org.apache.hive.service.server.HiveServer2.access$400(HiveServer2.java:68)

at org.apache.hive.service.server.HiveServer2$StartOptionExecutor.execute(HiveServer2.java:523)

at org.apache.hive.service.server.HiveServer2.main(HiveServer2.java:396)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.apache.hadoop.util.RunJar.run(RunJar.java:221)

at org.apache.hadoop.util.RunJar.main(RunJar.java:136)

Caused by: java.net.SocketTimeoutException: Read timed out

at java.net.SocketInputStream.socketRead0(Native Method)

at java.net.SocketInputStream.read(SocketInputStream.java:152)

at java.net.SocketInputStream.read(SocketInputStream.java:122)

at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)

at java.io.BufferedInputStream.read1(BufferedInputStream.java:275)

at java.io.BufferedInputStream.read(BufferedInputStream.java:334)

at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:127)

... 38 more

2016-05-05 08:46:03,035 WARN  [main]: metadata.Hive (Hive.java:registerAllFunctionsOnce(194)) - Failed to register all functions.

org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out

at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3126)

at org.apache.hadoop.hive.ql.metadata.Hive.reloadFunctions(Hive.java:205)

at org.apache.hadoop.hive.ql.metadata.Hive.registerAllFunctionsOnce(Hive.java:192)

at org.apache.hadoop.hive.ql.metadata.Hive.(Hive.java:302)

at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:263)

at org.apache.hadoop.hive.ql.metadata.Hive.get(Hive.java:238)

at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:493)

at org.apache.hive.service.cli.CLIService.applyAuthorizationConfigPolicy(CLIService.java:124)

at org.apache.hive.service.cli.CLIService.init(CLIService.java:111)

at org.apache.hive.service.CompositeService.init(CompositeService.java:59)

at org.apache.hive.service.server.HiveServer2.init(HiveServer2.java:92)

at org.apache.hive.service.server.HiveServer2.startHiveServer2(HiveServer2.java:309)

at org.apache.hive.service.server.HiveServer2.access$400(HiveServer2.java:68)

at org.apache.hive.service.server.HiveServer2$StartOptionExecutor.execute(HiveServer2.java:523)

at org.apache.hive.service.server.HiveServer2.main(HiveServer2.java:396)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.apache.hadoop.util.RunJar.run(RunJar.java:221)

at org.apache.hadoop.util.RunJar.main(RunJar.java:136)

Caused by: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out

at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:129)

at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86)

at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:429)

at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:318)

at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:219)

at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69)

at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_all_functions(ThriftHiveMetastore.java:3231)

at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_all_functions(ThriftHiveMetastore.java:3219)

at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getAllFunctions(HiveMetaStoreClient.java:1972)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:91)

at com.sun.proxy.$Proxy10.getAllFunctions(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.apache.hadoop.hive.metastore.HiveMetaStoreClient$SynchronizedHandler.invoke(HiveMetaStoreClient.java:1910)

at com.sun.proxy.$Proxy10.getAllFunctions(Unknown Source)

at org.apache.hadoop.hive.ql.metadata.Hive.getAllFunctions(Hive.java:3123)

... 20 more

Caused by: java.net.SocketTimeoutException: Read timed out

at java.net.SocketInputStream.socketRead0(Native Method)

at java.net.SocketInputStream.read(SocketInputStream.java:152)

at java.net.SocketInputStream.read(SocketInputStream.java:122)

at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)

at java.io.BufferedInputStream.read1(BufferedInputStream.java:275)

at java.io.BufferedInputStream.read(BufferedInputStream.java:334)

at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:127)

... 41 more

2016-05-05 08:46:05,003 INFO  [main]: session.SessionState (SessionState.java:createPath(626)) - Created local directory: /tmp/991b2176-bfdc-45a2-95c8-7efb05440097_resources

2016-05-05 08:46:05,027 INFO  [main]: session.SessionState (SessionState.java:createPath(626)) - Created HDFS directory: /tmp/hive/hive/991b2176-bfdc-45a2-95c8-7efb05440097

2016-05-05 08:46:05,030 INFO  [main]: session.SessionState (SessionState.java:createPath(626)) - Created local directory: /tmp/hive/991b2176-bfdc-45a2-95c8-7efb05440097

2016-05-05 08:46:05,039 INFO  [main]: session.SessionState (SessionState.java:createPath(626)) - Created HDFS directory: /tmp/hive/hive/991b2176-bfdc-45a2-95c8-7efb05440097/_tmp_space.db

2016-05-05 08:46:05,042 INFO  [main]: session.SessionState (SessionState.java:start(528)) - No Tez session required at this point. hive.execution.engine=mr.