The folks that know the WeeWx code better than I may have other ideas but what I do is to use your favourite SQLLite database tool to delete from where the duplications start (1612865736 in your case) to the end and then delete and rebuild the daily summary records. What the HP1000 driver does is to ask WeeWx for the date of the last record and then checks with the console for any records that are *after* that date and treats those as 'historic' records. Can you look at the database and see if there are records (possibly with dateTime values that don't seem to follow the general trend - for example nearly all of mine end in '0') that might be causing the issue. Also can you please provide the traceback for the error, not just the error itself. I'd like to see where the error is originating in the driver source file. Susan
On Tuesday, 18 January 2022 at 7:56:56 pm UTC+11 [email protected] wrote: > Hi All, > > I'm seeing a recurrence of catastrophic failures with my setup that I last > saw around this time last year. > > There are numerous unique constraint errors that appear to be due to the > HP1000 trying to insert historical data when there is already data there. > This results in reports and data never being updated and showing as offline. > > Jan 18 08:40:15 weatherpi weewx[1780] ERROR weewx.manager: Unable to add > record 2021-02-09 10:15:36 GMT (1612865736) to database 'weewx.sdb': UNIQUE > constraint failed: archive.dateTime > > The solution I used last year was to do a full clean install. I'd rather > not go down that path this year as I've reconfigured weewx to the simulator > and all is well. So that suggests the issue is with the HP1000 driver. I > reinstalled the driver but still see the same issue. > > My next guess would be to uninstall the driver but I don't know how to do > that. > > My original post is here > <https://groups.google.com/g/weewx-user/c/EoPbfNzH0n8/m/l9tl1dpLDQAJ> > > Any guidance would be very much appreciated. > > Thank you, > > Matt > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/8ecd1e01-55e3-43a8-b481-27cb40ceb4d1n%40googlegroups.com.
