My Oracle Support Banner

On BDA V4.4/CDH 5.5.1 the Service Monitor Will Not Start in Cloudera Manager-Fails with "MySQLSyntaxErrorException: Unknown database 'service_monitor'" (Doc ID 2215220.1)

Last updated on DECEMBER 16, 2016

Applies to:

Big Data Appliance Integrated Software - Version 4.4.0 and later
Linux x86-64


On BDA V4.4/CDH 5.5.1 the Service Monitor will not start in Cloudera Manager. It fails with "MySQLSyntaxErrorException: Unknown database 'service_monitor'":

1. The Service Monitor log file: shows:

2016-12-13 11:32:51,925 WARN com.mchange.v2.resourcepool.BasicResourcePool: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@31e3c910 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'service_monitor'
at sun.reflect.GeneratedConstructorAccessor33.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
at java.lang.reflect.Constructor.newInstance(
at com.mysql.jdbc.Util.handleNewInstance(
at com.mysql.jdbc.Util.getInstance(
at com.mysql.jdbc.SQLError.createSQLException(
at com.mysql.jdbc.MysqlIO.checkErrorPacket(
at com.mysql.jdbc.MysqlIO.checkErrorPacket(
at com.mysql.jdbc.MysqlIO.checkErrorPacket(
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(
at com.mysql.jdbc.MysqlIO.doHandshake(
at com.mysql.jdbc.ConnectionImpl.coreConnect(
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(
at com.mysql.jdbc.ConnectionImpl.createNewIO(
at com.mysql.jdbc.ConnectionImpl.(
at com.mysql.jdbc.JDBC4Connection.(

From this is looks like the Service Monitor is not starting up because the backend database in MySQL is missing.

2. A dump of the MySQL database shows that the service_monitor database is missing.


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

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