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.
