Header Shadow Image


Archive for March, 2019

ERROR scm-web-216:com.cloudera.cmf.model.DbCommand: Command null(clusterHostInspector) has completed. finalstate:FINISHED, success:false, msg:Can only run host inspector when host is healthy.

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

Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535.

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 […]

ERROR 1290 (HY000): The MySQL server is running with the –skip-grant-tables option so it cannot execute this statement

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 […]


     
  Copyright © 2003 - 2013 Tom Kacperski (microdevsys.com). All rights reserved.

Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 Unported License