Well I am operational again...but running on 4.0. Managed to get my backup data installed and rebuilt daily...Going to let it run for a few days, to make sure it’s stable. Going to look at logs to see if anything stands out...
Neville On Wednesday, June 3, 2020 at 7:01:10 AM UTC+10, Neville Davis wrote: > > OK here it is > > Last login: Tue Jun 2 23:32:02 2020 from 192.168.0.54 > > *pi@raspberrypi*:*~ $* cd /home/weewx/bin > > *pi@raspberrypi*:*/home/weewx/bin $* ./wee_database > /home/weewx/weewx.conf --drop-daily > > Using configuration file /home/weewx/weewx.conf > > Using database binding 'wx_binding', which is bound to database > 'archive_mysql' > > Proceeding will delete all your daily summaries from database 'weewx' > > Are you sure you want to proceed (y/n)? y > > Dropping daily summary tables from 'weewx' ... > > No daily summaries found in database 'weewx'. Nothing done. > > *pi@raspberrypi*:*/home/weewx/bin $* ./wee_database > /home/weewx/weewx.conf --rebuild-daily > > Using configuration file /home/weewx/weewx.conf > > Using database binding 'wx_binding', which is bound to database > 'archive_mysql' > > All daily summaries will be rebuilt. > > Proceed (y/n)? y > > Traceback (most recent call last): > > File "/home/weewx/bin/weedb/mysql.py", line 52, in guarded_fn > > return fn(*args, **kwargs) > > File "/home/weewx/bin/weedb/mysql.py", line 262, in execute > > self.cursor.execute(mysql_string, tuple(sql_tuple)) > > File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 250, in > execute > > self.errorhandler(self, exc, value) > > File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 50, > in defaulterrorhandler > > raise errorvalue > > File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 247, in > execute > > res = self._query(query) > > File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 411, in > _query > > rowcount = self._do_query(q) > > File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 374, in > _do_query > > db.query(q) > > File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 292, > in query > > _mysql.connection.query(self, query) > > _mysql_exceptions.OperationalError: (1050, "Table 'archive_day_altimeter' > already exists") > > > During handling of the above exception, another exception occurred: > > > Traceback (most recent call last): > > File "./wee_database", line 974, in <module> > > main() > > File "./wee_database", line 169, in main > > rebuildDaily(config_dict, db_binding, options) > > File "./wee_database", line 264, in rebuildDaily > > with weewx.manager.open_manager_with_config(config_dict, db_binding, > initialize=True) as dbmanager: > > File "/home/weewx/bin/weewx/manager.py", line 692, in > open_manager_with_config > > return open_manager(manager_dict, initialize) > > File "/home/weewx/bin/weewx/manager.py", line 680, in open_manager > > manager_dict['schema']) > > File "/home/weewx/bin/weewx/manager.py", line 163, in open_with_create > > dbmanager = cls(connection, table_name=table_name, schema=schema) > > File "/home/weewx/bin/weewx/manager.py", line 818, in __init__ > > self._initialize_day_tables(schema) > > File "/home/weewx/bin/weewx/manager.py", line 867, in > _initialize_day_tables > > cursor.execute(sql_create_str) > > File "/home/weewx/bin/weedb/mysql.py", line 61, in guarded_fn > > raise klass(e) > > weedb.TableExistsError: (1050, "Table 'archive_day_altimeter' already > exists") > > *pi@raspberrypi*:*/home/weewx/bin $* > > On Wednesday, June 3, 2020 at 6:34:56 AM UTC+10, gjr80 wrote: >> >> Ok, could you please run those two wee_database commands again one after >> each other and post the console output making sure you include the commands >> entered as well as the output. >> >> 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/2bfb87b4-9dc0-4787-bb9e-1bb6745ebf6f%40googlegroups.com.
