question Registry Schema failing right after starton HDF3.3 in Support Questions

question Registry Schema failing right after starton HDF3.3 in Support Questions https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236260#M198073 <P>I have installed a an HDF v3.3 cluster. everything seems to be working fine except Schema Registry which starts fine but then shuts down immediately giving the following errors:</P><P><BR /></P><P>The mysql drivers have been loaded fine in ambari and work for all other modules.</P><P><BR /></P><PRE> </PRE><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>Any ideas?</P><P>I</P> Tue, 21 Apr 2026 11:38:02 GMT shqiperih 2026-04-21T11:38:02Z Registry Schema failing right after starton HDF3.3 https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236260#M198073 <P>I have installed a an HDF v3.3 cluster. everything seems to be working fine except Schema Registry which starts fine but then shuts down immediately giving the following errors:</P><P><BR /></P><P>The mysql drivers have been loaded fine in ambari and work for all other modules.</P><P><BR /></P><PRE> </PRE><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141)</P><P> at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146)</P><P> at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113)</P><P> at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49)</P><P> at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79)</P><P> at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45)</P><P> at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66)</P><P> at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43)</P><P> at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85)</P><P> at io.dropwizard.cli.Cli.run(Cli.java:75)</P><P> at io.dropwizard.Application.run(Application.java:93)</P><P> at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297)</P><P>Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource</P><P> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)</P><P> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)</P><P> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)</P><P> at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126)</P><P> ... 18 more</P><P>Any ideas?</P><P>I</P> Tue, 21 Apr 2026 11:38:02 GMT https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236260#M198073 shqiperih 2026-04-21T11:38:02Z Re: Registry Schema failing right after starton HDF3.3 https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236261#M198074 <P><A rel="noopener noreferrer noopener noreferrer noopener noreferrer noopener noreferrer" href="http://lorenc%20hysi/" target="_blank"><EM>@Lorenc Hysi</EM></A><EM> </EM></P><P><EM>Looks like you back end database could be the cause.</EM></P><PRE><EM>################################################# </EM> <EM># Create  Schema Registry and SAM metastore: </EM> <EM>################################################## </EM> <EM>mysql -u root -p{root_password} create database registry; </EM> <EM>create database streamline; CREATE USER 'registry'@'%' IDENTIFIED BY 'registry'; </EM> <EM>CREATE USER 'streamline'@'%' IDENTIFIED BY 'streamline'; </EM> <EM>GRANT ALL PRIVILEGES ON registry.* TO 'registry'@'%' WITH GRANT OPTION ; </EM> <EM>GRANT ALL PRIVILEGES ON streamline.* TO 'streamline'@'%' WITH GRANT OPTION ; </EM> <EM>commit; </EM> <EM>exit; </EM> <EM>################################################# </EM> <EM># Test connection  </EM> <EM>################################################## </EM> <EM>mysql -u streamline -pstreamline;</EM> <EM>mysql -u registry -pregistry;</EM></PRE><P><EM><BR /></EM></P><P><EM>The above should succeed</EM></P><P><EM>It doesn't cost you a thing rerun the below to redeploy the jdbc jars</EM></P><PRE><EM>ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar           </EM></PRE> Fri, 22 Mar 2019 05:02:37 GMT https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236261#M198074 Shelton 2019-03-22T05:02:37Z Re: Registry Schema failing right after starton HDF3.3 https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236262#M198075 <P>I did all the steps above but still the same errors persists and i cannot start schema registry. I even moved the schema registry to the same server as the database but still issues. </P><P>I also tried to pick the option to let ambari create the user and database for registry during install. Ambari is able to create the user and database, but the issue still persists. </P><P><BR /></P><P>Is there any other way to force shcema registry to recognize the com.mysql.jdbc.jdbc2.optional.MysqlDataSource jar? This to me looks more like an issue with variables not being properly passed but i am not sure.</P> Thu, 28 Mar 2019 00:53:39 GMT https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236262#M198075 shqiperih 2019-03-28T00:53:39Z Re: Registry Schema failing right after starton HDF3.3 https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236263#M198076 <P>Ok i was able to start shcema_registry manually by first including the mysql conenctor jar in the classpath variable:</P><P>export CLASSPATH=/usr/share/java/mysql-connector-java.jar:$CLASSPATH</P><P><BR /></P><P>To make this persistent you can enter the abo command in the "registry-env template" under the advanced config of the schema_registry service in ambari.</P><P><BR /></P><P>It would be nice to figure out and fix why this variable does not get set automatically. </P> Thu, 28 Mar 2019 01:14:05 GMT https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/236263#M198076 shqiperih 2019-03-28T01:14:05Z Re: Registry Schema failing right after starton HDF3.3 https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/304059#M221860 <P>From what I've investigated, it may be due to the version of the mysql-connector-java.</P><P>The class com.mysql.jdbc.jdbc2.optional.MysqlDataSource is present in version 5 and the one that I have installed is the 8.</P><P>I tried installing explicitly the version 5 but I got different errors.</P><P>What I've done and got it working is changing that class to the one available in version 8, which is com.mysql.cj.jdbc.MysqlXADataSource.</P><P> </P><P>For Schema Registry you have to modify 2 files:</P><UL><LI>/var/lib/ambari-server/resources/mpacks/hdf-ambari-mpack-3.4.1.1-4/common-services/REGISTRY/0.3.0/package/scripts/params.py</LI><LI>/var/lib/ambari-agent/cache/common-services/REGISTRY/0.3.0/package/scripts/params.py</LI></UL><P>There change the variable registry_storage_java_class to the value com.mysql.cj.jdbc.MysqlXADataSource</P><P>Note: the variable should appear twice.</P><P> </P><P>The same for Streaming Analytics, you have to modify 2 files. This time:</P><UL><LI>/var/lib/ambari-server/resources/mpacks/hdf-ambari-mpack-3.4.1.1-4/common-services/STREAMLINE/0.5.0/package/scripts/params.py</LI><LI>/var/lib/ambari-agent/cache/common-services/STREAMLINE/0.5.0/package/scripts/params.py</LI></UL><P>There change the variable streamline_storage_java_class also to the value com.mysql.cj.jdbc.MysqlXADataSource</P><P> </P><P>You should then be able to start the services.</P><P>I just solved this, so I'm not aware if any other errors will show up by using these services.</P> Thu, 08 Oct 2020 06:00:14 GMT https://community.cloudera.com/t5/Support-Questions/Registry-Schema-failing-right-after-starton-HDF3-3/m-p/304059#M221860 pboffino 2020-10-08T06:00:14Z