Hey, TK,
Thanks for the pointers. I didn't know about the archive table and it wasn't obvious, just grepping for rain in the .dump output.
Do you know if there is a difference in the way that "real time" data is read from the WMR300A vs. reading the historical data?
I wonder if the "bug" is in reading the "real time" data... Could be a WMR300A bug, because one reason I have been exploring different software options is because no software I have tried has worked for reporting the rain data. :-(
So, by inspecting the "archive" table in weewx.sdb, it is proven that WeeWX didn't extract any rain on 2019-4-12; only the rainRate has a non-zero value.
pi@nixie:/var/lib/weewx $ sqlite3 -header weewx.sdb "select date(dateTime, 'unixepoch', 'localtime') as day, rain, rainRate from archive where rainRate != 0.0" | tail -20
2016-07-13|0.0|0.0899999999082
2016-07-13|0.0|0.0799999999184
2016-07-13|0.0|0.0799999999184
2016-07-13|0.0|0.0699999999286
2016-07-13|0.0|0.0699999999286
2016-07-13|0.0|0.0599999999388
2019-04-12|0.0|0.044692737384581
2019-04-12|0.0|0.314333333012714
2019-04-12|0.0|0.183352600969049
2019-04-12|0.0|0.131173184223745
2019-04-12|0.0|0.0929999999051399
2019-04-12|0.0|0.0899999999081999
2019-04-12|0.0|0.102011173080306
2019-04-12|0.0|0.092914285619513
2019-04-12|0.0|0.0669696969013877
2019-04-12|0.0|0.0599999999387998
2019-04-12|0.0|0.0599999999387998
2019-04-12|0.0|0.0599999999387998
2019-04-12|0.0|0.0589999999398198
2019-04-12|0.0|0.0452513966018882
It isn't as if reading the rain from the WMR300A is completely broken, because there is some data there from before the initial ingest got aborted:
pi@nixie:/var/lib/weewx $ sqlite3 -header weewx.sdb "select date(dateTime, 'unixepoch', 'localtime') as day, rain, rainRate from archive where rain != 0.0"
day|rain|rainRate
2016-07-08|0.01|0.0
2016-07-08|0.01|0.1199999998776
2016-07-08|0.01|0.0899999999082
2016-07-08|0.01|0.5099999994798
2016-07-08|0.02|1.0699999989086
2016-07-08|0.04|1.8299999981334
2016-07-08|0.01|0.8199999991636
2016-07-08|0.01|0.6199999993676
2016-07-08|0.01|0.199999999796
2016-07-08|0.01|0.0
2016-07-08|0.01|0.1199999998776
2016-07-08|0.01|0.149999999847
2016-07-08|0.00999999999999998|0.1699999998266
2016-07-08|0.01|0.2099999997858
2016-07-08|0.01|0.2399999997552
2016-07-08|0.00999999999999998|0.2099999997858
2016-07-08|0.00999999999999998|0.099999999898
2016-07-08|0.01|0.0799999999184
2016-07-08|0.01|0.0599999999388
2016-07-08|0.00999999999999998|0.0
2016-07-08|0.00999999999999998|0.0
2016-07-08|0.03|1.4299999985414
2016-07-08|0.03|2.7199999972256
2016-07-08|0.02|1.5399999984292
2016-07-08|0.02|0.8899999990922
2016-07-08|0.03|1.4699999985006
2016-07-08|0.00999999999999998|0.9099999990718
2016-07-08|0.00999999999999998|0.449999999541
2016-07-08|0.00999999999999998|0.6099999993778
2016-07-12|0.00999999999999998|0.0
2016-07-12|0.0100000000000001|0.4899999995002
2016-07-12|0.00999999999999998|0.5099999994798
2016-07-12|0.00999999999999998|0.6599999993268
2016-07-12|0.0100000000000001|0.0799999999184
2016-07-13|0.02|0.0
2016-07-13|0.00999999999999998|0.2799999997144
2016-07-13|0.00999999999999998|0.5399999994492