Is weewx running? -tk
On Sat, Dec 2, 2017 at 10:47 AM, Joe Brockway <[email protected]> wrote: > Hello, > > > I recently updated weewx from 3.6.1 to 3.8. > > > I read the upgrade guide. Updating the database was mentioned. I figured > might as well make sure the database is good to go. I ran the command > twice. First time I was told the database was read-only. The second time I > was told it is locked. What am I missing? I am not getting any other errors > in the log about the database being locked. > > > Thank you for your help. > > > Joe B > > > > pi@raspberrypi ~/Downloads $ wee_database /etc/weewx/weewx.conf --update > > Using configuration file /etc/weewx/weewx.conf > > Using database binding 'wx_binding', which is bound to database > 'archive_sqlite' > > The update process does not affect archive data, but does alter the > database. > > Continue (y/n)? y > > Preparing Interval Weighting Fix... > > Daily summary tables are at version 1.0 > > Calculating interval weights... > > Interval Weighting Fix completed in 11.00 seconds. > > Preparing Maximum windSpeed Fix... > > Traceback (most recent call last): > > File "/usr/bin/wee_database", line 793, in <module> > > main() > > File "/usr/bin/wee_database", line 165, in main > > update(config_dict, db_binding, options) > > File "/usr/bin/wee_database", line 558, in update > > _fix_wind(config_dict, db_binding, options) > > File "/usr/bin/wee_database", line 591, in _fix_wind > > wind_obj.run() > > File "/usr/share/weewx/weecfg/database.py", line 196, in run > > self.do_fix() > > File "/usr/share/weewx/weecfg/database.py", line 239, in do_fix > > day_max, day_max_ts) > > File "/usr/share/weewx/weecfg/database.py", line 331, in write_max > > _cursor.execute(max_update_str, (value, when_ts, row_ts)) > > File "/usr/share/weewx/weedb/sqlite.py", line 43, in guarded_fn > > raise weedb.OperationalError(e) > > weedb.OperationalError: attempt to write a readonly database > > pi@raspberrypi ~/Downloads $ sudo wee_database /etc/weewx/weewx.conf > --update > > Using configuration file /etc/weewx/weewx.conf > > Using database binding 'wx_binding', which is bound to database > 'archive_sqlite' > > The update process does not affect archive data, but does alter the > database. > > Continue (y/n)? y > > Preparing Interval Weighting Fix... > > Daily summary tables are at version 1.0 > > Calculating interval weights... > > Traceback (most recent call last):e: 2015-07-21 00:25:00 MDT (1437459900) > > File "/usr/bin/wee_database", line 793, in <module> > > main() > > File "/usr/bin/wee_database", line 165, in main > > update(config_dict, db_binding, options) > > File "/usr/bin/wee_database", line 552, in update > > weight_obj.run() > > File "/usr/share/weewx/weecfg/database.py", line 474, in run > > self.dbm.backfill_day_summary() > > File "/usr/share/weewx/weewx/manager.py", line 1477, in > backfill_day_summary > > self._write_metadata('lastUpdate', str(int(lastUpdate)), cursor) > > File "/usr/share/weewx/weewx/manager.py", line 1583, in _write_metadata > > (key, value)) > > File "/usr/share/weewx/weedb/sqlite.py", line 43, in guarded_fn > > raise weedb.OperationalError(e) > > weedb.OperationalError: database is locked > > -- > 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.
