FAQ
Hi Hiro,

Have you tried increasing the impala startup parameter "
statestore_subscriber_timeout_seconds" to 60sec?

Thanks,
Alan

On Fri, Jan 17, 2014 at 2:05 AM, hiro wrote:

Hi,

I am still having this problem .
Network is fine and Hadoop program works as usual.
so, I can't do anything for this issue.
Is there any way to initialize all the settings for impala ?

Thanks,

Hiro

2014年1月6日月曜日 21時53分41秒 UTC+9 hiro:
Hi,

I am using Impala 1.2.3 on CDH4.
I installed impala before and I have run several queries successfully.
I just started Impala again after a while and
I get errors like the following when I query.

------------------
[impalad003:21000] > select * from part where p_retailprice <= 900.18;
Query: select * from part where p_retailprice <= 900.18
ERROR: Cancelled due to unreachable impalad(s): impalad006:22000,
impalad063:22000, impalad015:22000, impalad100:22000, ...
ERROR: Invalid query handle
------------------

There seems some connection problems.
I also checked impalad.INFO in each impalad node,
it keeps reconnecting to state-store over and over and never stops as
shown below.
As far as I know, it wasn't like this before, so it might be the cause.

------------------
I0106 21:46:07.333633 32072 state-store-subscriber.cc:202]
impalad002:22000: Connection with state-store lost, entering recovery mode
I0106 21:46:07.333675 32072 state-store-subscriber.cc:206] Trying to
re-register with state-store, attempt: 1
I0106 21:46:07.336510 32072 state-store-subscriber.cc:210] Reconnected to
state-store. Exiting recovery mode
I0106 21:46:17.338811 32072 state-store-subscriber.cc:202]
impalad002:22000: Connection with state-store lost, entering recovery mode
I0106 21:46:17.338851 32072 state-store-subscriber.cc:206] Trying to
re-register with state-store, attempt: 1
I0106 21:46:17.339157 32072 state-store-subscriber.cc:210] Reconnected to
state-store. Exiting recovery mode
W0106 21:46:24.055603 320 Configuration.java:2227]
org.apache.hadoop.hive.conf.LoopingByteArrayInputStream@a1e5879:an
attempt to override final parameter: mapreduce.job.end-
notification.max.retry.interval; Ignoring.
W0106 21:46:24.056337 320 Configuration.java:2227]
org.apache.hadoop.hive.conf.LoopingByteArrayInputStream@a1e5879:an
attempt to override final parameter: mapreduce.job.end-notification.max.attempts;
Ignoring.
I0106 21:46:42.344254 32072 state-store-subscriber.cc:202]
impalad002:22000: Connection with state-store lost, entering recovery mode
I0106 21:46:42.344295 32072 state-store-subscriber.cc:206] Trying to
re-register with state-store, attempt: 1
I0106 21:46:42.344761 32072 state-store-subscriber.cc:210] Reconnected to
state-store. Exiting recovery mode
I0106 21:46:52.346424 32072 state-store-subscriber.cc:202]
impalad002:22000: Connection with state-store lost, entering recovery mode
I0106 21:46:52.346465 32072 state-store-subscriber.cc:206] Trying to
re-register with state-store, attempt: 1
I0106 21:46:52.347231 32072 state-store-subscriber.cc:210] Reconnected to
state-store. Exiting recovery mode
W0106 21:47:03.134521 325 Configuration.java:2227]
org.apache.hadoop.hive.conf.LoopingByteArrayInputStream@6d347991:an
attempt to override final parameter: mapreduce.job.end-
notification.max.retry.interval; Ignoring.
W0106 21:47:03.135227 325 Configuration.java:2227]
org.apache.hadoop.hive.conf.LoopingByteArrayInputStream@6d347991:an
attempt to override final parameter: mapreduce.job.end-notification.max.attempts;
Ignoring.
... (never stops)
------------------

Does anyone have any idea about this ?
Thanks in advance.


Hiro


To unsubscribe from this group and stop receiving emails from it, send
an email to impala-user+unsubscribe@cloudera.org.
To unsubscribe from this group and stop receiving emails from it, send an email to impala-user+unsubscribe@cloudera.org.

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
groupimpala-user @
categorieshadoop
postedJan 17, '14 at 10:05a
activeJan 18, '14 at 6:25a
posts2
users2
websitecloudera.com
irc#hadoop

2 users in discussion

Hiro: 1 post Alan Choi: 1 post

People

Translate

site design / logo © 2022 Grokbase