Gary: one thing I'm noticing is that the tag DaySummaryManager.getAggregate() is using its superclass version, Manager.getAggregate(), presumably because the boundaries of the query are not falling on midnight.
A clue, perhaps...? -tk On Sun, Nov 11, 2018 at 3:03 PM gjr80 <gjroder...@gmail.com> wrote: > I have set up a Stretch VM using the same locale and timezone settings as > you running a .deb weeWX install and I cannot reproduce the fault you are > experiencing. This really brings me back to the your database. I will > instrument one of the weeWX files with some extra logging so we can see > exactly what is happening when the offending tag(s) is/are called. In the > meantime can you confirm exactly what version of weeWX you are now running > on the problem system (3.8.2 I am guessing) so that I can ensure I give you > a compatible version of the file. > > Gary > > On Friday, 9 November 2018 20:27:44 UTC+10, Jonis Maurin Ceará wrote: >> >> Sure! >> And one more info: this error (wind) happens on all skins. >> >> pi@SkyWeather:~ $ locale >>> LANG=en_GB.UTF-8 >>> LANGUAGE= >>> LC_CTYPE="en_GB.UTF-8" >>> LC_NUMERIC="en_GB.UTF-8" >>> LC_TIME="en_GB.UTF-8" >>> LC_COLLATE="en_GB.UTF-8" >>> LC_MONETARY="en_GB.UTF-8" >>> LC_MESSAGES="en_GB.UTF-8" >>> LC_PAPER="en_GB.UTF-8" >>> LC_NAME="en_GB.UTF-8" >>> LC_ADDRESS="en_GB.UTF-8" >>> LC_TELEPHONE="en_GB.UTF-8" >>> LC_MEASUREMENT="en_GB.UTF-8" >>> LC_IDENTIFICATION="en_GB.UTF-8" >>> LC_ALL= >>> pi@SkyWeather:~ $ timedatectl >>> Local time: Fri 2018-11-09 08:26:49 -02 >>> Universal time: Fri 2018-11-09 10:26:49 UTC >>> RTC time: n/a >>> Time zone: America/Sao_Paulo (-02, -0200) >>> Network time on: yes >>> NTP synchronized: yes >>> RTC in local TZ: no >> >> >> >> Em sex, 9 de nov de 2018 às 00:53, gjr80 <gjrod...@gmail.com> escreveu: >> >>> I have not forgotten this. Definitely starting with a clean database: >>> >>> Nov 5 10:02:31 SkyWeather weewx[30088]: manager: Created and >>> initialized table 'archive' in database 'weewx.sdb' >>> Nov 5 10:02:31 SkyWeather weewx[30088]: manager: Created daily summary >>> tables >>> >>> Interesting that the only template that fails is week.html.tmpl, all of >>> its friends (index.html.tmpl, month.html.tmpl and year.html.tmpl) also >>> contain wind tags but only week.html.tmpl fails. Suggests the issue is >>> confined to week.wind.xxx. >>> >>> Can I ask you to run a couple of commands on your weeWX system and post >>> the output. The commands are: >>> >>> locale >>> timedatectl >>> >>> >>> Gary >>> >>> >>> On Tuesday, 6 November 2018 23:50:02 UTC+10, Jonis Maurin Ceará wrote: >>>> >>>> Yes, logs from fresh install yesterday. >>>> >>>> >>>> Nov 5 10:02:31 SkyWeather weewx[30084]: engine: Initializing weewx >>>>>> version 3.8.2 >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30084]: engine: Using Python 2.7.13 >>>>>> (default, Sep 26 2018, 18:42:22) #012[GCC 6.3.0 20170516] >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30084]: engine: Platform >>>>>> Linux-4.14.71-v7+-armv7l-with-debian-9.4 >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30084]: engine: Locale is >>>>>> 'en_GB.UTF-8' >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30084]: engine: pid file is >>>>>> /var/run/weewx.pid >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Using configuration >>>>>> file /etc/weewx/weewx.conf >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Loading station type >>>>>> Simulator (weewx.drivers.simulator) >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30073]: Starting weewx weather >>>>>> system: weewx. >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: StdConvert target >>>>>> unit is 0x1 >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: wxcalculate: The following >>>>>> values will be calculated: barometer=prefer_hardware, >>>>>> windchill=prefer_hardware, dewpoint=prefer_hardware, >>>>>> appTemp=prefer_hardware, rainRate=prefer_hardware, >>>>>> windrun=prefer_hardware, >>>>>> heatindex=prefer_hardware, maxSolarRad=prefer_hardware, >>>>>> humidex=prefer_hardware, pressure=prefer_hardware, >>>>>> inDewpoint=prefer_hardware, ET=prefer_hardware, >>>>>> altimeter=prefer_hardware, >>>>>> cloudbase=prefer_hardware >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: wxcalculate: The following >>>>>> algorithms will be used for calculations: altimeter=aaNOAA, >>>>>> maxSolarRad=RS >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Archive will use data >>>>>> binding wx_binding >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Record generation >>>>>> will be attempted in 'hardware' >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Using archive >>>>>> interval of 300 seconds (specified in weewx configuration) >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: manager: Created and >>>>>> initialized table 'archive' in database 'weewx.sdb' >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: manager: Created daily >>>>>> summary tables >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Using binding >>>>>> 'wx_binding' to database 'weewx.sdb' >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: manager: Starting backfill of >>>>>> daily summaries >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: restx: StationRegistry: >>>>>> Registration not requested. >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: restx: Wunderground: Posting >>>>>> not enabled. >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: restx: PWSweather: Posting >>>>>> not enabled. >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: restx: CWOP: Posting not >>>>>> enabled. >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: restx: WOW: Posting not >>>>>> enabled. >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: restx: AWEKAS: Posting not >>>>>> enabled. >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Starting up weewx >>>>>> version 3.8.2 >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Clock error is -0.30 >>>>>> seconds (positive is fast) >>>>> >>>>> Nov 5 10:02:31 SkyWeather weewx[30088]: engine: Starting main packet >>>>>> loop. >>>>> >>>>> Nov 5 10:05:16 SkyWeather weewx[30088]: manager: Added record >>>>>> 2018-11-05 10:05:00 -02 (1541419500) to database 'weewx.sdb' >>>>> >>>>> Nov 5 10:05:16 SkyWeather weewx[30088]: manager: Added record >>>>>> 2018-11-05 10:05:00 -02 (1541419500) to daily summary in 'weewx.sdb' >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: cheetahgenerator: Generate >>>>>> failed with exception '<class 'weedb.NoColumnError'>' >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: cheetahgenerator: **** >>>>>> Ignoring template /etc/weewx/skins/Standard/week.html.tmpl >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: cheetahgenerator: **** >>>>>> Reason: no such column: wind >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** Traceback (most recent >>>>>> call last): >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** print >> _file, >>>>>> compiled_template >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in >>>>>> __str__ >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** rc = getattr(self, >>>>>> mainMethName)() >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>>> "_etc_weewx_skins_Standard_week_html_tmpl.py", line 949, in respond >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>>> "_etc_weewx_skins_Standard_week_html_tmpl.py", line 245, in >>>>>> __errorCatcher26 >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File "<string>", line >>>>>> 1, in <module> >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__ >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** return >>>>>> self._do_query(aggregate_type) >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** val=val, >>>>>> **self.option_dict) >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** return >>>>>> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, >>>>>> aggregateType, **option_dict) >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weewx/manager.py", line 1249, in getAggregate >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** **option_dict) >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weewx/manager.py", line 458, in getAggregate >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** _row = >>>>>> self.getSql(select_stmt % interpolate_dict) >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weewx/manager.py", line 394, in getSql >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** >>>>>> _cursor.execute(sql, sqlargs) >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weedb/sqlite.py", line 41, in guarded_fn >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** raise >>>>>> weedb.NoColumnError(e) >>>>> >>>>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** NoColumnError: no such >>>>>> column: wind >>>>> >>>>> Nov 5 10:05:23 SkyWeather weewx[30088]: cheetahgenerator: Generated >>>>>> 13 files for report StandardReport in 6.81 seconds >>>>> >>>>> Nov 5 10:05:31 SkyWeather weewx[30088]: imagegenerator: Generated 49 >>>>>> images for StandardReport in 7.38 seconds >>>>> >>>>> Nov 5 10:05:31 SkyWeather weewx[30088]: copygenerator: copied 9 files >>>>>> to /var/www/html/weewx >>>>> >>>>> Nov 5 10:10:16 SkyWeather weewx[30088]: manager: Added record >>>>>> 2018-11-05 10:10:00 -02 (1541419800) to database 'weewx.sdb' >>>>> >>>>> Nov 5 10:10:16 SkyWeather weewx[30088]: manager: Added record >>>>>> 2018-11-05 10:10:00 -02 (1541419800) to daily summary in 'weewx.sdb' >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: cheetahgenerator: Generate >>>>>> failed with exception '<class 'weedb.NoColumnError'>' >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: cheetahgenerator: **** >>>>>> Ignoring template /etc/weewx/skins/Standard/week.html.tmpl >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: cheetahgenerator: **** >>>>>> Reason: no such column: wind >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** Traceback (most recent >>>>>> call last): >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** print >> _file, >>>>>> compiled_template >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in >>>>>> __str__ >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** rc = getattr(self, >>>>>> mainMethName)() >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>>> "_etc_weewx_skins_Standard_week_html_tmpl.py", line 949, in respond >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>>> "_etc_weewx_skins_Standard_week_html_tmpl.py", line 245, in >>>>>> __errorCatcher26 >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File "<string>", line >>>>>> 1, in <module> >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__ >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** return >>>>>> self._do_query(aggregate_type) >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** val=val, >>>>>> **self.option_dict) >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** return >>>>>> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, >>>>>> aggregateType, **option_dict) >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weewx/manager.py", line 1249, in getAggregate >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** **option_dict) >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weewx/manager.py", line 458, in getAggregate >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** _row = >>>>>> self.getSql(select_stmt % interpolate_dict) >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weewx/manager.py", line 394, in getSql >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** >>>>>> _cursor.execute(sql, sqlargs) >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** File >>>>>> "/usr/share/weewx/weedb/sqlite.py", line 41, in guarded_fn >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** raise >>>>>> weedb.NoColumnError(e) >>>>> >>>>> Nov 5 10:10:17 SkyWeather weewx[30088]: **** NoColumnError: no such >>>>>> column: wind >>>>> >>>>> Nov 5 10:10:18 SkyWeather weewx[30088]: cheetahgenerator: Generated >>>>>> 13 files for report StandardReport in 2.02 seconds >>>>> >>>>> Nov 5 10:10:19 SkyWeather weewx[30088]: imagegenerator: Generated 12 >>>>>> images for StandardReport in 0.98 seconds >>>>> >>>>> Nov 5 10:10:19 SkyWeather weewx[30088]: copygenerator: copied 0 files >>>>>> to /var/www/html/weewx >>>>> >>>>> >>>>> >>>> Em seg, 5 de nov de 2018 às 22:37, gjr80 <gjrod...@gmail.com> escreveu: >>>> >>>>> Ok, the problem is that if you are starting from a clean install >>>>> (including database) running the simulator after a daylight savings change >>>>> the timezone/daylight savings state of your system is irrelevant, all >>>>> times/timestamps are drawn from the system clock and if it is not changing >>>>> (since the daylight saving cutover was in the past) then daylight saving >>>>> cannot be the cause of the error. >>>>> >>>>> Do you still have the logs on your system from when you did the clean >>>>> install using simulator and SQLite? If so can you post the log from when >>>>> weeWX first started after that install through until the error appeared. >>>>> If >>>>> you don't have the logs then please do a clean install using the simulator >>>>> and SQLite and provide the log showing weeWX startup through until the >>>>> error occurs. >>>>> >>>>> Gary >>>>> >>>>> On Tuesday, 6 November 2018 09:59:06 UTC+10, Jonis Maurin Ceará wrote: >>>>>> >>>>>> Ok, let me explain: >>>>>> >>>>>> 1) Remove all packages and files relates to weewx (including all dir >>>>>> and subdirs on /etc/weewx, /usr/share/weewx, /var/lib/weewx or >>>>>> /usr/lib/weewx, don't rememebr now). Everything >>>>>> 2) Install from .deb package and accept default settings (name, >>>>>> location, driver=simulation, etc...) >>>>>> 3) Just start, done! >>>>>> >>>>>> When you access webpage, loads fine.....but still the same error in >>>>>> logfile, wind column not found (of course, the error is using sqlite, and >>>>>> not mysqllite like I posted). >>>>>> >>>>>> Second attempt: >>>>>> 1) Change archive database to mysql instead of sqlite. >>>>>> 2) Re-start weewx. Tables are created and archive page is created >>>>>> 3) Still the same problem on log (wind column), but information on >>>>>> log's say 'mysql' driver, and not sqlite. >>>>>> >>>>>> And then with fileparser driver, with exactly same results.... >>>>>> >>>>>> >>>>>> I found something related to brazilian daylight saving time, but I >>>>>> lost the link of thread and also I don't knwo where to put suggested user >>>>>> code (is modification of core code, I think). >>>>>> >>>>>> >>>>>> Em seg, 5 de nov de 2018 às 21:31, gjr80 <gjrod...@gmail.com> >>>>>> escreveu: >>>>>> >>>>>>> On Tuesday, 6 November 2018 01:57:22 UTC+10, Jonis Maurin Ceará >>>>>>> wrote: >>>>>>>> >>>>>>>> Content of /tmp/weather.data: >>>>>>>> >>>>>>>> rainRate=0.0 >>>>>>>> windSpeed=10.0466685247 >>>>>>>> windGust=16.3395133004 >>>>>>>> pressure=28.0709227 >>>>>>>> outTemp=84.2 >>>>>>>> outHumidity=71.1999969482 >>>>>>>> windDir=0.0 >>>>>>>> UV=1.59 >>>>>>>> VIS=554 >>>>>>>> >>>>>>> >>>>>>> OK, so dateTime is not being overridden by your source data (for >>>>>>> fileparse driver the default is for the dateTime field to be set from >>>>>>> the >>>>>>> system time). >>>>>>> >>>>>>> But the problem is that this errors ocours even with simulator on >>>>>>>> fresh install.... >>>>>>>> >>>>>>> >>>>>>> There must be more to this. What do you mean by 'simulator on fresh >>>>>>> install'. A fresh install of weeWX using the simulator I presume, but >>>>>>> what >>>>>>> about your database? You were using MySQL so a new weeWX install does >>>>>>> not >>>>>>> necessarily mean a clean database, whereas a new install using SQLite >>>>>>> does >>>>>>> erase the database. My apologies if your situation is very clear to you, >>>>>>> but you have used two drivers, two different database engines and two >>>>>>> versions of weeWX so it is not very clear to me exactly what your >>>>>>> current >>>>>>> setup is. >>>>>>> >>>>>>> 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/llOh8p8emYY/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/llOh8p8emYY/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/llOh8p8emYY/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. > -- 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.