Postgresql error on overlord node

I try to use postgresql as the metadata store and exactly follow the instruction in: http://druid.io/docs/latest/development/extensions-core/postgresql.html

But I saw the error below in the overlord log file and it looks like i might miss some configuration setup (create a table “druid_tasks” manually?)but I do not know what exactly I should do. I am using postgresql 9.5

Thanks in advance.

2017-08-23T17:14:06,259 WARN [Curator-LeaderSelector-0] io.druid.java.util.common.RetryUtils - Failed on try 7, retrying in 41,793ms.

org.skife.jdbi.v2.exceptions.CallbackFailedException: org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException: org.postgresql.util.PSQLException: ERROR: relation “druid_tasks” does not exist

Position: 41 [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.0-iap5.jar:0.10.0-iap5]

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

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

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

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

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

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

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

at io.druid.indexing.overlord.TaskMaster$1.takeLeadership(TaskMaster.java:110) [druid-indexing-service-0.10.0-iap5.jar:0.10.0-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_131]

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

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

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_131]

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

at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]

Caused by: org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException: org.postgresql.util.PSQLException: ERROR: relation “druid_tasks” does not exist

Position: 41 [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:257) ~[druid-server-0.10.0-iap5.jar:0.10.0-iap5]

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

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

… 21 more

Caused by: org.postgresql.util.PSQLException: ERROR: relation “druid_tasks” does not exist

Position: 41

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2284) ~[?:?]

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2003) ~[?:?]

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:200) ~[?:?]

at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:424) ~[?:?]

at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:161) ~[?:?]

at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:155) ~[?:?]

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:257) ~[druid-server-0.10.0-iap5.jar:0.10.0-iap5]

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

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

… 21 more

Good day, I just noticed that I have the same issue. We are using the Kafka Indexing service (That may be irrelevant, but I don’t remember seeing that while using the batch import).

Joel