Support Questions

Find answers, ask questions, and share your expertise

how to resolve the DB configs consistency check failed

avatar

hi all

we have a problem to start the ambari server

we try to start the ambari server after removing some services from ambari

for now we get the error as

DB configs consistency check failed. Run "ambari-server start --skip-database-check" to skip. You may try --auto-fix-database flag to attempt to fix issues automatically. If you use this "--skip-database-check" option, do not make any changes to your cluster topology or perform a cluster upgrade until you correct the database consistency issues. See /var/log/ambari-server/ambari-server-check-database.log for more details on the consistency issues.
ERROR: Exiting with exit code -1.
REASON: Ambari Server java process has stopped. Please check the logs for more information.
You have mail in 

we try also the flag --auto-fix-database ( but not help )

[root@master ~]# ambari-server restart
Using python  /usr/bin/python
Restarting ambari-server
Waiting for server stop...
Ambari Server stopped
Ambari Server running with administrator privileges.
Organizing resource files at /var/lib/ambari-server/resources...
Ambari database consistency check started...
Server PID at: /var/run/ambari-server/ambari-server.pid
Server out at: /var/log/ambari-server/ambari-server.out
Server log at: /var/log/ambari-server/ambari-server.log
Waiting for server start............
DB configs consistency check failed. Run "ambari-server start --skip-database-check" to skip. You may try --auto-fix-database flag to attempt to fix issues automatically. If you use this "--skip-database-check" option, do not make any changes to your cluster topology or perform a cluster upgrade until you correct the database consistency issues. See /var/log/ambari-server/ambari-server-check-database.log for more details on the consistency issues.
ERROR: Exiting with exit code -1.
REASON: Ambari Server java process has stopped. Please check the logs for more information.
You have mail in /var/spool/mail/root




[root@master ~]# ambari-server restart --auto-fix-database
Using python  /usr/bin/python
Restarting ambari-server
Ambari Server is not running
Ambari Server running with administrator privileges.
Organizing resource files at /var/lib/ambari-server/resources...
Ambari database consistency check started...
Server PID at: /var/run/ambari-server/ambari-server.pid
Server out at: /var/log/ambari-server/ambari-server.out
Server log at: /var/log/ambari-server/ambari-server.log
Waiting for server start............
DB configs consistency check failed. Run "ambari-server start --skip-database-check" to skip. You may try --auto-fix-database flag to attempt to fix issues automatically. If you use this "--skip-database-check" option, do not make any changes to your cluster topology or perform a cluster upgrade until you correct the database consistency issues. See /var/log/ambari-server/ambari-server-check-database.log for more details on the consistency issues.
ERROR: Exiting with exit code -1.
REASON: Ambari Server java process has stopped. Please check the logs for more information.




[root@master ~]# ambari-server start --skip-database-check
Using python  /usr/bin/python
Starting ambari-server
Ambari Server running with administrator privileges.
Organizing resource files at /var/lib/ambari-server/resources...
Ambari Server is starting with the database consistency check skipped. Do not make any changes to your cluster topology or perform a cluster upgrade until you correct the database consistency issues. See "/var/log/ambari-server/ambari-server-check-database.log" for more details on the consistency issues.
Server PID at: /var/run/ambari-server/ambari-server.pid
Server out at: /var/log/ambari-server/ambari-server.out
Server log at: /var/log/ambari-server/ambari-server.log
Waiting for server start.........................
Server started listening on 8080
Ambari Server 'start' completed successfully.

and finally we not have choice and we start the ambari with skip --database check

ambari-server start --skip-database-check

so what the steps that neded in order to fix this isshue ?

Michael-Bronson
1 ACCEPTED SOLUTION

avatar

Hi @Michael Bronson ,

refer to this article : https://community.hortonworks.com/articles/227486/how-to-fix-database-consistency-warnings-in-ambari...

The solution given here is irrespective of any config, it will work 100% for your DB warning too.

its taking backup of your orphaned configs and making the value mapped=1.

Please let me know if it doesnt work.

You can take backup if you are afraid to do so.

View solution in original post

11 REPLIES 11

avatar
Master Mentor

@Michael Bronson

Do you remember the components you removed?

avatar

yes they are:

MOON_SERVICE
JWE_SER
GFT_SER
Michael-Bronson