Member since
01-18-2018
11
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1563 | 03-27-2019 06:14 PM |
03-27-2019
06:14 PM
Ok i was able to start shcema_registry manually by first including the mysql conenctor jar in the classpath variable: export CLASSPATH=/usr/share/java/mysql-connector-java.jar:$CLASSPATH 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. It would be nice to figure out and fix why this variable does not get set automatically.
... View more
03-27-2019
05:53 PM
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. 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. 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.
... View more
03-21-2019
02:08 PM
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: The mysql drivers have been loaded fine in ambari and work for all other modules.
java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141) at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78) at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49) at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38) at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79) at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45) at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240) at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268) at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184) at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80) at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66) at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43) at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85) at io.dropwizard.cli.Cli.run(Cli.java:75) at io.dropwizard.Application.run(Application.java:93) at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297) Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126) ... 18 more java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141) at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78) at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49) at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38) at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79) at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45) at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240) at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268) at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184) at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80) at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66) at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43) at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85) at io.dropwizard.cli.Cli.run(Cli.java:75) at io.dropwizard.Application.run(Application.java:93) at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297) Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126) ... 18 more java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141) at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78) at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49) at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38) at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79) at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45) at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240) at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268) at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184) at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80) at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66) at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43) at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85) at io.dropwizard.cli.Cli.run(Cli.java:75) at io.dropwizard.Application.run(Application.java:93) at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297) Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126) ... 18 more java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141) at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78) at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49) at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38) at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79) at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45) at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240) at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268) at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184) at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80) at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66) at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43) at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85) at io.dropwizard.cli.Cli.run(Cli.java:75) at io.dropwizard.Application.run(Application.java:93) at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297) Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126) ... 18 more java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141) at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78) at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49) at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38) at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79) at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45) at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240) at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268) at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184) at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80) at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66) at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43) at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85) at io.dropwizard.cli.Cli.run(Cli.java:75) at io.dropwizard.Application.run(Application.java:93) at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297) Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126) ... 18 more java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141) at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78) at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49) at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38) at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79) at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45) at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240) at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268) at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184) at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80) at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66) at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43) at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85) at io.dropwizard.cli.Cli.run(Cli.java:75) at io.dropwizard.Application.run(Application.java:93) at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297) Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126) ... 18 more java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:141) at com.zaxxer.hikari.util.PoolUtilities.initializeDataSource(PoolUtilities.java:153) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:146) at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:113) at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:78) at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.prepare(HikariCPConnectionBuilder.java:49) at com.hortonworks.registries.storage.impl.jdbc.connection.HikariCPConnectionBuilder.<init>(HikariCPConnectionBuilder.java:38) at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.getHikariCPConnnectionBuilder(QueryExecutorFactory.java:79) at com.hortonworks.registries.storage.impl.jdbc.provider.QueryExecutorFactory.get(QueryExecutorFactory.java:45) at com.hortonworks.registries.storage.impl.jdbc.JdbcStorageManager.init(JdbcStorageManager.java:240) at com.hortonworks.registries.webservice.RegistryApplication.getStorageManager(RegistryApplication.java:268) at com.hortonworks.registries.webservice.RegistryApplication.registerResources(RegistryApplication.java:184) at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:80) at com.hortonworks.registries.webservice.RegistryApplication.run(RegistryApplication.java:66) at io.dropwizard.cli.EnvironmentCommand.run(EnvironmentCommand.java:43) at io.dropwizard.cli.ConfiguredCommand.run(ConfiguredCommand.java:85) at io.dropwizard.cli.Cli.run(Cli.java:75) at io.dropwizard.Application.run(Application.java:93) at com.hortonworks.registries.webservice.RegistryApplication.main(RegistryApplication.java:297) Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.jdbc2.optional.MysqlDataSource at java.net.URLClassLoader.findClass(URLClassLoader.java:381) at java.lang.ClassLoader.loadClass(ClassLoader.java:424) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349) at java.lang.ClassLoader.loadClass(ClassLoader.java:357) at com.zaxxer.hikari.util.PoolUtilities.createInstance(PoolUtilities.java:126) ... 18 more Any ideas? I
... View more
Labels: