Member since
03-02-2016
4
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1728 | 06-08-2016 08:03 AM |
06-08-2016
08:03 AM
I was able to find the solution. Below are steps - 1. Run this command on SCM and retrieve the password- cat /etc/cloudera-scm-server/db.properties Output - com.cloudera.cmf.db.type=postgresql com.cloudera.cmf.db.host=localhost:7432 com.cloudera.cmf.db.name=scm com.cloudera.cmf.db.user=scm com.cloudera.cmf.db.password=PASSWORD 2. Run another command - psql -U scm -p 7432 -h localhost -d scm This will open the interface to run Sql query 3. Run sql query specific to your needs e.g. delete from configs where role_id = 110 Hope this helps.
... View more
06-03-2016
09:36 PM
Hi, One of our VMs crashed and we are trying to remove it from the Cluster. We have been able to remove all the assigned Roles except 1 i.e. HDFS NFS Gateway. While removing this role, we are getting below mentioned error : Caused by: org.postgresql.util.PSQLException:ERROR: update or delete on table "roles" violates foreign key constraint "fk_config_role" on table "configs" Detail: Key (role_id)=(110) is still referenced from table "configs". at QueryExecutorImpl.java line 2102 in org.postgresql.core.v3.QueryExecutorImpl receiveErrorResponse() Kindly suggest.
... View more
03-02-2016
07:19 AM
Hi, Thanks for the prompt response. Yes, it was working perfectly fine before. I request you to kindly elaborate over Proxy settings. PS: I am able to ssh all the nodes from the Master/Namenode. HDFS and other services are working fine too. Regards and Thanks, Mayank
... View more
03-02-2016
03:09 AM
Hi, After login into Cloudera, can't able to browse any section. Below is the stack trace of error. Kindly help. A server error has occurred. Send the following information to Cloudera. Path: http://*******:7180/cmf/services/3/config2/metadata.json Version: Cloudera Express 5.5.3 (#1 built by jenkins on 20160216-1045 git: d7746acd0dc9054eeb350b73a781e38124736d9f) javax.persistence.EntityNotFoundException:Unable to find com.cloudera.cmf.model.DbConfig with id 289 at Ejb3Configuration.java line 157 in org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate handleEntityNotFound() Stack Trace: Ejb3Configuration.java line 157 in org.hibernate.ejb.Ejb3Configuration$Ejb3EntityNotFoundDelegate handleEntityNotFound() DefaultLoadEventListener.java line 212 in org.hibernate.event.internal.DefaultLoadEventListener load() DefaultLoadEventListener.java line 262 in org.hibernate.event.internal.DefaultLoadEventListener proxyOrLoad() DefaultLoadEventListener.java line 150 in org.hibernate.event.internal.DefaultLoadEventListener onLoad() SessionImpl.java line 1092 in org.hibernate.internal.SessionImpl fireLoad() SessionImpl.java line 1019 in org.hibernate.internal.SessionImpl internalLoad() EntityType.java line 672 in org.hibernate.type.EntityType resolveIdentifier() ManyToOneType.java line 280 in org.hibernate.type.ManyToOneType assemble() PersistentSet.java line 141 in org.hibernate.collection.internal.PersistentSet initializeFromCache() CollectionCacheEntry.java line 57 in org.hibernate.cache.spi.entry.CollectionCacheEntry assemble() DefaultInitializeCollectionEventListener.java line 148 in org.hibernate.event.internal.DefaultInitializeCollectionEventListener initializeCollectionFromCache() DefaultInitializeCollectionEventListener.java line 69 in org.hibernate.event.internal.DefaultInitializeCollectionEventListener onInitializeCollection() SessionImpl.java line 1849 in org.hibernate.internal.SessionImpl initializeCollection() AbstractPersistentCollection.java line 549 in org.hibernate.collection.internal.AbstractPersistentCollection$4 doWork() AbstractPersistentCollection.java line 234 in org.hibernate.collection.internal.AbstractPersistentCollection withTemporarySessionIfNeeded() AbstractPersistentCollection.java line 545 in org.hibernate.collection.internal.AbstractPersistentCollection initialize() AbstractPersistentCollection.java line 124 in org.hibernate.collection.internal.AbstractPersistentCollection read() PersistentSet.java line 180 in org.hibernate.collection.internal.PersistentSet iterator() MutationBustingSet.java line 64 in com.cloudera.cmf.model.MutationBustingSet iterator() DbService.java line 607 in com.cloudera.cmf.model.DbService prepareCachedMaskedConfigs() DbService.java line 695 in com.cloudera.cmf.model.DbService getServiceConfig() NotificationSuppressionConfig.java line 432 in com.cloudera.cmf.service.config.NotificationSuppressionConfig create() NotificationSuppressionConfig.java line 458 in com.cloudera.cmf.service.config.NotificationSuppressionConfig create() ValidationMessage.java line 47 in com.cloudera.server.web.cmf.config.ValidationMessage <init>() GroupableValidationMessage.java line 34 in com.cloudera.server.web.cmf.config.GroupableValidationMessage <init>() GenericConfigResponse.java line 295 in com.cloudera.server.web.cmf.config.GenericConfigResponse$Builder addProperties() GenericConfigHelper.java line 313 in com.cloudera.server.web.cmf.config.components.GenericConfigHelper addConfigForServiceCascaded() GenericConfigHelper.java line 275 in com.cloudera.server.web.cmf.config.components.GenericConfigHelper getConfigForService() GenericConfigController.java line 114 in com.cloudera.server.web.cmf.GenericConfigController serviceConfigPageMetadata() line -1 in sun.reflect.GeneratedMethodAccessor2402 invoke() DelegatingMethodAccessorImpl.java line 43 in sun.reflect.DelegatingMethodAccessorImpl invoke() Method.java line 606 in java.lang.reflect.Method invoke() HandlerMethodInvoker.java line 176 in org.springframework.web.bind.annotation.support.HandlerMethodInvoker invokeHandlerMethod() AnnotationMethodHandlerAdapter.java line 436 in org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter invokeHandlerMethod() AnnotationMethodHandlerAdapter.java line 424 in org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter handle() DispatcherServlet.java line 790 in org.springframework.web.servlet.DispatcherServlet doDispatch() DispatcherServlet.java line 719 in org.springframework.web.servlet.DispatcherServlet doService() FrameworkServlet.java line 669 in org.springframework.web.servlet.FrameworkServlet processRequest() FrameworkServlet.java line 574 in org.springframework.web.servlet.FrameworkServlet doGet() HttpServlet.java line 707 in javax.servlet.http.HttpServlet service() HttpServlet.java line 820 in javax.servlet.http.HttpServlet service() ServletHolder.java line 511 in org.mortbay.jetty.servlet.ServletHolder handle() ServletHandler.java line 1221 in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter() UserAgentFilter.java line 78 in org.mortbay.servlet.UserAgentFilter doFilter() GzipFilter.java line 131 in org.mortbay.servlet.GzipFilter doFilter() ServletHandler.java line 1212 in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter() JAMonServletFilter.java line 48 in com.jamonapi.http.JAMonServletFilter doFilter() ServletHandler.java line 1212 in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter() JavaMelodyFacade.java line 109 in com.cloudera.enterprise.JavaMelodyFacade$MonitoringFilter doFilter() ServletHandler.java line 1212 in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter() FilterChainProxy.java line 311 in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter() FilterSecurityInterceptor.java line 116 in org.springframework.security.web.access.intercept.FilterSecurityInterceptor invoke() FilterSecurityInterceptor.java line 83 in org.springframework.security.web.access.intercept.FilterSecurityInterceptor doFilter() FilterChainProxy.java line 323 in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter() ExceptionTranslationFilter.java line 113 in org.springframework.security.web.access.ExceptionTranslationFilter doFilter() FilterChainProxy.java line 323 in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter() SessionManagementFilter.java line 101 in org.springframework.security.web.session.SessionManagementFilter doFilter() FilterChainProxy.java line 323 in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter() AnonymousAuthenticationFilter.java line 113 in org.springframework.security.web.authentication.AnonymousAuthenticationFilter doFilter() FilterChainProxy.java line 323 in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter() RememberMeAuthenticationFilter.java line 146 in org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter doFilter() FilterChainProxy.java line 323 in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter() SecurityContextHolderAwareRequestFilter.java line 54 in org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter doFilter() FilterChainProxy.java line 323 in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter() RequestCacheAwareFilter.java line 45 in org.springframework.security.web.savedrequest.RequestCacheAwareFilter doFilter() FilterChainProxy.java line 323 in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter() AbstractAuthenticationProcessingFilter.java line 182 in org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter doFilter() FilterChainProxy.java line 323 in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter() LogoutFilter.java line 105 in org.springframework.security.web.authentication.logout.LogoutFilter doFilter() FilterChainProxy.java line 323 in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter() SecurityContextPersistenceFilter.java line 87 in org.springframework.security.web.context.SecurityContextPersistenceFilter doFilter() FilterChainProxy.java line 323 in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter() ConcurrentSessionFilter.java line 125 in org.springframework.security.web.session.ConcurrentSessionFilter doFilter() FilterChainProxy.java line 323 in org.springframework.security.web.FilterChainProxy$VirtualFilterChain doFilter() FilterChainProxy.java line 173 in org.springframework.security.web.FilterChainProxy doFilter() DelegatingFilterProxy.java line 237 in org.springframework.web.filter.DelegatingFilterProxy invokeDelegate() DelegatingFilterProxy.java line 167 in org.springframework.web.filter.DelegatingFilterProxy doFilter() ServletHandler.java line 1212 in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter() CharacterEncodingFilter.java line 88 in org.springframework.web.filter.CharacterEncodingFilter doFilterInternal() OncePerRequestFilter.java line 76 in org.springframework.web.filter.OncePerRequestFilter doFilter() ServletHandler.java line 1212 in org.mortbay.jetty.servlet.ServletHandler$CachedChain doFilter() ServletHandler.java line 399 in org.mortbay.jetty.servlet.ServletHandler handle() SecurityHandler.java line 216 in org.mortbay.jetty.security.SecurityHandler handle() SessionHandler.java line 182 in org.mortbay.jetty.servlet.SessionHandler handle() SecurityHandler.java line 216 in org.mortbay.jetty.security.SecurityHandler handle() ContextHandler.java line 767 in org.mortbay.jetty.handler.ContextHandler handle() WebAppContext.java line 450 in org.mortbay.jetty.webapp.WebAppContext handle() HandlerWrapper.java line 152 in org.mortbay.jetty.handler.HandlerWrapper handle() StatisticsHandler.java line 53 in org.mortbay.jetty.handler.StatisticsHandler handle() HandlerWrapper.java line 152 in org.mortbay.jetty.handler.HandlerWrapper handle() Server.java line 326 in org.mortbay.jetty.Server handle() HttpConnection.java line 542 in org.mortbay.jetty.HttpConnection handleRequest() HttpConnection.java line 928 in org.mortbay.jetty.HttpConnection$RequestHandler headerComplete() HttpParser.java line 549 in org.mortbay.jetty.HttpParser parseNext() HttpParser.java line 212 in org.mortbay.jetty.HttpParser parseAvailable() HttpConnection.java line 404 in org.mortbay.jetty.HttpConnection handle() SelectChannelEndPoint.java line 410 in org.mortbay.io.nio.SelectChannelEndPoint run() QueuedThreadPool.java line 582 in org.mortbay.thread.QueuedThreadPool$PoolThread run()
... View more
Labels:
- Labels:
-
Security