I have found exactly the same thing happening. The pages do not render correctly whilst database activities are taking place. It seems as though there is a resource problem.
Sent from my iPhone > On 13 Dec 2018, at 19:50, Hector Valenzuela <[email protected]> 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[25357]: **** (time_start_vt, > time_stop_vt, radiation_vt) = db_lookup().getSqlVectors(TimeSpan(_start_ts, > _end_ts), 'radiation', 'max', 86400) > Dec 13 12:38:29 san_martin weewx[25357]: **** > self.manager_cache[data_binding] = open_manager(manager_dict, initialize) > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 496, in getSqlVectors > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 976, in open_manager > Dec 13 12:38:29 san_martin weewx[25357]: **** aggregate_type, > aggregate_interval) > Dec 13 12:38:29 san_martin weewx[25357]: **** > manager_dict['table_name']) > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 723, in _getSqlVectors > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 102, in open > Dec 13 12:38:29 san_martin weewx[25357]: **** > _cursor.execute(sql_str, stamp) > Dec 13 12:38:29 san_martin weewx[25357]: **** dbmanager = > cls(connection, table_name) > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weedb/sqlite.py", line 37, in guarded_fn > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 1109, in __init__ > Dec 13 12:38:29 san_martin weewx[25357]: **** raise > weedb.OperationalError(e) > Dec 13 12:38:29 san_martin weewx[25357]: **** > super(DaySummaryManager, self).__init__(connection, table_name, schema) > Dec 13 12:38:29 san_martin weewx[25357]: **** OperationalError: > database is locked > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 70, in __init__ > Dec 13 12:38:29 san_martin weewx[25357]: **** Generator terminated... > Dec 13 12:38:29 san_martin weewx[25357]: **** self.sqlkeys = > self.connection.columnsOf(self.table_name) > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weedb/sqlite.py", line 155, in columnsOf > Dec 13 12:38:29 san_martin weewx[25357]: **** column_list = > [row[1] for row in self.genSchemaOf(table)] > Dec 13 12:38:29 san_martin weewx[25357]: **** File > "/home/weewx/bin/weedb/sqlite.py", line 144, in genSchemaOf > Dec 13 12:38:29 san_martin weewx[25357]: **** for row in > self.connection.execute("""PRAGMA table_info(%s);""" % table): > Dec 13 12:38:29 san_martin weewx[25357]: **** OperationalError: > database is locked > Dec 13 12:38:29 san_martin weewx[25357]: **** Generator terminated... > Dec 13 12:38:29 san_martin weewx[25357]: reportengine: copied 1 files to > /home/weewx/public_html/belchertown/images > Dec 13 12:38:29 san_martin weewx[25357]: reportengine: copied 0 files to > /home/weewx/public_html/belchertown/images > Dec 13 12:38:32 san_martin weewx[25357]: rsyncupload: rsync'd 17 files > (1,964,298 bytes) in 3.29 seconds > Dec 13 12:38:34 san_martin weewx[25357]: reportengine: Caught unrecoverable > exception in generator weewx.cheetahgenerator.CheetahGenerator > Dec 13 12:38:34 san_martin weewx[25357]: **** database is locked > Dec 13 12:38:34 san_martin weewx[25357]: **** Traceback (most recent > call last): > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/reportengine.py", line 140, in run > Dec 13 12:38:34 san_martin weewx[25357]: **** obj.start() > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/reportengine.py", line 170, in start > Dec 13 12:38:34 san_martin weewx[25357]: **** self.run() > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 143, in run > Dec 13 12:38:34 san_martin weewx[25357]: **** ngen = > self.generate(gen_dict[option_section_name], self.gen_ts) > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 206, in generate > Dec 13 12:38:34 san_martin weewx[25357]: **** ngen += > self.generate(section[subsection], gen_ts) > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 206, in generate > Dec 13 12:38:34 san_martin weewx[25357]: **** ngen += > self.generate(section[subsection], gen_ts) > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 290, in generate > Dec 13 12:38:34 san_martin weewx[25357]: **** default_binding) > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 332, in _getSearchList > Dec 13 12:38:34 san_martin weewx[25357]: **** searchList += > obj.get_extension_list(timespan, db_lookup) > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/user/belchertown_highchartsSearchX.py", line 1039, in > get_extension_list > Dec 13 12:38:34 san_martin weewx[25357]: **** (time_start_vt, > time_stop_vt, rainRate_vt) = db_lookup().getSqlVectors(TimeSpan(_start_ts, > _end_ts), 'rain', '', 86400) > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 496, in getSqlVectors > Dec 13 12:38:34 san_martin weewx[25357]: **** aggregate_type, > aggregate_interval) > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 742, in _getSqlVectors > Dec 13 12:38:34 san_martin weewx[25357]: **** for _rec in > _cursor.execute(sql_str, (startstamp, stopstamp)): > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weedb/sqlite.py", line 37, in guarded_fn > Dec 13 12:38:34 san_martin weewx[25357]: **** raise > weedb.OperationalError(e) > Dec 13 12:38:34 san_martin weewx[25357]: **** OperationalError: > database is locked > Dec 13 12:38:34 san_martin weewx[25357]: **** Generator terminated... > Dec 13 12:38:34 san_martin weewx[25357]: reportengine: copied 0 files to > /home/weewx/public_html/belchertown/images > Dec 13 12:38:34 san_martin weewx[25357]: reportengine: Caught unrecoverable > exception in generator weewx.cheetahgenerator.CheetahGenerator > Dec 13 12:38:34 san_martin weewx[25357]: **** database is locked > Dec 13 12:38:34 san_martin weewx[25357]: **** Traceback (most recent > call last): > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/reportengine.py", line 140, in run > Dec 13 12:38:34 san_martin weewx[25357]: **** obj.start() > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/reportengine.py", line 170, in start > Dec 13 12:38:34 san_martin weewx[25357]: **** self.run() > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 140, in run > Dec 13 12:38:34 san_martin weewx[25357]: **** > self.initExtensions(gen_dict[option_section_name]) > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 177, in initExtensions > Dec 13 12:38:34 san_martin weewx[25357]: **** > self.search_list_objs.append(class_(self)) > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/cheetahgenerator.py", line 433, in __init__ > Dec 13 12:38:34 san_martin weewx[25357]: **** archive = > self.generator.db_binder.get_manager() > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 824, in get_manager > Dec 13 12:38:34 san_martin weewx[25357]: **** > self.manager_cache[data_binding] = open_manager(manager_dict, initialize) > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 976, in open_manager > Dec 13 12:38:34 san_martin weewx[25357]: **** > manager_dict['table_name']) > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 102, in open > Dec 13 12:38:34 san_martin weewx[25357]: **** dbmanager = > cls(connection, table_name) > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 1109, in __init__ > Dec 13 12:38:34 san_martin weewx[25357]: **** > super(DaySummaryManager, self).__init__(connection, table_name, schema) > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weewx/manager.py", line 70, in __init__ > Dec 13 12:38:34 san_martin weewx[25357]: **** self.sqlkeys = > self.connection.columnsOf(self.table_name) > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weedb/sqlite.py", line 155, in columnsOf > Dec 13 12:38:34 san_martin weewx[25357]: **** column_list = > [row[1] for row in self.genSchemaOf(table)] > Dec 13 12:38:34 san_martin weewx[25357]: **** File > "/home/weewx/bin/weedb/sqlite.py", line 144, in genSchemaOf > Dec 13 12:38:34 san_martin weewx[25357]: **** for row in > self.connection.execute("""PRAGMA table_info(%s);""" % table): > Dec 13 12:38:34 san_martin weewx[25357]: **** OperationalError: > database is locked > Dec 13 12:38:34 san_martin weewx[25357]: **** Generator terminated... > Dec 13 12:38:34 san_martin weewx[25357]: reportengine: copied 1 files to > /home/weewx/public_html/belchertown/images > Dec 13 12:38:35 san_martin weewx[25357]: rsyncupload: rsync'd 1 files (40,464 > bytes) in 1.33 seconds > Dec 13 12:38:35 san_martin weewx[25357]: engine: Caught database > OperationalError: database is locked > Dec 13 12:38:35 san_martin weewx[25357]: **** Waiting 2 minutes then > retrying... > Dec 13 12:38:39 san_martin weewx[25357]: cheetahgenerator: Generated 13 files > for report Belchertown in 5.24 seconds > Dec 13 12:38:39 san_martin weewx[25357]: reportengine: copied 1 files to > /home/weewx/public_html/belchertown/images > Dec 13 12:38:40 san_martin weewx[25357]: rsyncupload: rsync'd 14 files > (259,266 bytes) in 1.50 seconds > > > El viernes, 7 de diciembre de 2018, 15:13:16 (UTC-7), Pat escribió: >> >> Done and done! To all, let's pick up the conversation there since this >> thread is a bit too long now. >> >> >> On Friday, December 7, 2018 at 4:25:46 PM UTC-5, gjr80 wrote: >>> >>> Pat, >>> How about a new thread for the release of 0.8.1, I was given a ticket for >>> loitering yesterday waiting for this thread to load :) >>> >>> 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 [email protected]. > 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
