I am seeing similar error on druid 0.11.0:
```
[ 2018-09-21T00:58:57.401Z ] WARN - io.druid.java.util.common.RetryUtils -
Failed on try 6, retrying in 20,194ms.
org.skife.jdbi.v2.exceptions.CallbackFailedException:
org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Duplicate entry
'location_updated_2018-09-20T18:00:00.000Z_2018-09-20T19:00:00.00' for key
'PRIMARY' [statement:\"INSERT INTO druid_pendingSegments (id, dataSource,
created_date, start, `end`, sequence_name, sequence_prev_id,
sequence_name_prev_id_sha1, payload) VALUES (:id, :dataSource, :created_date,
:start, :end, :sequence_name, :sequence_prev_id,
:sequence_name_prev_id_sha1,:payload)\", located:\"INSERT INTO
druid_pendingSegments (id, dataSource, created_date, start, `end`,
sequence_name, sequence_prev_id, sequence_name_prev_id_sha1, payload) VALUES
(:id, :dataSource, :created_date, :start, :end, :sequence_name,
:sequence_prev_id, :sequence_name_prev_id_sha1, :payload)\", rewri
tten:\"INSERT INTO druid_pendingSegments (id, dataSource, created_date, start,
`end`, sequence_name, sequence_prev_id, sequence_name_prev_id_sha1, payload)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\", arguments:{ positional:{},
named:{sequence_prev_id:'',payload:[123, 34, 100, 97, 116, 97, 83, 111, 117,
114, 99, 101, 34, 58, 34, 108, 111, 99, 97, 116, 105, 111, 110, 95, 117, 112,
100, 97, 116, 101, 100, 34, 44, 34, 105, 110, 116, 101, 114, 118, 97, 108, 34,
58, 34, 50, 48, 49, 56, 45, 48, 57, 45, 50, 48, 84, 49, 56, 58, 48, 48, 58, 48,
48, 46, 48, 48, 48, 90, 47, 50, 48, 49, 56, 45, 48, 57, 45, 50, 48, 84, 49, 57,
58, 48, 48, 58, 48, 48, 46, 48, 48, 48, 90, 34, 44, 34, 118, 101, 114, 115,
105, 111, 110, 34, 58, 34, 50, 48, 49, 56, 45, 48, 57, 45, 50, 48, 84, 49, 56,
58, 48, 48, 58, 48, 48, 46, 53, 50, 54, 90, 34, 44, 34, 115, 104, 97, 114, 100,
83, 112, 101, 99, 34, 58, 123, 34, 116, 121, 112, 101, 34, 58, 34, 110, 117,
109, 98, 101, 114, 101, 100, 34, 44, 34, 112, 97, 114, 116, 105, 116,
105, 111, 110, 78, 117, 109, 34, 58, 55, 49, 44, 34, 112, 97, 114, 116, 105,
116, 105, 111, 110, 115, 34, 58, 48, 125,
125],start:'2018-09-20T18:00:00.000Z',end:'2018-09-20T19:00:00.000Z',id:'location_updated_2018-09-20T18:00:00.000Z_2018-09-20T19:00:00.000Z_2018-09-20T18:00:00.526Z_71',created_date:'2018-09-21T00:58:57.397Z',dataSource:'location_updated',sequence_name:'index_kafka_location_updated_408db328f185145_22',sequence_name_prev_id_sha1:'A628E20131F12D1E21E9E04AE237E0589B694F72'},
finder:[]}]
at org.skife.jdbi.v2.DBI.withHandle(DBI.java:284)
at org.skife.jdbi.v2.DBI.inTransaction(DBI.java:329)
at
io.druid.metadata.SQLMetadataConnector$3.call(SQLMetadataConnector.java:156)
at io.druid.java.util.common.RetryUtils.retry(RetryUtils.java:63)
at
io.druid.metadata.SQLMetadataConnector.retryTransaction(SQLMetadataConnector.java:160)
at
io.druid.metadata.IndexerSQLMetadataStorageCoordinator.allocatePendingSegment(IndexerSQLMetadataStorageCoordinator.java:398)
at
io.druid.indexing.common.actions.SegmentAllocateAction.perform(SegmentAllocateAction.java:179)
at
io.druid.indexing.common.actions.SegmentAllocateAction.perform(SegmentAllocateAction.java:54)
at
io.druid.indexing.common.actions.LocalTaskActionClient.submit(LocalTaskActionClient.java:64)
at
io.druid.indexing.overlord.http.OverlordResource$3.apply(OverlordResource.java:339)
at
io.druid.indexing.overlord.http.OverlordResource$3.apply(OverlordResource.java:328)
at
io.druid.indexing.overlord.http.OverlordResource.asLeaderWith(OverlordResource.java:635)
at
io.druid.indexing.overlord.http.OverlordResource.doAction(OverlordResource.java:325)
at sun.reflect.GeneratedMethodAccessor64.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
at
com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)
at
com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
at
com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
at
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at
com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
at
com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at
com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
at
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
at
com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
at
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
at
com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
at
com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
at
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:558)
at
com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:733)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at
com.google.inject.servlet.ServletDefinition.doServiceImpl(ServletDefinition.java:286)
at
com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:276)
at
com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:181)
at
com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)
at
com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:85)
at
com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:120)
at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:135)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1759)
at io.druid.server.http.RedirectFilter.doFilter(RedirectFilter.java:72)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1759)
at
io.druid.server.security.PreResponseAuthorizationCheckFilter.doFilter(PreResponseAuthorizationCheckFilter.java:84)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1759)
at
io.druid.server.security.AllowAllAuthenticator$1.doFilter(AllowAllAuthenticator.java:85)
at
io.druid.server.security.AuthenticationWrappingFilter.doFilter(AuthenticationWrappingFilter.java:60)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1759)
at
io.druid.server.security.SecuritySanityCheckFilter.doFilter(SecuritySanityCheckFilter.java:86)
at
org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1759)
at
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:582)
at
org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224)
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180)
at
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:512)
at
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at
org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:493)
at
org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
at org.eclipse.jetty.server.Server.handle(Server.java:534)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:320)
at
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
at
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108)
at
org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
at
org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
at
org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
at
org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)
at
org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Duplicate entry
'location_updated_2018-09-20T18:00:00.000Z_2018-09-20T19:00:00.00' for key
'PRIMARY' [statement:\"INSERT INTO druid_pendingSegments (id, dataSource,
created_date, start, `end`, sequence_name, sequence_prev_id,
sequence_name_prev_id_sha1, payload) VALUES (:id, :dataSource, :created_date,
:start, :end, :sequence_name, :sequence_prev_id, :sequence_name_prev_id_sha1,
:payload)\", located:\"INSERT INTO druid_pendingSegments (id, dataSource,
created_date, start, `end`, sequence_name, sequence_prev_id,
sequence_name_prev_id_sha1, payload) VALUES (:id, :dataSource, :created_date,
:start, :end, :sequence_name, :sequence_prev_id, :sequence_name_prev_id_sha1,
:payload)\", rewritten:\"INSERT INTO druid_pendingSegments (id, dataSource,
created_date, start, `end`, sequence_name, sequence_prev_id,
sequence_name_prev_id_sha1, payload)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\", arguments:{ positional:{},
named:{sequence_prev_id:'',payload:[123, 34, 100, 97, 116, 97, 83, 111, 117,
114, 99, 101, 34, 58, 34, 108, 111, 99, 97, 116, 105, 111, 110, 95, 117, 112,
100, 97, 116, 101, 100, 34, 44, 34, 105, 110, 116, 101, 114, 118, 97, 108, 34,
58, 34, 50, 48, 49, 56, 45, 48, 57, 45, 50, 48, 84, 49, 56, 58, 48, 48, 58, 48,
48, 46, 48, 48, 48, 90, 47, 50, 48, 49, 56, 45, 48, 57, 45, 50, 48, 84, 49, 57,
58, 48, 48, 58, 48, 48, 46, 48, 48, 48, 90, 34, 44, 34, 118, 101, 114, 115,
105, 111, 110, 34, 58, 34, 50, 48, 49, 56, 45, 48, 57, 45, 50, 48, 84, 49, 56,
58, 48, 48, 58, 48, 48, 46, 53, 50, 54, 90, 34, 44, 34, 115, 104, 97, 114, 100,
83, 112, 101, 99, 34, 58, 123, 34, 116, 121, 112, 101, 34, 58, 34, 110, 117,
109, 98, 101, 114, 101, 100, 34, 44, 34, 112, 97, 114, 116, 105, 116, 105, 111,
110, 78, 117, 109, 34, 58, 55, 49, 44, 34, 112, 97, 114, 116, 105, 116, 105,
111, 110, 115, 34, 58, 48, 125, 125],start:'2018-09-20T18:00:00.000Z'
,end:'2018-09-20T19:00:00.000Z',id:'location_updated_2018-09-20T18:00:00.000Z_2018-09-20T19:00:00.000Z_2018-09-20T18:00:00.526Z_71',created_date:'2018-09-21T00:58:57.397Z',dataSource:'location_updated',sequence_name:'index_kafka_location_updated_408db328f185145_22',sequence_name_prev_id_sha1:'A628E20131F12D1E21E9E04AE237E0589B694F72'},
finder:[]}]
at
org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1334)
at org.skife.jdbi.v2.Update.execute(Update.java:56)
at
io.druid.metadata.IndexerSQLMetadataStorageCoordinator$3.inTransaction(IndexerSQLMetadataStorageCoordinator.java:579)
at
io.druid.metadata.IndexerSQLMetadataStorageCoordinator$3.inTransaction(IndexerSQLMetadataStorageCoordinator.java:400)
at
org.skife.jdbi.v2.tweak.transactions.LocalTransactionHandler.inTransaction(LocalTransactionHandler.java:184)
at org.skife.jdbi.v2.BasicHandle.inTransaction(BasicHandle.java:327)
at org.skife.jdbi.v2.DBI$5.withHandle(DBI.java:333)
at org.skife.jdbi.v2.DBI.withHandle(DBI.java:281)
... 70 more
Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Duplicate entry
'location_updated_2018-09-20T18:00:00.000Z_2018-09-20T19:00:00.00' for key
'PRIMARY'
at sun.reflect.GeneratedConstructorAccessor139.newInstance(Unknown
Source)
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:404)
at com.mysql.jdbc.Util.getInstance(Util.java:387)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:932)
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)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:198)
at
org.skife.jdbi.v2.SQLStatement.internalExecute(SQLStatement.java:1328)
... 77 more
```
[ Full content available at:
https://github.com/apache/incubator-druid/issues/5498 ]
This message was relayed via gitbox.apache.org for [email protected]
