I am away from home so cannot help with the locale issue, Tom or others may
have some insights. It does not appear to be related to the meanmax/wind
issue.
I still think that something is causing WeeWX to see future dated records,
or more precisely, the current record during a report cycle is not being
seen as the most recent record. If 20:43 was the time of your most recent
archive record I am guessing you are using a very short archive period, say
one minute? From the short log extract it appears that WeeWX is handling
this OK, but it would be better to see a longer log extract, preferably
following a WeeWX restart so we can see the full WeeWX startup. Could you
restart WeeWX and then post a log extract showing the full WeeWX startup
and then say, at least 10 or so archive intervals.
Gary
On Monday, 5 June 2023 at 20:52:36 UTC+2 mihec wrote:
> Hi Gary,
> thanks for you quick response!
> I checked for the latest date in my database and it seems I have no such
> records:
>
> pi@raspberrypi:~/database $ sqlite3 weewx.sdb
> SQLite version 3.16.2 2017-01-06 16:32:41
> Enter ".help" for usage hints.
>
> sqlite> SELECT datetime(MAX(dateTime), 'unixepoch', 'localtime') FROM
> archive;
> 2023-06-05 20:43:00
> sqlite> .q
>
> I tried to do a rebuild-daily:
>
> pi@raspberrypi:~/database $ wee_database --rebuild-daily
>
> Traceback (most recent call last):
> File "/usr/bin/wee_database", line 18, in <module>
> import user.extensions #@UnusedImport
> File "/usr/share/weewx/user/extensions.py", line 18, in <module>
> locale.setlocale(locale.LC_ALL, '')
> File "/usr/lib/python2.7/locale.py", line 581, in setlocale
> return _setlocale(category, locale)
> locale.Error: unsupported locale setting
>
> Something in my configuration doesn't seem ok... Probably not related to
> original post.
>
> Thanks for any further hint.
> ponedeljek, 5. junij 2023 ob 20:02:53 UTC+2 je oseba gjr80 napisala:
>
>> Something appears to be forcing some of your aggregates that should be
>> calculated on the daily summaries to be instead calculated on the archive.
>> is there any chance you have some future dated records in your archive? Try
>> the following to check:
>>
>> 1. open your database with sqlite3:
>> $ sqlite3 /var/lib/weewx/weewx.sdb
>> (if sqlite3 is not found you will need to install it using something
>> like sudo apt install sqlite3 and then try again)
>>
>> 2. obtain the timestamp of the last record in the archive in human
>> readable form:
>> sqlite> SELECT datetime(MAX(dateTime), 'unixepoch', 'localtime') FROM
>> archive;
>> This should display something like:
>> 2023-06-05 03:05:00
>>
>> 3. exit sqlite3:
>> sqlite> .q
>>
>> If the date at step 2 above is in the future you have some future dated
>> records in your archive. To remove these:
>>
>> 1. stop WeeWX
>> $ sudo systemctl stop weewx
>>
>> 2. make a backup of your WeeWX database:
>> $ cp /var/lib/weewx/weewx.sdb /var/lib/weewx/weewx_backup.sdb
>>
>> 3. open your database with sqlite3:
>> $ sqlite3 /var/lib/weewx/weewx.sdb
>>
>> 4. delete all future dated archive records:
>> sqlite> DELETE FROM archive WHERE dateTime>STRFTIME('%s');
>>
>> 5. check there are no more future dated records:
>> sqlite> SELECT datetime(MAX(dateTime), 'unixepoch', 'localtime') FROM
>> archive;
>>
>> 6. if there are no more future dated records exit sqlite3:
>> sqlite> .q
>>
>> 7. rebuild the daily summaries:
>> $ wee_database --rebuild-daily
>>
>> 8. restart WeeWX:
>> $ sudo systemctl restart WeeWX
>>
>> Depending on your system some of the above linux commands may need to be
>> prefixed with sudo.
>>
>> Gary
>> On Monday, 5 June 2023 at 18:59:05 UTC+2 mihec wrote:
>>
>>> Hi,
>>> I'm having issues with NOAA report generation ever since I installed the
>>> station but never minded enough to fix it.
>>> I use Weatherflow Air & Sky, weewx version is 3.9.2.
>>>
>>> This is the error message in the /var/log/syslog:
>>>
>>> Jun 5 18:52:37 raspberrypi weewx[451]: cheetahgenerator: Generate
>>> failed with exception '<class 'weewx.ViolatedPrecondition'>'
>>> Jun 5 18:52:37 raspberrypi weewx[451]: cheetahgenerator: **** Ignoring
>>> template /etc/weewx/skins/neowx/NOAA/NOAA-YYYY.txt.tmpl
>>> Jun 5 18:52:37 raspberrypi weewx[451]: cheetahgenerator: **** Reason:
>>> Invalid aggregation type 'meanmax'
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** Traceback (most recent
>>> call last):
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 332, in generate
>>> Jun 5 18:52:37 raspberrypi weewx[451]: ****
>>> fd.write(str(compiled_template))
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
>>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in
>>> __str__
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** rc = getattr(self,
>>> mainMethName)()
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
>>> "_etc_weewx_skins_neowx_NOAA_NOAA_YYYY_txt_tmpl.py", line 741, in respond
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
>>> "_etc_weewx_skins_neowx_NOAA_NOAA_YYYY_txt_tmpl.py", line 315, in
>>> __errorCatcher28
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** File "<string>", line 1,
>>> in <module>
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
>>> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** return
>>> self._do_query(aggregate_type)
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
>>> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** val=val,
>>> **self.option_dict)
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
>>> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** return
>>> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type,
>>> aggregateType, **option_dict)
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
>>> "/usr/share/weewx/weewx/manager.py", line 1268, in getAggregate
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** **option_dict)
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** File
>>> "/usr/share/weewx/weewx/manager.py", line 450, in getAggregate
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** raise
>>> weewx.ViolatedPrecondition("Invalid aggregation type '%s'" % aggregate_type)
>>> Jun 5 18:52:37 raspberrypi weewx[451]: **** ViolatedPrecondition:
>>> Invalid aggregation type 'meanmax'
>>> Jun 5 18:52:37 raspberrypi weewx[451]: cheetahgenerator: Generate
>>> failed with exception '<class 'weedb.NoColumnError'>'
>>> Jun 5 18:52:37 raspberrypi weewx[451]: cheetahgenerator: **** Ignoring
>>> template /etc/weewx/skins/neowx/NOAA/NOAA-YYYY-MM.txt.tmpl
>>> Jun 5 18:52:38 raspberrypi weewx[451]: cheetahgenerator: **** Reason:
>>> no such column: wind
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** Traceback (most recent
>>> call last):
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 332, in generate
>>> Jun 5 18:52:38 raspberrypi weewx[451]: ****
>>> fd.write(str(compiled_template))
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
>>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in
>>> __str__
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** rc = getattr(self,
>>> mainMethName)()
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
>>> "_etc_weewx_skins_neowx_NOAA_NOAA_YYYY_MM_txt_tmpl.py", line 496, in respond
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
>>> "_etc_weewx_skins_neowx_NOAA_NOAA_YYYY_MM_txt_tmpl.py", line 308, in
>>> __errorCatcher35
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** File "<string>", line 1,
>>> in <module>
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
>>> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** return
>>> self._do_query(aggregate_type)
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
>>> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** val=val,
>>> **self.option_dict)
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
>>> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** return
>>> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type,
>>> aggregateType, **option_dict)
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
>>> "/usr/share/weewx/weewx/manager.py", line 1268, in getAggregate
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** **option_dict)
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
>>> "/usr/share/weewx/weewx/manager.py", line 459, in getAggregate
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** _row =
>>> self.getSql(select_stmt % interpolate_dict)
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
>>> "/usr/share/weewx/weewx/manager.py", line 395, in getSql
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** _cursor.execute(sql,
>>> sqlargs)
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** File
>>> "/usr/share/weewx/weedb/sqlite.py", line 41, in guarded_fn
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** raise
>>> weedb.NoColumnError(e)
>>> Jun 5 18:52:38 raspberrypi weewx[451]: **** NoColumnError: no such
>>> column: wind
>>>
>>> Is the problem related to the missing aggregation type or something else?
>>>
>>> Thanks.
>>>
>>
--
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/ed7a7d73-64fa-4c73-bfa8-ec140dbc6aa1n%40googlegroups.com.
