If you are facing issue Clock offset issue then there will be problem with your ntp is not in sync.   To resolve follow some commands   Check in which host it is giving problem go under that host through CLI and   1. systemctl status ntpd.service (For checking the status, if its not working the it showing Inactive message)   2. route -n copy the ntp server ip address (You will find under Destination column)    3. ntpdate <ntp server ip address>   4. systemctl start ntpd.service (for starting & syncing your host, after firing wait for sometime)   5. ntpstat (for checking whether it is synchronized or not it should be in synchronized)   after performing above steps your Clock offset issue will get resolved.   Regard,   ... View more

If you're in doubt how to do scm database operations: cd /var/lib/cloudera-scm-server-db/data/ export PGPASSWORD=`head -1 generated_password.txt` sudo -Eu cloudera-scm psql -p 7432 scm scm=# delete from process_active_releases; scm=# delete from processes; ... View more