WSO2 API Manager Analytics "Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS'WSO2 API Manager - Sharing registryWSO2 APIM 2.0 Clustering deployment issue when deploy sample APIWSO2 API Manager authentication Violation of UNIQUE KEY constraint errorWSO2 API Manager 2.1 Analytics - Fails to Start up while connecting to Oracle DBWSO2 Identity server as key manager 5.3.0 with AM 2.1.0WSO2 APIM Analytics server setup issueChange password in WSO2 AM-Analyticsorg.wso2.carbon.apimgt.gateway.handlers.security.APISecurityException: Error while accessing backend services for API key validationNot able to validate token when using pre-packaged wso2 identity server as key manager for wso2 api managerCannot change credentials for wso2 api manager Analytics
What happens if nobody can form a government in Israel?
Should I complain to HR about being mocked for request I made
Is there any reason nowadays to use a neon indicator lamp instead of an LED?
What is the need of methods like GET and POST in the HTTP protocol?
Does wetting a beer glass change the foam characteristics?
Social leper versus social leopard
How to make interviewee comfortable interviewing in lounge chairs
How to conditionally load a package only if shell-escape (write18) is passed
To what extent is it worthwhile to report check fraud / refund scams?
What do you do if you have developments on your paper during the long peer review process?
Is it a good idea to leave minor world details to the reader's imagination?
How much Damage can be done with "just" heating matter?
The quicker I go up, the sooner I’ll go down - Riddle
If the EU does not offer an extension to UK's Article 50 invocation, is the Benn Bill irrelevant?
Is It Possible to Have Different Sea Levels, Eventually Causing New Landforms to Appear?
As an employer, can I compel my employees to vote?
Did Apollo carry and use WD40?
Do the villains know Batman has no superpowers?
Is it possible to encode a message in such a way that can only be read by someone or something capable of seeing into the very near future?
What is the meaning of "heutig" in this sentence?
Does the Orange League not count as an official Pokemon League, making the Alolan League his first-ever win?
Is it more effective to add yeast before or after kneading?
Why is there is no screening for Ovarian Cancer?
Worms crawling under skin
WSO2 API Manager Analytics "Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS'
WSO2 API Manager - Sharing registryWSO2 APIM 2.0 Clustering deployment issue when deploy sample APIWSO2 API Manager authentication Violation of UNIQUE KEY constraint errorWSO2 API Manager 2.1 Analytics - Fails to Start up while connecting to Oracle DBWSO2 Identity server as key manager 5.3.0 with AM 2.1.0WSO2 APIM Analytics server setup issueChange password in WSO2 AM-Analyticsorg.wso2.carbon.apimgt.gateway.handlers.security.APISecurityException: Error while accessing backend services for API key validationNot able to validate token when using pre-packaged wso2 identity server as key manager for wso2 api managerCannot change credentials for wso2 api manager Analytics
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
We are using WSO2 API Manager Analytics with a clustered API Manager configuration.
We have only a worker and a dashboard (API Manager Analytics).
After some times, we have this error
ERROR org.wso2.siddhi.core.stream.input.source.InputEventHandler - Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY' Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY'
at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:438)
at org.wso2.siddhi.core.table.record.AbstractRecordTable.add(AbstractRecordTable.java:98)
at org.wso2.siddhi.core.table.Table.addEvents(Table.java:139)
at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchEvents(IncrementalExecutor.java:244)
at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchAggregateEvents(IncrementalExecutor.java:212)
at org.wso2.siddhi.core.aggregation.IncrementalExecutor.execute(IncrementalExecutor.java:119)
at org.wso2.siddhi.core.aggregation.AggregationRuntime.processEvents(AggregationRuntime.java:350)
at org.wso2.siddhi.core.aggregation.IncrementalAggregationProcessor.process(IncrementalAggregationProcessor.java:91)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.processAndClear(ProcessStreamReceiver.java:186)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.process(ProcessStreamReceiver.java:96)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.receive(ProcessStreamReceiver.java:132)
at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:179)
at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:380)
at org.wso2.siddhi.core.stream.input.InputDistributor.send(InputDistributor.java:34)
at org.wso2.siddhi.core.stream.input.InputEntryValve.send(InputEntryValve.java:44)
at org.wso2.siddhi.core.stream.input.InputHandler.send(InputHandler.java:61)
at org.wso2.siddhi.core.stream.input.source.PassThroughSourceHandler.sendEvent(PassThroughSourceHandler.java:35)
at org.wso2.siddhi.core.stream.input.source.InputEventHandler.sendEvent(InputEventHandler.java:76)
at org.wso2.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66)
at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136)
at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66)
at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110)
at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117)
at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41)
at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95)
at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135)
at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74)
at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165)
at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54)
at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72)
at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156)
at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375)
at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56)
at org.wso2.siddhi.core.query.output.ratelimit.OutputRateLimiter.sendToCallBacks(OutputRateLimiter.java:88)
at org.wso2.siddhi.core.query.output.ratelimit.PassThroughOutputRateLimiter.process(PassThroughOutputRateLimiter.java:46)
at org.wso2.siddhi.core.query.selector.QuerySelector.process(QuerySelector.java:98)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.processAndClear(ProcessStreamReceiver.java:186)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.process(ProcessStreamReceiver.java:96)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.receive(ProcessStreamReceiver.java:132)
at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:179)
at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:380)
at org.wso2.siddhi.core.stream.input.InputDistributor.send(InputDistributor.java:34)
at org.wso2.siddhi.core.stream.input.InputEntryValve.send(InputEntryValve.java:44)
at org.wso2.siddhi.core.stream.input.InputHandler.send(InputHandler.java:61)
at org.wso2.siddhi.core.stream.input.source.PassThroughSourceHandler.sendEvent(PassThroughSourceHandler.java:35)
at org.wso2.siddhi.core.stream.input.source.InputEventHandler.sendEvent(InputEventHandler.java:76)
at org.wso2.extension.siddhi.map.wso2event.source.WSO2SourceMapper.mapAndProcess(WSO2SourceMapper.java:227)
at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136)
at org.wso2.extension.siddhi.io.wso2event.source.AgentCallbackImpl.receive(AgentCallbackImpl.java:72)
at org.wso2.carbon.databridge.core.internal.queue.QueueWorker.run(QueueWorker.java:80)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.BatchUpdateException: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
at sun.reflect.GeneratedConstructorAccessor81.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.cj.util.Util.handleNewInstance(Util.java:191)
at com.mysql.cj.util.Util.getInstance(Util.java:166)
at com.mysql.cj.util.Util.getInstance(Util.java:173)
at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:870)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:452)
at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814)
at com.zaxxer.hikari.proxy.StatementProxy.executeBatch(StatementProxy.java:127)
at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeBatch(HikariPreparedStatementProxy.java)
at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchExecuteQueriesWithRecords(RDBMSEventTable.java:1198)
at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:435)
... 54 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1109)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:849)
... 60 more
We are using MySQL as database.
At the beginning, we have supposed this problem was caused by the gateways. Anyway, even if we turn off one of these two gateways the problem happens again.
Thank you for your support!
wso2 wso2-am
add a comment
|
We are using WSO2 API Manager Analytics with a clustered API Manager configuration.
We have only a worker and a dashboard (API Manager Analytics).
After some times, we have this error
ERROR org.wso2.siddhi.core.stream.input.source.InputEventHandler - Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY' Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY'
at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:438)
at org.wso2.siddhi.core.table.record.AbstractRecordTable.add(AbstractRecordTable.java:98)
at org.wso2.siddhi.core.table.Table.addEvents(Table.java:139)
at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchEvents(IncrementalExecutor.java:244)
at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchAggregateEvents(IncrementalExecutor.java:212)
at org.wso2.siddhi.core.aggregation.IncrementalExecutor.execute(IncrementalExecutor.java:119)
at org.wso2.siddhi.core.aggregation.AggregationRuntime.processEvents(AggregationRuntime.java:350)
at org.wso2.siddhi.core.aggregation.IncrementalAggregationProcessor.process(IncrementalAggregationProcessor.java:91)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.processAndClear(ProcessStreamReceiver.java:186)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.process(ProcessStreamReceiver.java:96)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.receive(ProcessStreamReceiver.java:132)
at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:179)
at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:380)
at org.wso2.siddhi.core.stream.input.InputDistributor.send(InputDistributor.java:34)
at org.wso2.siddhi.core.stream.input.InputEntryValve.send(InputEntryValve.java:44)
at org.wso2.siddhi.core.stream.input.InputHandler.send(InputHandler.java:61)
at org.wso2.siddhi.core.stream.input.source.PassThroughSourceHandler.sendEvent(PassThroughSourceHandler.java:35)
at org.wso2.siddhi.core.stream.input.source.InputEventHandler.sendEvent(InputEventHandler.java:76)
at org.wso2.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66)
at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136)
at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66)
at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110)
at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117)
at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41)
at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95)
at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135)
at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74)
at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165)
at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54)
at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72)
at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156)
at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375)
at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56)
at org.wso2.siddhi.core.query.output.ratelimit.OutputRateLimiter.sendToCallBacks(OutputRateLimiter.java:88)
at org.wso2.siddhi.core.query.output.ratelimit.PassThroughOutputRateLimiter.process(PassThroughOutputRateLimiter.java:46)
at org.wso2.siddhi.core.query.selector.QuerySelector.process(QuerySelector.java:98)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.processAndClear(ProcessStreamReceiver.java:186)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.process(ProcessStreamReceiver.java:96)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.receive(ProcessStreamReceiver.java:132)
at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:179)
at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:380)
at org.wso2.siddhi.core.stream.input.InputDistributor.send(InputDistributor.java:34)
at org.wso2.siddhi.core.stream.input.InputEntryValve.send(InputEntryValve.java:44)
at org.wso2.siddhi.core.stream.input.InputHandler.send(InputHandler.java:61)
at org.wso2.siddhi.core.stream.input.source.PassThroughSourceHandler.sendEvent(PassThroughSourceHandler.java:35)
at org.wso2.siddhi.core.stream.input.source.InputEventHandler.sendEvent(InputEventHandler.java:76)
at org.wso2.extension.siddhi.map.wso2event.source.WSO2SourceMapper.mapAndProcess(WSO2SourceMapper.java:227)
at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136)
at org.wso2.extension.siddhi.io.wso2event.source.AgentCallbackImpl.receive(AgentCallbackImpl.java:72)
at org.wso2.carbon.databridge.core.internal.queue.QueueWorker.run(QueueWorker.java:80)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.BatchUpdateException: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
at sun.reflect.GeneratedConstructorAccessor81.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.cj.util.Util.handleNewInstance(Util.java:191)
at com.mysql.cj.util.Util.getInstance(Util.java:166)
at com.mysql.cj.util.Util.getInstance(Util.java:173)
at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:870)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:452)
at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814)
at com.zaxxer.hikari.proxy.StatementProxy.executeBatch(StatementProxy.java:127)
at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeBatch(HikariPreparedStatementProxy.java)
at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchExecuteQueriesWithRecords(RDBMSEventTable.java:1198)
at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:435)
... 54 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1109)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:849)
... 60 more
We are using MySQL as database.
At the beginning, we have supposed this problem was caused by the gateways. Anyway, even if we turn off one of these two gateways the problem happens again.
Thank you for your support!
wso2 wso2-am
add a comment
|
We are using WSO2 API Manager Analytics with a clustered API Manager configuration.
We have only a worker and a dashboard (API Manager Analytics).
After some times, we have this error
ERROR org.wso2.siddhi.core.stream.input.source.InputEventHandler - Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY' Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY'
at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:438)
at org.wso2.siddhi.core.table.record.AbstractRecordTable.add(AbstractRecordTable.java:98)
at org.wso2.siddhi.core.table.Table.addEvents(Table.java:139)
at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchEvents(IncrementalExecutor.java:244)
at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchAggregateEvents(IncrementalExecutor.java:212)
at org.wso2.siddhi.core.aggregation.IncrementalExecutor.execute(IncrementalExecutor.java:119)
at org.wso2.siddhi.core.aggregation.AggregationRuntime.processEvents(AggregationRuntime.java:350)
at org.wso2.siddhi.core.aggregation.IncrementalAggregationProcessor.process(IncrementalAggregationProcessor.java:91)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.processAndClear(ProcessStreamReceiver.java:186)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.process(ProcessStreamReceiver.java:96)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.receive(ProcessStreamReceiver.java:132)
at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:179)
at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:380)
at org.wso2.siddhi.core.stream.input.InputDistributor.send(InputDistributor.java:34)
at org.wso2.siddhi.core.stream.input.InputEntryValve.send(InputEntryValve.java:44)
at org.wso2.siddhi.core.stream.input.InputHandler.send(InputHandler.java:61)
at org.wso2.siddhi.core.stream.input.source.PassThroughSourceHandler.sendEvent(PassThroughSourceHandler.java:35)
at org.wso2.siddhi.core.stream.input.source.InputEventHandler.sendEvent(InputEventHandler.java:76)
at org.wso2.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66)
at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136)
at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66)
at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110)
at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117)
at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41)
at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95)
at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135)
at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74)
at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165)
at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54)
at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72)
at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156)
at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375)
at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56)
at org.wso2.siddhi.core.query.output.ratelimit.OutputRateLimiter.sendToCallBacks(OutputRateLimiter.java:88)
at org.wso2.siddhi.core.query.output.ratelimit.PassThroughOutputRateLimiter.process(PassThroughOutputRateLimiter.java:46)
at org.wso2.siddhi.core.query.selector.QuerySelector.process(QuerySelector.java:98)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.processAndClear(ProcessStreamReceiver.java:186)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.process(ProcessStreamReceiver.java:96)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.receive(ProcessStreamReceiver.java:132)
at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:179)
at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:380)
at org.wso2.siddhi.core.stream.input.InputDistributor.send(InputDistributor.java:34)
at org.wso2.siddhi.core.stream.input.InputEntryValve.send(InputEntryValve.java:44)
at org.wso2.siddhi.core.stream.input.InputHandler.send(InputHandler.java:61)
at org.wso2.siddhi.core.stream.input.source.PassThroughSourceHandler.sendEvent(PassThroughSourceHandler.java:35)
at org.wso2.siddhi.core.stream.input.source.InputEventHandler.sendEvent(InputEventHandler.java:76)
at org.wso2.extension.siddhi.map.wso2event.source.WSO2SourceMapper.mapAndProcess(WSO2SourceMapper.java:227)
at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136)
at org.wso2.extension.siddhi.io.wso2event.source.AgentCallbackImpl.receive(AgentCallbackImpl.java:72)
at org.wso2.carbon.databridge.core.internal.queue.QueueWorker.run(QueueWorker.java:80)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.BatchUpdateException: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
at sun.reflect.GeneratedConstructorAccessor81.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.cj.util.Util.handleNewInstance(Util.java:191)
at com.mysql.cj.util.Util.getInstance(Util.java:166)
at com.mysql.cj.util.Util.getInstance(Util.java:173)
at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:870)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:452)
at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814)
at com.zaxxer.hikari.proxy.StatementProxy.executeBatch(StatementProxy.java:127)
at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeBatch(HikariPreparedStatementProxy.java)
at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchExecuteQueriesWithRecords(RDBMSEventTable.java:1198)
at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:435)
... 54 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1109)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:849)
... 60 more
We are using MySQL as database.
At the beginning, we have supposed this problem was caused by the gateways. Anyway, even if we turn off one of these two gateways the problem happens again.
Thank you for your support!
wso2 wso2-am
We are using WSO2 API Manager Analytics with a clustered API Manager configuration.
We have only a worker and a dashboard (API Manager Analytics).
After some times, we have this error
ERROR org.wso2.siddhi.core.stream.input.source.InputEventHandler - Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY' Error in applying transport property mapping for 'inMemory' source at 'Request' stream. org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on 'APIM_ACCESS_SUMMARY'. Error in adding events to 'ApiUserPerAppAgg_SECONDS' store: Duplicate entry '1553785980000-1553785980000-/parix/2.0-api-extgw.umbriadigitale.' for key 'PRIMARY'
at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:438)
at org.wso2.siddhi.core.table.record.AbstractRecordTable.add(AbstractRecordTable.java:98)
at org.wso2.siddhi.core.table.Table.addEvents(Table.java:139)
at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchEvents(IncrementalExecutor.java:244)
at org.wso2.siddhi.core.aggregation.IncrementalExecutor.dispatchAggregateEvents(IncrementalExecutor.java:212)
at org.wso2.siddhi.core.aggregation.IncrementalExecutor.execute(IncrementalExecutor.java:119)
at org.wso2.siddhi.core.aggregation.AggregationRuntime.processEvents(AggregationRuntime.java:350)
at org.wso2.siddhi.core.aggregation.IncrementalAggregationProcessor.process(IncrementalAggregationProcessor.java:91)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.processAndClear(ProcessStreamReceiver.java:186)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.process(ProcessStreamReceiver.java:96)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.receive(ProcessStreamReceiver.java:132)
at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:179)
at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:380)
at org.wso2.siddhi.core.stream.input.InputDistributor.send(InputDistributor.java:34)
at org.wso2.siddhi.core.stream.input.InputEntryValve.send(InputEntryValve.java:44)
at org.wso2.siddhi.core.stream.input.InputHandler.send(InputHandler.java:61)
at org.wso2.siddhi.core.stream.input.source.PassThroughSourceHandler.sendEvent(PassThroughSourceHandler.java:35)
at org.wso2.siddhi.core.stream.input.source.InputEventHandler.sendEvent(InputEventHandler.java:76)
at org.wso2.siddhi.core.stream.input.source.PassThroughSourceMapper.mapAndProcess(PassThroughSourceMapper.java:66)
at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136)
at org.wso2.siddhi.core.stream.input.source.InMemorySource$1.onMessage(InMemorySource.java:66)
at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.broadcast(InMemoryBroker.java:110)
at org.wso2.siddhi.core.util.transport.InMemoryBroker$MessageBroker.publish(InMemoryBroker.java:117)
at org.wso2.siddhi.core.util.transport.InMemoryBroker.publish(InMemoryBroker.java:41)
at org.wso2.siddhi.core.stream.output.sink.InMemorySink.publish(InMemorySink.java:95)
at org.wso2.siddhi.core.stream.output.sink.Sink.publish(Sink.java:135)
at org.wso2.siddhi.core.stream.output.sink.PassThroughSinkMapper.mapAndSend(PassThroughSinkMapper.java:74)
at org.wso2.siddhi.core.stream.output.sink.SinkMapper.mapAndSend(SinkMapper.java:165)
at org.wso2.siddhi.core.stream.output.sink.SinkCallback.receive(SinkCallback.java:54)
at org.wso2.siddhi.core.stream.output.StreamCallback.receive(StreamCallback.java:72)
at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:156)
at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:375)
at org.wso2.siddhi.core.query.output.callback.InsertIntoStreamCallback.send(InsertIntoStreamCallback.java:56)
at org.wso2.siddhi.core.query.output.ratelimit.OutputRateLimiter.sendToCallBacks(OutputRateLimiter.java:88)
at org.wso2.siddhi.core.query.output.ratelimit.PassThroughOutputRateLimiter.process(PassThroughOutputRateLimiter.java:46)
at org.wso2.siddhi.core.query.selector.QuerySelector.process(QuerySelector.java:98)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.processAndClear(ProcessStreamReceiver.java:186)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.process(ProcessStreamReceiver.java:96)
at org.wso2.siddhi.core.query.input.ProcessStreamReceiver.receive(ProcessStreamReceiver.java:132)
at org.wso2.siddhi.core.stream.StreamJunction.sendEvent(StreamJunction.java:179)
at org.wso2.siddhi.core.stream.StreamJunction$Publisher.send(StreamJunction.java:380)
at org.wso2.siddhi.core.stream.input.InputDistributor.send(InputDistributor.java:34)
at org.wso2.siddhi.core.stream.input.InputEntryValve.send(InputEntryValve.java:44)
at org.wso2.siddhi.core.stream.input.InputHandler.send(InputHandler.java:61)
at org.wso2.siddhi.core.stream.input.source.PassThroughSourceHandler.sendEvent(PassThroughSourceHandler.java:35)
at org.wso2.siddhi.core.stream.input.source.InputEventHandler.sendEvent(InputEventHandler.java:76)
at org.wso2.extension.siddhi.map.wso2event.source.WSO2SourceMapper.mapAndProcess(WSO2SourceMapper.java:227)
at org.wso2.siddhi.core.stream.input.source.SourceMapper.onEvent(SourceMapper.java:136)
at org.wso2.extension.siddhi.io.wso2event.source.AgentCallbackImpl.receive(AgentCallbackImpl.java:72)
at org.wso2.carbon.databridge.core.internal.queue.QueueWorker.run(QueueWorker.java:80)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.BatchUpdateException: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
at sun.reflect.GeneratedConstructorAccessor81.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.cj.util.Util.handleNewInstance(Util.java:191)
at com.mysql.cj.util.Util.getInstance(Util.java:166)
at com.mysql.cj.util.Util.getInstance(Util.java:173)
at com.mysql.cj.jdbc.exceptions.SQLError.createBatchUpdateException(SQLError.java:224)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:870)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchInternal(ClientPreparedStatement.java:452)
at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:814)
at com.zaxxer.hikari.proxy.StatementProxy.executeBatch(StatementProxy.java:127)
at com.zaxxer.hikari.proxy.HikariPreparedStatementProxy.executeBatch(HikariPreparedStatementProxy.java)
at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchExecuteQueriesWithRecords(RDBMSEventTable.java:1198)
at org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.add(RDBMSEventTable.java:435)
... 54 more
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '1553785980000-1553785980000-/api/2.0-api-extgw.xxxx.' for key 'PRIMARY'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1109)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeBatchSerially(ClientPreparedStatement.java:849)
... 60 more
We are using MySQL as database.
At the beginning, we have supposed this problem was caused by the gateways. Anyway, even if we turn off one of these two gateways the problem happens again.
Thank you for your support!
wso2 wso2-am
wso2 wso2-am
asked Mar 28 at 15:34
FrancescoAzzolaFrancescoAzzola
2,1382 gold badges11 silver badges21 bronze badges
2,1382 gold badges11 silver badges21 bronze badges
add a comment
|
add a comment
|
1 Answer
1
active
oldest
votes
FrancescoAzzola, this could be due to the data conflict. If you used a previously used APIM_ANALYTICS_DB, can you please point to a new Database. Also, you can truncate data if test data are no longer required.
add a comment
|
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55401515%2fwso2-api-manager-analytics-error-on-apim-access-summary-error-in-adding-even%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
FrancescoAzzola, this could be due to the data conflict. If you used a previously used APIM_ANALYTICS_DB, can you please point to a new Database. Also, you can truncate data if test data are no longer required.
add a comment
|
FrancescoAzzola, this could be due to the data conflict. If you used a previously used APIM_ANALYTICS_DB, can you please point to a new Database. Also, you can truncate data if test data are no longer required.
add a comment
|
FrancescoAzzola, this could be due to the data conflict. If you used a previously used APIM_ANALYTICS_DB, can you please point to a new Database. Also, you can truncate data if test data are no longer required.
FrancescoAzzola, this could be due to the data conflict. If you used a previously used APIM_ANALYTICS_DB, can you please point to a new Database. Also, you can truncate data if test data are no longer required.
answered Mar 29 at 9:21
ruksruks
1371 silver badge5 bronze badges
1371 silver badge5 bronze badges
add a comment
|
add a comment
|
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55401515%2fwso2-api-manager-analytics-error-on-apim-access-summary-error-in-adding-even%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown