Connection refused on Overloard

2,606 views

Skip to first unread message

Maurizio Gallelli

unread,

Mar 17, 2015, 10:22:14 AM3/17/15

to druid-de...@googlegroups.com

Hi,

I'm currently updating to new 0.7 version.

The Overlord module seems now to have some strange errors:

2015-03-17T07:04:48,355 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.indexing.overlord.autoscaling.ResourceManagementSchedulerConfig] from props[druid.indexer.autoscale.] as [io.druid.indexing.overlord.autoscaling.ResourceManagementSchedulerConfig@557eb543]
2015-03-17T07:04:48,360 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.curator.CuratorConfig] from props[druid.zk.service.] as [io.druid.curator.CuratorConfig@7123be6c]
2015-03-17T07:04:48,365 WARN [main] org.apache.curator.retry.ExponentialBackoffRetry - maxRetries too large (30). Pinning to 29
2015-03-17T07:04:48,414 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.initialization.CuratorDiscoveryConfig] from props[druid.discovery.curator.] as [io.druid.server.initialization.CuratorDiscoveryConfig@96a75da]
2015-03-17T07:04:48,646 WARN [main] io.druid.metadata.SQLMetadataConnector - Exception creating table
org.skife.jdbi.v2.exceptions.UnableToObtainConnectionException: java.sql.SQLException: Cannot create PoolableConnectionFactory (java.net.ConnectException : Error connecting to server localhost on port 1,527 with message Connection refused.)
        at org.skife.jdbi.v2.DBI.open(DBI.java:210) ~[jdbi-2.32.jar:?]
        at org.skife.jdbi.v2.DBI.withHandle(DBI.java:257) ~[jdbi-2.32.jar:?]
        at io.druid.metadata.SQLMetadataConnector.createTable(SQLMetadataConnector.java:88) [druid-server-0.7.0.jar:0.7.0]
        at io.druid.metadata.SQLMetadataConnector.createConfigTable(SQLMetadataConnector.java:164) [druid-server-0.7.0.jar:0.7.0]
        at io.druid.metadata.SQLMetadataConnector.createConfigTable(SQLMetadataConnector.java:303) [druid-server-0.7.0.jar:0.7.0]
        at io.druid.guice.JacksonConfigManagerModule$1.start(JacksonConfigManagerModule.java:56) [druid-common-0.7.0.jar:0.7.0]
        at com.metamx.common.lifecycle.Lifecycle.start(Lifecycle.java:250) [java-util-0.26.14.jar:?]
        at io.druid.guice.LifecycleModule$2.start(LifecycleModule.java:136) [druid-api-0.3.4.jar:0.7.0]
        at io.druid.cli.GuiceRunnable.initLifecycle(GuiceRunnable.java:71) [druid-services-0.7.0.jar:0.7.0]
        at io.druid.cli.ServerRunnable.run(ServerRunnable.java:38) [druid-services-0.7.0.jar:0.7.0]
        at io.druid.cli.Main.main(Main.java:88) [druid-services-0.7.0.jar:0.7.0]
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (java.net.ConnectException : Error connecting to server localhost on port 1,527 with message Connection refused.)
        at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2152) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.skife.jdbi.v2.DataSourceConnectionFactory.openConnection(DataSourceConnectionFactory.java:36) ~[jdbi-2.32.jar:?]
        at org.skife.jdbi.v2.DBI.open(DBI.java:192) ~[jdbi-2.32.jar:?]
        ... 10 more
Caused by: java.sql.SQLNonTransientConnectionException: java.net.ConnectException : Error connecting to server localhost on port 1,527 with message Connection refused.
        at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2162) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2148) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.skife.jdbi.v2.DataSourceConnectionFactory.openConnection(DataSourceConnectionFactory.java:36) ~[jdbi-2.32.jar:?]
        at org.skife.jdbi.v2.DBI.open(DBI.java:192) ~[jdbi-2.32.jar:?]
        ... 10 more
Caused by: org.apache.derby.client.am.DisconnectException: java.net.ConnectException : Error connecting to server localhost on port 1,527 with message Connection refused.
        at org.apache.derby.client.net.NetAgent.<init>(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.net.NetConnection.newAgent_(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.am.ClientConnection.<init>(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.net.NetConnection.<init>(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl.newNetConnection(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2162) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2148) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.skife.jdbi.v2.DataSourceConnectionFactory.openConnection(DataSourceConnectionFactory.java:36) ~[jdbi-2.32.jar:?]
        at org.skife.jdbi.v2.DBI.open(DBI.java:192) ~[jdbi-2.32.jar:?]
        ... 10 more
Caused by: java.net.ConnectException: Connection refused
        at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:1.8.0_25]
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:345) ~[?:1.8.0_25]
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[?:1.8.0_25]
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[?:1.8.0_25]
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:1.8.0_25]
        at java.net.Socket.connect(Socket.java:589) ~[?:1.8.0_25]
        at java.net.Socket.connect(Socket.java:538) ~[?:1.8.0_25]
        at java.net.Socket.<init>(Socket.java:434) ~[?:1.8.0_25]
        at java.net.Socket.<init>(Socket.java:211) ~[?:1.8.0_25]
        at javax.net.DefaultSocketFactory.createSocket(SocketFactory.java:271) ~[?:1.8.0_25]
        at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_25]
        at org.apache.derby.client.net.NetAgent.<init>(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.net.NetConnection.newAgent_(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.am.ClientConnection.<init>(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.net.NetConnection.<init>(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl.newNetConnection(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2162) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2148) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.skife.jdbi.v2.DataSourceConnectionFactory.openConnection(DataSourceConnectionFactory.java:36) ~[jdbi-2.32.jar:?]
        at org.skife.jdbi.v2.DBI.open(DBI.java:192) ~[jdbi-2.32.jar:?]
        ... 10 more

my runtime properties configuration is:

druid.service=overlord
druid.host=10.200.6.60
druid.port=8087

# Curator Module (All nodes)
druid.zk.service.host=10.200.6.60:2181,10.200.6.70:2181

druid.extensions.coordinates=["io.druid.extensions:druid-kafka-eight:0.6.147"]

# Metrics Module (All nodes)
#druid.monitoring.monitors=["com.metamx.metrics.SysMonitor","com.metamx.metrics.JvmMonitor"]

druid.db.connector.connectURI=jdbc:mysql://10.200.6.5:3306/druid
druid.db.connector.user=druid
druid.db.connector.password=druid

# Emitter Module (All nodes)
druid.emitter=logging

# Task Log Module (Overlord and MiddleManager node)
druid.indexer.logs.type=file
druid.indexer.logs.directory=/usr/local/druid/logs/

# Indexing Service Discovery Module (All nodes)
druid.selectors.indexing.serviceName=overlord
druid.indexer.queue.startDelay=PT1M

#druid.indexer.runner.type=remote
#druid.indexer.storage.type=db

druid.indexer.runner.javaOpts="-server -Xmx1g"
druid.indexer.runner.startPort=8088
druid.indexer.fork.property.druid.processing.numThreads=1
druid.indexer.fork.property.druid.computation.buffer.size=100000000

and this is how I'm starting overlord:

java -server -Xmx10g -Xms10g -XX:NewSize=512m -XX:MaxNewSize=512m -XX:+UseConcMarkSweepGC -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -Duser.timezone=UTC -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/usr/local/tmp_druid -Dlog4j.configuration=file:"/usr/local/druid/config/overlord/log4j.xml" -classpath /usr/local/druid/config/overlord:/usr/local/druid/lib/* io.druid.cli.Main server overlord

Can you please help me on understand which is the connection Overlord is trying to do and doesn't have answer (Error connecting to server localhost on port 1,527 with message Connection refused.)

Thanks

Maurizio

Nishant Bangarwa

unread,

Mar 17, 2015, 10:29:58 AM3/17/15

to druid-de...@googlegroups.com

Hi,

you have not configured the metadata storage properly,

refer to http://druid.io/docs/latest/Configuration.html and search for Metadata Storage for correct configurations.

--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-developm...@googlegroups.com.
To post to this group, send email to druid-de...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/5e5a3c5f-6cfe-4da8-95e7-9e19d181c178%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Nishant

Software Engineer

METAMARKETS

m	+91-9729200044

nishant....@metamarkets.com

Fangjin Yang

unread,

Mar 17, 2015, 7:01:37 PM3/17/15

to druid-de...@googlegroups.com

Specifically, mysql is not included as module (it is no longer the default, so you need to include the module and specify that you are using mysql)

See:

http://druid.io/docs/latest/Production-Cluster-Configuration.html

To unsubscribe from this group and stop receiving emails from it, send an email to druid-development+unsubscribe@googlegroups.com.
To post to this group, send email to druid-development@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/5e5a3c5f-6cfe-4da8-95e7-9e19d181c178%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Nishant
Software Engineer | METAMARKETS
m +91-9729200044

nishant.bangarwa@metamarkets.com

Maurizio Gallelli

unread,

Mar 18, 2015, 4:32:02 AM3/18/15

to druid-de...@googlegroups.com

Thanks about your feedback.

Loading mysql module and setting new Metadata configurations I was able to start Overlord module.

Thanks,

Maurizio

To unsubscribe from this group and stop receiving emails from it, send an email to druid-developm...@googlegroups.com.
To post to this group, send email to druid-de...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/5e5a3c5f-6cfe-4da8-95e7-9e19d181c178%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Nishant
Software Engineer | METAMARKETS
m +91-9729200044

nishant....@metamarkets.com

Rodolfo Mijangos

unread,

May 11, 2015, 11:32:47 AM5/11/15

to druid-de...@googlegroups.com

Maurizio, how included the mysql module ? I have the same issue.

Mysql server running in the same node that overloard.

I was configure the user druid with full privileges.

The issue is :

2015-05-11T15:10:48,331 WARN [main] io.druid.metadata.SQLMetadataConnector - Exception creating table

org.skife.jdbi.v2.exceptions.UnableToObtainConnectionException: java.sql.SQLException: Cannot create PoolableConnectionFactory (java.net.ConnectException : Error connecting to server localhost on port 1,527 with message Connection refused.)
        at org.skife.jdbi.v2.DBI.open(DBI.java:210) ~[jdbi-2.32.jar:?]
        at org.skife.jdbi.v2.DBI.withHandle(DBI.java:257) ~[jdbi-2.32.jar:?]
        at io.druid.metadata.SQLMetadataConnector.createTable(SQLMetadataConnector.java:88) [druid-server-0.7.0.jar:0.7.0]
        at io.druid.metadata.SQLMetadataConnector.createConfigTable(SQLMetadataConnector.java:164) [druid-server-0.7.0.jar:0.7.0]
        at io.druid.metadata.SQLMetadataConnector.createConfigTable(SQLMetadataConnector.java:303) [druid-server-0.7.0.jar:0.7.0]
        at io.druid.guice.JacksonConfigManagerModule$1.start(JacksonConfigManagerModule.java:56) [druid-common-0.7.0.jar:0.7.0]
        at com.metamx.common.lifecycle.Lifecycle.start(Lifecycle.java:250) [java-util-0.26.14.jar:?]
        at io.druid.guice.LifecycleModule$2.start(LifecycleModule.java:136) [druid-api-0.3.4.jar:0.7.0]
        at io.druid.cli.GuiceRunnable.initLifecycle(GuiceRunnable.java:71) [druid-services-0.7.0.jar:0.7.0]
        at io.druid.cli.ServerRunnable.run(ServerRunnable.java:38) [druid-services-0.7.0.jar:0.7.0]
        at io.druid.cli.Main.main(Main.java:88) [druid-services-0.7.0.jar:0.7.0]

The configuration Extensions and Metadata Storage on common.runtime.properties

# Extensions
druid.extensions.coordinates=["io.druid.extensions:druid-s3-extensions", "io.druid.extensions:druid-histogram", "io.druid.extensions:mysql-metadata-storage","io.druid.extensions:druid-examples","io.druid.extensions:druid-kafka-eight"]

# Metadata Storage (mysql)
druid.metadata.storage.type=mysql
druid.metadata.storage.connector.createTables=true
druid.metadata.storage.connector.connectURI=jdbc:mysql://localhost:3306/druid
druid.metadata.storage.connector.user=druid
druid.metadata.storage.connector.password=diurd

# Deep storage (local filesystem for examples - don't use this in production)
druid.storage.type=s3
druid.s3.accessKey=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
druid.s3.secretKey=xxxxxxxxxxxxxxxxxxxxxxxx
druid.s3.bucket=s3:xxxxxxxxxxxxx

my overlord -> runtime.properties

druid.host=x.x.x.x:8080
druid.port=8080
druid.service=druid/prod/overlord

druid.indexer.autoscale.doAutoscale=true
druid.indexer.autoscale.strategy=ec2
druid.indexer.autoscale.workerIdleTimeout=PT90m
druid.indexer.autoscale.terminatePeriod=PT5M
#druid.indexer.autoscale.workerVersion=#{WORKER_VERSION}

# Upload all task logs to deep storage
druid.indexer.logs.type=s3
druid.indexer.logs.s3Bucket=druid
druid.indexer.logs.s3Prefix=prod/logs/v1

# Run in remote mode
druid.indexer.runner.type=remote

#druid.indexer.runner.minWorkerVersion=#{WORKER_VERSION}

# Store all task state in the metadata storage
druid.indexer.storage.type=metadata

if you have any idea let me know.

Eric Tschetter

unread,

May 11, 2015, 5:55:57 PM5/11/15

to druid-de...@googlegroups.com

It seems fishy that it says it's not connecting to port 1527 when you are specifying 3306...

To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/21b1e290-eae6-48df-a330-ba22d94760a8%40googlegroups.com.

Eric Tschetter

unread,

May 11, 2015, 6:24:26 PM5/11/15

to druid-de...@googlegroups.com

Hrm, ok, after looking at the code a bit more, it looks like it might not be taking the config. Can you see if you can find the line that would line up with

log.info("Loaded class[%s] from props[%s] as [%s]", clazz, propertyBase, config);

For class MetadataStorageConnectorConfig and provide it here?

Secondly, FJ, other committers, the code for the metadata connectors is rather convoluted, especially the SQL ones. It looks like there was an intention to try to reuse various parts, but it's honestly just resulting in weird things like this error (and the stack trace doesn't even tell us if the code is trying to use the Derby one, which the failing config would indicate, or the MySQL one which was actually configured). Can we go to a model where each of the implementations provides its own config objects (which can look very similar by convention) and have a more direct injection/usage path? That would simplify this class of error because either it's using the Derby config or its using the MySQL, but there wouldn't be questions of which one it happens to be using.

--Eric

Message has been deleted

Fangjin

unread,

May 11, 2015, 6:31:19 PM5/11/15

to druid-de...@googlegroups.com

I think we should remove the metadata store altogether and have the logic live on the coordinator. We plan to do this around the same time we remove the overlord node. Proposals will be written "soon".

To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/CAB8U%2Bh2auf4DQg5XqMZYhGfek9CVThWDAhKkf0ZtPDx0VGyr-Q%40mail.gmail.com.

Message has been deleted

pja...@yahoo-inc.com

unread,

May 11, 2015, 6:33:40 PM5/11/15

to druid-de...@googlegroups.com

If you're trying to run it from an IDE then you have to specify the version of package with the extension name (Druid cannot get default package version). Can you try specifying the druid version along with the extension name, so the "io.druid.extensions:mysql-

metadata-storage" should look like "io.druid.extensions:mysql-metadata-storage:<version_of_druid_in_pom>".

Rodolfo Mijangos

unread,

May 13, 2015, 10:34:56 AM5/13/15

to druid-de...@googlegroups.com

Attached you found the event log,   If you have any idea let me know.

        at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
        at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
        at java.util.logging.LogManager$1.run(LogManager.java:191)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.util.logging.LogManager.<clinit>(LogManager.java:181)
        at java.util.logging.Logger.demandLogger(Logger.java:339)
        at java.util.logging.Logger.getLogger(Logger.java:393)
        at com.sun.jmx.remote.util.ClassLogger.<init>(ClassLogger.java:55)
        at javax.management.NotificationBroadcasterSupport.<clinit>(NotificationBroadcasterSupport.java:352)
        at javax.management.MBeanServerDelegate.<init>(MBeanServerDelegate.java:72)
        at com.sun.jmx.mbeanserver.MBeanServerDelegateImpl.<init>(MBeanServerDelegateImpl.java:100)
        at com.sun.jmx.mbeanserver.JmxMBeanServer.newMBeanServerDelegate(JmxMBeanServer.java:1374)
        at javax.management.MBeanServerBuilder.newMBeanServerDelegate(MBeanServerBuilder.java:66)
        at javax.management.MBeanServerFactory.newMBeanServer(MBeanServerFactory.java:320)
        at javax.management.MBeanServerFactory.createMBeanServer(MBeanServerFactory.java:231)
        at javax.management.MBeanServerFactory.createMBeanServer(MBeanServerFactory.java:192)
        at java.lang.management.ManagementFactory.getPlatformMBeanServer(ManagementFactory.java:466)
        at org.apache.logging.log4j.core.jmx.Server.reregisterMBeansAfterReconfigure(Server.java:120)
        at org.apache.logging.log4j.core.LoggerContext.setConfiguration(LoggerContext.java:370)
        at org.apache.logging.log4j.core.LoggerContext.reconfigure(LoggerContext.java:420)
        at org.apache.logging.log4j.core.LoggerContext.start(LoggerContext.java:138)
        at org.apache.logging.log4j.core.impl.Log4jContextFactory.getContext(Log4jContextFactory.java:147)
        at org.apache.logging.log4j.core.impl.Log4jContextFactory.getContext(Log4jContextFactory.java:41)
        at org.apache.logging.log4j.LogManager.getContext(LogManager.java:175)
        at org.apache.logging.log4j.spi.AbstractLoggerAdapter.getContext(AbstractLoggerAdapter.java:102)
        at org.apache.logging.slf4j.Log4jLoggerFactory.getContext(Log4jLoggerFactory.java:43)
        at org.apache.logging.log4j.spi.AbstractLoggerAdapter.getLogger(AbstractLoggerAdapter.java:42)
        at org.apache.logging.slf4j.Log4jLoggerFactory.getLogger(Log4jLoggerFactory.java:29)
        at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:253)
        at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:265)
        at com.metamx.common.logger.Logger.<init>(Logger.java:36)
        at io.druid.guice.PropertiesModule.<clinit>(PropertiesModule.java:41)
        at io.druid.guice.GuiceInjectors.makeDefaultStartupModules(GuiceInjectors.java:38)
        at io.druid.guice.GuiceInjectors.makeStartupInjector(GuiceInjectors.java:57)
        at io.druid.cli.Main.main(Main.java:74)
2015-05-13T14:20:28,115 INFO [main] io.druid.guice.PropertiesModule - Loading properties from runtime.properties
2015-05-13T14:20:28,930 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.guice.ExtensionsConfig] from props[druid.extensions.] as [ExtensionsConfig{searchCurrentClassloader=true, coordinates=[], defaultVersion='0.7.0', localRepository='/root/.m2/repository', remoteRepositories=[http://repo1.maven.org/maven2/, https://metamx.artifactoryonline.com/metamx/pub-libs-releases-local]}]
2015-05-13T14:20:30,073 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.metadata.MetadataStorageConnectorConfig] from props[druid.metadata.storage.connector.] as [DbConnectorConfig{createTables=true, connectURI='jdbc:derby://localhost:1527/druid;create=true', user='null', password=****}]
2015-05-13T14:20:30,096 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.metadata.MetadataStorageTablesConfig] from props[druid.metadata.storage.tables.] as [io.druid.metadata.MetadataStorageTablesConfig@131a58a4]
3.063: [GC3.063: [ParNew: 209792K->21003K(235968K), 0.0579220 secs] 209792K->21003K(4168128K), 0.0579970 secs] [Times: user=0.18 sys=0.01, real=0.06 secs]
2015-05-13T14:20:30,374 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.common.config.ConfigManagerConfig] from props[druid.manager.config.] as [io.druid.common.config.ConfigManagerConfig@d0c51d7]
2015-05-13T14:20:30,398 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.metrics.DruidMonitorSchedulerConfig] from props[druid.monitoring.] as [io.druid.server.metrics.DruidMonitorSchedulerConfig@15343560]
2015-05-13T14:20:30,410 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.metrics.MonitorsConfig] from props[druid.monitoring.] as [MonitorsConfig{monitors=[]}]
2015-05-13T14:20:30,450 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.DruidNode] from props[druid.] as [DruidNode{serviceName='druid/prod/overlord', host='xxx.xxx.xxx.xxx', port=8080}]
2015-05-13T14:20:30,464 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.initialization.ServerConfig] from props[druid.server.http.] as [ServerConfig{numThreads=40, maxIdleTime=PT5M}]
2015-05-13T14:20:30,472 INFO [main] org.eclipse.jetty.util.log - Logging initialized @3181ms
2015-05-13T14:20:30,563 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.indexing.overlord.config.TaskQueueConfig] from props[druid.indexer.queue.] as [io.druid.indexing.overlord.config.TaskQueueConfig@1f2bc217]
2015-05-13T14:20:30,568 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.indexing.common.config.TaskStorageConfig] from props[druid.indexer.storage.] as [io.druid.indexing.common.config.TaskStorageConfig@766c6aef]
2015-05-13T14:20:30,593 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.initialization.ZkPathsConfig] from props[druid.zk.paths.] as [io.druid.server.initialization.ZkPathsConfig@58d3f4be]
2015-05-13T14:20:30,597 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.initialization.IndexerZkConfig] from props[druid.zk.paths.indexer.] as [io.druid.server.initialization.IndexerZkConfig@d5bd5202]
2015-05-13T14:20:30,604 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.curator.CuratorConfig] from props[druid.zk.service.] as [io.druid.curator.CuratorConfig@20648b59]
2015-05-13T14:20:30,610 WARN [main] org.apache.curator.retry.ExponentialBackoffRetry - maxRetries too large (30). Pinning to 29
2015-05-13T14:20:30,663 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.indexing.overlord.config.RemoteTaskRunnerConfig] from props[druid.indexer.runner.] as [io.druid.indexing.overlord.config.RemoteTaskRunnerConfig@29158876]
2015-05-13T14:20:30,669 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.guice.http.DruidHttpClientConfig] from props[druid.global.http.] as [io.druid.guice.http.DruidHttpClientConfig@49cda1d4]
2015-05-13T14:20:30,713 INFO [main] io.druid.common.config.ConfigManager - Creating watch for key[worker.config]
2015-05-13T14:20:30,732 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.indexing.overlord.autoscaling.SimpleResourceManagementConfig] from props[druid.indexer.autoscale.] as [io.druid.indexing.overlord.autoscaling.SimpleResourceManagementConfig@137a9c67]
2015-05-13T14:20:30,773 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.indexing.overlord.autoscaling.ResourceManagementSchedulerConfig] from props[druid.indexer.autoscale.] as [io.druid.indexing.overlord.autoscaling.ResourceManagementSchedulerConfig@465e4471]
2015-05-13T14:20:30,777 INFO [main] io.druid.guice.JsonConfigurator - Loaded class[class io.druid.server.initialization.CuratorDiscoveryConfig] from props[druid.discovery.curator.] as [io.druid.server.initialization.CuratorDiscoveryConfig@df9cf7b]
2015-05-13T14:20:30,971 WARN [main] io.druid.metadata.SQLMetadataConnector - Exception creating table

        at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:1.7.0_75]
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) ~[?:1.7.0_75]
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) ~[?:1.7.0_75]
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) ~[?:1.7.0_75]
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:1.7.0_75]
        at java.net.Socket.connect(Socket.java:579) ~[?:1.7.0_75]
        at java.net.Socket.connect(Socket.java:528) ~[?:1.7.0_75]
        at java.net.Socket.<init>(Socket.java:425) ~[?:1.7.0_75]
        at java.net.Socket.<init>(Socket.java:208) ~[?:1.7.0_75]
        at javax.net.DefaultSocketFactory.createSocket(SocketFactory.java:271) ~[?:1.7.0_75]

at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]

at java.security.AccessController.doPrivileged(Native Method) ~[?:1.7.0_75]

        at org.apache.derby.client.net.NetAgent.<init>(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.net.NetConnection.newAgent_(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.am.ClientConnection.<init>(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.net.NetConnection.<init>(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl.newNetConnection(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2162) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2148) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.skife.jdbi.v2.DataSourceConnectionFactory.openConnection(DataSourceConnectionFactory.java:36) ~[jdbi-2.32.jar:?]
        at org.skife.jdbi.v2.DBI.open(DBI.java:192) ~[jdbi-2.32.jar:?]
        ... 10 more

2015-05-13T14:20:30,979 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void io.druid.common.config.ConfigManager.start()] on object[io.druid.common.config.ConfigManager@2a617a82].
2015-05-13T14:20:30,981 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void com.metamx.emitter.service.ServiceEmitter.start()] on object[com.metamx.emitter.service.ServiceEmitter@51282629].
2015-05-13T14:20:30,981 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void com.metamx.metrics.MonitorScheduler.start()] on object[com.metamx.metrics.MonitorScheduler@22e1775f].
2015-05-13T14:20:30,982 INFO [main] com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler - Invoking start method[public void io.druid.indexing.overlord.MetadataTaskStorage.start()] on object[io.druid.indexing.overlord.MetadataTaskStorage@640fdd].
2015-05-13T14:20:30,981 WARN [config-manager-0] io.druid.common.config.ConfigManager - Exception when checking property[worker.config]

        at io.druid.metadata.SQLMetadataConnector.lookup(SQLMetadataConnector.java:329) ~[druid-server-0.7.0.jar:0.7.0]
        at io.druid.common.config.ConfigManager.poll(ConfigManager.java:106) [druid-common-0.7.0.jar:0.7.0]
        at io.druid.common.config.ConfigManager.access$600(ConfigManager.java:42) [druid-common-0.7.0.jar:0.7.0]
        at io.druid.common.config.ConfigManager$PollingCallable.call(ConfigManager.java:248) [druid-common-0.7.0.jar:0.7.0]
        at io.druid.common.config.ConfigManager$PollingCallable.call(ConfigManager.java:232) [druid-common-0.7.0.jar:0.7.0]
        at com.metamx.common.concurrent.ScheduledExecutors$2.run(ScheduledExecutors.java:99) [java-util-0.26.14.jar:?]
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [?:1.7.0_75]
        at java.util.concurrent.FutureTask.run(FutureTask.java:262) [?:1.7.0_75]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) [?:1.7.0_75]
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) [?:1.7.0_75]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [?:1.7.0_75]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [?:1.7.0_75]
        at java.lang.Thread.run(Thread.java:745) [?:1.7.0_75]

Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (java.net.ConnectException : Error connecting to server localhost on port 1,527 with message Connection refused.)
        at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2152) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.skife.jdbi.v2.DataSourceConnectionFactory.openConnection(DataSourceConnectionFactory.java:36) ~[jdbi-2.32.jar:?]
        at org.skife.jdbi.v2.DBI.open(DBI.java:192) ~[jdbi-2.32.jar:?]

... 14 more

Caused by: java.sql.SQLNonTransientConnectionException: java.net.ConnectException : Error connecting to server localhost on port 1,527 with message Connection refused.
        at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2162) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2148) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.skife.jdbi.v2.DataSourceConnectionFactory.openConnection(DataSourceConnectionFactory.java:36) ~[jdbi-2.32.jar:?]
        at org.skife.jdbi.v2.DBI.open(DBI.java:192) ~[jdbi-2.32.jar:?]

... 14 more

Caused by: org.apache.derby.client.am.DisconnectException: java.net.ConnectException : Error connecting to server localhost on port 1,527 with message Connection refused.
        at org.apache.derby.client.net.NetAgent.<init>(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.net.NetConnection.newAgent_(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.am.ClientConnection.<init>(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.net.NetConnection.<init>(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.client.net.ClientJDBCObjectFactoryImpl.newNetConnection(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
        at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:39) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2162) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2148) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.skife.jdbi.v2.DataSourceConnectionFactory.openConnection(DataSourceConnectionFactory.java:36) ~[jdbi-2.32.jar:?]
        at org.skife.jdbi.v2.DBI.open(DBI.java:192) ~[jdbi-2.32.jar:?]

... 14 more

Caused by: java.net.ConnectException: Connection refused

at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]

at java.security.AccessController.doPrivileged(Native Method) ~[?:1.7.0_75]

... 14 more
2015-05-13T14:20:30,983 WARN [main] io.druid.metadata.SQLMetadataConnector - Exception creating table

        at io.druid.metadata.SQLMetadataConnector.createEntryTable(SQLMetadataConnector.java:182) [druid-server-0.7.0.jar:0.7.0]
        at io.druid.metadata.SQLMetadataConnector.createTaskTables(SQLMetadataConnector.java:312) [druid-server-0.7.0.jar:0.7.0]
        at io.druid.indexing.overlord.MetadataTaskStorage.start(MetadataTaskStorage.java:108) [druid-indexing-service-0.7.0.jar:0.7.0]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_75]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_75]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_75]
        at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_75]
        at com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler.start(Lifecycle.java:331) [java-util-0.26.14.jar:?]

        at com.metamx.common.lifecycle.Lifecycle.start(Lifecycle.java:250) [java-util-0.26.14.jar:?]
        at io.druid.guice.LifecycleModule$2.start(LifecycleModule.java:136) [druid-api-0.3.4.jar:0.7.0]
        at io.druid.cli.GuiceRunnable.initLifecycle(GuiceRunnable.java:71) [druid-services-0.7.0.jar:0.7.0]
        at io.druid.cli.ServerRunnable.run(ServerRunnable.java:38) [druid-services-0.7.0.jar:0.7.0]
        at io.druid.cli.Main.main(Main.java:88) [druid-services-0.7.0.jar:0.7.0]
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (java.net.ConnectException : Error connecting to server localhost on port 1,527 with message Connection refused.)
        at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2152) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:1903) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1413) ~[commons-dbcp2-2.0.1.jar:2.0.1]
        at org.skife.jdbi.v2.DataSourceConnectionFactory.openConnection(DataSourceConnectionFactory.java:36) ~[jdbi-2.32.jar:?]
        at org.skife.jdbi.v2.DBI.open(DBI.java:192) ~[jdbi-2.32.jar:?]

... 15 more

Caused by: java.net.ConnectException: Connection refused

at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]

at java.security.AccessController.doPrivileged(Native Method) ~[?:1.7.0_75]

... 15 more
2015-05-13T14:20:30,985 WARN [main] io.druid.metadata.SQLMetadataConnector - Exception creating table

        at io.druid.metadata.SQLMetadataConnector.createLogTable(SQLMetadataConnector.java:205) [druid-server-0.7.0.jar:0.7.0]
        at io.druid.metadata.SQLMetadataConnector.createTaskTables(SQLMetadataConnector.java:313) [druid-server-0.7.0.jar:0.7.0]
        at io.druid.indexing.overlord.MetadataTaskStorage.start(MetadataTaskStorage.java:108) [druid-indexing-service-0.7.0.jar:0.7.0]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_75]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_75]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_75]
        at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_75]
        at com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler.start(Lifecycle.java:331) [java-util-0.26.14.jar:?]

... 15 more

Caused by: java.net.ConnectException: Connection refused

at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]

at java.security.AccessController.doPrivileged(Native Method) ~[?:1.7.0_75]

... 15 more
2015-05-13T14:20:30,988 WARN [main] io.druid.metadata.SQLMetadataConnector - Exception creating table

        at io.druid.metadata.SQLMetadataConnector.createLockTable(SQLMetadataConnector.java:225) [druid-server-0.7.0.jar:0.7.0]
        at io.druid.metadata.SQLMetadataConnector.createTaskTables(SQLMetadataConnector.java:314) [druid-server-0.7.0.jar:0.7.0]
        at io.druid.indexing.overlord.MetadataTaskStorage.start(MetadataTaskStorage.java:108) [druid-indexing-service-0.7.0.jar:0.7.0]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_75]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_75]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_75]
        at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_75]
        at com.metamx.common.lifecycle.Lifecycle$AnnotationBasedHandler.start(Lifecycle.java:331) [java-util-0.26.14.jar:?]

... 15 more

Caused by: java.net.ConnectException: Connection refused

at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]
at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source) ~[derbyclient-10.11.1.1.jar:?]

at java.security.AccessController.doPrivileged(Native Method) ~[?:1.7.0_75]

... 15 more
2015-05-13T14:20:30,991 INFO [main] io.druid.curator.CuratorModule - Starting Curator
2015-05-13T14:20:30,991 INFO [main] org.apache.curator.framework.imps.CuratorFrameworkImpl - Starting
2015-05-13T14:20:30,999 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:zookeeper.version=3.4.6-1569965, built on 02/20/2014 09:09 GMT
2015-05-13T14:20:30,999 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:host.name=<NA>
2015-05-13T14:20:30,999 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.version=1.7.0_75
2015-05-13T14:20:30,999 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.vendor=Oracle Corporation
2015-05-13T14:20:30,999 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.home=/usr/lib/jvm/java-1.7.0-openjdk-1.7.0.75.x86_64/jre
2015-05-13T14:20:30,999 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.class.path=config/overlord:config/overlord:lib/irc-api-1.0-0011.jar:lib/http-client-1.0.0.jar:lib/google-http-client-jackson2-1.15.0-rc.jar:lib/jetty-server-9.2.5.v20141112.jar:lib/curator-recipes-2.7.0.jar:lib/jetty-continuation-9.2.5.v20141112.jar:lib/guice-multibindings-4.0-beta.jar:lib/plexus-interpolation-1.19.jar:lib/maxminddb-0.2.0.jar:lib/okhttp-1.0.2.jar:lib/derby-10.11.1.1.jar:lib/bcprov-jdk15-1.46.jar:lib/aether-connector-okhttp-0.0.9.jar:lib/spymemcached-2.11.4.jar:lib/aether-util-0.9.0.M2.jar:lib/jets3t-0.9.1.jar:lib/classmate-1.0.0.jar:lib/jetty-proxy-9.2.5.v20141112.jar:lib/java-xmlbuilder-0.4.jar:lib/jackson-jaxrs-base-2.4.4.jar:lib/tesla-aether-0.0.5.jar:lib/opencsv-2.3.jar:lib/jetty-http-9.2.5.v20141112.jar:lib/guice-4.0-beta.jar:lib/guice-servlet-4.0-beta.jar:lib/mx4j-3.0.2.jar:lib/zookeeper-3.4.6.jar:lib/druid-aws-common-0.7.0.jar:lib/log4j-1.2.16.jar:lib/aether-impl-0.9.0.M2.jar:lib/druid-indexing-service-0.7.0.jar:lib/httpcore-4.2.jar:lib/jackson-mapper-asl-1.9.13.jar:lib/airline-0.6.jar:lib/jackson-jaxrs-json-provider-2.4.4.jar:lib/aether-spi-0.9.0.M2.jar:lib/jackson-core-asl-1.9.12.jar:lib/javax.el-api-3.0.0.jar:lib/extendedset-1.3.8.jar:lib/maven-repository-metadata-3.1.1.jar:lib/druid-processing-0.7.0.jar:lib/google-http-client-1.15.0-rc.jar:lib/RoaringBitmap-0.4.5.jar:lib/javax.servlet-api-3.1.0.jar:lib/commons-pool-1.6.jar:lib/netty-3.9.5.Final.jar:lib/server-metrics-0.1.0.jar:lib/plexus-utils-3.0.15.jar:lib/maven-model-builder-3.1.1.jar:lib/geoip2-0.4.0.jar:lib/jetty-security-9.2.5.v20141112.jar:lib/jersey-server-1.17.1.jar:lib/jackson-databind-2.4.4.jar:lib/mapdb-1.0.6.jar:lib/curator-framework-2.7.0.jar:lib/antlr4-runtime-4.0.jar:lib/aether-api-0.9.0.M2.jar:lib/aws-java-sdk-1.8.11.jar:lib/commons-pool2-2.2.jar:lib/jdbi-2.32.jar:lib/xpp3-1.1.4c.jar:lib/jetty-util-9.2.5.v20141112.jar:lib/org.abego.treelayout.core-1.0.1.jar:lib/jackson-datatype-guava-2.4.4.jar:lib/jersey-core-1.17.1.jar:lib/asm-3.1.jar:lib/commons-dbcp2-2.0.1.jar:lib/javax.el-3.0.0.jar:lib/jetty-io-9.2.5.v20141112.jar:lib/jline-0.9.94.jar:lib/maven-settings-builder-3.1.1.jar:lib/derbyclient-10.11.1.1.jar:lib/derbynet-10.11.1.1.jar:lib/druid-common-0.7.0.jar:lib/icu4j-4.8.1.jar:lib/validation-api-1.1.0.Final.jar:lib/commons-logging-1.1.1.jar:lib/jboss-logging-3.1.3.GA.jar:lib/jackson-dataformat-smile-2.4.4.jar:lib/jetty-servlets-9.2.5.v20141112.jar:lib/jackson-module-jaxb-annotations-2.4.4.jar:lib/java-util-0.26.14.jar:lib/jersey-servlet-1.17.1.jar:lib/commons-io-2.0.1.jar:lib/config-magic-0.9.jar:lib/javax.inject-1.jar:lib/maven-settings-3.1.1.jar:lib/jetty-client-9.2.5.v20141112.jar:lib/jackson-datatype-joda-2.4.4.jar:lib/aether-connector-file-0.9.0.M2.jar:lib/rhino-1.7R4.jar:lib/jetty-servlet-9.2.5.v20141112.jar:lib/slf4j-api-1.6.4.jar:lib/httpclient-4.2.jar:lib/lz4-1.3.0.jar:lib/disruptor-3.3.0.jar:lib/druid-indexing-hadoop-0.7.0.jar:lib/curator-client-2.7.0.jar:lib/emitter-0.3.0.jar:lib/druid-server-0.7.0.jar:lib/mail-1.4.7.jar:lib/jersey-guice-1.17.1.jar:lib/commons-codec-1.7.jar:lib/maven-model-3.1.1.jar:lib/aopalliance-1.0.jar:lib/log4j-slf4j-impl-2.1.jar:lib/activation-1.1.1.jar:lib/guava-16.0.1.jar:lib/bytebuffer-collections-0.1.5.jar:lib/druid-services-0.7.0.jar:lib/hibernate-validator-5.1.3.Final.jar:lib/druid-api-0.3.4.jar:lib/commons-lang-2.6.jar:lib/commons-cli-1.2.jar:lib/jackson-annotations-2.4.4.jar:lib/jackson-core-2.4.4.jar:lib/curator-x-discovery-2.7.0.jar:lib/jackson-jaxrs-smile-provider-2.4.4.jar:lib/protobuf-java-2.5.0.jar:lib/compress-lzf-1.0.3.jar:lib/wagon-provider-api-2.4.jar:lib/maven-aether-provider-3.1.1.jar:lib/jsr305-2.0.1.jar:lib/log4j-api-2.1.jar:lib/aws-java-sdk-core-1.8.11.jar:lib/joda-time-2.6.jar:lib/log4j-core-2.1.jar
2015-05-13T14:20:30,999 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.library.path=/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
2015-05-13T14:20:31,000 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.io.tmpdir=/mnt/tmp
2015-05-13T14:20:31,000 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:java.compiler=<NA>
2015-05-13T14:20:31,000 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:os.name=Linux
2015-05-13T14:20:31,000 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:os.arch=amd64
2015-05-13T14:20:31,000 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:os.version=2.6.32-504.12.2.el6.x86_64
2015-05-13T14:20:31,000 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:user.name=root
2015-05-13T14:20:31,000 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:user.home=/root
2015-05-13T14:20:31,000 INFO [main] org.apache.zookeeper.ZooKeeper - Client environment:user.dir=/opt/druid-0.7.0

Rodolfo Mijangos

unread,

May 13, 2015, 10:49:37 AM5/13/15

to druid-de...@googlegroups.com

I'm using Druid-0.7.0, i try with

druid.extensions.coordinates=["io.druid.extensions:druid-s3-extensions", "io.druid.extensions:druid-histogram", "io.druid.extensions:mysql-metadata-storage:druid-0.7.0","io.druid.extensions:druid-examples"

and the issue persist.

Himanshu

unread,

May 13, 2015, 11:08:40 AM5/13/15

to druid-de...@googlegroups.com

Looks like your "common.runtime.properties" file is not loaded. Are you sure it is on the classpath like that for "runtime.properties"?

what is the java command you are using to run the druid process? Or, what does "ps -ef | grep druid" say?

-- Himanshu

--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-developm...@googlegroups.com.
To post to this group, send email to druid-de...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/67d4ca50-2e46-4195-8726-ddf18cc6ff4e%40googlegroups.com.

Rodolfo Mijangos

unread,

May 14, 2015, 10:09:21 AM5/14/15

to druid-de...@googlegroups.com

Hi Himanshu, i'm using IDE and java command is:

java -server -Xmx4g -Xms4g -XX:NewSize=256m -XX:MaxNewSize=256m -XX:+UseConcMarkSweepGC -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -Duser.timezone=UTC -Dfile.encoding=UTF-8 -Djava.util.logging.manager=org.apache.logging.log4j.jul.LogManager -Djava.io.tmpdir=/mnt/tmp -classpath config/overlord:config/overlord:lib/* io.druid.cli.Main server overlord

the runtime.properties is:

druid.host=localhost:8080
druid.port=8080
druid.service=druid/prod/overlord

# Only required if you are autoscaling middle managers

druid.indexer.autoscale.doAutoscale=true
druid.indexer.autoscale.strategy=ec2
druid.indexer.autoscale.workerIdleTimeout=PT90m
druid.indexer.autoscale.terminatePeriod=PT5M
#druid.indexer.autoscale.workerVersion=#{WORKER_VERSION}

# Upload all task logs to deep storage
druid.indexer.logs.type=s3
druid.indexer.logs.s3Bucket=druid
druid.indexer.logs.s3Prefix=prod/logs/v1

# Run in remote mode
druid.indexer.runner.type=remote
#druid.indexer.runner.minWorkerVersion=#{WORKER_VERSION}

# Store all task state in the metadata storage
druid.indexer.storage.type=metadata

...

Himanshu

unread,

May 14, 2015, 10:13:28 AM5/14/15

to druid-de...@googlegroups.com

where is the "common.runtime.properties" file located. Also, can you try and specify absolute paths in the classpath. I don't know what your working directory is and if that is causing the problem.

-- Himanshur

--

You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-developm...@googlegroups.com.
To post to this group, send email to druid-de...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/ae3788a4-8459-4d2a-aae6-66d3dd09c35d%40googlegroups.com.

Message has been deleted

Rodolfo Mijangos

unread,

May 15, 2015, 10:58:26 AM5/15/15

to druid-de...@googlegroups.com

This file is located at :

/opt/druid-0.7.0/config/_

common/

Thanks.

...

Maurizio Gallelli

unread,

May 15, 2015, 11:02:50 AM5/15/15

to druid-de...@googlegroups.com

Hi Rodolfo,

in your start script doesn't seems to be set common path into classpath.

This is my start:

java -server -Xmx10g -Xms10g -XX:NewSize=512m -XX:MaxNewSize=512m -XX:+UseConcMarkSweepGC -XX:+PrintGCDetails -XX:+PrintGCTimeStamps -Duser.timezone=EDT -Dfile.encoding=UTF-8 -Djava.io.tmpdir=/usr/local/tmp_druid -Djava.util.logging.manager=org.apache.logging.log4j.jul.LogManager -classpath /usr/local/druid/config/_common:/usr/local/druid/config/overlord:/usr/local/druid/lib/* io.druid.cli.Main server overlord

Thanks

Maurizio

Maurizio Gallelli

Acotel Spa
http://www.acotel.com
Via della Valle dei Fontanili, 29
00168 Roma
mailto:maurizio...@acotel.com

skype: mgallelli

Phone +390661141248
Fax +39066149936

--
You received this message because you are subscribed to a topic in the Google Groups "Druid Development" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/druid-development/LZ5Hwk_OytQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to druid-developm...@googlegroups.com.

To post to this group, send email to druid-de...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/e2b90a7e-c2ce-4981-8753-dca95089ef1e%40googlegroups.com.

Himanshu

unread,

May 15, 2015, 11:07:32 AM5/15/15

to druid-de...@googlegroups.com

classpath in the java command "-classpath config/overlord:config/overlord:lib/*" does not have "config/_common/" , that might be the case that file is not loaded. Pls try to add that and check. (if that does not work then try adding absolute paths in the classpath)

if/when the file is loaded you would see "Loading properties from /path/to/common/properties/file" in the logs.

-- Himanshu

On Fri, May 15, 2015 at 9:57 AM, Rodolfo Mijangos <rmij...@gmail.com> wrote:

this file is located at :

/opt/druid-0.7.0/config/_common/

thanks for your time and your response.

El jueves, 14 de mayo de 2015, 8:13:28 (UTC-6), Himanshu Gupta escribió:

...

--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-developm...@googlegroups.com.
To post to this group, send email to druid-de...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/14ba7086-7385-4399-b9a8-b0d64ba01704%40googlegroups.com.

Rodolfo Mijangos

unread,

May 19, 2015, 11:25:58 AM5/19/15

to druid-de...@googlegroups.com

To all, thanks for your support i made the following changes

- Change the -classpath parameters to correct paths.
- Add the machine name to file /etc/hosts

My issue was fixed.