As luck would have it, the mysterious rain storm error popped up today.... <https://lh3.googleusercontent.com/-dNj2vDw5tc4/WEHuOm4E27I/AAAAAAABBwg/5mTAp0j8K88nsNQyssiADsN7_y8lna-wgCLcB/s1600/dayrain-Bootstrap.png> sqlite> select dateTime, datetime(dateTime,'unixepoch','localtime'), rain from archive;
1480709100|2016-12-02 14:05:00|0.0 1480709400|2016-12-02 14:10:00|0.0 1480709700|2016-12-02 14:15:00|0.0 1480710000|2016-12-02 14:20:00|0.0 1480710300|2016-12-02 14:25:00|0.159999999836802 1480710600|2016-12-02 14:30:00|0.0 1480710900|2016-12-02 14:35:00|0.0 1480711200|2016-12-02 14:40:00|0.0 1480711500|2016-12-02 14:45:00|0.0 1480711800|2016-12-02 14:50:00|0.0 1480712100|2016-12-02 14:55:00|0.0 select dateTime, datetime(dateTime,'unixepoch','localtime'), rainRate from archive; 1480709100|2016-12-02 14:05:00|0.0 1480709400|2016-12-02 14:10:00|0.0 1480709700|2016-12-02 14:15:00|0.0 1480710000|2016-12-02 14:20:00|0.0 1480710300|2016-12-02 14:25:00|0.274285714005946 1480710600|2016-12-02 14:30:00|0.639999999347208 1480710900|2016-12-02 14:35:00|0.639999999347208 1480711200|2016-12-02 14:40:00|0.365714285341262 1480711500|2016-12-02 14:45:00|0.0 1480711800|2016-12-02 14:50:00|0.0 1480712100|2016-12-02 14:55:00|0.0 This time it wasn't as severe as it normally is. I just nulled out the values, dropped daily, backfilled and re-started weewx. On Thursday, December 1, 2016 at 8:17:53 AM UTC-6, Chris Swanda wrote: > > [StdQC] > > [[MinMax]] > ...... > rainRate = 0, 10, inch_per_hour > rain = 0, 10, inch > > Since we sometimes has massive rain storms here in the midwest, I keep it > like this. > > Back in September we received almost a whole month's of rain in about 3 > hours. :) > > <https://lh3.googleusercontent.com/-x_KLtVDhxr4/WEAvogqLYFI/AAAAAAABBqY/oxeRYfgdbIsMGLkPIVhzm9ozKvEbk31pACLcB/s1600/Screen%2BShot%2B2016-12-01%2Bat%2B08.11.21.jpg> > > > > > > > > > But, randomly about every two weeks, I will get a spike of anywhere > between 30 in/hr to 99 in/hr (four records written to the DB every 300 > seconds) > > As luck would have it, I have a backup copy of my DB, but I had already > nulled out the records... but here it is for example. > > RainRate: > 1478168400|2016-11-03 05:20:00|0.0 > 1478168700|2016-11-03 05:25:00| > 1478169000|2016-11-03 05:30:00| > 1478169300|2016-11-03 05:35:00| > 1478169600|2016-11-03 05:40:00| > 1478169900|2016-11-03 05:45:00|0.0 > > Rain: > 1478168400|2016-11-03 05:20:00|0.0 > 1478168700|2016-11-03 05:25:00| > 1478169000|2016-11-03 05:30:00|0.0 > > Just like clockwork, four records for RainRate that are erroneous and one > record for rain. > > Next time it happens, I'll grep for logs and get a copy of the database > entries. > > > > On Thursday, December 1, 2016 at 7:51:30 AM UTC-6, Andrew Milner wrote: >> >> What limits have you got set in QC for rain and rainrate such that the >> spikes are not detected and prevented? >> >> >> >> >> On Thursday, 1 December 2016 15:46:05 UTC+2, Chris Swanda wrote: >> >>> I mean to say >>> >>> 99 inches of RainRate (four records) written >>> >>> . >>> >>> On Thursday, December 1, 2016 at 7:45:01 AM UTC-6, Chris Swanda wrote: >>>> >>>> mwall, >>>> >>>> QC has never prevented Rain nor RainRate spikes being written to my >>>> database. I typically will get 30 inches of rain (one record) and 99 >>>> inches of rain (four records) written. >>>> >>>> I typically just null them out and restart. >>>> >>>> On Wednesday, November 30, 2016 at 4:40:43 PM UTC-6, mwall wrote: >>>>> >>>>> On Wednesday, November 30, 2016 at 3:01:36 PM UTC-5, Marc Ratés wrote: >>>>>> >>>>>> The class or plugin in charge of acurite 5 in 1 inserts randoms >>>>>> inputs of rain, today 2000mm. >>>>>> It's very annoying because I have to delete by hand the sqlite.db. >>>>>> and I lose the accuracy of the liters. >>>>>> >>>>> >>>>> i forgot to mention the weewx quality control (QC). >>>>> >>>>> in weewx.conf, do something like this in your QC section: >>>>> >>>>> [StdQC] >>>>> [[MinMax]] >>>>> ... >>>>> rain = 0, 1000, mm >>>>> >>>>> this will not fix the root cause (spurious data from the acurite >>>>> station), but it will prevent obviously bad values from getting into the >>>>> database. >>>>> >>>>> m >>>>> >>>> -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.