@Ted Yu Hi Ted. Thank you for your reply. When i provided the StartRow with the suitable information, i can retrieve data in less than 2 seconds. Thank you very much. ... View more

@mqureshi Thank you for this answer. I'm using a VPN to access the cluster. But the query returns only 312 rows. I executed the same application this morning while my PC was in our LAN and got the same duration. So i think there should be something else i'm missing. ... View more

I finally solved the issue by traking the taskID 30170 in the ambari DB. I found that there is an inconsistancy due to the DB crash. The tables "execution_command" and "host_role_command" were those containing the reference to this taskID while the table "task" has no reference to it. These twotables were those i repaired after the DB crashed. After cleaning up these tables i was able to restart all services. But to avoid any other related problem that could occur later, i restored an older ambari DB as @Artem Ervits suggested. Now all services are running fine. Thank you all for your help. ... View more

@Sunile Manjee Yes the ambari-server.log file contains a lot of information. Among them, some tables crashed and needed to be repaired. That is what i did first. After taht i'm seeing this java error: 15 Jul 2016 20:11:34,776 WARN [ambari-action-scheduler] ActionScheduler:200 - Exception received java.lang.RuntimeException: Invalid DB state, broken one-to-one relation for taskId=30710 at org.apache.ambari.server.actionmanager.HostRoleCommand.getExecutionCommandWrapper(HostRoleCommand.java:371) at org.apache.ambari.server.actionmanager.Stage.loadExecutionCommandWrappers(Stage.java:216) at org.apache.ambari.server.actionmanager.Stage.checkWrappersLoaded(Stage.java:203) at org.apache.ambari.server.actionmanager.Stage.getExecutionCommands(Stage.java:595) at org.apache.ambari.server.actionmanager.ActionScheduler.isStageHasBackgroundCommandsOnly(ActionScheduler.java:529) at org.apache.ambari.server.actionmanager.ActionScheduler.filterParallelPerHostStages(ActionScheduler.java:485) at org.apache.ambari.server.actionmanager.ActionScheduler.doWork(ActionScheduler.java:251) at org.apache.ambari.server.actionmanager.ActionScheduler.run(ActionScheduler.java:195) at java.lang.Thread.run(Thread.java:745) ... View more

Thank you Deepak. I mean the configuration database was on a small partition disk which got full. So mysql shut down. We made a cleanup and restarted mysql and the Ambani server. After that nothing works normally. ... View more

Thank you Deepak. I mean the configuration database was on a small partition disk which got full. So mysql shut down. We made a cleanup and restarted mysql and the Ambani server. After that nothing works normally. ... View more