Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HiveServer2-Background-Pool table not found

HiveServer2-Background-Pool table not found

New Contributor

Hello :)

I am using rapidminer to create a model for analysing big data but when I statrt running my model I got some error in log file in cloudera manager :(

 

Can you help me please to solve this problem :( :(

 

This is the messages I get:

 

[HiveServer2-Background-Pool: Thread-504]: Table radoop__tmp_lola_1499279743370_ruyrrcu not found: default.radoop__tmp_lola_1499279743370_ruyrrcu table not found
[HiveServer2-Background-Pool: Thread-515]: Could not find uri with key [dfs.encryption.key.provider.uri] to create a keyProvider !!

 

 
(7 skipped) Unable to retrieve remote parcel repository manifest
java.util.concurrent.ExecutionException: java.net.ConnectException: http://archive.cloudera.com/cdh5/parcels/5.10.0/manifest.json
	at com.ning.http.client.providers.netty.NettyResponseFuture.abort(NettyResponseFuture.java:297)
	at com.ning.http.client.providers.netty.NettyConnectListener.operationComplete(NettyConnectListener.java:104)
	at org.jboss.netty.channel.DefaultChannelFuture.notifyListener(DefaultChannelFuture.java:399)
	at org.jboss.netty.channel.DefaultChannelFuture.addListener(DefaultChannelFuture.java:145)
	at com.ning.http.client.providers.netty.NettyAsyncHttpProvider.doConnect(NettyAsyncHttpProvider.java:1041)
	at com.ning.http.client.providers.netty.NettyAsyncHttpProvider.execute(NettyAsyncHttpProvider.java:858)
	at com.ning.http.client.AsyncHttpClient.executeRequest(AsyncHttpClient.java:512)
	at com.ning.http.client.AsyncHttpClient$BoundRequestBuilder.execute(AsyncHttpClient.java:234)
	at com.cloudera.parcel.components.ParcelDownloaderImpl.getRepositoryInfoFuture(ParcelDownloaderImpl.java:534)
	at com.cloudera.parcel.components.ParcelDownloaderImpl.getRepositoryInfo(ParcelDownloaderImpl.java:492)
	at com.cloudera.parcel.components.ParcelDownloaderImpl.syncRemoteRepos(ParcelDownloaderImpl.java:344)
	at com.cloudera.parcel.components.ParcelDownloaderImpl$1.run(ParcelDownloaderImpl.java:416)
	at com.cloudera.parcel.components.ParcelDownloaderImpl$1.run(ParcelDownloaderImpl.java:411)
	at com.cloudera.cmf.persist.ReadWriteDatabaseTaskCallable.call(ReadWriteDatabaseTaskCallable.java:36)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.ConnectException: http://archive.cloudera.com/cdh5/parcels/5.10.0/manifest.json
	at com.ning.http.client.providers.netty.NettyConnectListener.operationComplete(NettyConnectListener.java:100)
	... 16 more
Caused by: java.nio.channels.UnresolvedAddressException
	at sun.nio.ch.Net.checkAddress(Net.java:101)
	at sun.nio.ch.SocketChannelImpl.connect(SocketChannelImpl.java:622)
	at org.jboss.netty.channel.socket.nio.NioClientSocketPipelineSink.connect(NioClientSocketPipelineSink.java:139)
	at org.jboss.netty.channel.socket.nio.NioClientSocketPipelineSink.eventSunk(NioClientSocketPipelineSink.java:102)
	at org.jboss.netty.handler.codec.oneone.OneToOneEncoder.handleDownstream(OneToOneEncoder.java:55)
	at org.jboss.netty.handler.codec.http.HttpClientCodec.handleDownstream(HttpClientCodec.java:97)
	at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleDownstream(ChunkedWriteHandler.java:108)
	at org.jboss.netty.channel.Channels.connect(Channels.java:642)
	at org.jboss.netty.channel.AbstractChannel.connect(AbstractChannel.java:204)
	at org.jboss.netty.bootstrap.ClientBootstrap.connect(ClientBootstrap.java:230)
	at org.jboss.netty.bootstrap.ClientBootstrap.connect(ClientBootstrap.java:183)
	at com.ning.http.client.providers.netty.NettyAsyncHttpProvider.doConnect(NettyAsyncHttpProvider.java:999)
	... 13 more
3 REPLIES 3

Re: HiveServer2-Background-Pool table not found

Champion
The first error is just stating that the table can't be found, default.radoop__tmp_lola_1499279743370_ruyrrcu.

The name makes me think that is is coming from Radoop which I believe can be an operation within RM. Either RM or the users using RM can't create tables under default. Or is creating them but under a different DB but RM Radoop is looking for them under default.

The second can be safely ignored.

The third could possible be serious but not directly related to RM or HS2. CM at some point, or possible during the RM operation, tried to access the Cloudera repo to install CDH 5.10.0 due to it not being able to resolve the name archive.cloudera.com. This is likely do to an issue with the DNS client on the CM host or possible a DNS configuration issue with the DNS server that the CM host is using. There is no date or time information to see if these are related. If CDH is already up and running it is unlikely that the third error has anything to do with the RM operation.
Highlighted

Re: HiveServer2-Background-Pool table not found

New Contributor

Thank you for replying :)

I found that the CDH  wasn't activated, so after activating it the third problem was resolved,

but can you tell me how to solve the first one? should I create a database under hiveserver?

Thank you in advance :)

Re: HiveServer2-Background-Pool table not found

Champion
Can you provide more information? Is there more in the logs? Once you have the error try getting all of the logs related to the same thread.

Can you provide the details of your RM workflow? Specifically, all of the operations and their order, and the specific actions/details of any Hive operators.

Was this working or is this a new setup?
Don't have an account?
Coming from Hortonworks? Activate your account here