I haven't run into this issue before. Looks like it's something with weewx maybe and not the skin? How big is your database? Is it sqlite or mysql (in weewx.conf [DataBindings] -> [[dest_binding]], what is database = ???)
On Thursday, December 13, 2018 at 4:50:21 PM UTC-5, steeple ian wrote: > > I am running a Pi 3 B+ > > Sent from my iPhone > > On 13 Dec 2018, at 21:25, kutz...@gmail.com <javascript:> wrote: > > Your log indicates that the database is becoming locked, causing weewx to > terminate the Generator. > > What are you running weewx on? > Is it a Raspberry Pi? > If so, what model? > > I had similar problems when I was running weewx with the Belchertown skin > on a Raspberry Pi Zero W. The Pi Zero W took over 240 seconds to render the > graphs. My archive period is 5 minutes (300 seconds). When I added another > task to the Pi, it slowed down enough that weewx hung because the > Belchertown skin was trying to read the database at the same time that > weewx was trying to write archive data to the database. > > I moved my weewx implementation to a Raspberry Pi 3B+ and the Belchertown > graph rendering dropped to about 45 seconds and my problems went away. > > I suspect that's what's happening. to you. > > phil > > On Thursday, December 13, 2018 at 2:50:16 PM UTC-5, Hector Valenzuela > wrote: > > Hi Pat this is my problem. Most of the time weewx works well but there is > a moment when the following error occurs, the page loses all graphics and 3 > minutes later it works normally again. > > Dec 13 12:38:21 san_martin weewx[25357]: engine: Shutting down StdReport > thread > Dec 13 12:38:21 san_martin weewx[25357]: reportengine: Caught > unrecoverable exception in generator weewx.cheetahgenerator.CheetahGenerator > Dec 13 12:38:21 san_martin weewx[25357]: **** database is locked > Dec 13 12:38:21 san_martin weewx[25357]: **** Traceback (most > recent call last): > Dec 13 12:38:21 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/reportengine.py", line 140, in run > Dec 13 12:38:21 san_martin weewx[25357]: **** obj.start() > Dec 13 12:38:21 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/reportengine.py", line 170, in start > Dec 13 12:38:21 san_martin weewx[25357]: **** self.run() > Dec 13 12:38:21 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 143, in run > Dec 13 12:38:21 san_martin weewx[25357]: **** ngen = > self.generate(gen_dict[option_section_name], self.gen_ts) > Dec 13 12:38:21 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 206, in generate > Dec 13 12:38:21 san_martin weewx[25357]: **** ngen += > self.generate(section[subsection], gen_ts) > Dec 13 12:38:21 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 206, in generate > Dec 13 12:38:21 san_martin weewx[25357]: **** ngen += > self.generate(section[subsection], gen_ts) > Dec 13 12:38:21 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 290, in generate > Dec 13 12:38:21 san_martin weewx[25357]: **** default_binding) > Dec 13 12:38:21 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 332, in _getSearchList > Dec 13 12:38:21 san_martin weewx[25357]: **** searchList += > obj.get_extension_list(timespan, db_lookup) > Dec 13 12:38:21 san_martin weewx[25357]: **** File > "/home/weewx/bin/user/belchertown_highchartsSearchX.py", line 1084, in > get_extension_list > Dec 13 12:38:21 san_martin weewx[25357]: **** (time_start_vt, > time_stop_vt, radiation_vt) = db_lookup().getSqlVectors(TimeSpan(_start_ts, > _end_ts), 'radiation', 'max', 86400) > Dec 13 12:38:21 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 496, in getSqlVectors > Dec 13 12:38:21 san_martin weewx[25357]: **** aggregate_type, > aggregate_interval) > Dec 13 12:38:21 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 723, in _getSqlVectors > Dec 13 12:38:21 san_martin weewx[25357]: **** > _cursor.execute(sql_str, stamp) > Dec 13 12:38:21 san_martin weewx[25357]: **** File > "/home/weewx/bin/weedb/sqlite.py", line 37, in guarded_fn > Dec 13 12:38:21 san_martin weewx[25357]: **** raise > weedb.OperationalError(e) > Dec 13 12:38:21 san_martin weewx[25357]: **** OperationalError: > database is locked > Dec 13 12:38:21 san_martin weewx[25357]: **** Generator > terminated... > Dec 13 12:38:23 san_martin weewx[25357]: reportengine: copied 0 files to > /home/weewx/public_html/belchertown/images > Dec 13 12:38:29 san_martin weewx[25357]: reportengine: Caught > unrecoverable exception in generator weewx.cheetahgenerator.CheetahGenerator > Dec 13 12:38:29 san_martin weewx[25357]: **** database is locked > Dec 13 12:38:29 san_martin weewx[25357]: reportengine: Caught > unrecoverable exception in generator weewx.cheetahgenerator.CheetahGenerator > Dec 13 12:38:29 san_martin weewx[25357]: **** database is locked > Dec 13 12:38:29 san_martin weewx[25357]: **** Traceback (most > recent call last): > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/reportengine.py", line 140, in run > Dec 13 12:38:29 san_martin weewx[25357]: **** obj.start() > Dec 13 12:38:29 san_martin weewx[25357]: **** Traceback (most > recent call last): > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/reportengine.py", line 170, in start > Dec 13 12:38:29 san_martin weewx[25357]: **** self.run() > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/reportengine.py", line 140, in run > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 143, in run > Dec 13 12:38:29 san_martin weewx[25357]: **** obj.start() > Dec 13 12:38:29 san_martin weewx[25357]: **** ngen = > self.generate(gen_dict[option_section_name], self.gen_ts) > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/reportengine.py", line 170, in start > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 206, in generate > Dec 13 12:38:29 san_martin weewx[25357]: **** ngen += > self.generate(section[subsection], gen_ts) > Dec 13 12:38:29 san_martin weewx[25357]: **** self.run() > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 206, in generate > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 140, in run > Dec 13 12:38:29 san_martin weewx[25357]: **** ngen += > self.generate(section[subsection], gen_ts) > Dec 13 12:38:29 san_martin weewx[25357]: **** > self.initExtensions(gen_dict[option_section_name]) > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 290, in generate > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 177, in initExtensions > Dec 13 12:38:29 san_martin weewx[25357]: **** default_binding) > Dec 13 12:38:29 san_martin weewx[25357]: **** > self.search_list_objs.append(class_(self)) > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 332, in _getSearchList > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 433, in __init__ > Dec 13 12:38:29 san_martin weewx[25357]: **** searchList += > obj.get_extension_list(timespan, db_lookup) > Dec 13 12:38:29 san_martin weewx[25357]: **** archive = > self.generator.db_binder.get_manager() > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/user/belchertown_highchartsSearchX.py", line 1084, in > get_extension_list > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 824, in get_manager > Dec 13 12:38:29 san_martin weewx[2535 > > ... -- 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.