Table 'druid.druid_tasks' doesn't exist after proper MySQL setup also

Hi,

After i set

[mysqld]

character-set-server = utf8

show_compatibility_56 = on

Still druid unable to create table.

2017-12-01T13:23:46,211 WARN [Curator-LeaderSelector-0] io.druid.java.util.common.RetryUtils - Failed on try 6, retrying in 33,140ms.

org.skife.jdbi.v2.exceptions.CallbackFailedException: org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘druid.druid_tasks’ doesn’t exist [statement:“SELECT id, payload, status_payload FROM druid_tasks WHERE active = TRUE ORDER BY created_date”, located:“SELECT id, payload, status_payload FROM druid_tasks WHERE active = TRUE ORDER BY created_date”, rewritten:“SELECT id, payload, status_payload FROM druid_tasks WHERE active = TRUE ORDER BY created_date”, arguments:{ positional:{}, named:{}, finder:}]

at org.skife.jdbi.v2.DBI.withHandle(DBI.java:284) ~[jdbi-2.63.1.jar:2.63.1]

at io.druid.metadata.SQLMetadataConnector$2.call(SQLMetadataConnector.java:129) ~[druid-server-0.10.1-iap5.jar:0.10.1-iap5]

at io.druid.java.util.common.RetryUtils.retry(RetryUtils.java:63) [java-util-0.10.1-iap5.jar:0.10.1-iap5]

at io.druid.java.util.common.RetryUtils.retry(RetryUtils.java:81) [java-util-0.10.1-iap5.jar:0.10.1-iap5]

at io.druid.metadata.SQLMetadataConnector.retryWithHandle(SQLMetadataConnector.java:133) [druid-server-0.10.1-iap5.jar:0.10.1-iap5]

at io.druid.metadata.SQLMetadataConnector.retryWithHandle(SQLMetadataConnector.java:142) [druid-server-0.10.1-iap5.jar:0.10.1-iap5]

at io.druid.metadata.SQLMetadataStorageActionHandler.getActiveEntriesWithStatus(SQLMetadataStorageActionHandler.java:224) [druid-server-0.10.1-iap5.jar:0.10.1-iap5]

at io.druid.indexing.overlord.MetadataTaskStorage.getActiveTasks(MetadataTaskStorage.java:187) [druid-indexing-service-0.10.1-iap5.jar:0.10.1-iap5]

at io.druid.indexing.overlord.TaskLockbox.syncFromStorage(TaskLockbox.java:96) [druid-indexing-service-0.10.1-iap5.jar:0.10.1-iap5]

at io.druid.indexing.overlord.TaskMaster$1.takeLeadership(TaskMaster.java:110) [druid-indexing-service-0.10.1-iap5.jar:0.10.1-iap5]

at org.apache.curator.framework.recipes.leader.LeaderSelector$WrappedListener.takeLeadership(LeaderSelector.java:534) [curator-recipes-2.11.0.jar:?]

at org.apache.curator.framework.recipes.leader.LeaderSelector.doWork(LeaderSelector.java:399) [curator-recipes-2.11.0.jar:?]

at org.apache.curator.framework.recipes.leader.LeaderSelector.doWorkLoop(LeaderSelector.java:441) [curator-recipes-2.11.0.jar:?]

at org.apache.curator.framework.recipes.leader.LeaderSelector.access$100(LeaderSelector.java:64) [curator-recipes-2.11.0.jar:?]

at org.apache.curator.framework.recipes.leader.LeaderSelector$2.call(LeaderSelector.java:245) [curator-recipes-2.11.0.jar:?]

at org.apache.curator.framework.recipes.leader.LeaderSelector$2.call(LeaderSelector.java:239) [curator-recipes-2.11.0.jar:?]

at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_102]

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_102]

at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_102]

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_102]

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_102]

at java.lang.Thread.run(Thread.java:745) [?:1.8.0_102]

Caused by: org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘druid.druid_tasks’ doesn’t exist [statement:“SELECT id, payload, status_payload FROM druid_tasks WHERE active = TRUE ORDER BY created_date”, located:“SELECT id, payload, status_payload FROM druid_tasks WHERE active = TRUE ORDER BY created_date”, rewritten:“SELECT id, payload, status_payload FROM druid_tasks WHERE active = TRUE ORDER BY created_date”, arguments:{ positional:{}, named:{}, finder:}]

at org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1334) ~[jdbi-2.63.1.jar:2.63.1]

at org.skife.jdbi.v2.Query.fold(Query.java:173) ~[jdbi-2.63.1.jar:2.63.1]

at org.skife.jdbi.v2.Query.list(Query.java:82) ~[jdbi-2.63.1.jar:2.63.1]

at org.skife.jdbi.v2.Query.list(Query.java:75) ~[jdbi-2.63.1.jar:2.63.1]

at io.druid.metadata.SQLMetadataStorageActionHandler$6.withHandle(SQLMetadataStorageActionHandler.java:262) ~[druid-server-0.10.1-iap5.jar:0.10.1-iap5]

at io.druid.metadata.SQLMetadataStorageActionHandler$6.withHandle(SQLMetadataStorageActionHandler.java:226) ~[druid-server-0.10.1-iap5.jar:0.10.1-iap5]

at org.skife.jdbi.v2.DBI.withHandle(DBI.java:281) ~[jdbi-2.63.1.jar:2.63.1]

… 21 more

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘druid.druid_tasks’ doesn’t exist

at sun.reflect.GeneratedConstructorAccessor44.newInstance(Unknown Source) ~[?:?]

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_102]

at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_102]

at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) ~[?:?]

at com.mysql.jdbc.Util.getInstance(Util.java:387) ~[?:?]

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:939) ~[?:?]

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878) ~[?:?]

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814) ~[?:?]

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478) ~[?:?]

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625) ~[?:?]

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2551) ~[?:?]

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861) ~[?:?]

at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1192) ~[?:?]

at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:198) ~[commons-dbcp2-2.0.1.jar:2.0.1]

at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:198) ~[commons-dbcp2-2.0.1.jar:2.0.1]

at org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1328) ~[jdbi-2.63.1.jar:2.63.1]

at org.skife.jdbi.v2.Query.fold(Query.java:173) ~[jdbi-2.63.1.jar:2.63.1]

at org.skife.jdbi.v2.Query.list(Query.java:82) ~[jdbi-2.63.1.jar:2.63.1]

at org.skife.jdbi.v2.Query.list(Query.java:75) ~[jdbi-2.63.1.jar:2.63.1]

at io.druid.metadata.SQLMetadataStorageActionHandler$6.withHandle(SQLMetadataStorageActionHandler.java:262) ~[druid-server-0.10.1-iap5.jar:0.10.1-iap5]

at io.druid.metadata.SQLMetadataStorageActionHandler$6.withHandle(SQLMetadataStorageActionHandler.java:226) ~[druid-server-0.10.1-iap5.jar:0.10.1-iap5]

at org.skife.jdbi.v2.DBI.withHandle(DBI.java:281) ~[jdbi-2.63.1.jar:2.63.1]