Here is the use case:
1. MySql insert every 5 min on full minute
2. randomly value is inccorect (returns "0")
ie. dbase.ram shows:
Code: Select all
sqlite> select ts, datetime(ts, 'unixepoch'), sum(val) from rain0total_min where ts > strftime('%s','2019-01-13 03:30:00') and ts < strftime('%s','2019-01-13 03:35:00');
1547350440|2019-01-13 03:34:00|200
Code: Select all
select ts, datetime(ts, 'unixepoch'), val,ts, minval,datetime(mints, 'unixepoch'),maxval,datetime(mints, 'unixepoch') from rain0total_min where ts > strftime('%s','2019-01-13 03:30:00') and ts < strftime('%s','2019-01-13 03:35:00');
1547350260|2019-01-13 03:31:00|0|1547350260|0|2019-01-13 03:31:50|0|2019-01-13 03:31:50
1547350320|2019-01-13 03:32:00|0|1547350320|0|2019-01-13 03:32:46|0|2019-01-13 03:32:46
1547350380|2019-01-13 03:33:00|0|1547350380|0|2019-01-13 03:33:42|0|2019-01-13 03:33:42
1547350440|2019-01-13 03:34:00|200|1547350440|200|2019-01-13 03:34:10|200|2019-01-13 03:34:10
but MySql insert run at 2019-01-13 03:35:00 rain0total-sum5.2:NULL returned "0"
For me it looks like this selector does not sum up last minute.
Same setup on Meteobridge TL-MR3020 returns correctly.
How to fix this issue