[ https://issues.apache.org/jira/browse/HIVE-19117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16427810#comment-16427810 ]
t oo commented on HIVE-19117: ----------------------------- [~gopalv] Even with ;http.header.Connection=close it is still an issue > hiveserver2 org.apache.thrift.transport.TTransportException error when > running 2nd query after minute of inactivity > ------------------------------------------------------------------------------------------------------------------- > > Key: HIVE-19117 > URL: https://issues.apache.org/jira/browse/HIVE-19117 > Project: Hive > Issue Type: Bug > Components: Hive, HiveServer2, Metastore, Thrift API > Affects Versions: 2.1.1 > Environment: * Hive 2.1.1 with hive.server2.transport.mode set to > binary (sample JDBC string is jdbc:hive2://remotehost:10000/default) > * Hadoop 2.8.3 > * Metastore using MySQL > * Java 8 > Reporter: t oo > Priority: Blocker > > I make a JDBC connection from my SQL tool (ie Squirrel SQL, Oracle SQL > Developer) to HiveServer2 (running on remote server) with port 10000. > I am able to run some queries successfully. I then do something else (not in > the SQL tool) for 1-2minutes and then return to my SQL tool and attempt to > run a query but I get this error: > {code:java} > org.apache.thrift.transport.TTransportException: java.net.SocketException: > Software caused connection abort: socket write error{code} > If I now disconnect and reconnect in my SQL tool I can run queries again. But > does anyone know what HiveServer2 settings I should change to prevent the > error? I assume something in hive-site.xml > From the hiveserver2 logs below, can see an exact 1 minute gap from 30th min > to 31stmin where the disconnect happens. > {code:java} > 2018-04-05T03:30:41,706 INFO [HiveServer2-Handler-Pool: Thread-36] > session.SessionState: Resetting thread name to HiveServer2-Handler-Pool: > Thread-36 > 2018-04-05T03:30:41,712 INFO [HiveServer2-Handler-Pool: Thread-36] > session.SessionState: Updating thread name to > c81ec0f9-7a9d-46b6-9708-e7d78520a48a HiveServer2-Handler-Pool: Thread-36 > 2018-04-05T03:30:41,712 INFO [HiveServer2-Handler-Pool: Thread-36] > session.SessionState: Resetting thread name to HiveServer2-Handler-Pool: > Thread-36 > 2018-04-05T03:30:41,718 INFO [HiveServer2-Handler-Pool: Thread-36] > session.SessionState: Updating thread name to > c81ec0f9-7a9d-46b6-9708-e7d78520a48a HiveServer2-Handler-Pool: Thread-36 > 2018-04-05T03:30:41,719 INFO [HiveServer2-Handler-Pool: Thread-36] > session.SessionState: Resetting thread name to HiveServer2-Handler-Pool: > Thread-36 > 2018-04-05T03:31:41,232 INFO [HiveServer2-Handler-Pool: Thread-36] > thrift.ThriftCLIService: Session disconnected without closing properly. > 2018-04-05T03:31:41,233 INFO [HiveServer2-Handler-Pool: Thread-36] > thrift.ThriftCLIService: Closing the session: SessionHandle > [c81ec0f9-7a9d-46b6-9708-e7d78520a48a] > 2018-04-05T03:31:41,233 INFO [HiveServer2-Handler-Pool: Thread-36] > service.CompositeService: Session closed, SessionHandle > [c81ec0f9-7a9d-46b6-9708-e7d78520a48a], current sessions:0 > 2018-04-05T03:31:41,233 INFO [HiveServer2-Handler-Pool: Thread-36] > session.SessionState: Updating thread name to > c81ec0f9-7a9d-46b6-9708-e7d78520a48a HiveServer2-Handler-Pool: Thread-36 > 2018-04-05T03:31:41,233 INFO [HiveServer2-Handler-Pool: Thread-36] > session.SessionState: Resetting thread name to HiveServer2-Handler-Pool: > Thread-36 > 2018-04-05T03:31:41,233 INFO [HiveServer2-Handler-Pool: Thread-36] > session.SessionState: Updating thread name to > c81ec0f9-7a9d-46b6-9708-e7d78520a48a HiveServer2-Handler-Pool: Thread-36 > 2018-04-05T03:31:41,233 INFO [HiveServer2-Handler-Pool: Thread-36] > session.HiveSessionImpl: Operation log session directory is deleted: > /var/hive/hs2log/tmp/c81ec0f9-7a9d-46b6-9708-e7d78520a48a > 2018-04-05T03:31:41,233 INFO [HiveServer2-Handler-Pool: Thread-36] > session.SessionState: Resetting thread name to HiveServer2-Handler-Pool: > Thread-36 > 2018-04-05T03:31:41,236 INFO [HiveServer2-Handler-Pool: Thread-36] > session.SessionState: Deleted directory: > /var/hive/scratch/tmp/anonymous/c81ec0f9-7a9d-46b6-9708-e7d78520a48a on fs > with scheme file > 2018-04-05T03:31:41,236 INFO [HiveServer2-Handler-Pool: Thread-36] > session.SessionState: Deleted directory: > /var/hive/ec2-user/c81ec0f9-7a9d-46b6-9708-e7d78520a48a on fs with scheme file > 2018-04-05T03:31:41,236 INFO [HiveServer2-Handler-Pool: Thread-36] > hive.metastore: Closed a connection to metastore, current connections: 1{code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)