A lot of 0 (zero) values

Telegraf
1

Hi!

We’re running kakfa-python to consume / produce metrics from different services. That part is working fine, and the in- and output is clean. Every 15 seconds a cron-job runs to get the data and we send it to influxdb once we get 5000 points:

    if len(points) >= 5000:
    influxdb_client.write_points(points, time_precision='s')
    points.clear()

But in the database we get arbitrary 0-values for requestsCounter:
1564664406 18958
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 4956
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664406 0
1564664407 0
1564664407 0
1564664407 0
1564664407 18924
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 8902
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664407 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 5091
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664408 0
1564664418 0
1564664418 0
1564664418 0
1564664418 0
1564664418 0
1564664418 0
1564664418 0
1564664418 0
1564664418 4965
1564664418 0
1564664418 0
1564664418 0
1564664418 0
1564664418 0
1564664418 0
1564664418 0
1564664418 0
1564664418 0
1564664418 0
1564664418 0
1564664418 0
1564664418 0
1564664419 0
1564664419 0
1564664419 0
1564664419 0
1564664419 0
1564664419 0
1564664419 0
1564664419 0
1564664419 0
1564664419 0
1564664419 0
1564664419 0
1564664419 0
1564664419 0
1564664420 0
1564664420 0
1564664420 0
1564664420 0
1564664420 0
1564664420 0
1564664420 0
1564664420 0
1564664421 0
1564664421 0
1564664421 0
1564664421 0
1564664421 0
1564664421 0
1564664421 0
1564664421 8917
1564664421 0
1564664421 0
1564664421 0
1564664421 0
1564664421 0
1564664421 0
1564664421 0
1564664421 0
1564664421 0
1564664421 0
1564664432 0
1564664432 0
1564664432 4975
1564664432 0
1564664432 0
1564664432 0
1564664432 0
1564664432 0
1564664432 0
1564664432 5100
1564664432 0
1564664432 0
1564664432 0
1564664432 0
1564664432 0
1564664432 0
1564664432 0
1564664432 0
1564664432 0
1564664434 0
1564664434 0
1564664434 18992
1564664434 0
1564664434 0
1564664434 0
1564664434 0

What is going awry here?
Thanks for any help!!

2

Hi @nino welcome to the community ,

Maybe the zero’s come from another source ? Can you modify the job and write the output also to a file and see if zero’s are written to the file as well ?
If you stop the cronjob for let’s say 5 minutes , are datapoints still coming in the database ?

1 Like
3

It’s possible this is related to GROUP BY time intervals and fill(), which could insert zero values into the results of a query. How are you validating what data is in the database? Through Chronograf or the CLI? What is the query you’re using?