When receiving this error, look into the worker cloudera–scm-agent to determine why.  In our case it was:   [29/Mar/2019 00:11:47 +0000] 800 MainThread agent        ERROR    Error, CM server guid updated, expected f2f1e171-d20d-4425-afe9-58b567b51397, received 18757343-bd5c-4b15-a104-91fd432ebc82 Then follow this page to resolve the above.   Thx, TK

If you are getting the following: 2019-03-21 01:04:17,021 FATAL main:org.hsqldb.cmdline.SqlFile: SQL Error at 'UTF-8' line 6: "alter table SETTINGS     add column LDAP_USER_SEARCH_BASE varchar(1024),     add column LDAP_USER_SEARCH_FILTER varchar(1024),     add column LDAP_GROUP_SEARCH_BASE varchar(1024),     add column LDAP_GROUP_SEARCH_FILTER varchar(1024)" Row size too large. The maximum row size for the used table […]

This is how to fix root password on MySQL Galera clusters if the environment doesn't let you login with your old one.  In other words, if you're getting this: ERROR 1045 (28000): Access denied for user 'root'@'mysql03.nix.mds.xyz' (using password: YES) Do the following: [root@mysql01 mysql]# [root@mysql01 mysql]#systemctl set-environment MYSQLD_OPTS="–wsrep-new-cluster –skip-grant-tables" [root@mysql01 mysql]#systemctl start mysqld [root@mysql01 […]