mysql error

Hi Druid Gurus,

we recently upgraded our druid environment to 0.9.1.1 and since then when i i am trying to start overlord i am getting following error

Exception in thread “main” com.metamx.common.ISE: Extension [/x/home/kchada/druid-0.9.1.1/extensions/mysql-metadata-storage] specified in “druid.extensions.loadList” didn’t exist!?

below are few lines from common.runtime.properties file

druid.extensions.loadList=[“druid-hdfs-storage”,“mysql-metadata-storage”]

For MySQL:

druid.metadata.storage.type=mysql

druid.metadata.storage.connector.connectURI=jdbc:mysql://:3306/druid?characterEncoding=UTF-8

druid.metadata.storage.connector.user=druid

druid.metadata.storage.connector.password=diurd

one thing i noticed is path /druid-0.9.1.1/extensions does not have any jars related to mysql-metadata-storage. is this something i need to build manually?

Regards

Karteek

The mysql extension is a separate download, you can get it here: http://druid.io/downloads.html

Hi Gian,

I was able to get over this error, and after that i i was having issues with jackson jars while i was running indexing task, i did a druid sbt build and am using the fat jar in the class path to start my overlord. Since then i am again getting an error related to mysql. below is the error i get when i try to start overlord

INFO [main] io.druid.initialization.Initialization - Loading extension [mysql-metadata-storage] for class [io.druid.initialization.DruidModule]

Exception in thread “main” java.lang.IncompatibleClassChangeError: Implementing class

at java.lang.ClassLoader.defineClass1(Native Method)

    at java.lang.ClassLoader.defineClass(ClassLoader.java:800)

    at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)

    at java.net.URLClassLoader.defineClass(URLClassLoader.java:449)

    at java.net.URLClassLoader.access$100(URLClassLoader.java:71)

    at java.net.URLClassLoader$1.run(URLClassLoader.java:361)

    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.lang.ClassLoader.defineClass1(Native Method)

    at java.lang.ClassLoader.defineClass(ClassLoader.java:800)

    at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)

    at java.net.URLClassLoader.defineClass(URLClassLoader.java:449)

    at java.net.URLClassLoader.access$100(URLClassLoader.java:71)

    at java.net.URLClassLoader$1.run(URLClassLoader.java:361)

    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 io.druid.query.aggregation.histogram.ApproximateHistogramDruidModule.getJacksonModules(ApproximateHistogramDruidModule.java:36)

    at io.druid.initialization.Initialization$ModuleList.registerJacksonModules(Initialization.java:421)

    at io.druid.initialization.Initialization$ModuleList.addModule(Initialization.java:394)

    at io.druid.initialization.Initialization.makeInjectorWithModules(Initialization.java:364)

    at io.druid.cli.GuiceRunnable.makeInjector(GuiceRunnable.java:60)

    at io.druid.cli.ServerRunnable.run(ServerRunnable.java:39)

    at io.druid.cli.Main.main(Main.java:105)

can you please help me with this issue?

Thanks

Karteek