https://community.cloudera.com/t5/Archives-of-Support-Questions/Ambari-2-1-2-null-pointer-exception-after-deleting-a-node/m-p/116528#M16862 <P>Hi,</P><P>wired situation...while deleting a node from HDP-cluster I received a popup from Ambari with a very long error message.</P><P>But the node has been deleted, at least it disappeared from the node list.</P><P>Unfortunately now Ambari (MySQL as backend) is no longer working, it is hanging in the "Loading" state and nothing happens further.</P><P>Here is an excerpt from Ambari-server log of the time of deleting the node:</P><PRE>28 Jan 2016 20:14:53,448 INFO [qtp-client-1030] ServiceComponentImpl:626 - Deleting servicecomponenthost for cluster, clusterName=hdpprd, serviceName=SPARK, componentName=SPARK_CLIENT, hostname=b0d0b7k2.com 28 Jan 2016 20:14:53,488 INFO [qtp-client-1030] ServiceComponentImpl:626 - Deleting servicecomponenthost for cluster, clusterName=hdpprd, serviceName=SQOOP, componentName=SQOOP, hostname=b0d0b7k2.com 28 Jan 2016 20:14:53,520 INFO [qtp-client-1030] ServiceComponentImpl:626 - Deleting servicecomponenthost for cluster, clusterName=hdpprd, serviceName=TEZ, componentName=TEZ_CLIENT, hostname=b0d0b7k2.com 28 Jan 2016 20:14:53,840 INFO [qtp-client-1030] ServiceComponentImpl:626 - Deleting servicecomponenthost for cluster, clusterName=hdpprd, serviceName=ZOOKEEPER, componentName=ZOOKEEPER_CLIENT, hostname=b0d0b7k2.com 28 Jan 2016 20:14:53,879 INFO [qtp-client-1030] ServiceComponentImpl:626 - Deleting servicecomponenthost for cluster, clusterName=hdpprd, serviceName=PIG, componentName=PIG, hostname=b0d0b7k2.com 28 Jan 2016 20:14:56,916 INFO [qtp-client-1030] ServiceComponentImpl:626 - Deleting servicecomponenthost for cluster, clusterName=hdpprd, serviceName=YARN, componentName=YARN_CLIENT, hostname=b0d0b7k2.com 28 Jan 2016 20:14:56,920 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd/hosts/b0d0b7k2.com/host_components/YARN_CLIENT java.lang.NullPointerException at org.apache.ambari.server.state.svccomphost.ServiceComponentHostImpl.getStateEntity(ServiceComponentHostImpl.java:1644) at org.apache.ambari.server.state.svccomphost.ServiceComponentHostImpl.removeEntities(ServiceComponentHostImpl.java:1411) at org.apache.ambari.server.orm.AmbariJpaLocalTxnInterceptor.invoke(AmbariJpaLocalTxnInterceptor.java:68)</PRE><P>...</P><P>Here is the current log output from ambari-server after I tried to login (this messages are repeating):</P><PRE>28 Jan 2016 20:14:57,381 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd/hosts java.lang.NullPointerException at org.apache.ambari.server.state.svccomphost.ServiceComponentHostImpl.getStateEntity(ServiceComponentHostImpl.java:1644) ... 28 Jan 2016 20:14:57,413 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException at org.apache.ambari.server.state.svccomphost.ServiceComponentHostImpl.getStateEntity(ServiceComponentHostImpl.java:1644) ... 28 Jan 2016 20:14:57,900 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters java.lang.NullPointerException28 Jan 2016 20:14:59,310 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException at org.apache.ambari.server.state.svccomphost.ServiceComponentHostImpl.getStateEntity(ServiceComponentHostImpl.java:1644) ... 28 Jan 2016 20:15:18,873 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException 28 Jan 2016 20:15:18,874 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd/ java.lang.NullPointerException 28 Jan 2016 20:15:19,029 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException 28 Jan 2016 20:15:19,030 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd/hosts/b0d02ef2.ldc.uk.zurich.com java.lang.NullPointerException 28 Jan 2016 20:15:19,054 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException 28 Jan 2016 20:15:19,056 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd java.lang.NullPointerException 28 Jan 2016 20:15:19,079 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException 28 Jan 2016 20:15:19,081 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd java.lang.NullPointerException 28 Jan 2016 20:15:19,090 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException 28 Jan 2016 20:15:19,092 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd/hosts java.lang.NullPointerException 28 Jan 2016 20:15:19,279 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException 28 Jan 2016 20:15:19,280 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd/hosts java.lang.NullPointerException 28 Jan 2016 20:15:19,644 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException</PRE><P>Is there something to check directly in MySQL db?!?!</P><P>Any hints highly appreciated, Ambari is highly requested to proceed working on that cluster <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>Thanks in advance...</P> Fri, 29 Jan 2016 03:43:15 GMT geko 2016-01-29T03:43:15Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Ambari-2-1-2-null-pointer-exception-after-deleting-a-node/m-p/116528#M16862 <P>Hi,</P><P>wired situation...while deleting a node from HDP-cluster I received a popup from Ambari with a very long error message.</P><P>But the node has been deleted, at least it disappeared from the node list.</P><P>Unfortunately now Ambari (MySQL as backend) is no longer working, it is hanging in the "Loading" state and nothing happens further.</P><P>Here is an excerpt from Ambari-server log of the time of deleting the node:</P><PRE>28 Jan 2016 20:14:53,448 INFO [qtp-client-1030] ServiceComponentImpl:626 - Deleting servicecomponenthost for cluster, clusterName=hdpprd, serviceName=SPARK, componentName=SPARK_CLIENT, hostname=b0d0b7k2.com 28 Jan 2016 20:14:53,488 INFO [qtp-client-1030] ServiceComponentImpl:626 - Deleting servicecomponenthost for cluster, clusterName=hdpprd, serviceName=SQOOP, componentName=SQOOP, hostname=b0d0b7k2.com 28 Jan 2016 20:14:53,520 INFO [qtp-client-1030] ServiceComponentImpl:626 - Deleting servicecomponenthost for cluster, clusterName=hdpprd, serviceName=TEZ, componentName=TEZ_CLIENT, hostname=b0d0b7k2.com 28 Jan 2016 20:14:53,840 INFO [qtp-client-1030] ServiceComponentImpl:626 - Deleting servicecomponenthost for cluster, clusterName=hdpprd, serviceName=ZOOKEEPER, componentName=ZOOKEEPER_CLIENT, hostname=b0d0b7k2.com 28 Jan 2016 20:14:53,879 INFO [qtp-client-1030] ServiceComponentImpl:626 - Deleting servicecomponenthost for cluster, clusterName=hdpprd, serviceName=PIG, componentName=PIG, hostname=b0d0b7k2.com 28 Jan 2016 20:14:56,916 INFO [qtp-client-1030] ServiceComponentImpl:626 - Deleting servicecomponenthost for cluster, clusterName=hdpprd, serviceName=YARN, componentName=YARN_CLIENT, hostname=b0d0b7k2.com 28 Jan 2016 20:14:56,920 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd/hosts/b0d0b7k2.com/host_components/YARN_CLIENT java.lang.NullPointerException at org.apache.ambari.server.state.svccomphost.ServiceComponentHostImpl.getStateEntity(ServiceComponentHostImpl.java:1644) at org.apache.ambari.server.state.svccomphost.ServiceComponentHostImpl.removeEntities(ServiceComponentHostImpl.java:1411) at org.apache.ambari.server.orm.AmbariJpaLocalTxnInterceptor.invoke(AmbariJpaLocalTxnInterceptor.java:68)</PRE><P>...</P><P>Here is the current log output from ambari-server after I tried to login (this messages are repeating):</P><PRE>28 Jan 2016 20:14:57,381 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd/hosts java.lang.NullPointerException at org.apache.ambari.server.state.svccomphost.ServiceComponentHostImpl.getStateEntity(ServiceComponentHostImpl.java:1644) ... 28 Jan 2016 20:14:57,413 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException at org.apache.ambari.server.state.svccomphost.ServiceComponentHostImpl.getStateEntity(ServiceComponentHostImpl.java:1644) ... 28 Jan 2016 20:14:57,900 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters java.lang.NullPointerException28 Jan 2016 20:14:59,310 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException at org.apache.ambari.server.state.svccomphost.ServiceComponentHostImpl.getStateEntity(ServiceComponentHostImpl.java:1644) ... 28 Jan 2016 20:15:18,873 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException 28 Jan 2016 20:15:18,874 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd/ java.lang.NullPointerException 28 Jan 2016 20:15:19,029 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException 28 Jan 2016 20:15:19,030 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd/hosts/b0d02ef2.ldc.uk.zurich.com java.lang.NullPointerException 28 Jan 2016 20:15:19,054 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException 28 Jan 2016 20:15:19,056 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd java.lang.NullPointerException 28 Jan 2016 20:15:19,079 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException 28 Jan 2016 20:15:19,081 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd java.lang.NullPointerException 28 Jan 2016 20:15:19,090 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException 28 Jan 2016 20:15:19,092 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd/hosts java.lang.NullPointerException 28 Jan 2016 20:15:19,279 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException 28 Jan 2016 20:15:19,280 WARN [qtp-client-1030] ServletHandler:563 - /api/v1/clusters/hdpprd/hosts java.lang.NullPointerException 28 Jan 2016 20:15:19,644 ERROR [qtp-client-1030] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException</PRE><P>Is there something to check directly in MySQL db?!?!</P><P>Any hints highly appreciated, Ambari is highly requested to proceed working on that cluster <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>Thanks in advance...</P> Fri, 29 Jan 2016 03:43:15 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Ambari-2-1-2-null-pointer-exception-after-deleting-a-node/m-p/116528#M16862 geko 2016-01-29T03:43:15Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Ambari-2-1-2-null-pointer-exception-after-deleting-a-node/m-p/116529#M16863 <P>This is the error after providing credentials to login</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1631-after-login.png" style="width: 584px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/23048i4F1D76A9B5B3E98B/image-size/medium?v=v2&amp;px=400" role="button" title="1631-after-login.png" alt="1631-after-login.png" /></span></P> Mon, 19 Aug 2019 10:54:04 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Ambari-2-1-2-null-pointer-exception-after-deleting-a-node/m-p/116529#M16863 geko 2019-08-19T10:54:04Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Ambari-2-1-2-null-pointer-exception-after-deleting-a-node/m-p/116530#M16864 <A rel="user" href="https://community.cloudera.com/users/1198/koenigbodensee.html" nodeid="1198">@Gerd Koenig</A><P> You should open support ticket. </P><P>Restart ambari server and check if it helps.</P> Fri, 29 Jan 2016 04:06:25 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Ambari-2-1-2-null-pointer-exception-after-deleting-a-node/m-p/116530#M16864 nsabharwal 2016-01-29T04:06:25Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Ambari-2-1-2-null-pointer-exception-after-deleting-a-node/m-p/116531#M16865 <P>Hi <A rel="user" href="https://community.cloudera.com/users/140/nsabharwal.html" nodeid="140">@Neeraj Sabharwal</A> ,</P><P>thanks...a restart brought back Ambari into life.....right after opening a ticket <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> Fri, 29 Jan 2016 04:25:57 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Ambari-2-1-2-null-pointer-exception-after-deleting-a-node/m-p/116531#M16865 geko 2016-01-29T04:25:57Z