My Oracle Support Banner

After Migrating Node 3, with Activity Monitor Role, the Activity Monitor Fails to Start with MySQLSyntaxErrorException on the New/Migrated Node (Doc ID 2530478.1)

Last updated on NOVEMBER 08, 2019

Applies to:

Big Data Appliance Integrated Software - Version 4.11.0 to 4.12.0 [Release 4.10]
Linux x86-64

Symptoms

After migrating Node 3, with Activity Monitor role, the Activity Monitor fails to start with MySQLSyntaxErrorException on the new/migrated node.

The Activity Monitor log on the migrated host, /var/log/cloudera-scm-firehose/mgmt-cmf-mgmt-ACTIVITYMONITOR-<HOSTNAME>.<DOMAIN>.log.out, reports a MySQLSyntaxErrorException exception due to a missing table as below:

mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'activity_monitor.CMON_LL_TIME_SERIES_ATTRIBUTE' doesn't exist

The full stack shows:

<TIMESTAMP> FATAL org.hsqldb.cmdline.SqlFile: SQL Error at 'UTF-8' line 4:
"update CMON_LL_TIME_SERIES_ATTRIBUTE
set VALUE='REPORTSMANAGER'
where ATTR_key=BUNDLE-REDACTED and VALUE='RESOURCEMANAGER'"
Table 'activity_monitor.CMON_LL_TIME_SERIES_ATTRIBUTE' doesn't exist
<TIMESTAMP> FATAL org.hsqldb.cmdline.SqlFile: Rolling back SQL transaction.
<TIMESTAMP> ERROR com.cloudera.enterprise.dbutil.SqlFileRunner: Exception while executing ddl scripts.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'activity_monitor.CMON_LL_TIME_SERIES_ATTRIBUTE' doesn't exist
...
<TIMESTAMP> ERROR com.cloudera.cmon.FhDatabaseManager: Unable to upgrade schema to latest version.
java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'activity_monitor.CMON_LL_TIME_SERIES_ATTRIBUTE' doesn't exist
...
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'activity_monitor.CMON_LL_TIME_SERIES_ATTRIBUTE' doesn't exist

 

Checking the MySQL database on the migrated node shows that the activity_monitor table, CMON_LL_TIME_SERIES_ATTRIBUTE, does not exist, although it should. 

  

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.