java.net.SocketTimeoutException: Read timed out" As the metastore we are using MySQL, that is being used by Thrift server. The design / architecture is like this: Oozie -- > Hive Action --> ELB (AWS) --> Hive Thrift ( 2 servers) --> MySQL (Master) -- > MySQL (Slave). Software versions: Hive version : 0.10.0 Hadoop: 1.2.1 Looks like when the load is beyond some threshold for certain operations it is having problem in responding. As the hive jobs sometimes fails because of this issue, we also have a auto-restart check to see if the Thrift server is not responding, it stops / kills and restart the service. Other tuning done: Thrift Server: Given 11gb heap, and configured CMS GC algo. MySQL: Tuned innodb_buffer, tmp_table and max_heap parameters. So, can somebody please help to understand, what could be the root cause for this or somebody faced the similar issue. I found one related JIRA : https://issues.apache.org/jira/browse/HCATALOG-541 But this JIRA shows that Hive Thrift Server shows OOM error, but in my case I didnt see any OOM error in my case. Regards, Manish Full Exception Stack:

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
via ibm.com by Unknown author

Adjust the timeout barrier so that its more flexible on network delays. It is very important to consider doing that especially when your server application will run in a remote machine. Other than that, avoid whatever causes delays in network.

,
via javacodegeeks.com by Unknown author

This exception emerges when a blocking operation of the two, an accept or a read, is blocked for a certain amount of time, called the timeout.

Solutions on the web

via hive-user by Manish Malhotra, 1 year ago
, can somebody please help to understand, what could be the root cause for this or somebody faced the similar issue. I found one related JIRA : https://issues.apache.org/jira/browse/HCATALOG-541 But this JIRA shows that Hive Thrift Server shows OOM error, but in my case I didnt see any OOM error in my case. Regards, Manish Full Exception Stack:
java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:150)
at java.net.SocketInputStream.read(SocketInputStream.java:121)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:235)
at java.io.BufferedInputStream.read1(BufferedInputStream.java:275)
at java.io.BufferedInputStream.read(BufferedInputStream.java:334)

Users with the same issue

3 times, 2 days ago
2 times, 1 week ago
10 times, 1 week ago
Once, 1 week ago
2 times, 1 week ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.