chaperone icon indicating copy to clipboard operation
chaperone copied to clipboard

stacktrace unless the chaperone db is manually created

Open smferguson opened this issue 8 years ago • 0 comments

if I don't manually create the chaperone database I get the stacktrace below when running the following command: ./ChaperoneDistribution/target/ChaperoneDistribution-pkg/bin/start-chaperone-collector.sh

[2017-02-01 12:01:16,721] INFO Trying to start ChaperoneCollector with args: [startChaperoneCollector, com.uber.stream.kafka.chaperone.collector.KafkaIngester] (com.uber.stream.kafka.chaperone.starter.ChaperoneStarter:50) [2017-02-01 12:01:16,730] INFO Kafka ingester topic : null (com.uber.stream.kafka.chaperone.collector.KafkaIngester:180) [2017-02-01 12:01:16,996] INFO Try to create dataTable=audit_metrics and offsetTable=ingester_offsets (com.uber.stream.kafka.chaperone.collector.reporter.DbAuditReporter:191) [2017-02-01 12:01:17,404] WARN Got exception to create table=audit_metrics with sql=CREATE TABLE IF NOT EXISTS %s (time_begin DATETIME, time_end DATETIME, topic_name VARCHAR(128), host_name VARCHAR(64), audit_dc VARCHAR(64), tier VARCHAR(64), metrics text, PRIMARY KEY (time_begin, time_end, topic_name, host_name, audit_dc, tier)) (com.uber.stream.kafka.chaperone.collector.reporter.DbAuditReporter:205) java.sql.SQLException: Cannot create PoolableConnectionFactory (Unknown database 'chaperone') at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2294) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2039) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1533) at com.uber.stream.kafka.chaperone.collector.reporter.DbAuditReporter.getConnection(DbAuditReporter.java:524) at com.uber.stream.kafka.chaperone.collector.reporter.DbAuditReporter.maybeCreateTable(DbAuditReporter.java:200) at com.uber.stream.kafka.chaperone.collector.reporter.DbAuditReporter.(DbAuditReporter.java:192) at com.uber.stream.kafka.chaperone.collector.reporter.DbAuditReporter.(DbAuditReporter.java:46) at com.uber.stream.kafka.chaperone.collector.reporter.DbAuditReporter$DbAuditReporter2Builder.build(DbAuditReporter.java:142) at com.uber.stream.kafka.chaperone.collector.reporter.AuditReporterFactory.getAuditReporter(AuditReporterFactory.java:40) at com.uber.stream.kafka.chaperone.collector.KafkaIngester.(KafkaIngester.java:51) at com.uber.stream.kafka.chaperone.collector.KafkaIngester.main(KafkaIngester.java:182) at com.uber.stream.kafka.chaperone.starter.ChaperoneStarter.main(ChaperoneStarter.java:51) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'chaperone' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:943) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4113) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1308)

smferguson avatar Feb 01 '17 17:02 smferguson