Member since
03-14-2016
4721
Posts
1111
Kudos Received
874
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2438 | 04-27-2020 03:48 AM | |
4870 | 04-26-2020 06:18 PM | |
3973 | 04-26-2020 06:05 PM | |
3212 | 04-13-2020 08:53 PM | |
4907 | 03-31-2020 02:10 AM |
02-17-2017
04:51 AM
@Manish Anand
Start ambari-server and then you should be able to now, login to ambari and then setup cluster.
... View more
02-17-2017
04:38 AM
1 Kudo
@Manish Anand In MySQL also you will have no data ... because you do not have a dump. (Hence using MySQL / Postgres both are same in this scenario) The current cluster information is anyway lost due to postgres table/db corruption. In this case you can try running the following command to reset postgres ambari DB (it will clear all previous data) ambari-server reset .
... View more
02-17-2017
04:02 AM
@Manish Anand Also please see if you can recreate the index on metainfo table. Something like described in: http://stackoverflow.com/questions/6895736/error-could-not-read-block-4707-of-relation-1663-16384-16564-success
... View more
02-17-2017
03:59 AM
@Manish Anand
Without having an earlier DB dump it is hard to recover the DB. However it is good that we isolated that the issue is actually with the "Postgres", Not with ambari. Postgres forums might have some quick workarounds for such corruption scenarios to fix the DB. From Ambari side i do not think we have much to do. If your cluster is just a test cluster (with minimal configuration) then may be you can do recreate fresh cluster. Or if you have any other cluster at your end then may be you can try recovering the entries on "metainfo" (it might help if only the "metainfo" table is corrupted) I will share if i find something from Postgres side.
... View more
02-17-2017
03:42 AM
@Manish Anand
Some default values you can find from the SQL files like: # grep -A3 'INSERT INTO metainfo' /var/lib/ambari-server/resources/Ambari-DDL-Postgres-CREATE.sql
INSERT INTO metainfo(metainfo_key, metainfo_value) VALUES
('version','2.4.2');
COMMIT; . However i till believe that there is a Database Corruption based on the error message "could not read block 0 of relation base/16384/16953: read only". So i guess even if you restore that particular table still you will be facing the same issue, As "metainfo" is one of the first table that ambari looks at during the start.... so later you might find the same issue with other tables as well. I will suggest if you have any prior DB dump then try to recover it. - My "metainfo" table entry might not help... but sharing to show how it looks like normally: .
... View more
02-17-2017
01:09 AM
@Manish Anand
"metainfo" table should contain the ambari version and the HDP/HDP-UTIL repository informations. In your case it seems to be missing. But the error "ERROR: could not read block 0 of relation base/16384/16953: read only 0 of 8192 bytes Error Code:" indicates more of a Database issue, Not directly related to ambari. If it is a test system then may be you should try to recover any old ambari DB dump if you already have it. .
... View more
02-17-2017
12:32 AM
2 Kudos
@Junior The Path seems to be incorrect isn't it? 'user/root/pig_demo.txt'
OR
'/user/root/pig_demo.txt'
... View more
02-16-2017
08:57 AM
@rahul gulati Can you please share the error that you are getting while it is failing to write content in hdfs?
... View more
02-16-2017
08:43 AM
@rahul gulati
Have you changed the permission/ownership as well of the directory "/user/admin" ? sudo -u hdfs hdfs dfs -mkdir /user/admin
sudo -u hdfs hdfs dfs -chown admin:hadoop /user/admin
.
... View more
02-16-2017
06:33 AM
@rahul gulati Local/Remote cluster configuration can be done at the View Level. As mentioned in : https://docs.hortonworks.com/HDPDocuments/Ambari-2.4.0.0/bk_ambari-administration/content/registering_remote_clusters.html - Once a remote cluster is configured then you can create view instances to use that remote cluster like: "manage ambari" --> View ---> File --> Create instance. . As in the above image you can see that i am using "ErieClusterRemote" a remote cluster for my file View. By default the default view instance uses "Local Cluster".
... View more