Re: [weewx-user] Re: daily graphs stuck on an old date
BTW, same thing is happening with Firefox.. it's caching an image from a week ago. On Sunday, May 13, 2018 at 5:11:14 PM UTC-4 Richard Beare wrote: > OK - I'll keep an eye on it. I haven't noticed the same behaviour since > then. It is also possible that chrome has been updated. > > On Mon, May 14, 2018 at 2:31 AM, 'Rich Altmaier' via weewx-user < > weewx...@googlegroups.com> wrote: > >> The next time you see a stale image, please try a screen capture of this >> Chrome browser info: >>-click on Chrome 3-dots menu and select MoreTools-Developer Tools >>-then click the Network tab in the developer box. >>-then click the URL bar refresh. >>-the page repaints, and each of the image files is listed in the left >> column. >>-set the browser to full screen and drag the vertical bar which is to >> the left of the bar graphs to see more info on each filename. >> -the "Size" field shows if the image was fetched, giving a size >> number, or it says "(from memory", or "(from disk cache". >>-Click on the stale image filename, e.g. daytempdew.png. >>-screen capture the information on Request Headers and Response Headers >> >> That data should inform as to why the image is fetched or not! >> Rich >> >> >> >> On Monday, November 20, 2017 at 1:27:15 PM UTC-8, Richard Beare wrote: >>> >>> Hi, >>> I've had the following problems with weewx following a brief power >>> outage. The system is a fineoffset station connected to a raspberry pi. The >>> power cycle corrupted the database, but didn't appear to affect the >>> station. I restored the database from a backup earlier in the week, and >>> everything appears to be running fine. Missing data was fetched from the >>> station, the panel on the left seems to be updating correctly. However the >>> graphs are stuck on a single day. (2017/11/18). The weekly graphs are fine. >>> >>> I've confirmed the clock settings are OK, and I've upgraded to the >>> latest version. >>> >>> I've tried the following using various combinations of backup databases: >>> dumping newer than the day before the power outage, dropping and rebuilding >>> summaries and deleting the png files. >>> >>> At this point I'm starting to think I need to reinstall, but I hope I'm >>> missing something basic. >>> >>> Thanks >>> >>> Summary logs: >>> >>> Nov 21 08:21:11 raspberrypi weewx[23919]: manager: Added record >>> 2017-11-21 08:20:00 AEDT (1511212800) to database 'weewx.sdb' >>> >>> Nov 21 08:21:11 raspberrypi weewx[23919]: manager: Added record >>> 2017-11-21 08:20:00 AEDT (1511212800) to daily summary in 'weewx.sdb' >>> >>> Nov 21 08:21:11 raspberrypi weewx[23919]: reportengine: Running reports >>> for latest time in the database. >>> >>> Nov 21 08:21:11 raspberrypi weewx[23919]: reportengine: Running report >>> StandardReport >>> >>> Nov 21 08:21:12 raspberrypi weewx[23919]: reportengine: Found >>> configuration file /home/weewx/skins/Standard/skin.conf for report >>> StandardReport >>> >>> Nov 21 08:21:12 raspberrypi weewx[23919]: cheetahgenerator: using search >>> list ['weewx.cheetahgenerator.Almanac', 'weewx.cheetahgenerator.Station', >>> 'weewx.cheetahgenerator.Current', 'weewx.cheetahgenerator.Stats', >>> 'weewx.cheetahgenerator.UnitInfo', 'weewx.cheetahgenerator.Extras'] >>> >>> Nov 21 08:21:12 raspberrypi weewx[23919]: manager: Daily summary version >>> is 2.0 >>> >>> Nov 21 08:21:12 raspberrypi weewx[23919]: restx: Wunderground-PWS: >>> Published record 2017-11-21 08:20:00 AEDT (1511212800) >>> >>> Nov 21 08:21:24 raspberrypi weewx[23919]: cheetahgenerator: Generated 14 >>> files for report StandardReport in 12.17 seconds >>> >>> Nov 21 08:21:24 raspberrypi weewx[23919]: manager: Daily summary version >>> is 2.0 >>> >>> Nov 21 08:21:28 raspberrypi weewx[23919]: imagegenerator: Generated 12 >>> images for StandardReport in 4.18 seconds >>> >>> Nov 21 08:21:28 raspberrypi weewx[23919]: copygenerator: copied 0 files >>> to /home/weewx/public_html >>> >>> Nov 21 08:21:28 raspberrypi weewx[23919]: reportengine: Running report >>> FTP >>> >>> Nov 21 08:21:28 raspberrypi weewx[23919]: reportengine: Found >>> configuration file /home/weewx/skins/Ftp/skin.conf for report FTP >>> >>> Nov 21 08:21:28 raspberrypi weewx[23919]: ftpgenerator: FTP upload not >>> requested. Skipped. >>> >>> Nov 21 08:21:28 raspberrypi weewx[23919]: reportengine: Running report >>> RSYNC >>> >>> Nov 21 08:21:28 raspberrypi weewx[23919]: reportengine: Found >>> configuration file /home/weewx/skins/Rsync/skin.conf for report RSYNC >>> >>> Nov 21 08:21:28 raspberrypi weewx[23919]: rsyncgenerator: rsync upload >>> not requested. Skipped. >>> >>> >>> sudo /home/weewx/bin/wee_device /home/weewx/weewx.conf --info >>> >>> Using configuration file /home/weewx/weewx.conf >>> >>> Using FineOffsetUSB driver version 1.9 (weewx.drivers.fousb) >>> >>> Querying the station... >>> >>> Fine Offset station settings: >>> >>> local time: 2017.11.21 08:26:
Re: [weewx-user] Re: daily graphs stuck on an old date
OK - I'll keep an eye on it. I haven't noticed the same behaviour since then. It is also possible that chrome has been updated. On Mon, May 14, 2018 at 2:31 AM, 'Rich Altmaier' via weewx-user < weewx-user@googlegroups.com> wrote: > The next time you see a stale image, please try a screen capture of this > Chrome browser info: >-click on Chrome 3-dots menu and select MoreTools-Developer Tools >-then click the Network tab in the developer box. >-then click the URL bar refresh. >-the page repaints, and each of the image files is listed in the left > column. >-set the browser to full screen and drag the vertical bar which is to > the left of the bar graphs to see more info on each filename. > -the "Size" field shows if the image was fetched, giving a size > number, or it says "(from memory", or "(from disk cache". >-Click on the stale image filename, e.g. daytempdew.png. >-screen capture the information on Request Headers and Response Headers > > That data should inform as to why the image is fetched or not! > Rich > > > > On Monday, November 20, 2017 at 1:27:15 PM UTC-8, Richard Beare wrote: >> >> Hi, >> I've had the following problems with weewx following a brief power >> outage. The system is a fineoffset station connected to a raspberry pi. The >> power cycle corrupted the database, but didn't appear to affect the >> station. I restored the database from a backup earlier in the week, and >> everything appears to be running fine. Missing data was fetched from the >> station, the panel on the left seems to be updating correctly. However the >> graphs are stuck on a single day. (2017/11/18). The weekly graphs are fine. >> >> I've confirmed the clock settings are OK, and I've upgraded to the latest >> version. >> >> I've tried the following using various combinations of backup databases: >> dumping newer than the day before the power outage, dropping and rebuilding >> summaries and deleting the png files. >> >> At this point I'm starting to think I need to reinstall, but I hope I'm >> missing something basic. >> >> Thanks >> >> Summary logs: >> >> Nov 21 08:21:11 raspberrypi weewx[23919]: manager: Added record >> 2017-11-21 08:20:00 AEDT (1511212800) to database 'weewx.sdb' >> >> Nov 21 08:21:11 raspberrypi weewx[23919]: manager: Added record >> 2017-11-21 08:20:00 AEDT (1511212800) to daily summary in 'weewx.sdb' >> >> Nov 21 08:21:11 raspberrypi weewx[23919]: reportengine: Running reports >> for latest time in the database. >> >> Nov 21 08:21:11 raspberrypi weewx[23919]: reportengine: Running report >> StandardReport >> >> Nov 21 08:21:12 raspberrypi weewx[23919]: reportengine: Found >> configuration file /home/weewx/skins/Standard/skin.conf for report >> StandardReport >> >> Nov 21 08:21:12 raspberrypi weewx[23919]: cheetahgenerator: using search >> list ['weewx.cheetahgenerator.Almanac', 'weewx.cheetahgenerator.Station', >> 'weewx.cheetahgenerator.Current', 'weewx.cheetahgenerator.Stats', >> 'weewx.cheetahgenerator.UnitInfo', 'weewx.cheetahgenerator.Extras'] >> >> Nov 21 08:21:12 raspberrypi weewx[23919]: manager: Daily summary version >> is 2.0 >> >> Nov 21 08:21:12 raspberrypi weewx[23919]: restx: Wunderground-PWS: >> Published record 2017-11-21 08:20:00 AEDT (1511212800) >> >> Nov 21 08:21:24 raspberrypi weewx[23919]: cheetahgenerator: Generated 14 >> files for report StandardReport in 12.17 seconds >> >> Nov 21 08:21:24 raspberrypi weewx[23919]: manager: Daily summary version >> is 2.0 >> >> Nov 21 08:21:28 raspberrypi weewx[23919]: imagegenerator: Generated 12 >> images for StandardReport in 4.18 seconds >> >> Nov 21 08:21:28 raspberrypi weewx[23919]: copygenerator: copied 0 files >> to /home/weewx/public_html >> >> Nov 21 08:21:28 raspberrypi weewx[23919]: reportengine: Running report FTP >> >> Nov 21 08:21:28 raspberrypi weewx[23919]: reportengine: Found >> configuration file /home/weewx/skins/Ftp/skin.conf for report FTP >> >> Nov 21 08:21:28 raspberrypi weewx[23919]: ftpgenerator: FTP upload not >> requested. Skipped. >> >> Nov 21 08:21:28 raspberrypi weewx[23919]: reportengine: Running report >> RSYNC >> >> Nov 21 08:21:28 raspberrypi weewx[23919]: reportengine: Found >> configuration file /home/weewx/skins/Rsync/skin.conf for report RSYNC >> >> Nov 21 08:21:28 raspberrypi weewx[23919]: rsyncgenerator: rsync upload >> not requested. Skipped. >> >> >> sudo /home/weewx/bin/wee_device /home/weewx/weewx.conf --info >> >> Using configuration file /home/weewx/weewx.conf >> >> Using FineOffsetUSB driver version 1.9 (weewx.drivers.fousb) >> >> Querying the station... >> >> Fine Offset station settings: >> >> local time: 2017.11.21 08:26:19 AEDT >> >> polling mode: PERIODIC >> >> >> abs_pressure: 1019.1 >> >>current_pos: 21728 >> >> data_changed: 0 >> >> data_count: 4080 >> >> date_time: 2017-11-21 07:23 >> >> hum_in_offse
[weewx-user] Re: daily graphs stuck on an old date
The next time you see a stale image, please try a screen capture of this Chrome browser info: -click on Chrome 3-dots menu and select MoreTools-Developer Tools -then click the Network tab in the developer box. -then click the URL bar refresh. -the page repaints, and each of the image files is listed in the left column. -set the browser to full screen and drag the vertical bar which is to the left of the bar graphs to see more info on each filename. -the "Size" field shows if the image was fetched, giving a size number, or it says "(from memory", or "(from disk cache". -Click on the stale image filename, e.g. daytempdew.png. -screen capture the information on Request Headers and Response Headers That data should inform as to why the image is fetched or not! Rich On Monday, November 20, 2017 at 1:27:15 PM UTC-8, Richard Beare wrote: > > Hi, > I've had the following problems with weewx following a brief power outage. > The system is a fineoffset station connected to a raspberry pi. The power > cycle corrupted the database, but didn't appear to affect the station. I > restored the database from a backup earlier in the week, and everything > appears to be running fine. Missing data was fetched from the station, the > panel on the left seems to be updating correctly. However the graphs are > stuck on a single day. (2017/11/18). The weekly graphs are fine. > > I've confirmed the clock settings are OK, and I've upgraded to the latest > version. > > I've tried the following using various combinations of backup databases: > dumping newer than the day before the power outage, dropping and rebuilding > summaries and deleting the png files. > > At this point I'm starting to think I need to reinstall, but I hope I'm > missing something basic. > > Thanks > > Summary logs: > > Nov 21 08:21:11 raspberrypi weewx[23919]: manager: Added record 2017-11-21 > 08:20:00 AEDT (1511212800) to database 'weewx.sdb' > > Nov 21 08:21:11 raspberrypi weewx[23919]: manager: Added record 2017-11-21 > 08:20:00 AEDT (1511212800) to daily summary in 'weewx.sdb' > > Nov 21 08:21:11 raspberrypi weewx[23919]: reportengine: Running reports > for latest time in the database. > > Nov 21 08:21:11 raspberrypi weewx[23919]: reportengine: Running report > StandardReport > > Nov 21 08:21:12 raspberrypi weewx[23919]: reportengine: Found > configuration file /home/weewx/skins/Standard/skin.conf for report > StandardReport > > Nov 21 08:21:12 raspberrypi weewx[23919]: cheetahgenerator: using search > list ['weewx.cheetahgenerator.Almanac', 'weewx.cheetahgenerator.Station', > 'weewx.cheetahgenerator.Current', 'weewx.cheetahgenerator.Stats', > 'weewx.cheetahgenerator.UnitInfo', 'weewx.cheetahgenerator.Extras'] > > Nov 21 08:21:12 raspberrypi weewx[23919]: manager: Daily summary version > is 2.0 > > Nov 21 08:21:12 raspberrypi weewx[23919]: restx: Wunderground-PWS: > Published record 2017-11-21 08:20:00 AEDT (1511212800) > > Nov 21 08:21:24 raspberrypi weewx[23919]: cheetahgenerator: Generated 14 > files for report StandardReport in 12.17 seconds > > Nov 21 08:21:24 raspberrypi weewx[23919]: manager: Daily summary version > is 2.0 > > Nov 21 08:21:28 raspberrypi weewx[23919]: imagegenerator: Generated 12 > images for StandardReport in 4.18 seconds > > Nov 21 08:21:28 raspberrypi weewx[23919]: copygenerator: copied 0 files to > /home/weewx/public_html > > Nov 21 08:21:28 raspberrypi weewx[23919]: reportengine: Running report FTP > > Nov 21 08:21:28 raspberrypi weewx[23919]: reportengine: Found > configuration file /home/weewx/skins/Ftp/skin.conf for report FTP > > Nov 21 08:21:28 raspberrypi weewx[23919]: ftpgenerator: FTP upload not > requested. Skipped. > > Nov 21 08:21:28 raspberrypi weewx[23919]: reportengine: Running report > RSYNC > > Nov 21 08:21:28 raspberrypi weewx[23919]: reportengine: Found > configuration file /home/weewx/skins/Rsync/skin.conf for report RSYNC > > Nov 21 08:21:28 raspberrypi weewx[23919]: rsyncgenerator: rsync upload not > requested. Skipped. > > > sudo /home/weewx/bin/wee_device /home/weewx/weewx.conf --info > > Using configuration file /home/weewx/weewx.conf > > Using FineOffsetUSB driver version 1.9 (weewx.drivers.fousb) > > Querying the station... > > Fine Offset station settings: > > local time: 2017.11.21 08:26:19 AEDT > > polling mode: PERIODIC > > > abs_pressure: 1019.1 > >current_pos: 21728 > > data_changed: 0 > > data_count: 4080 > > date_time: 2017-11-21 07:23 > > hum_in_offset: 8967 > > hum_out_offset: 8465 > > id: None > > lux_wm2_coeff: 0 > >magic_1: 0x55 > >magic_2: 0xaa > > model: None > > rain_coef: None > >read_period: 5 > >
Re: [weewx-user] Re: daily graphs stuck on an old date
Richard, thanks for this thread - I had the same issue here. Weird. /dan On Tuesday, November 21, 2017 at 3:47:18 AM UTC-5, Richard Beare wrote: > > Well, this is embarrassing. Data is going in, and timestamp is appropriate: > > SELECT dateTime, outTemp FROM archive ORDER BY dateTime DESC LIMIT 20; > > 1511253600|84.08 > > as.POSIXct(1511253600, origin = "1970-01-01") > > [1] "2017-11-21 19:40:00 AEDT" > > > Repeated refresh of page from chrome, and restarts of chrome didn't change > the image in the web page. But using a different browser and viewing the > graph images manually showed that they're actually OK. Explicitly clearing > the image cache in chrome eventually did the trick. > > I'll go and hide now... > > Thanks for all the prompt help. > > > > > On Tue, Nov 21, 2017 at 4:00 PM, Richard Beare > wrote: > >> Have done the refreshing, but not separate viewing. Will confirm. >> Thanks >> >> On Tue, Nov 21, 2017 at 3:51 PM, Andrew Milner > > wrote: >> >>> An obvious one - but it's caught me out before - have you forced a page >>> reload in the browser and/or have you viewed the .png file directly via a >>> file explorer? >>> >>> On Tuesday, 21 November 2017 05:16:42 UTC+2, Richard Beare wrote: OK, thanks, I'll check that tonight. On Tue, Nov 21, 2017 at 1:51 PM, gjr80 wrote: > max(dateTime) will just show you the most recent archive record > timestamp, what we need to see is whether there is any observational data > being recorded in the archive. It is quite possible that no observational > data is being recorded for some reason and hence the generated plots show > no data. Weekly and greater plots display some form of aggregate data so > they may well still show something whilst the daily plot does not. > > Gary > > On Tuesday, 21 November 2017 11:37:17 UTC+10, Richard Beare wrote: >> >> I'm not in front of the machine at the moment, but I did check the >> most recent time, and it matched the current time. >> >> from memory: >> >> select max(timeDate) from archive; >> >> which I then converted to a readable form (with R). It was definitely >> today, not the stuck date of 3 days ago. >> >> Mysterious! >> >> On Tue, Nov 21, 2017 at 12:18 PM, gjr80 wrote: >> >>> On Tuesday, 21 November 2017 07:27:15 UTC+10, Richard Beare wrote: At this point I'm starting to think I need to reinstall, but I hope I'm missing something basic. >>> Don't go doing this, it is seldom required and is usually a waste of >>> your and our time. If forcing regeneration by deletion has not helped >>> then >>> I would have a look at what is in your database, are you getting >>> current >>> data in there or not? Assuming you are using SQLite and not MySQL try >>> the >>> following (assumes sqlite3 is installed, if not you need something >>> like sudo apt-get install sqlite3 to install it, also change paths >>> to suit your install): >>> >>> $ sqlite3 /home/weewx/archive/weewx.sdb >>> sqlite> SELECT STRFTIME('%d-%m-%Y %H:%M:%S', datetime(dateTime, >>> 'unixepoch')), outTemp FROM archive ORDER BY dateTime DESC LIMIT 20; >>> sqlite> .quit >>> >>> What does the SQLite query return? This will show whether you in >>> fact have current data being saved to archive or not. >>> >>> Gary >>> >>> -- >>> You received this message because you are subscribed to a topic in >>> the Google Groups "weewx-user" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/weewx-user/Qkb5l9fjk9Q/unsubscribe >>> . >>> To unsubscribe from this group and all its topics, send an email to >>> weewx-user+...@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > You received this message because you are subscribed to a topic in the > Google Groups "weewx-user" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/weewx-user/Qkb5l9fjk9Q/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > weewx-user+...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "weewx-user" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/weewx-user/Qkb5l9fjk9Q/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> weewx-user+...@googlegroups.com . >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving ema
Re: [weewx-user] Re: daily graphs stuck on an old date
Sometimes the obvious proves to be the 'solution'!! Gets harder trying to work out why the cache clear worked whilst the refresh didn't though!!! Glad to hear you're sorted now though. From experience it's often best to put weewx itself at the end of any list of possible causes!! On 21 November 2017 at 10:47, Richard Beare wrote: > Well, this is embarrassing. Data is going in, and timestamp is appropriate: > > SELECT dateTime, outTemp FROM archive ORDER BY dateTime DESC LIMIT 20; > > 1511253600|84.08 > > as.POSIXct(1511253600, origin = "1970-01-01") > > [1] "2017-11-21 19:40:00 AEDT" > > > Repeated refresh of page from chrome, and restarts of chrome didn't change > the image in the web page. But using a different browser and viewing the > graph images manually showed that they're actually OK. Explicitly clearing > the image cache in chrome eventually did the trick. > > I'll go and hide now... > > Thanks for all the prompt help. > > > > > On Tue, Nov 21, 2017 at 4:00 PM, Richard Beare > wrote: > >> Have done the refreshing, but not separate viewing. Will confirm. >> Thanks >> >> On Tue, Nov 21, 2017 at 3:51 PM, Andrew Milner < >> andrew.s.r.mil...@gmail.com> wrote: >> >>> An obvious one - but it's caught me out before - have you forced a page >>> reload in the browser and/or have you viewed the .png file directly via a >>> file explorer? >>> >>> On Tuesday, 21 November 2017 05:16:42 UTC+2, Richard Beare wrote: OK, thanks, I'll check that tonight. On Tue, Nov 21, 2017 at 1:51 PM, gjr80 wrote: > max(dateTime) will just show you the most recent archive record > timestamp, what we need to see is whether there is any observational data > being recorded in the archive. It is quite possible that no observational > data is being recorded for some reason and hence the generated plots show > no data. Weekly and greater plots display some form of aggregate data so > they may well still show something whilst the daily plot does not. > > Gary > > On Tuesday, 21 November 2017 11:37:17 UTC+10, Richard Beare wrote: >> >> I'm not in front of the machine at the moment, but I did check the >> most recent time, and it matched the current time. >> >> from memory: >> >> select max(timeDate) from archive; >> >> which I then converted to a readable form (with R). It was definitely >> today, not the stuck date of 3 days ago. >> >> Mysterious! >> >> On Tue, Nov 21, 2017 at 12:18 PM, gjr80 wrote: >> >>> On Tuesday, 21 November 2017 07:27:15 UTC+10, Richard Beare wrote: At this point I'm starting to think I need to reinstall, but I hope I'm missing something basic. >>> Don't go doing this, it is seldom required and is usually a waste of >>> your and our time. If forcing regeneration by deletion has not helped >>> then >>> I would have a look at what is in your database, are you getting current >>> data in there or not? Assuming you are using SQLite and not MySQL try >>> the >>> following (assumes sqlite3 is installed, if not you need something >>> like sudo apt-get install sqlite3 to install it, also change paths >>> to suit your install): >>> >>> $ sqlite3 /home/weewx/archive/weewx.sdb >>> sqlite> SELECT STRFTIME('%d-%m-%Y %H:%M:%S', datetime(dateTime, >>> 'unixepoch')), outTemp FROM archive ORDER BY dateTime DESC LIMIT 20; >>> sqlite> .quit >>> >>> What does the SQLite query return? This will show whether you in >>> fact have current data being saved to archive or not. >>> >>> Gary >>> >>> -- >>> You received this message because you are subscribed to a topic in >>> the Google Groups "weewx-user" group. >>> To unsubscribe from this topic, visit https://groups.google.com/d/to >>> pic/weewx-user/Qkb5l9fjk9Q/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> weewx-user+...@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > You received this message because you are subscribed to a topic in the > Google Groups "weewx-user" group. > To unsubscribe from this topic, visit https://groups.google.com/d/to > pic/weewx-user/Qkb5l9fjk9Q/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > weewx-user+...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "weewx-user" group. >>> To unsubscribe from this topic, visit https://groups.google.com/d/to >>> pic/weewx-user/Qkb5l9fjk9Q/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> weewx-user+unsubscr...@googlegroups.com. >>> For more options, visit https://groups.google.
Re: [weewx-user] Re: daily graphs stuck on an old date
Well, this is embarrassing. Data is going in, and timestamp is appropriate: SELECT dateTime, outTemp FROM archive ORDER BY dateTime DESC LIMIT 20; 1511253600|84.08 as.POSIXct(1511253600, origin = "1970-01-01") [1] "2017-11-21 19:40:00 AEDT" Repeated refresh of page from chrome, and restarts of chrome didn't change the image in the web page. But using a different browser and viewing the graph images manually showed that they're actually OK. Explicitly clearing the image cache in chrome eventually did the trick. I'll go and hide now... Thanks for all the prompt help. On Tue, Nov 21, 2017 at 4:00 PM, Richard Beare wrote: > Have done the refreshing, but not separate viewing. Will confirm. > Thanks > > On Tue, Nov 21, 2017 at 3:51 PM, Andrew Milner < > andrew.s.r.mil...@gmail.com> wrote: > >> An obvious one - but it's caught me out before - have you forced a page >> reload in the browser and/or have you viewed the .png file directly via a >> file explorer? >> >> On Tuesday, 21 November 2017 05:16:42 UTC+2, Richard Beare wrote: >>> >>> OK, thanks, I'll check that tonight. >>> >>> On Tue, Nov 21, 2017 at 1:51 PM, gjr80 wrote: >>> max(dateTime) will just show you the most recent archive record timestamp, what we need to see is whether there is any observational data being recorded in the archive. It is quite possible that no observational data is being recorded for some reason and hence the generated plots show no data. Weekly and greater plots display some form of aggregate data so they may well still show something whilst the daily plot does not. Gary On Tuesday, 21 November 2017 11:37:17 UTC+10, Richard Beare wrote: > > I'm not in front of the machine at the moment, but I did check the > most recent time, and it matched the current time. > > from memory: > > select max(timeDate) from archive; > > which I then converted to a readable form (with R). It was definitely > today, not the stuck date of 3 days ago. > > Mysterious! > > On Tue, Nov 21, 2017 at 12:18 PM, gjr80 wrote: > >> On Tuesday, 21 November 2017 07:27:15 UTC+10, Richard Beare wrote: >>> >>> >>> At this point I'm starting to think I need to reinstall, but I hope >>> I'm missing something basic. >>> >>> >> Don't go doing this, it is seldom required and is usually a waste of >> your and our time. If forcing regeneration by deletion has not helped >> then >> I would have a look at what is in your database, are you getting current >> data in there or not? Assuming you are using SQLite and not MySQL try the >> following (assumes sqlite3 is installed, if not you need something >> like sudo apt-get install sqlite3 to install it, also change paths >> to suit your install): >> >> $ sqlite3 /home/weewx/archive/weewx.sdb >> sqlite> SELECT STRFTIME('%d-%m-%Y %H:%M:%S', datetime(dateTime, >> 'unixepoch')), outTemp FROM archive ORDER BY dateTime DESC LIMIT 20; >> sqlite> .quit >> >> What does the SQLite query return? This will show whether you in fact >> have current data being saved to archive or not. >> >> Gary >> >> -- >> You received this message because you are subscribed to a topic in >> the Google Groups "weewx-user" group. >> To unsubscribe from this topic, visit https://groups.google.com/d/to >> pic/weewx-user/Qkb5l9fjk9Q/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> weewx-user+...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to a topic in the Google Groups "weewx-user" group. To unsubscribe from this topic, visit https://groups.google.com/d/to pic/weewx-user/Qkb5l9fjk9Q/unsubscribe. To unsubscribe from this group and all its topics, send an email to weewx-user+...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. >>> >>> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "weewx-user" group. >> To unsubscribe from this topic, visit https://groups.google.com/d/to >> pic/weewx-user/Qkb5l9fjk9Q/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> weewx-user+unsubscr...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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.
Re: [weewx-user] Re: daily graphs stuck on an old date
Have done the refreshing, but not separate viewing. Will confirm. Thanks On Tue, Nov 21, 2017 at 3:51 PM, Andrew Milner wrote: > An obvious one - but it's caught me out before - have you forced a page > reload in the browser and/or have you viewed the .png file directly via a > file explorer? > > On Tuesday, 21 November 2017 05:16:42 UTC+2, Richard Beare wrote: >> >> OK, thanks, I'll check that tonight. >> >> On Tue, Nov 21, 2017 at 1:51 PM, gjr80 wrote: >> >>> max(dateTime) will just show you the most recent archive record >>> timestamp, what we need to see is whether there is any observational data >>> being recorded in the archive. It is quite possible that no observational >>> data is being recorded for some reason and hence the generated plots show >>> no data. Weekly and greater plots display some form of aggregate data so >>> they may well still show something whilst the daily plot does not. >>> >>> Gary >>> >>> On Tuesday, 21 November 2017 11:37:17 UTC+10, Richard Beare wrote: I'm not in front of the machine at the moment, but I did check the most recent time, and it matched the current time. from memory: select max(timeDate) from archive; which I then converted to a readable form (with R). It was definitely today, not the stuck date of 3 days ago. Mysterious! On Tue, Nov 21, 2017 at 12:18 PM, gjr80 wrote: > On Tuesday, 21 November 2017 07:27:15 UTC+10, Richard Beare wrote: >> >> >> At this point I'm starting to think I need to reinstall, but I hope >> I'm missing something basic. >> >> > Don't go doing this, it is seldom required and is usually a waste of > your and our time. If forcing regeneration by deletion has not helped then > I would have a look at what is in your database, are you getting current > data in there or not? Assuming you are using SQLite and not MySQL try the > following (assumes sqlite3 is installed, if not you need something > like sudo apt-get install sqlite3 to install it, also change paths to > suit your install): > > $ sqlite3 /home/weewx/archive/weewx.sdb > sqlite> SELECT STRFTIME('%d-%m-%Y %H:%M:%S', datetime(dateTime, > 'unixepoch')), outTemp FROM archive ORDER BY dateTime DESC LIMIT 20; > sqlite> .quit > > What does the SQLite query return? This will show whether you in fact > have current data being saved to archive or not. > > Gary > > -- > You received this message because you are subscribed to a topic in the > Google Groups "weewx-user" group. > To unsubscribe from this topic, visit https://groups.google.com/d/to > pic/weewx-user/Qkb5l9fjk9Q/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > weewx-user+...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "weewx-user" group. >>> To unsubscribe from this topic, visit https://groups.google.com/d/to >>> pic/weewx-user/Qkb5l9fjk9Q/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> weewx-user+...@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > You received this message because you are subscribed to a topic in the > Google Groups "weewx-user" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/weewx-user/Qkb5l9fjk9Q/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > weewx-user+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- 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.
Re: [weewx-user] Re: daily graphs stuck on an old date
An obvious one - but it's caught me out before - have you forced a page reload in the browser and/or have you viewed the .png file directly via a file explorer? On Tuesday, 21 November 2017 05:16:42 UTC+2, Richard Beare wrote: > > OK, thanks, I'll check that tonight. > > On Tue, Nov 21, 2017 at 1:51 PM, gjr80 > > wrote: > >> max(dateTime) will just show you the most recent archive record >> timestamp, what we need to see is whether there is any observational data >> being recorded in the archive. It is quite possible that no observational >> data is being recorded for some reason and hence the generated plots show >> no data. Weekly and greater plots display some form of aggregate data so >> they may well still show something whilst the daily plot does not. >> >> Gary >> >> On Tuesday, 21 November 2017 11:37:17 UTC+10, Richard Beare wrote: >>> >>> I'm not in front of the machine at the moment, but I did check the most >>> recent time, and it matched the current time. >>> >>> from memory: >>> >>> select max(timeDate) from archive; >>> >>> which I then converted to a readable form (with R). It was definitely >>> today, not the stuck date of 3 days ago. >>> >>> Mysterious! >>> >>> On Tue, Nov 21, 2017 at 12:18 PM, gjr80 wrote: >>> On Tuesday, 21 November 2017 07:27:15 UTC+10, Richard Beare wrote: > > > At this point I'm starting to think I need to reinstall, but I hope > I'm missing something basic. > > Don't go doing this, it is seldom required and is usually a waste of your and our time. If forcing regeneration by deletion has not helped then I would have a look at what is in your database, are you getting current data in there or not? Assuming you are using SQLite and not MySQL try the following (assumes sqlite3 is installed, if not you need something like sudo apt-get install sqlite3 to install it, also change paths to suit your install): $ sqlite3 /home/weewx/archive/weewx.sdb sqlite> SELECT STRFTIME('%d-%m-%Y %H:%M:%S', datetime(dateTime, 'unixepoch')), outTemp FROM archive ORDER BY dateTime DESC LIMIT 20; sqlite> .quit What does the SQLite query return? This will show whether you in fact have current data being saved to archive or not. Gary -- You received this message because you are subscribed to a topic in the Google Groups "weewx-user" group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/weewx-user/Qkb5l9fjk9Q/unsubscribe. To unsubscribe from this group and all its topics, send an email to weewx-user+...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. >>> >>> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "weewx-user" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/weewx-user/Qkb5l9fjk9Q/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> weewx-user+...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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.
Re: [weewx-user] Re: daily graphs stuck on an old date
OK, thanks, I'll check that tonight. On Tue, Nov 21, 2017 at 1:51 PM, gjr80 wrote: > max(dateTime) will just show you the most recent archive record > timestamp, what we need to see is whether there is any observational data > being recorded in the archive. It is quite possible that no observational > data is being recorded for some reason and hence the generated plots show > no data. Weekly and greater plots display some form of aggregate data so > they may well still show something whilst the daily plot does not. > > Gary > > On Tuesday, 21 November 2017 11:37:17 UTC+10, Richard Beare wrote: >> >> I'm not in front of the machine at the moment, but I did check the most >> recent time, and it matched the current time. >> >> from memory: >> >> select max(timeDate) from archive; >> >> which I then converted to a readable form (with R). It was definitely >> today, not the stuck date of 3 days ago. >> >> Mysterious! >> >> On Tue, Nov 21, 2017 at 12:18 PM, gjr80 wrote: >> >>> On Tuesday, 21 November 2017 07:27:15 UTC+10, Richard Beare wrote: At this point I'm starting to think I need to reinstall, but I hope I'm missing something basic. >>> Don't go doing this, it is seldom required and is usually a waste of >>> your and our time. If forcing regeneration by deletion has not helped then >>> I would have a look at what is in your database, are you getting current >>> data in there or not? Assuming you are using SQLite and not MySQL try the >>> following (assumes sqlite3 is installed, if not you need something like sudo >>> apt-get install sqlite3 to install it, also change paths to suit your >>> install): >>> >>> $ sqlite3 /home/weewx/archive/weewx.sdb >>> sqlite> SELECT STRFTIME('%d-%m-%Y %H:%M:%S', datetime(dateTime, >>> 'unixepoch')), outTemp FROM archive ORDER BY dateTime DESC LIMIT 20; >>> sqlite> .quit >>> >>> What does the SQLite query return? This will show whether you in fact >>> have current data being saved to archive or not. >>> >>> Gary >>> >>> -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "weewx-user" group. >>> To unsubscribe from this topic, visit https://groups.google.com/d/to >>> pic/weewx-user/Qkb5l9fjk9Q/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> weewx-user+...@googlegroups.com. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- > You received this message because you are subscribed to a topic in the > Google Groups "weewx-user" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/weewx-user/Qkb5l9fjk9Q/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > weewx-user+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- 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.
Re: [weewx-user] Re: daily graphs stuck on an old date
max(dateTime) will just show you the most recent archive record timestamp, what we need to see is whether there is any observational data being recorded in the archive. It is quite possible that no observational data is being recorded for some reason and hence the generated plots show no data. Weekly and greater plots display some form of aggregate data so they may well still show something whilst the daily plot does not. Gary On Tuesday, 21 November 2017 11:37:17 UTC+10, Richard Beare wrote: > > I'm not in front of the machine at the moment, but I did check the most > recent time, and it matched the current time. > > from memory: > > select max(timeDate) from archive; > > which I then converted to a readable form (with R). It was definitely > today, not the stuck date of 3 days ago. > > Mysterious! > > On Tue, Nov 21, 2017 at 12:18 PM, gjr80 > > wrote: > >> On Tuesday, 21 November 2017 07:27:15 UTC+10, Richard Beare wrote: >>> >>> >>> At this point I'm starting to think I need to reinstall, but I hope I'm >>> missing something basic. >>> >>> >> Don't go doing this, it is seldom required and is usually a waste of your >> and our time. If forcing regeneration by deletion has not helped then I >> would have a look at what is in your database, are you getting current data >> in there or not? Assuming you are using SQLite and not MySQL try the >> following (assumes sqlite3 is installed, if not you need something like sudo >> apt-get install sqlite3 to install it, also change paths to suit your >> install): >> >> $ sqlite3 /home/weewx/archive/weewx.sdb >> sqlite> SELECT STRFTIME('%d-%m-%Y %H:%M:%S', datetime(dateTime, >> 'unixepoch')), outTemp FROM archive ORDER BY dateTime DESC LIMIT 20; >> sqlite> .quit >> >> What does the SQLite query return? This will show whether you in fact >> have current data being saved to archive or not. >> >> Gary >> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "weewx-user" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/weewx-user/Qkb5l9fjk9Q/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> weewx-user+...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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.
Re: [weewx-user] Re: daily graphs stuck on an old date
I'm not in front of the machine at the moment, but I did check the most recent time, and it matched the current time. from memory: select max(timeDate) from archive; which I then converted to a readable form (with R). It was definitely today, not the stuck date of 3 days ago. Mysterious! On Tue, Nov 21, 2017 at 12:18 PM, gjr80 wrote: > On Tuesday, 21 November 2017 07:27:15 UTC+10, Richard Beare wrote: >> >> >> At this point I'm starting to think I need to reinstall, but I hope I'm >> missing something basic. >> >> > Don't go doing this, it is seldom required and is usually a waste of your > and our time. If forcing regeneration by deletion has not helped then I > would have a look at what is in your database, are you getting current data > in there or not? Assuming you are using SQLite and not MySQL try the > following (assumes sqlite3 is installed, if not you need something like sudo > apt-get install sqlite3 to install it, also change paths to suit your > install): > > $ sqlite3 /home/weewx/archive/weewx.sdb > sqlite> SELECT STRFTIME('%d-%m-%Y %H:%M:%S', datetime(dateTime, > 'unixepoch')), outTemp FROM archive ORDER BY dateTime DESC LIMIT 20; > sqlite> .quit > > What does the SQLite query return? This will show whether you in fact have > current data being saved to archive or not. > > Gary > > -- > You received this message because you are subscribed to a topic in the > Google Groups "weewx-user" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/weewx-user/Qkb5l9fjk9Q/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > weewx-user+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- 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.
[weewx-user] Re: daily graphs stuck on an old date
On Tuesday, 21 November 2017 07:27:15 UTC+10, Richard Beare wrote: > > > At this point I'm starting to think I need to reinstall, but I hope I'm > missing something basic. > > Don't go doing this, it is seldom required and is usually a waste of your and our time. If forcing regeneration by deletion has not helped then I would have a look at what is in your database, are you getting current data in there or not? Assuming you are using SQLite and not MySQL try the following (assumes sqlite3 is installed, if not you need something like sudo apt-get install sqlite3 to install it, also change paths to suit your install): $ sqlite3 /home/weewx/archive/weewx.sdb sqlite> SELECT STRFTIME('%d-%m-%Y %H:%M:%S', datetime(dateTime, 'unixepoch' )), outTemp FROM archive ORDER BY dateTime DESC LIMIT 20; sqlite> .quit What does the SQLite query return? This will show whether you in fact have current data being saved to archive or not. Gary -- 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.