Thanks Susan, sent a PM On Wednesday, 19 January 2022 at 01:42:10 UTC [email protected] wrote:
> 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/9c02ffe8-8ab5-41a1-9702-4b3fafc1956an%40googlegroups.com.
