Sensu Client discarding data ?


#1

When send large size of metric data to sensu client, the data was discarded, what should I do?

Check the logs:

···

{“timestamp”:“2015-07-08T18:18:39.247643+0800”,“level”:“error”,“message”:“failed to process check result from socket”,“data”:"{“name”: “oracle_metric_wor
st_top10”, “command”:“oracle_metric”,“type”: “metric”,“handlers”: [“influxdb”],“output”: "[{\“app_id\”:\“b68d6023d5584c448ce09c4e3443f
6c8\”,\“host\”:\“10.111.133.199\”,\“key\”:\“oracle.worst.sql\”,\“timestamp\”:1436350709,\“value\”:[{\“executions\”:\“3\”,
\“worst_sql\”:\“DELETE FROM PLAN_TRAIN_STN WHERE PLAN_TRAIN_ID IN ( SELECT PLAN_TRAIN_ID FROM PLAN_TRAIN PT WHERE PT.START_TIME > :1 AND
EXISTS ( SELECT 1 FROM PLAN_CROSS PC WHERE PC.CROSS_NAME = :2 AND PC.TOKEN_VEH_BUREAU = :3 AND PC.BASE_CHA
RT_ID = :4 AND PT.PLAN_CROSS_ID = PC.PLAN_CROSS_ID ) )\”,\“resp_time\”:\“103.9991\”},{\“e
xecutions\”:\“4\”,\“worst_sql\”:\“select M.planCrossId, M.baseCrossId, M.planCrossName, M.tokenVehBureau,M.startBureau,M.checkType,M.relevantBu
reau, WMSYS.WM_CONCAT(P.CHECK_BUREAU) AS checkedBureau,M.baseChartName,m.is_auto_generate isAutoGenerate, m.runDate FROM ( select t.plan_cross_id plan
CrossId, t.base_cross_id baseCrossId, t.cross_name planCrossName, t.TOKEN_VEH_BUREAU as tokenVehBureau , t.S
TART_BUREAU as startBureau, t.CHECK_TYPE as checkType, t.RELEVANT_BUREAU as relevantBureau, t.BASE_CHART_NAME
as baseChartName ,t.is_auto_generate ,(select a.run_date from plan_train a where a.plan_cross_id = t.plan_cross_id and rownum <
2) runDate from plan_cross t, PLAN_TRAIN p where 1=1 AND t.HIGHLINE_FLAG != ‘1’
AND RELEVANT_BUREAU like ‘%W%’ \”,\“resp_time\”:\“36.0247\”},{\“e
xecutions\”:\“3\”,\“worst_sql\”:\“DELETE FROM PLAN_TRAIN PT WHERE PT.START_TIME > :1 AND EXISTS ( SELECT 1 FROM PLAN_CROSS PC W
HERE PC.CROSS_NAME = :2 AND PC.TOKEN_VEH_BUREAU = :3 AND PC.BASE_CHART_ID = :4 AND P
T.PLAN_CROSS_ID = PC.PLAN_CROSS_ID )\”,\“resp_time\”:\“34.1617\”},{\“executions\”:\“2\”,\“worst_sql\”:\“SELECT P., t.run_
date runDay, t.group_serial_nbr groupSerialNbr, t.train_sort trainSort, t.train_nbr trainNbr, t.start_stn startStn, t.end_stn endStn,
t.spare_flag runFlag, case when t.DAILYPLAN_ID is not null then ‘1’ else ‘0’ end as createFlag, t.plan_train_id planTrainId, t.base_train_id baseTr
ainId, t.PLAN_CROSS_ID planCrossId ,p.cross_start_date FROM ( SELECT M.
,ROWNUM NUM FROM ( select U.UNIT_CROSS_ID as unitCrossId
, U.TOKEN_VEH_BUREAU as tokenVehBureau , U.START_BUREAU as startBureau, U.HIGHLINE_FLAG as highlineFlag, U.CROSS_NAME as
crossName, U.BASE_CROSS_ID as”,“error”:“no implicit conversion of Symbol into Integer”}

{“timestamp”:“2015-07-08T18:18:39.828280+0800”,“level”:“warn”,“message”:“discarding data buffer for sender and closing connection”,“data”:" crossId, PC.PLAN_CROSS_ID as planCrossId, case when U.check_time is not null then ‘1’ else ‘0’ end as checkFlag, case when U.CREAT_CROSS_TIME is not null then ‘1’ else ‘0’ end as unitCreateFlag ,u.cross_start_date FROM UNIT_CROSS U LEFT JOIN (SELECT * FROM PLAN_CRO\",\“resp_time\”:\“32.6037\”},{\“executions\”:\“2\”,\“worst_sql\”:\“select M.planCrossId, M.baseCrossId, M.planCrossName, M.tokenVehBureau,M.startBureau,M.checkType,M.relevantBureau, WMSYS.WM_CONCAT(P.CHECK_BUREAU) AS checkedBureau,M.baseChartName,m.is_auto_generate isAutoGenerate, m.runDate FROM ( select t.plan_cross_id planCrossId, t.base_cross_id baseCrossId, t.cross_name planCrossName, t.TOKEN_VEH_BUREAU as tokenVehBureau , t.START_BUREAU as startBureau, t.CHECK_TYPE as checkType, t.RELEVANT_BUREAU as relevantBureau, t.BASE_CHART_NAME as baseChartName ,t.is_auto_generate ,(select a.run_date from plan_train a where a.plan_cross_id = t.plan_cross_id and rownum < 2) runDate from plan_cross t, PLAN_TRAIN p where 1=1 AND t.HIGHLINE_FLAG != ‘1’ AND t.TOKEN_VEH_BUREAU= :1 AND R\”,\“resp_time\”:\“30.3379\”},{\“executions\”:\“5\”,\“worst_sql\”:\“select * from ( select * from (select t.TRAIN_NBR, t.START_STN, TO_CHAR(T.START_TIME, ‘yyyy-MM-dd hh24:mi:ss’) START_TIME, t.END_STN, TO_CHAR(T.END_TIME, ‘yyyy-MM-dd hh24:mi:ss’) END_TIME, t.END_DAYS, t.PASS_BUREAU, t.PLAN_TRAIN_ID, t.PLAN_CROSS_ID, t.START_BUREAU, t.END_BUREAU, t.HIGHLINE_FLAG, case when T.CREAT_TYPE = 0 OR T.CREAT_TYPE = 1 then t.tel_name when t.creat_type =2 then t.tel_shortinfo when t.creat_type=3 then t.cmd_shortinfo end as laiyuan, (case when t.creat_type =0 then ‘3’ when t.creat_type =1 then ‘3’ when t.creat_type =2 then ‘2’ when t.creat_type =3 then ‘1’ ELSE ‘’ END ) laiyuan1, ( CASE WHEN t.SPARE_FLAG =1 THEN ‘u5F00u884C’ WHEN t.SPARE_FLAG =2 THEN ‘u5907u7528’ WHEN t.SPARE_FLAG =9 THEN ‘u505Cu8FD0’ ELSE ‘’ END ) spareFlagTxt, (CASE WHEN t.START_BUREAU =:1 AND T.END_BUREAU <>:2 THEN ‘SFJC’ WHEN t.START_BUREAU <>:3 AND T.END_BUREAU =:4 THEN ‘JRZD’ WHEN t.START_BUREAU <>:5 AND T.END_BUR\”,\“resp_time\”:\“25.7006\”},{\“executions\”:\“15\”,\“worst_sql\”:\“select * from ( select * from (select t.TRAIN_NBR, t.START_STN, TO_CHAR(T.START_TIME, ‘yyyy-MM-dd hh24:mi:ss’) START_TIME, t.END_STN, TO_CHAR(T.END_TIME, ‘yyyy-MM-dd hh24:mi:ss’) END_TIME, t.END_DAYS, t.PASS_BUREAU, t.PLAN_TRAIN_ID, t.PLAN_CROSS_ID, t.START_BUREAU, t.END_BUREAU, t.HIGHLINE_FLAG, case when T.CREAT_TYPE = 0 OR T.CREAT_TYPE = 1 then t.tel_name when t.creat_type =2 then t.tel_shortinfo when t.creat_type=3 then t.cmd_shortinfo end as laiyuan, (case when t.creat_type =0 then ‘3’ when t.creat_type =1 then ‘3’ when t.creat_type =2 then ‘2’ when t.creat_type =3 then ‘1’ ELSE ‘’ END ) laiyuan1, ( CASE WHEN t.SPARE_FLAG =1 THEN ‘u5F00u884C’ WHEN t.SPARE_FLAG =2 THEN ‘u5907u7528’ WHEN t.SPARE_FLAG =9 THEN ‘u505Cu8FD0’ ELSE ‘’ END ) spareFlagTxt, (CASE WHEN t.START_BUREAU =:1 AND T.END_BUREAU <>:2 THEN ‘SFJC’ WHEN t.START_BUREAU <>:3 AND T.END_BUREAU =:4 THEN ‘JRZD’ WHEN t.START_BUREAU <>:5 AND T.END_BUR\”,\“resp_time\”:\“8.2397\”},{\“executions\”:\“3\”,\“worst_sql\”:\“SELECT DISTINCT START_TIME, GROUP_SERIAL_NBR, TRAIN_SORT, PLAN_TRAIN_ID, END_TIME, CROSS_NAME, PLAN_CROSS_ID FROM ( SELECT MAX(PT.START_TIME) OVER (PARTITION BY PT.GROUP_SERIAL_NBR) AS MAX_TIME, PT.GROUP_SERIAL_NBR AS GROUP_SERIAL_NBR, PT.TRAIN_SORT AS TRAIN_SORT, PT.START_TIME AS START_TIME, PT.END_TIME AS END_TIME, PT.PLAN_TRAIN_ID AS PLAN_TRAIN_ID, PC.CROSS_NAME AS CROSS_NAME, PT.PLAN_CROSS_ID AS PLAN_CROSS_ID FROM PLAN_TRAIN PT INNER JOIN PLAN_CROSS PC ON PT.PLAN_CROSS_ID = PC.PLAN_CROSS_ID WHERE PC.CROSS_NAME = :1 AND PC.BASE_CHART_ID = :2 ) WHERE START_TIME = MAX_TIME ORDER BY GROUP_SERIAL_NBR, START_TIME\”,\“resp_time\”:\“7.9100\”},{\“executions\”:\“5\”,\“worst_sql\”:\“select * from ( select * from (select t.TRAIN_NBR, t.START_STN, TO_CHAR(T.START_TIME, ‘yyyy-MM-dd hh24:mi:ss’) START_TIME, t.END_STN, TO_CHAR(T.END_TIME, ‘yyyy-MM-dd hh24:mi:ss’) END_TIME, t.END_DAYS, t.PASS_BUREAU, t.PLAN_TRAIN_ID, t.PLAN_CROSS_ID, t.START_BUREAU, t.END_BUREAU, t.HIGHLINE_FLAG, case when T.CREAT_TYPE = 0 OR T.CREAT_TYPE = 1 then t.tel_name when t.creat_type =2 then t.tel_shortinfo when t.creat_type=3 then t.cmd_shortinfo end as laiyuan, (case when t.creat_type =0 then ‘3’ when t.creat_type =1 then ‘3’ when t.creat_type =2 then ‘2’ when t.creat_type =3 then ‘1’ ELSE ‘’ END ) laiyuan1, ( CASE WHEN t.SPARE_FLAG =1 THEN ‘u5F00u884C’ WHEN t.SPARE_FLAG =2 THEN ‘u5907u7528’ WHEN t.SPARE_FLAG =9 THEN ‘u505Cu8FD0’ ELSE ‘’ END ) spareFlagTxt, (CASE WHEN t.START_BUREAU =:1 AND T.END_BUREAU <>:2 THEN ‘SFJC’ WHEN t.START_BUREAU <>:3 AND T.END_BUREAU =:4 THEN ‘JRZD’ WHEN t.START_BUREAU <>:5 AND T.END_BUR\”,\“resp_time\”:\“7.6642\”},{\“executions\”:\“37\”,\“worst_sql\”:\“select DISTINCT BUSINESS as businessName from jhpt_jbt.M_TRAINLINE_TEMP\”,\“resp_time\”:\“0.0855\”}],\“value_type\”:\“json\”}]",“status”: 0}",“parse_error”:“lexical error: invalid char in json text.\n crossId, PC.PLAN_CROSS\n (right here) ------^\n”}

``