The plot thickens. I have done a 'drop database weewx' and then restarted weewx. I waited for several archive cycles and then looked at the database. I did 'select * from archive' but there is nothing there. Then I did 'select * from archive_day_barometer' and there is a record. +------------+--------+------------+-------+------------+------+-------+------+---------+ | dateTime | min | mintime | max | maxtime | sum | count | wsum | sumtime | +------------+--------+------------+-------+------------+------+-------+------+---------+ | 1481443200 | 30.125 | 1481484842 | 30.13 | 1481484302 | 0 | 0 | 0 | 0 | +------------+--------+------------+-------+------------+------+-------+------+---------+ 1 row in set (0.00 sec)
As I said in a previous post I can't find where the archive table is updated. I searched all of the files for 'INSERT' and 'REPLACE' but found not place where the 'archive' table is updated. I can find 'REPLACE' entries for all of the 'archive_day-...' tables but nothing for 'archive'. Can you tell me where to look for the 'archive' table update? On Saturday, December 10, 2016 at 8:48:52 AM UTC-8, Barton Phillips wrote: > > I may not have posted this right the first time so here goes again. > > My weather station has been working for years but a couple of days ago > it started to freeze after running several hours. When I looked at the > database the last entry was not updating. I was running 3.1.2 so I upgraded > to 3.6.2 but the same thing happens. I tried changing from sqlite to mysql > but still no help. What can I do to debug this problem? Do you think it > might be something wrong with the console? When I do 'wee_device > --clear-memory' it starts working again but within a day it freezes. The > 'Weewx > uptime: ' changes every 5 minutes so I know that the files are being > updated but the image times don't change and the date and time at the top > is frozen. > Any help would be appreciated. > > When I run weewxd from the command line I see the dateTime updating every > 2 seconds but if I look at the logfile the "Getting archive packets since > 2016-12-09 09:15:00 PST (1481303700)" does not change. In this case it is > stuck at 09:15:00 PST. > > I can't think of anything I might have done to cause the change from > running OK to freeze. > > -- > Sent From my Good Old Desktop PC. > > Barton Phillips > Granby Rotary Club > http://www.granbyrotary.org > Applitec Inc. > http://www.applitec.com > Personal > http://www.bartonphillips.com > -- 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.
