Fixed the cheetah errors by manually renaming the weewxwd tables using: RENAME TABLE archive_day_apptemp TO archive_day_appTemp; RENAME TABLE archive_day_outtempday TO archive_day_outTempDay; RENAME TABLE archive_day_outtempnight TO archive_day_outTempNight;
On Saturday, February 9, 2019 at 7:50:13 AM UTC-6, john hutchison wrote: > > OK, thanks for looking into it. Further info is I had made NO changes to > weewx AFIAK, and it has been happening since mid last year. The cheetah > errors are the only errors shown when debug=1, and happen every archive > interval. > > Are the cheetah errors related to the wdSearchX3 issue? > > On Thursday, February 7, 2019 at 11:19:32 PM UTC-6, gjr80 wrote: >> >> Hi, >> >> I have seen this error (the import error) appear on a few machines and we >> have never been able to reliably reproduce it nor track down a cause. I >> will look into it but it may not be a quick solution. >> >> Gary >> >> On Friday, 8 February 2019 06:31:41 UTC+10, john hutchison wrote: >>> >>> I am receiving the following errors: >>> >>> john@john-PS583AA-ABA-a1020n ~ $ wd_database -h >>> Traceback (most recent call last): >>> File "/usr/local/bin/wd_database", line 44, in <module> >>> import user.wdSearchX3 >>> ImportError: No module named wdSearchX3 >>> >>> && >>> >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: cheetahgenerator: >>> Generate failed with exception '<class 'NameMapper.NotFound'>' >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: cheetahgenerator: >>> **** Ignoring template /etc/weewx/skins/Clientraw/clientraw.txt.tmpl >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: cheetahgenerator: >>> **** Reason: cannot find 'max' while searching for 'appTemp.max.degree_C' >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: **** Traceback >>> (most recent call last): >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: **** File >>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 332, in generate >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: **** >>> fd.write(str(compiled_template)) >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: **** File >>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in >>> __str__ >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: **** rc = >>> getattr(self, mainMethName)() >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: **** File >>> "_etc_weewx_skins_Clientraw_clientraw_txt_tmpl.py", line 536, in respond >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: **** NotFound: >>> cannot find 'max' while searching for 'appTemp.max.degree_C' >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: cheetahgenerator: >>> Generated 0 files for report wdClientraw in 0.70 seconds >>> >>> && >>> >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: cheetahgenerator: >>> Generate failed with exception '<class 'NameMapper.NotFound'>' >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: cheetahgenerator: >>> **** Ignoring template /etc/weewx/skins/SteelGauges/customclientraw.txt.tmpl >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: cheetahgenerator: >>> **** Reason: cannot find 'min' while searching for 'appTemp.min.formatted' >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: **** Traceback >>> (most recent call last): >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: **** File >>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 332, in generate >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: **** >>> fd.write(str(compiled_template)) >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: **** File >>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in >>> __str__ >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: **** rc = >>> getattr(self, mainMethName)() >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: **** File >>> "_etc_weewx_skins_SteelGauges_customclientraw_txt_tmpl.py", line 229, in >>> respond >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: **** NotFound: >>> cannot find 'min' while searching for 'appTemp.min.formatted' >>> Feb 7 13:56:16 john-PS583AA-ABA-a1020n weewx[29003]: cheetahgenerator: >>> Generated 0 files for report wdSteelGauges in 0.07 second >>> >>> Please also see the attached pip.txt and wee_debug.txt files. >>> >>> I was having this issue a few weeks ago with 3.8.0, and now am on 3.9.1. >>> I have successfully uninstalled and reinstalled weewxwd 1.0.3 and the >>> issue persists. If anyone wonders why I have copies of weewxwd3.py in the >>> ~/user folder it is because the 1_03.py is a backup of the official >>> package, and the 1_04.py is a copy of the patched version 1.0.4. >>> >>> Running on Linux Mint 17.2, mariaDB 10.1.37. >>> >>> This issue was happening before migrating my DB from one server running >>> mariaDB 5.5 to the current vm running mariaDB 10.1.37. After the migration >>> I experienced and resolved the lower_case_table = 1 issue and >>> dropped/rebuilt the weewx daily and now the table has the correct cases. >>> When attempting to drop/rebuild weewxwd I receive the error: >>> >>> john@john-PS583AA-ABA-a1020n ~ $ wd_database --drop-daily >>> Traceback (most recent call last): >>> File "/usr/local/bin/wd_database", line 44, in <module> >>> import user.wdSearchX3 >>> ImportError: No module named wdSearchX3 >>> >>> I have verified the wdSearchX3.py is in the correct folder: >>> >>> john@john-PS583AA-ABA-a1020n /usr/share/weewx/user $ ls -la >>> total 1344 >>> drwxr-xr-x 3 root root 4096 Feb 7 13:41 . >>> drwxr-xr-x 10 root root 4096 Feb 7 12:29 .. >>> -rw-r--r-- 1 root root 3329 Feb 6 02:11 alltime.py >>> -rw-r--r-- 1 root root 2381 Feb 7 12:30 alltime.pyc >>> -rw-r--r-- 1 root root 31127 Feb 7 12:39 cmon.py >>> -rw-r--r-- 1 root root 26616 Feb 7 12:41 cmon.pyc >>> -rw-r--r-- 1 root root 31164 Feb 6 02:12 crt.py >>> -rw-r--r-- 1 root root 26200 Feb 7 12:29 crt.pyc >>> -rw-r--r-- 1 root root 3223 Feb 6 02:11 csv.py >>> -rw-r--r-- 1 root root 3792 Feb 7 12:29 csv.pyc >>> -rw-r--r-- 1 root root 4799 Feb 6 02:13 cwxn.py >>> -rw-r--r-- 1 root root 5754 Feb 7 12:29 cwxn.pyc >>> -rw-r--r-- 1 root root 12081 Feb 6 02:12 emoncms.py >>> -rw-r--r-- 1 root root 10640 Feb 7 12:29 emoncms.pyc >>> -rw-r--r-- 1 root root 541 Mar 13 2016 extensions.py >>> -rw-r--r-- 1 root root 419 Feb 7 12:29 extensions.pyc >>> -rw-r--r-- 1 root root 191165 Feb 6 02:10 forecast.py >>> -rw-r--r-- 1 root root 124790 Feb 7 12:29 forecast.pyc >>> -rw-rw-r-- 1 root root 14587 Feb 6 02:11 gaugeengine.py >>> -rw-r--r-- 1 root root 10550 Feb 7 12:30 gaugeengine.pyc >>> -rw-rw-r-- 1 root root 25053 Feb 6 02:11 gauges.py >>> -rw-r--r-- 1 root root 18712 Feb 7 12:30 gauges.pyc >>> -rw-rw-r-- 1 root root 16195 Feb 6 02:11 historygenerator.py >>> -rw-r--r-- 1 root root 11726 Feb 7 12:30 historygenerator.pyc >>> -rw-r--r-- 1 root root 36491 Feb 7 10:24 imageStackedWindRose3.py >>> -rw-r--r-- 1 root root 16152 Feb 7 12:31 imageStackedWindRose3.pyc >>> -rw-rw-r-- 1 root root 6087 Feb 6 02:11 inigo-since.py >>> -rw-r--r-- 1 root root 5320 Feb 7 12:30 inigo-since.pyc >>> -rw-r--r-- 1 root root 306 Feb 6 07:27 __init__.py >>> -rw-r--r-- 1 root root 324 Feb 7 12:29 __init__.pyc >>> drwxr-xr-x 19 root root 4096 Feb 7 13:41 installer >>> -rw-r--r-- 1 root root 9870 Feb 6 02:11 meteotemplate.py >>> -rw-r--r-- 1 root root 10994 Feb 7 12:29 meteotemplate.pyc >>> -rw-r--r-- 1 root root 16923 Feb 6 02:11 mqtt.py >>> -rw-r--r-- 1 root root 14260 Feb 7 12:29 mqtt.pyc >>> -rw-rw-r-- 1 root root 3332 Feb 6 02:11 translategenerator.py >>> -rw-r--r-- 1 root root 3563 Feb 7 12:30 translategenerator.pyc >>> -rw-r--r-- 1 root root 13504 Feb 6 02:11 wcloud.py >>> -rw-r--r-- 1 root root 12112 Feb 7 12:29 wcloud.pyc >>> -rw-r--r-- 1 root root 35464 Feb 7 10:24 wdAstroSearchX3.py >>> -rw-r--r-- 1 root root 26298 Feb 7 12:31 wdAstroSearchX3.pyc >>> -rw-r--r-- 1 root root 41510 Feb 7 10:24 wd_database >>> -rw-r--r-- 1 root root 186059 Feb 7 10:24 wdSearchX3.py >>> -rw-r--r-- 1 root root 97702 Feb 7 12:31 wdSearchX3.pyc >>> -rw-r--r-- 1 root root 44366 Feb 7 10:24 wdTaggedStats3.py >>> -rw-r--r-- 1 root root 30414 Feb 7 12:31 wdTaggedStats3.pyc >>> -rw-r--r-- 1 root root 12249 Jan 26 19:01 weewxwd3_1_03.py >>> -rw-r--r-- 1 root root 12706 Feb 6 09:31 weewxwd3_1_04.py >>> -rw-r--r-- 1 root root 12706 Feb 7 10:27 weewxwd3.py >>> -rw-r--r-- 1 root root 6944 Feb 7 12:29 weewxwd3.pyc >>> -rw-rw-r-- 1 root root 23044 Feb 6 02:11 wxobs.py >>> -rw-r--r-- 1 root root 9932 Feb 7 12:30 wxobs.pyc >>> -rw-r--r-- 1 root root 2553 Feb 6 02:10 zabbix.py >>> -rw-r--r-- 1 root root 2859 Feb 7 12:29 zabbix.pyc >>> >>> >>> -- 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.
