Support Questions

viha · ‎07-17-2019

Hi,

cloudera manager url is not opening.

This is what I have checked so far.

1. All the services are running: Mysql, Cloudera-scm-agent, Cloudera-scm-server

2.

/etc/cloudera-scm-server/db.properties

# Auto-generated by scm_prepare_database.sh on Wed Jul 10 05:13:24 EDT 2019

#

# For information describing how to configure the Cloudera Manager Server

# to connect to databases, see the "Cloudera Manager Installation Guide."

#

com.cloudera.cmf.db.type=mysql

com.cloudera.cmf.db.host=servername

com.cloudera.cmf.db.name=scm

com.cloudera.cmf.db.user=scm

com.cloudera.cmf.db.setupType=EXTERNAL

com.cloudera.cmf.db.password=password

3.

/etc/my.cnf configuration:-

[mysqld]

datadir=/var/lib/mysql

socket=/var/run/mysql/mysql.sock

transaction-isolation = READ-COMMITTED

# Disabling symbolic-links is recommended to prevent assorted security risks;

# to do so, uncomment this line:

symbolic-links = 0

key_buffer_size = 32M

max_allowed_packet = 32M

thread_stack = 256K

thread_cache_size = 64

query_cache_limit = 8M

query_cache_size = 64M

query_cache_type = 1

max_connections = 550

#expire_logs_days = 10

#max_binlog_size = 100M

#log_bin should be on a disk with enough free space.

#Replace '/var/lib/mysql/mysql_binary_log' with an appropriate path for your

#system and chown the specified folder to the mysql user.

log_bin=/var/lib/mysql/mysql_binary_log

#In later versions of MySQL, if you enable the binary log and do not set

#a server_id, MySQL will not start. The server_id must be unique within

#the replicating group.

server_id=1

binlog_format = mixed

read_buffer_size = 2M

read_rnd_buffer_size = 16M

sort_buffer_size = 8M

join_buffer_size = 8M

# InnoDB settings

innodb_file_per_table = 1

innodb_flush_log_at_trx_commit = 2

innodb_log_buffer_size = 64M

innodb_buffer_pool_size = 4G

innodb_thread_concurrency = 8

innodb_flush_method = O_DIRECT

innodb_log_file_size = 512M

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

sql_mode=STRICT_ALL_TABLES

But I found the below error after starting cloudera manager and not able to run webUI

Error log in /var/log/cloudera-scm-server/cloudera-scm-server.log:

at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.checkVersionDoFail(EntityManagerFactoryBean.java:358)

at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:172)

at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:75)

at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:178)

... 22 more

Caused by: javax.persistence.NoResultException: No entity found for query

at org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1446)

at com.cloudera.cmf.persist.DbVersionDao.getVersion(DbVersionDao.java:53)

at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getPersistedCmRelease(EntityManagerFactoryBean.java:307)

... 26 more

2019-07-16 05:04:13,522 INFO main:com.cloudera.server.cmf.Main: ================================================================================

2019-07-16 05:04:13,532 INFO main:com.cloudera.server.cmf.Main: Starting SCM Server. JVM Args: [-Dlog4j.configuration=file:/etc/cloudera-scm-server/log4j.properties, -Dfile.encoding=UTF-8, -Dcmf.root.logger=INFO,LOGFILE, -Dcmf.log.dir=/var/log/cloudera-scm-server, -Dcmf.log.file=cloudera-scm-server.log, -Dcmf.jetty.threshhold=WARN, -Dcmf.schema.dir=/opt/cloudera/cm/schema, -Djava.awt.headless=true, -Djava.net.preferIPv4Stack=true, -Dpython.home=/opt/cloudera/cm/python, -XX:+UseConcMarkSweepGC, -XX:+UseParNewGC, -XX:+HeapDumpOnOutOfMemoryError, -Xmx4G, -XX:MaxPermSize=256m, -XX:+HeapDumpOnOutOfMemoryError, -XX:HeapDumpPath=/tmp, -Dcom.cloudera.server.cmf.components.scmActive.killOnError=false, -XX:OnOutOfMemoryError=kill -9 %p], Args: [], Version: 6.2.0 (#968826 built by jenkins on 20190314-1704 git: 16bbe6211555460a860cf22d811680b35755ea81)

2019-07-16 05:04:13,725 INFO main:org.springframework.context.support.ClassPathXmlApplicationContext: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@11758f2a: startup date [Tue Jul 16 05:04:13 EDT 2019]; root of context hierarchy

2019-07-16 05:04:13,787 INFO main:org.springframework.beans.factory.xml.XmlBeanDefinitionReader: Loading XML bean definitions from class path resource [webapp/WEB-INF/spring/beanRefFactory.xml]

2019-07-16 05:04:14,199 INFO main:org.springframework.context.support.GenericApplicationContext: Refreshing org.springframework.context.support.GenericApplicationContext@671a5887: startup date [Tue Jul 16 05:04:14 EDT 2019]; root of context hierarchy

2019-07-16 05:04:14,283 INFO main:com.cloudera.enterprise.CommonMain: Reading database properties from /etc/cloudera-scm-server/db.properties

2019-07-16 05:04:14,288 INFO main:com.cloudera.enterprise.CommonMain: Statistics not enabled, c3p0 JMX disabled

2019-07-16 05:04:16,335 INFO main:com.mchange.v2.log.MLog: MLog clients using log4j logging.

2019-07-16 05:04:16,403 INFO main:com.mchange.v2.c3p0.C3P0Registry: Initializing c3p0-0.9.2.1 [built 20-March-2013 10:47:27 +0000; debug? true; trace: 10]

2019-07-16 05:04:16,474 INFO main:com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource: Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@ec455c1 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@b1ded02e [ acquireIncrement -> 3, acquireRetryAttempts -> 5, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 32imm5a31xdfks21u9iznx|5cb5bb88, idleConnectionTestPeriod -> 300, initialPoolSize -> 5, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 50, maxStatements -> 2500, maxStatementsPerConnection -> 0, minPoolSize -> 5, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@8436a9a3 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 32imm5a31xdfks21u9iznx|abff8b7, jdbcUrl -> jdbc:mysql://Servername/scm?useUnicode=true&characterEncoding=UTF-8, properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 32imm5a31xdfks21u9iznx|5fcfca62, numHelperThreads -> 3 ]

2019-07-16 05:04:19,110 INFO main:com.cloudera.enterprise.CommonMain: Statistics not enabled, JMX will not be registered

2019-07-16 05:04:19,259 INFO main:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: MYSQL database engine and table mapping: {InnoDB=[AUDITS, CONFIG_REVISIONS, CLIENT_CONFIGS, RELEASES, SERVICES, USER_SETTINGS, HOSTS_AUD, HOST_TEMPLATE_TO_ROLE_CONF_GRP, CM_PEERS, CLUSTER_ACTIVATED_RELEASES, SCHEMA_VERSION, CREDENTIALS, ROLES_AUD, PARCEL_COMPONENTS, ROLE_CONFIG_GROUPS, CLUSTERS_AUD, SERVICES_AUD, COMMAND_SCHEDULES, CONFIGS_AUD, SNAPSHOT_POLICIES, REVISIONS, CLUSTER_MANAGED_RELEASES, CONFIG_CONTAINERS, GLOBAL_SETTINGS, HOST_TEMPLATES, PARCELS, PROCESSES, CLUSTER_UNDISTRIBUTED_RELEASES, CONFIGS, USER_ROLES, ROLE_CONFIG_GROUPS_AUD, HOSTS, COMMANDS, CLUSTERS, ROLES, ROLE_CONF_GRP_TO_ROLE, CONF_REV_TO_ROLE_CONF_GRP, USERS, CM_VERSION, PROCESS_ACTIVE_RELEASES]}

2019-07-16 05:04:19,268 WARN main:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: Failed to determine prior version. This is expected if you are starting Cloudera Manager for the first time. Please also ignore any error messages about missing tables. Moving ahead assuming no upgrade: No entity found for query

2019-07-16 05:04:19,276 INFO main:com.cloudera.enterprise.dbutil.DbUtil: Schema version table already exists.

2019-07-16 05:04:19,276 INFO main:com.cloudera.enterprise.dbutil.DbUtil: DB Schema version 5002.

2019-07-16 05:04:19,279 WARN main:org.springframework.context.support.GenericApplicationContext: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.cloudera.server.cmf.TrialState': Cannot resolve reference to bean 'entityManagerFactoryBean' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactoryBean': FactoryBean threw exception on object creation; nested exception is java.lang.RuntimeException: Unable to obtain CM release version.

2019-07-16 05:04:19,279 ERROR main:com.cloudera.server.cmf.Main: Server failed.

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.cloudera.server.cmf.TrialState': Cannot resolve reference to bean 'entityManagerFactoryBean' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactoryBean': FactoryBean threw exception on object creation; nested exception is java.lang.RuntimeException: Unable to obtain CM release version.

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)

at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634)

at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:145)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1198)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1100)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:511)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:481)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:312)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:308)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)

at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)

at com.cloudera.server.cmf.Main.bootstrapSpringContext(Main.java:418)

at com.cloudera.server.cmf.Main.<init>(Main.java:260)

at com.cloudera.server.cmf.Main.main(Main.java:233)

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactoryBean': FactoryBean threw exception on object creation; nested exception is java.lang.RuntimeException: Unable to obtain CM release version.

at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:185)

at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:103)

at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1640)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:254)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)

... 17 more

Caused by: java.lang.RuntimeException: Unable to obtain CM release version.

at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getPersistedCmRelease(EntityManagerFactoryBean.java:311)

at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.checkVersionDoFail(EntityManagerFactoryBean.java:358)

at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:172)

at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:75)

at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:178)

... 22 more

Caused by: javax.persistence.NoResultException: No entity found for query

at org.hibernate.query.internal.AbstractProducedQuery.getSingleResult(AbstractProducedQuery.java:1446)

at com.cloudera.cmf.persist.DbVersionDao.getVersion(DbVersionDao.java:53)

at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getPersistedCmRelease(EntityManagerFactoryBean.java:307)

... 26 more

Thanks,

Sai Vijaya

viha · ‎07-24-2019

Hi @bgooley,

I have downgraded Mysql version10.2 to 10.0.

Now it is working fine:)

Thank you so much for your support.

Thanks,

Vijaya

View solution in original post

viha · ‎07-18-2019

Hi,

I have seen Nulls in scm database in mysql

+--------------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+

| AUDITS | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| CLIENT_CONFIGS | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:37 | NULL | NULL | utf8_general_ci | NULL | | |

| CLUSTERS | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:37 | NULL | NULL | utf8_general_ci | NULL | | |

| CLUSTERS_AUD | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| CLUSTER_ACTIVATED_RELEASES | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2019-07-17 07:03:39 | NULL | NULL | utf8_general_ci | NULL | | |

| CLUSTER_MANAGED_RELEASES | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2019-07-17 07:03:39 | NULL | NULL | utf8_general_ci | NULL | | |

| CLUSTER_UNDISTRIBUTED_RELEASES | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2019-07-17 07:03:39 | NULL | NULL | utf8_general_ci | NULL | | |

| CM_PEERS | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:37 | NULL | NULL | utf8_general_ci | NULL | | |

| CM_VERSION | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| COMMANDS | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 114688 | 0 | NULL | 2019-07-17 07:03:39 | NULL | NULL | utf8_general_ci | NULL | | |

| COMMAND_SCHEDULES | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 65536 | 0 | NULL | 2019-07-17 07:03:39 | NULL | NULL | utf8_general_ci | NULL | | |

| CONFIGS | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 81920 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| CONFIGS_AUD | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| CONFIG_CONTAINERS | InnoDB | 10 | Dynamic | 2 | 8192 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| CONFIG_REVISIONS | InnoDB | 10 | Dynamic | 2 | 8192 | 16384 | 0 | 32768 | 0 | NULL | 2019-07-17 07:03:37 | NULL | NULL | utf8_general_ci | NULL | | |

| CONF_REV_TO_ROLE_CONF_GRP | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| CREDENTIALS | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:37 | NULL | NULL | utf8_general_ci | NULL | | |

| GLOBAL_SETTINGS | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2019-07-17 07:03:39 | NULL | NULL | utf8_general_ci | NULL | | |

| HOSTS | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 49152 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| HOSTS_AUD | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| HOST_TEMPLATES | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2019-07-17 07:03:39 | NULL | NULL | utf8_general_ci | NULL | | |

| HOST_TEMPLATE_TO_ROLE_CONF_GRP | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2019-07-17 07:03:39 | NULL | NULL | utf8_general_ci | NULL | | |

| PARCELS | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| PARCEL_COMPONENTS | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:38 | NULL | NULL | utf8_general_ci | NULL | | |

| PROCESSES | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 49152 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| PROCESS_ACTIVE_RELEASES | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2019-07-17 07:03:39 | NULL | NULL | utf8_general_ci | NULL | | |

| RELEASES | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:39 | NULL | NULL | utf8_general_ci | NULL | | |

| REVISIONS | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| ROLES | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 65536 | 0 | NULL | 2019-07-17 07:03:39 | NULL | NULL | utf8_general_ci | NULL | | |

| ROLES_AUD | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| ROLE_CONFIG_GROUPS | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 49152 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| ROLE_CONFIG_GROUPS_AUD | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| ROLE_CONF_GRP_TO_ROLE | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| SCHEMA_VERSION | InnoDB | 10 | Dynamic | 1 | 16384 | 16384 | 0 | 0 | 0 | NULL | 2019-07-17 07:03:34 | 2019-07-17 07:03:40 | NULL | utf8_general_ci | NULL | | |

| SERVICES | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 49152 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| SERVICES_AUD | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| SNAPSHOT_POLICIES | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 65536 | 0 | NULL | 2019-07-17 07:03:40 | NULL | NULL | utf8_general_ci | NULL | | |

| USERS | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:37 | NULL | NULL | utf8_general_ci | NULL | | |

| USER_ROLES | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2019-07-17 07:03:37 | NULL | NULL | utf8_general_ci | NULL | | |

| USER_SETTINGS | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2019-07-17 07:03:39 | NULL | NULL | utf8_general_ci | NULL | | |

+--------------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+

Thanks,

Vijaya

bgooley · ‎07-19-2019

@viha,

If that is the first time you have started Cloudera Manager, those tables should not exist. CM, when first started, will create the necessary tables and populate them accordingly. Maybe there was an error or problem during install previously that led to the tables being created but not populated with any data? Seems like we are in a strange state either way.

I would recommend starting over with an empty database and then try starting CM.

The exception you get indicates that the VERSION column (in CM_VERSION table) value is "null".

That should not be possible, so startup fails.

viha · ‎07-24-2019

Hi @bgooley,

I have downgraded Mysql version10.2 to 10.0.

Now it is working fine:)

Thank you so much for your support.

Thanks,

Vijaya

Cloudera Community

Support Questions

Cloudera manager url is not opening in cloudera 6.2