AnsweredAssumed Answered

Querying with mapr 6.0 json db

Question asked by gravindran on Feb 27, 2018
Latest reply on Feb 28, 2018 by deborah

Hello All,

 

We recently upgraded our cluster from 5.2.2 to 6.0. We are using mapr json db to persist data. The upgradation caused issues with some of the queries. 

 

Initially some of the queries failed to execute with the following exception

 

`com.mapr.db.exceptions.DBException: MapR-DB Query Service is not enabled for cluster:`

 

I went ahead and enabled query service using the steps documented here 

Configure the OJAI Query Service 

 

The same queries have now started to fail with a different exception

Caused by: com.mapr.db.exceptions.DBException: clusterQueryServiceParamCache.load() failed.,
at com.mapr.db.exceptions.ExceptionHandler.handle(ExceptionHandler.java:65)
at com.mapr.ojai.store.impl.LazyClient$1.load(LazyClient.java:155)
at com.mapr.ojai.store.impl.LazyClient$1.load(LazyClient.java:148)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
... 48 more
Caused by: java.io.IOException: While trying to apply Zookeeper operation, received KeeperErrorCode = AuthFailed for /queryservice/connection. Can not reconnect to zookeeper service for 10.0.1.128:5181. Bailing out.
at com.mapr.fs.ServiceWatcher.applyZooKeeperFunction(ServiceWatcher.java:208)
at com.mapr.fs.ServiceWatcher.getChildren(ServiceWatcher.java:157)
at com.mapr.fs.QueryServiceWatcher.getQueryServiceParam(QueryServiceWatcher.java:87)
at com.mapr.fs.MapRClientImpl.getQueryServiceParam(MapRClientImpl.java:971)
at com.mapr.fs.MapRFileSystem.getQueryServiceParam(MapRFileSystem.java:3246)
at com.mapr.ojai.store.impl.LazyClient$1.load(LazyClient.java:152)
... 53 more
Caused by: org.apache.zookeeper.KeeperException$AuthFailedException: KeeperErrorCode = AuthFailed for /queryservice/connection
at org.apache.zookeeper.KeeperException.create(KeeperException.java:123)
at org.apache.zookeeper.KeeperException.create(KeeperException.java:51)
at org.apache.zookeeper.ZooKeeper.getChildren(ZooKeeper.java:1472)
at org.apache.zookeeper.ZooKeeper.getChildren(ZooKeeper.java:1500)
at com.mapr.fs.ServiceWatcher$4.apply(ServiceWatcher.java:162)
at com.mapr.fs.ServiceWatcher$4.apply(ServiceWatcher.java:158)
at com.mapr.fs.ServiceWatcher.applyZooKeeperFunction(ServiceWatcher.java:193)
... 58 more

 

I understand there is some issue getting authorization from zookeeper. Can someone help ?

 

All the queries are executed from a edge node and not from a cluster node.

 

Thanks

Gowri

Outcomes