<div dir="ltr">Hi Luca,<div><br></div><div>well, given that you are already have to deal with Hive today, just to report back that I have had a few situations with the HS2 server rejecting my queries in the previous days, reporting back that the most likely reason is the number of open connections. I guess some defensive programming in my R scripts will take care of running the queries when the rush is not that dense, however, nothing similar has ever happened in the previous months, so I wanted to report back.</div><div><br></div><div>You know that I'm not in Data Engineering so I don't have a clue whether this has or does not have to do with the HS2 settings as they were planned by Analytics-Engineering. Maybe nothing needs to be changed. Just wanted to let you know.</div><div><br></div><div>Good luck with the daemon.</div><div><br></div><div>Best,</div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div>Goran S. Milovanović, PhD<br></div>Data Scientist, Software Department<br></div>Wikimedia Deutschland<br><br>------------------------------------------------<br>"It's not the size of the dog in the fight, <br>it's the size of the fight in the dog."<br>- Mark Twain<span><br>------------------------------------------------</span><br><span></span></div></div></div>
<br><div class="gmail_quote">On Thu, Dec 7, 2017 at 12:36 PM, Luca Toscano <span dir="ltr"><<a href="mailto:ltoscano@wikimedia.org" target="_blank">ltoscano@wikimedia.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi everybody,<div><br></div><div>we are experiencing some issues with the Hive daemon, so currently Hive queries are not available. I am going to update this thread as soon as the issue is over.</div><div><br></div><div>For more info, please contact me (elukey) on IRC (#wikimedia-analytics).</div><div><br></div><div>Sorry for the trouble!</div><span class="HOEnZb"><font color="#888888"><div><br></div><div>Luca </div></font></span><div><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">2017-12-06 19:47 GMT+01:00 Luca Toscano <span dir="ltr"><<a href="mailto:ltoscano@wikimedia.org" target="_blank">ltoscano@wikimedia.org</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi everybody,<div><br></div><div>we'd need to reboot the analytics1003 host for Linux kernel and openjdk updates tomorrow Dec 07 at 10 AM CET. Hive and Oozie will stop for a (hopefully) brief amount of time, but since they'll need to stop before the reboot it might happen that in flight jobs/queries fail. We'll try to avoid the reboot if too many jobs are running, but at some point we'll need to pull the trigger.</div><div><br></div><div>Please let me know on IRC (#wikimedia-analytics, elukey) or via email if you have any issue with this maintenance.</div><div><br></div><div>Thanks and sorry for the trouble!</div><div><br></div><div>Luca (on behalf of the Analytics team) </div></div>
</blockquote></div><br></div></div></div></div>
<br>______________________________<wbr>_________________<br>
Engineering mailing list<br>
<a href="mailto:Engineering@lists.wikimedia.org">Engineering@lists.wikimedia.<wbr>org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/engineering" rel="noreferrer" target="_blank">https://lists.wikimedia.org/<wbr>mailman/listinfo/engineering</a><br>
<br></blockquote></div><br></div></div>