Some news: as mentioned in my previous post, I decided to reinstall WeeWX with the Debian package. But this didn't change anything to my issue, archive records are rejected because of this NOT NULL constraint on archive.interval.
I decided to clear the data log on the WMR200. I first stopped WeeWX, cleared the log, and restarted the service. One archive record, generated between the clear and the restart was then rejected, but then WeeWX started on process the live records, and these ones finally made their way into the database! This is a step forward, but I still wanted to see what happened if WeeWX was not catching the records on the fly. So I stopped the service for 15 minutes, and then restarted it. Unfortunately, the archive records recorded during this period were also rejected: Apr 26 12:28:51 raspiMeteo weewx[2490]: wmr200: MainThread: I genStartup() Still receiving archive packets cnt:7 len:1 Apr 26 12:28:51 raspiMeteo weewx[2490]: wmr200: MainThread: I Using pc time adjusting archive record time by 14 sec 2017-04-26 14:26:00 CEST (1493209560) => 2017-04-26 14:26:14 CEST (1493209574) Apr 26 12:28:51 raspiMeteo weewx[2490]: manager: Unable to add record 2017-04-26 14:26:14 CEST (1493209574) to database 'weewx.sdb': NOT NULL constraint failed: archive.interval Apr 26 12:28:54 raspiMeteo weewx[2490]: wmr200: MainThread: I genStartup() Still receiving archive packets cnt:8 len:1 Apr 26 12:28:54 raspiMeteo weewx[2490]: wmr200: MainThread: I Using pc time adjusting archive record time by 14 sec 2017-04-26 14:27:00 CEST (1493209620) => 2017-04-26 14:27:14 CEST (1493209634) Apr 26 12:28:54 raspiMeteo weewx[2490]: manager: Unable to add record 2017-04-26 14:27:14 CEST (1493209634) to database 'weewx.sdb': NOT NULL constraint failed: archive.interval Apr 26 12:30:55 raspiMeteo weewx[2490]: wmr200: MainThread: I genStartup() phase exiting since looks like all archive packets have been retrieved after 120 sec cnt:9 Apr 26 12:30:55 raspiMeteo rsyslogd-2007: action 'action 17' suspended, next retry is Wed Apr 26 12:32:25 2017 [try http://www.rsyslog.com/e/2007 ] Apr 26 12:30:55 raspiMeteo weewx[2490]: wmr200: MainThread: I genStartup() Yielded 9 packets in 480 sec between these dates 2017-04-26 14:19:14 CEST (1493209154) ==> 2017-04-26 14:27:14 CEST (1493209634) Apr 26 12:30:55 raspiMeteo weewx[2490]: wmr200: MainThread: I genStartup() Average packets per minute:1.125000 Apr 26 12:30:55 raspiMeteo weewx[2490]: engine: Starting main packet loop. Apr 26 12:31:19 raspiMeteo weewx[2490]: manager: Added record 2017-04-26 14:31:00 CEST (1493209860) to database 'weewx.sdb' Apr 26 12:31:19 raspiMeteo weewx[2490]: manager: Added record 2017-04-26 14:31:00 CEST (1493209860) to daily summary in 'weewx.sdb' Apr 26 12:31:49 raspiMeteo weewx[2490]: cheetahgenerator: Generated 14 files for report StandardReport in 28.43 seconds Apr 26 12:31:54 raspiMeteo weewx[2490]: imagegenerator: Generated 12 images for StandardReport in 4.01 seconds Apr 26 12:31:54 raspiMeteo weewx[2490]: copygenerator: copied 9 files to /var/www/html/weewx Apr 26 12:32:15 raspiMeteo weewx[2490]: manager: Added record 2017-04-26 14:32:00 CEST (1493209920) to database 'weewx.sdb' Apr 26 12:32:15 raspiMeteo weewx[2490]: manager: Added record 2017-04-26 14:32:00 CEST (1493209920) to daily summary in 'weewx.sdb' Apr 26 12:32:26 raspiMeteo weewx[2490]: cheetahgenerator: Generated 14 files for report StandardReport in 8.97 seconds So there is still an issue... And in addition, some records were lost, the ones from 14:28, 14:29 and 14:30. I would really appreciate if someone could help. Patrick -- 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]. For more options, visit https://groups.google.com/d/optout.
