Guys I had quite an issue but luckily I had backed up about 6 hrs before my drama....Now I find that when I attempt to rebuild dailies from the backup it creates the tables then says the following and exits. This last attempt was after shutdown and reboot. This happened several times so I dropped weewx created new weewx and imported backup....so daily tables not in existence...when it exits I can see the tables have been created..then it crashes.
Neville Jun 02 22:54:50 raspberrypi weewxd[628]: *weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 163, in open_with_create* Jun 02 22:54:50 raspberrypi weewxd[628]: *weewx[628] CRITICAL __main__: **** dbmanager = cls(connection, table_name=table_name, schema=schema)* Jun 02 22:54:50 raspberrypi weewxd[628]: *weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 818, in __init__* Jun 02 22:54:50 raspberrypi weewxd[628]: *weewx[628] CRITICAL __main__: **** self._initialize_day_tables(schema)* Jun 02 22:54:50 raspberrypi weewxd[628]: *weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 867, in _initialize_day_tables* Jun 02 22:54:50 raspberrypi weewxd[628]: *weewx[628] CRITICAL __main__: **** cursor.execute(sql_create_str)* Jun 02 22:54:50 raspberrypi weewxd[628]: *weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weedb/mysql.py", line 61, in guarded_fn* Jun 02 22:54:50 raspberrypi weewxd[628]: *weewx[628] CRITICAL __main__: **** raise klass(e)* Jun 02 22:54:50 raspberrypi weewxd[628]: *weewx[628] CRITICAL __main__: **** weedb.TableExistsError: (1050, "Table 'archive_day_altimeter' already exists")* Jun 02 22:54:50 raspberrypi weewxd[628]: *weewx[628] CRITICAL __main__: **** Exiting.* *~* *user log * Jun 2 22:26:34 raspberrypi weewx[26307] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 163, in open_with_create Jun 2 22:26:34 raspberrypi weewx[26307] CRITICAL __main__: **** dbmanager = cls(connection, table_name=table_name, schema=schema) Jun 2 22:26:34 raspberrypi weewx[26307] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 818, in __init__ Jun 2 22:26:34 raspberrypi weewx[26307] CRITICAL __main__: **** self._initialize_day_tables(schema) Jun 2 22:26:34 raspberrypi weewx[26307] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 867, in _initialize_day_tables Jun 2 22:26:34 raspberrypi weewx[26307] CRITICAL __main__: **** cursor.execute(sql_create_str) Jun 2 22:26:34 raspberrypi weewx[26307] CRITICAL __main__: **** File "/home/weewx/bin/weedb/mysql.py", line 61, in guarded_fn Jun 2 22:26:34 raspberrypi weewx[26307] CRITICAL __main__: **** raise klass(e) Jun 2 22:26:34 raspberrypi weewx[26307] CRITICAL __main__: **** weedb.TableExistsError: (1050, "Table 'archive_day_altimeter' already exists") Jun 2 22:26:34 raspberrypi weewx[26307] CRITICAL __main__: **** Exiting. Jun 2 22:41:28 raspberrypi wee_database[26571] INFO __main__: All daily summaries will be rebuilt. Jun 2 22:47:12 raspberrypi wee_database[26653] INFO __main__: All daily summaries will be rebuilt. Jun 2 22:50:50 raspberrypi wee_database[26723] INFO __main__: All daily summaries will be rebuilt. Jun 2 22:52:05 raspberrypi mtp-probe: checking bus 1, device 5: "/sys/devices/platform/soc/3f980000.usb/usb1/1-1/1-1.5" Jun 2 22:52:05 raspberrypi mtp-probe: checking bus 1, device 4: "/sys/devices/platform/soc/3f980000.usb/usb1/1-1/1-1.2" Jun 2 22:52:05 raspberrypi mtp-probe: bus: 1, device: 5 was not an MTP device Jun 2 22:52:05 raspberrypi mtp-probe: checking bus 1, device 3: "/sys/devices/platform/soc/3f980000.usb/usb1/1-1/1-1.1" Jun 2 22:52:05 raspberrypi mtp-probe: bus: 1, device: 4 was not an MTP device Jun 2 22:52:05 raspberrypi mtp-probe: bus: 1, device: 3 was not an MTP device Jun 2 22:52:13 raspberrypi weewx[471] INFO __main__: Initializing weewx version 4.1.0 Jun 2 22:52:13 raspberrypi weewx[471] INFO __main__: Using Python 3.7.3 (default, Dec 20 2019, 18:57:59) #012[GCC 8.3.0] Jun 2 22:52:13 raspberrypi weewx[471] INFO __main__: Platform Linux-4.19.97-v7+-armv7l-with-debian-10.4 Jun 2 22:52:13 raspberrypi weewx[471] INFO __main__: Locale is 'en_AU.UTF-8' Jun 2 22:52:13 raspberrypi weewx[471] INFO __main__: PID file is /var/run/weewx.pid Jun 2 22:52:14 raspberrypi weewx[628] INFO __main__: Using configuration file /home/weewx/weewx.conf Jun 2 22:52:14 raspberrypi weewx[628] INFO __main__: Debug is 0 Jun 2 22:52:14 raspberrypi weewx[628] INFO weewx.engine: Loading station type PiWeather (user.piweather) Jun 2 22:52:14 raspberrypi weewx[628] INFO user.owfs: service version is 0.23.6 (pyownet) Jun 2 22:52:14 raspberrypi weewx[628] INFO user.owfs: binding is loop Jun 2 22:52:14 raspberrypi weewx[628] INFO user.owfs: interface is localhost:4304 Jun 2 22:52:14 raspberrypi weewx[628] INFO user.owfs: sensor map is {'rain': '/1D.E3AB0D000000'} Jun 2 22:52:14 raspberrypi weewx[628] INFO user.owfs: sensor type map is {'rain': 'rainwise_bucket'} Jun 2 22:52:14 raspberrypi weewx[628] INFO user.owfs: dallas direction map is {} Jun 2 22:52:14 raspberrypi weewx[628] INFO user.owfs: sensor unit system is metric Jun 2 22:52:14 raspberrypi /weewxd: Aircon: using /var/ramdisk/aircontemps.csv Jun 2 22:52:14 raspberrypi weewx[628] INFO weewx.engine: StdConvert target unit is 0x1 Jun 2 22:52:15 raspberrypi weewx[628] CRITICAL __main__: Database connection exception: (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)") Jun 2 22:52:15 raspberrypi weewx[628] CRITICAL __main__: **** Waiting 60 seconds then retrying... Jun 2 22:54:50 raspberrypi weewx[628] INFO __main__: retrying... Jun 2 22:54:50 raspberrypi weewx[628] INFO __main__: Using configuration file /home/weewx/weewx.conf Jun 2 22:54:50 raspberrypi weewx[628] INFO __main__: Debug is 0 Jun 2 22:54:50 raspberrypi weewx[628] INFO weewx.engine: Loading station type PiWeather (user.piweather) Jun 2 22:54:50 raspberrypi weewx[628] INFO user.owfs: service version is 0.23.6 (pyownet) Jun 2 22:54:50 raspberrypi weewx[628] INFO user.owfs: binding is loop Jun 2 22:54:50 raspberrypi weewx[628] INFO user.owfs: interface is localhost:4304 Jun 2 22:54:50 raspberrypi weewx[628] INFO user.owfs: sensor map is {'rain': '/1D.E3AB0D000000'} Jun 2 22:54:50 raspberrypi weewx[628] INFO user.owfs: sensor type map is {'rain': 'rainwise_bucket'} Jun 2 22:54:50 raspberrypi weewx[628] INFO user.owfs: dallas direction map is {} Jun 2 22:54:50 raspberrypi weewx[628] INFO user.owfs: sensor unit system is metric Jun 2 22:54:50 raspberrypi /weewxd: Aircon: using /var/ramdisk/aircontemps.csv Jun 2 22:54:50 raspberrypi weewx[628] INFO weewx.engine: StdConvert target unit is 0x1 Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: Caught unrecoverable exception: Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** (1050, "Table 'archive_day_altimeter' already exists") Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** Traceback (most recent call last): Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weedb/mysql.py", line 52, in guarded_fn Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** return fn(*args, **kwargs) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weedb/mysql.py", line 262, in execute Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** self.cursor.execute(mysql_string, tuple(sql_tuple)) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 250, in execute Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** self.errorhandler(self, exc, value) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** raise errorvalue Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 247, in execute Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** res = self._query(query) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 411, in _query Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** rowcount = self._do_query(q) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 374, in _do_query Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** db.query(q) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 292, in query Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** _mysql.connection.query(self, query) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** _mysql_exceptions.OperationalError: (1050, "Table 'archive_day_altimeter' already exists") Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** During handling of the above exception, another exception occurred: Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** Traceback (most recent call last): Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewxd", line 148, in main Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** engine = weewx.engine.StdEngine(config_dict) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/engine.py", line 75, in __init__ Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** self.loadServices(config_dict) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/engine.py", line 138, in loadServices Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** obj = weeutil.weeutil.get_object(svc)(self,config_dict) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/wxservices.py", line 81, in __init__ Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** engine.db_binder) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/wxservices.py", line 124, in __init__ Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** initialize=True) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 530, in get_manager Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** self.manager_cache[data_binding] = open_manager(manager_dict, initialize) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 680, in open_manager Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** manager_dict['schema']) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 163, in open_with_create Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** dbmanager = cls(connection, table_name=table_name, schema=schema) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 818, in __init__ Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** self._initialize_day_tables(schema) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 867, in _initialize_day_tables Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** cursor.execute(sql_create_str) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weedb/mysql.py", line 61, in guarded_fn Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** raise klass(e) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** weedb.TableExistsError: (1050, "Table 'archive_day_altimeter' already exists") Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** Exiting. sys log un 2 22:52:13 raspberrypi weewx[471] INFO __main__: Initializing weewx version 4.1.0 Jun 2 22:52:13 raspberrypi weewx[471] INFO __main__: Using Python 3.7.3 (default, Dec 20 2019, 18:57:59) #012[GCC 8.3.0] Jun 2 22:52:13 raspberrypi weewx[471] INFO __main__: Platform Linux-4.19.97-v7+-armv7l-with-debian-10.4 Jun 2 22:52:13 raspberrypi weewx[471] INFO __main__: Locale is 'en_AU.UTF-8' Jun 2 22:52:13 raspberrypi weewx[471] INFO __main__: PID file is /var/run/weewx.pid Jun 2 22:52:14 raspberrypi weewx[325]: Starting weewx weather system: weewx. Jun 2 22:52:14 raspberrypi systemd[1]: Started LSB: weewx weather system. Jun 2 22:52:14 raspberrypi weewx[628] INFO __main__: Using configuration file /home/weewx/weewx.conf Jun 2 22:52:14 raspberrypi weewx[628] INFO __main__: Debug is 0 Jun 2 22:52:14 raspberrypi weewx[628] INFO weewx.engine: Loading station type PiWeather (user.piweather) Jun 2 22:52:14 raspberrypi weewx[628] INFO user.owfs: service version is 0.23.6 (pyownet) Jun 2 22:52:14 raspberrypi weewx[628] INFO user.owfs: binding is loop Jun 2 22:52:14 raspberrypi weewx[628] INFO user.owfs: interface is localhost:4304 Jun 2 22:52:14 raspberrypi weewx[628] INFO user.owfs: sensor map is {'rain': '/1D.E3AB0D000000'} Jun 2 22:52:14 raspberrypi weewx[628] INFO user.owfs: sensor type map is {'rain': 'rainwise_bucket'} Jun 2 22:52:14 raspberrypi weewx[628] INFO user.owfs: dallas direction map is {} Jun 2 22:52:14 raspberrypi weewx[628] INFO user.owfs: sensor unit system is metric Jun 2 22:52:14 raspberrypi /weewxd: Aircon: using /var/ramdisk/aircontemps.csv Jun 2 22:52:14 raspberrypi weewx[628] INFO weewx.engine: StdConvert target unit is 0x1 Jun 2 22:52:15 raspberrypi systemd[1]: systemd-rfkill.service: Succeeded. Jun 2 22:52:15 raspberrypi weewx[628] CRITICAL __main__: Database connection exception: (2002, "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)") Jun 2 22:52:15 raspberrypi weewx[628] CRITICAL __main__: **** Waiting 60 seconds then retrying... Jun 2 22:52:16 raspberrypi dhcpcd[417]: eth0: fe80::be30:d9ff:fed7:8de6 is reachable again Jun 2 22:52:16 raspberrypi dhcpcd[417]: eth0: fe80::be30:d9ff:fed7:8de6 is reachable again Jun 2 22:52:16 raspberrypi systemd[1]: Started MariaDB 10.3.22 database server. Jun 2 22:52:16 raspberrypi systemd[1]: Reached target Multi-User System. Jun 2 22:52:17 raspberrypi /etc/mysql/debian-start[665]: Upgrading MySQL tables if necessary. Jun 2 22:52:17 raspberrypi systemd[1]: Started My sensordata Service. Jun 2 22:52:17 raspberrypi systemd[1]: Started My fan Service. Jun 2 22:52:17 raspberrypi systemd[1]: Starting Update UTMP about System Runlevel Changes... Jun 2 22:52:17 raspberrypi systemd[1]: Started My aircon Service. Jun 2 22:52:17 raspberrypi systemd[1]: systemd-update-utmp-runlevel.service: Succeeded. Jun 2 22:52:17 raspberrypi systemd[1]: Started Update UTMP about System Runlevel Changes. Jun 2 22:52:17 raspberrypi systemd[1]: Startup finished in 7.921s (kernel) + 27.829s (userspace) = 35.750s. Jun 2 22:52:18 raspberrypi dhcpcd[417]: eth0: leased 192.168.0.190 for 86400 seconds Jun 2 22:52:18 raspberrypi avahi-daemon[341]: Joining mDNS multicast group on interface eth0.IPv4 with address 192.168.0.190. Jun 2 22:52:18 raspberrypi dhcpcd[417]: eth0: adding route to 192.168.0.0/24 Jun 2 22:52:18 raspberrypi avahi-daemon[341]: New relevant interface eth0.IPv4 for mDNS. Jun 2 22:52:18 raspberrypi avahi-daemon[341]: Registering new address record for 192.168.0.190 on eth0.IPv4. Jun 2 22:52:18 raspberrypi dhcpcd[417]: eth0: adding default route via 192.168.0.1 Jun 2 22:52:18 raspberrypi /etc/mysql/debian-start[669]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Jun 2 22:52:18 raspberrypi /etc/mysql/debian-start[669]: Looking for 'mysql' as: /usr/bin/mysql Jun 2 22:52:18 raspberrypi /etc/mysql/debian-start[669]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Jun 2 22:52:18 raspberrypi /etc/mysql/debian-start[669]: This installation of MySQL is already upgraded to 10.3.22-MariaDB, use --force if you still need to run mysql_upgrade Jun 2 22:52:18 raspberrypi /etc/mysql/debian-start[744]: Checking for insecure root accounts. Jun 2 22:52:19 raspberrypi /etc/mysql/debian-start[755]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables Jun 2 22:52:31 raspberrypi systemd[1]: systemd-fsckd.service: Succeeded. Jun 2 22:54:07 raspberrypi systemd-timesyncd[278]: Synchronized to time server for the first time [2001:418:3ff::1:53]:123 (2.debian.pool.ntp.org). Jun 2 22:54:17 raspberrypi systemd[1]: systemd-hostnamed.service: Succeeded. Jun 2 22:54:50 raspberrypi weewx[628] INFO __main__: retrying... Jun 2 22:54:50 raspberrypi weewx[628] INFO __main__: Using configuration file /home/weewx/weewx.conf Jun 2 22:54:50 raspberrypi weewx[628] INFO __main__: Debug is 0 Jun 2 22:54:50 raspberrypi weewx[628] INFO weewx.engine: Loading station type PiWeather (user.piweather) Jun 2 22:54:50 raspberrypi weewx[628] INFO user.owfs: service version is 0.23.6 (pyownet) Jun 2 22:54:50 raspberrypi weewx[628] INFO user.owfs: binding is loop Jun 2 22:54:50 raspberrypi weewx[628] INFO user.owfs: interface is localhost:4304 Jun 2 22:54:50 raspberrypi weewx[628] INFO user.owfs: sensor map is {'rain': '/1D.E3AB0D000000'} Jun 2 22:54:50 raspberrypi weewx[628] INFO user.owfs: sensor type map is {'rain': 'rainwise_bucket'} Jun 2 22:54:50 raspberrypi weewx[628] INFO user.owfs: dallas direction map is {} Jun 2 22:54:50 raspberrypi weewx[628] INFO user.owfs: sensor unit system is metric Jun 2 22:54:50 raspberrypi /weewxd: Aircon: using /var/ramdisk/aircontemps.csv Jun 2 22:54:50 raspberrypi weewx[628] INFO weewx.engine: StdConvert target unit is 0x1 Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: Caught unrecoverable exception: Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** (1050, "Table 'archive_day_altimeter' already exists") Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** Traceback (most recent call last): Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weedb/mysql.py", line 52, in guarded_fn Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** return fn(*args, **kwargs) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weedb/mysql.py", line 262, in execute Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** self.cursor.execute(mysql_string, tuple(sql_tuple)) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 250, in execute Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** self.errorhandler(self, exc, value) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** raise errorvalue Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 247, in execute Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** res = self._query(query) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 411, in _query Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** rowcount = self._do_query(q) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 374, in _do_query Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** db.query(q) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 292, in query Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** _mysql.connection.query(self, query) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** _mysql_exceptions.OperationalError: (1050, "Table 'archive_day_altimeter' already exists") Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** During handling of the above exception, another exception occurred: Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** Traceback (most recent call last): Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewxd", line 148, in main Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** engine = weewx.engine.StdEngine(config_dict) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/engine.py", line 75, in __init__ Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** self.loadServices(config_dict) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/engine.py", line 138, in loadServices Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** obj = weeutil.weeutil.get_object(svc)(self,config_dict) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/wxservices.py", line 81, in __init__ Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** engine.db_binder) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/wxservices.py", line 124, in __init__ Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** initialize=True) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 530, in get_manager Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** self.manager_cache[data_binding] = open_manager(manager_dict, initialize) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 680, in open_manager Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** manager_dict['schema']) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 163, in open_with_create Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** dbmanager = cls(connection, table_name=table_name, schema=schema) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 818, in __init__ Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** self._initialize_day_tables(schema) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weewx/manager.py", line 867, in _initialize_day_tables Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** cursor.execute(sql_create_str) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** File "/home/weewx/bin/weedb/mysql.py", line 61, in guarded_fn Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** raise klass(e) Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** weedb.TableExistsError: (1050, "Table 'archive_day_altimeter' already exists") Jun 2 22:54:50 raspberrypi weewx[628] CRITICAL __main__: **** Exiting. Jun 2 22:54:58 raspberrypi systemd[1]: Created slice User Slice of UID 1000. Jun 2 22:54:58 raspberrypi systemd[1]: Starting User Runtime Directory /run/user/1000... Jun 2 22:54:58 raspberrypi systemd[1]: Started User Runtime Directory /run/user/1000. Jun 2 22:54:58 raspberrypi systemd[1]: Starting User Manager for UID 1000... Jun 2 22:54:59 raspberrypi systemd[845]: Listening on GnuPG network certificate management daemon. Jun 2 22:54:59 raspberrypi systemd[845]: Listening on GnuPG cryptographic agent and passphrase cache. Jun 2 22:54:59 raspberrypi systemd[845]: Reached target Timers. Jun 2 22:54:59 raspberrypi systemd[845]: Listening on GnuPG cryptographic agent and passphrase cache (restricted). Jun 2 22:54:59 raspberrypi systemd[845]: Reached target Paths. Jun 2 22:54:59 raspberrypi systemd[845]: Starting D-Bus User Message Bus Socket. Jun 2 22:54:59 raspberrypi systemd[845]: Listening on GnuPG cryptographic agent (ssh-agent emulation). Jun 2 22:54:59 raspberrypi systemd[845]: Listening on GnuPG cryptographic agent and passphrase cache (access for web browsers). Jun 2 22:54:59 raspberrypi systemd[845]: Listening on D-Bus User Message Bus Socket. Jun 2 22:54:59 raspberrypi systemd[845]: Reached target Sockets. Jun 2 22:54:59 raspberrypi systemd[845]: Reached target Basic System. Jun 2 22:54:59 raspberrypi systemd[1]: Started User Manager for UID 1000. Jun 2 22:54:59 raspberrypi systemd[1]: Started Session c1 of user pi. Jun 2 22:54:59 raspberrypi systemd[845]: Reached target Default. Jun 2 22:54:59 raspberrypi systemd[845]: Startup finished in 495ms. Jun 2 22:55:02 raspberrypi CRON[881]: (pi) CMD (~/duckdns/duck.sh >/dev/null 2>&1) Jun 2 22:56:52 raspberrypi systemd[1]: Started Session c2 of user pi. Jun 2 22:58:02 raspberrypi systemd[1]: session-c2.scope: Succeeded. Jun 2 23:00:01 raspberrypi CRON[946]: (pi) CMD (~/duckdns/duck.sh >/dev/null 2>&1) Jun 2 23:02:29 raspberrypi systemd[1]: Started Session c3 of user pi. Jun 2 23:02:42 raspberrypi systemd[1]: Started Session c4 of user pi. -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/5849c6fa-925e-4889-b94a-e35173c69b58%40googlegroups.com.