Hello,
Globally Analytics recording events but I find this kind of error in the log of
analytics-worker so probably all events are not correctly recorded:
For now I'm using out of the box default H2 DB but we will soon migrate to
postgres DBs.
[2018-11-28 16:30:07,921] ERROR
{org.wso2.siddhi.core.stream.input.source.InputEventHandler} - Error on
'EI_Analytics_StatApp'. Cannot execute update/insert operation (update) on
table 'ConfigEntryTable' with SQL query INSERT INTO ConfigEntryTable
(metaTenantId , hashcode , entryName , configData , eventTimestamp ) VALUES
(?, ?, ?, ?, ?) . Error in applying transport property mapping for 'wso2event'
source at 'ConfigEntryEventStream' stream.
org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on
'EI_Analytics_StatApp'. Cannot execute update/insert operation (update) on
table 'ConfigEntryTable' with SQL query INSERT INTO ConfigEntryTable
(metaTenantId , hashcode , entryName , configData , eventTimestamp ) VALUES
(?, ?, ?, ?, ?) .
at
org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.batchProcessInsert(RDBMSEventTable.java:733)
at
org.wso2.extension.siddhi.store.rdbms.RDBMSEventTable.updateOrAdd(RDBMSEventTable.java:622)
at
org.wso2.siddhi.core.table.record.AbstractRecordTable.updateOrAdd(AbstractRecordTable.java:323)
at org.wso2.siddhi.core.table.Table.updateOrAddEvents(Table.java:288)
at
org.wso2.siddhi.core.query.output.callback.UpdateOrInsertTableCallback.send(UpdateOrInsertTableCallback.java:78)
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: org.h2.jdbc.JdbcBatchUpdateException: Value too long for column
"CONFIGDATA VARCHAR(6000)":
"'[{""id"":""Students-API@0:Students-API"",""parentId"":null,""group"":null},{""id"":""Students-API@1:Resource"",""parentId"":""Students-API@0:S...
(28593)"; SQL statement:
INSERT INTO ConfigEntryTable (metaTenantId , hashcode , entryName , configData
, eventTimestamp ) VALUES (?, ?, ?, ?, ?) [22001-196]
at
org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1234)
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.batchProcessInsert(RDBMSEventTable.java:729)
... 26 more
or
ERROR {org.wso2.siddhi.core.query.processor.stream.AbstractStreamProcessor} -
Error on 'EI_Analytics_StatApp'. Error in adding events to 'ESBEventTable'
store: Value too long for column "BEFOREPAYLOAD VARCHAR(5000)":
"STRINGDECODE('<?xml version=''1.0'' encoding=''utf-8''?><soapenv:Envelope
xmlns:soapenv=\""http://schemas.xmlsoap.org/soap/envelo... (238694)"; SQL
statement:
INSERT INTO ESBEventTable (metaTenantId , messageFlowId , host , hashCode ,
componentName , componentType , componentIndex , componentId , startTime ,
endTime , duration , beforePayload , afterPayload , contextPropertyMap ,
transportPropertyMap , children , entryPoint , entryPointHashcode , faultCount
, eventTimestamp ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?) [22001-196] Dropping event chunk EventChunk{first=StreamEvent{
timestamp=1543485702341, beforeWindowData=[true, -1234,
urn_uuid_e9f191fb-c8e0-4110-809c-c497e22a2b6620029659860835128,
H4sIAAAAAAAAAOy9W48kOZYmttUzEISBsBi0Fgu9CDD0S2YBGZWX3qmtTlTXIDIqKjum84aMrNkBBKFAN6e7M8vczNouURnzD/SofzBvWzEC5qkf9O4/YCAI+74PAvQD9Af
VERY LONG STUFS HERE
buPHu7/RZ8lY99py6So+Pj6P/rmD370rzX19Peu1dO1erpWT+PU06Nr9XStnq7V04Z6euzSJAYO1snHpI5X0sH6Naac/o2mnP7utXK6Vk7Xymmccnp8rZyuldO1ctpQTrt3XbXTmzIvaFmfiy34ZN0+lb3ZX339d5iu+r80XfV3QFf999e66lpXXesq/wblsFNGrpXVtbL6G6GsnOZtgLL6nl8bIFWV8mJ/9fXfZbqqU1LdH3/rWldd66prXTVSV11P09iOrvrra111Vbrq8nmYoqUGB2kMBvzY5pHhvr+H1FM8eqKSCZXVVbTfvtZc15rrWnON1FzXQzO2o7n+23/nWnNdpZcFB+E3IuFnHZ+83nn06MHjnd0paixr0n99WY0xFO7v7e/d/4v/H1I3wlBg9wgA],
onAfterWindowData=[null], outputData=[null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null, null,
null], type=CURRENT, next=null}}, error in processing
org.wso2.extension.siddhi.execution.esbanalytics.decompress.DecompressStreamProcessorExtension.
org.wso2.extension.siddhi.store.rdbms.exception.RDBMSTableException: Error on
'EI_Analytics_StatApp'. Error in adding events to 'ESBEventTable' store: Value
too long for column "BEFOREPAYLOAD VARCHAR(5000)": "STRINGDECODE('<?xml
version=''1.0'' encoding=''utf-8''?><soapenv:Envelope
xmlns:soapenv=\""http://schemas.xmlsoap.org/soap/envelo... (238694)"; SQL
statement:
INSERT INTO ESBEventTable (metaTenantId , messageFlowId , host , hashCode ,
componentName , componentType , componentIndex , componentId , startTime ,
endTime , duration , beforePayload , afterPayload , contextPropertyMap ,
transportPropertyMap , children , entryPoint , entryPointHashcode , faultCount
, eventTimestamp ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?) [22001-196]
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.query.output.callback.InsertIntoTableCallback.send(InsertIntoTableCallback.java:74)
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.processor.filter.FilterProcessor.process(FilterProcessor.java:60)
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:121)
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.extension.siddhi.execution.esbanalytics.decompress.DecompressStreamProcessorExtension.process(DecompressStreamProcessorExtension.java:260)
at
org.wso2.siddhi.core.query.processor.stream.StreamProcessor.processEventChunk(StreamProcessor.java:47)
at
org.wso2.siddhi.core.query.processor.stream.AbstractStreamProcessor.process(AbstractStreamProcessor.java:125)
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: org.h2.jdbc.JdbcBatchUpdateException: Value too long for column
"BEFOREPAYLOAD VARCHAR(5000)": "STRINGDECODE('<?xml version=''1.0''
encoding=''utf-8''?><soapenv:Envelope
xmlns:soapenv=\""http://schemas.xmlsoap.org/soap/envelo... (238694)"; SQL
statement:
INSERT INTO ESBEventTable (metaTenantId , messageFlowId , host , hashCode ,
componentName , componentType , componentIndex , componentId , startTime ,
endTime , duration , beforePayload , afterPayload , contextPropertyMap ,
transportPropertyMap , children , entryPoint , entryPointHashcode , faultCount
, eventTimestamp ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?) [22001-196]
at
org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1234)
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)
... 38 more
Bernard
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
