Hello,
Problem with MySql and create new table.
weewx.manager: Created and initialized table 'archive5' in database 'weewx'
weewx.engine: Caught unrecoverable exception:
(1050, "Table 'archive_day_barometer' already exists")
Traceback (most recent call last):
File "/home/weewx/bin/weedb/mysql.py", line 51, in guarded_fn
return fn(*args, **kwargs)
File "/home/weewx/bin/weedb/mysql.py", line 261, 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_barometer'
already exists")
Its from a new test system. (Installed with install-weewx.sh).
At first start an Sqlite database is created (can all be seen in attached
logging). Stopped.
Configuration was then changed to a MySql database: The current MySql
database schema/user (for the 'production' system) but with a new tablename
archive5.
Tabel archive5 is created ok.
Regards,
Jaap
--
You received this message because you are subscribed to the Google Groups
"weewx-development" 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-development/a9eb77ce-82f9-44e2-9bd1-6d21c4323add%40googlegroups.com.
Jan 7 21:25:24 vub1904-2 systemd[1]: Started weewx weather system.
Jan 7 21:25:24 vub1904-2 weewx[8177] INFO weewx.engine: Initializing weewx
version 4.0.0b6
Jan 7 21:25:24 vub1904-2 weewx[8177] INFO weewx.engine: Using Python 3.7.5
(default, Nov 20 2019, 09:21:52) #012[GCC 9.2.1 20191008]
Jan 7 21:25:24 vub1904-2 weewx[8177] INFO weewx.engine: Platform
Linux-5.3.0-26-generic-x86_64-with-Ubuntu-19.10-eoan
Jan 7 21:25:24 vub1904-2 weewx[8177] INFO weewx.engine: Locale is 'nl_NL.UTF-8'
Jan 7 21:25:24 vub1904-2 weewx[8177] INFO weewx.engine: PID file is
/var/run/weewx.pid
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.engine: Using configuration
file /home/weewx/weewx.conf
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Debug is 1
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Initializing engine
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.engine: Loading station type
Simulator (weewx.drivers.simulator)
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Loading service
weewx.engine.StdTimeSynch
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Finished loading
service weewx.engine.StdTimeSynch
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Loading service
weewx.engine.StdConvert
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.engine: StdConvert target unit
is 0x1
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Finished loading
service weewx.engine.StdConvert
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Loading service
weewx.engine.StdCalibrate
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Finished loading
service weewx.engine.StdCalibrate
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Loading service
weewx.engine.StdQC
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Finished loading
service weewx.engine.StdQC
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Loading service
weewx.wxservices.StdWXCalculate
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.manager: Created and
initialized table 'archive' in database 'weewx.sdb'
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.manager: Created daily summary
tables
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.manager: Daily summary
version is 2.0
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.wxservices: The following
values will be calculated: altimeter=prefer_hardware, appTemp=prefer_hardware,
barometer=prefer_hardware, beaufort=prefer_hardware, cloudbase=prefer_hardware,
dewpoint=prefer_hardware, ET=prefer_hardware, heatindex=prefer_hardware,
humidex=prefer_hardware, inDewpoint=prefer_hardware,
maxSolarRad=prefer_hardware, pressure=prefer_hardware,
rainRate=prefer_hardware, windchill=prefer_hardware, windrun=prefer_hardware
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.wxservices: The following
algorithms will be used for calculations: altimeter=aaASOS, maxSolarRad=RS
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Finished loading
service weewx.wxservices.StdWXCalculate
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Loading service
weewx.engine.StdArchive
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.engine: Archive will use data
binding wx_binding
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.engine: Record generation will
be attempted in 'hardware'
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.engine: Using archive interval
of 300 seconds (specified in weewx configuration)
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Use LOOP data in
hi/low calculations: 1
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Finished loading
service weewx.engine.StdArchive
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Loading service
weewx.restx.StdStationRegistry
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.restx: StationRegistry:
Registration not requested.
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Finished loading
service weewx.restx.StdStationRegistry
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Loading service
weewx.restx.StdWunderground
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.restx: Wunderground: Posting
not enabled.
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Finished loading
service weewx.restx.StdWunderground
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Loading service
weewx.restx.StdPWSweather
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.restx: PWSweather: Posting not
enabled.
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Finished loading
service weewx.restx.StdPWSweather
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Loading service
weewx.restx.StdCWOP
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.restx: CWOP: Posting not
enabled.
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Finished loading
service weewx.restx.StdCWOP
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Loading service
weewx.restx.StdWOW
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.restx: WOW: Posting not
enabled.
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Finished loading
service weewx.restx.StdWOW
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Loading service
weewx.restx.StdAWEKAS
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.restx: AWEKAS: Posting not
enabled.
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Finished loading
service weewx.restx.StdAWEKAS
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Loading service
weewx.engine.StdPrint
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Finished loading
service weewx.engine.StdPrint
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Loading service
weewx.engine.StdReport
Jan 7 21:25:24 vub1904-2 weewx[8191] DEBUG weewx.engine: Finished loading
service weewx.engine.StdReport
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.engine: Starting up weewx
version 4.0.0b6
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.engine: Clock error is -0.07
seconds (positive is fast)
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.engine: Using binding
'wx_binding' to database 'weewx.sdb'
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.manager: Starting backfill of
daily summaries
Jan 7 21:25:24 vub1904-2 weewx[8191] INFO weewx.engine: Starting main packet
loop.
Jan 7 21:25:48 vub1904-2 systemd[1]: Stopping weewx weather system...
Jan 7 21:25:48 vub1904-2 weewx[8191] INFO weewx.engine: Received signal TERM
(15).
Jan 7 21:25:48 vub1904-2 weewx[8191] INFO weewx.engine: Main loop exiting.
Shutting engine down.
Jan 7 21:25:48 vub1904-2 weewx[8191] INFO weewx.engine: Terminating weewx
version 4.0.0b6
Jan 7 21:25:48 vub1904-2 weewx[8191] INFO weewx.engine: **** Traceback
(most recent call last):
Jan 7 21:25:48 vub1904-2 weewx[8191] INFO weewx.engine: **** File
"/home/weewx/bin/weewx/engine.py", line 903, in main
Jan 7 21:25:48 vub1904-2 weewx[8191] INFO weewx.engine: ****
engine.run()
Jan 7 21:25:48 vub1904-2 weewx[8191] INFO weewx.engine: **** File
"/home/weewx/bin/weewx/engine.py", line 194, in run
Jan 7 21:25:48 vub1904-2 weewx[8191] INFO weewx.engine: **** for
packet in self.console.genLoopPackets():
Jan 7 21:25:48 vub1904-2 weewx[8191] INFO weewx.engine: **** File
"/home/weewx/bin/weewx/drivers/simulator.py", line 148, in genLoopPackets
Jan 7 21:25:48 vub1904-2 weewx[8191] INFO weewx.engine: ****
time.sleep(sleep_time)
Jan 7 21:25:48 vub1904-2 weewx[8191] INFO weewx.engine: **** File
"/home/weewx/bin/weewx/engine.py", line 823, in sigTERMhandler
Jan 7 21:25:48 vub1904-2 weewx[8191] INFO weewx.engine: **** raise
Terminate
Jan 7 21:25:48 vub1904-2 weewx[8191] INFO weewx.engine: ****
weewx.engine.Terminate
Jan 7 21:25:48 vub1904-2 systemd[1]: weewx.service: Main process exited,
code=killed, status=15/TERM
Jan 7 21:25:48 vub1904-2 systemd[1]: weewx.service: Succeeded.
Jan 7 21:25:48 vub1904-2 systemd[1]: Stopped weewx weather system.
Jan 7 21:33:12 vub1904-2 systemd[1]: Started weewx weather system.
Jan 7 21:33:13 vub1904-2 weewx[8690] INFO weewx.engine: Initializing weewx
version 4.0.0b6
Jan 7 21:33:13 vub1904-2 weewx[8690] INFO weewx.engine: Using Python 3.7.5
(default, Nov 20 2019, 09:21:52) #012[GCC 9.2.1 20191008]
Jan 7 21:33:13 vub1904-2 weewx[8690] INFO weewx.engine: Platform
Linux-5.3.0-26-generic-x86_64-with-Ubuntu-19.10-eoan
Jan 7 21:33:13 vub1904-2 weewx[8690] INFO weewx.engine: Locale is 'nl_NL.UTF-8'
Jan 7 21:33:13 vub1904-2 weewx[8690] INFO weewx.engine: PID file is
/var/run/weewx.pid
Jan 7 21:33:13 vub1904-2 weewx[8705] INFO weewx.engine: Using configuration
file /home/weewx/weewx.conf
Jan 7 21:33:13 vub1904-2 weewx[8705] DEBUG weewx.engine: Debug is 1
Jan 7 21:33:13 vub1904-2 weewx[8705] DEBUG weewx.engine: Initializing engine
Jan 7 21:33:13 vub1904-2 weewx[8705] INFO weewx.engine: Loading station type
Simulator (weewx.drivers.simulator)
Jan 7 21:33:13 vub1904-2 weewx[8705] DEBUG weewx.engine: Loading service
weewx.engine.StdTimeSynch
Jan 7 21:33:13 vub1904-2 weewx[8705] DEBUG weewx.engine: Finished loading
service weewx.engine.StdTimeSynch
Jan 7 21:33:13 vub1904-2 weewx[8705] DEBUG weewx.engine: Loading service
weewx.engine.StdConvert
Jan 7 21:33:13 vub1904-2 weewx[8705] INFO weewx.engine: StdConvert target unit
is 0x1
Jan 7 21:33:13 vub1904-2 weewx[8705] DEBUG weewx.engine: Finished loading
service weewx.engine.StdConvert
Jan 7 21:33:13 vub1904-2 weewx[8705] DEBUG weewx.engine: Loading service
weewx.engine.StdCalibrate
Jan 7 21:33:13 vub1904-2 weewx[8705] DEBUG weewx.engine: Finished loading
service weewx.engine.StdCalibrate
Jan 7 21:33:13 vub1904-2 weewx[8705] DEBUG weewx.engine: Loading service
weewx.engine.StdQC
Jan 7 21:33:13 vub1904-2 weewx[8705] DEBUG weewx.engine: Finished loading
service weewx.engine.StdQC
Jan 7 21:33:13 vub1904-2 weewx[8705] DEBUG weewx.engine: Loading service
weewx.wxservices.StdWXCalculate
Jan 7 21:33:13 vub1904-2 weewx[8705] INFO weewx.manager: Created and
initialized table 'archive5' in database 'weewx'
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: Caught
unrecoverable exception:
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** (1050,
"Table 'archive_day_barometer' already exists")
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
Traceback (most recent call last):
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/home/weewx/bin/weedb/mysql.py", line 51, in guarded_fn
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
return fn(*args, **kwargs)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/home/weewx/bin/weedb/mysql.py", line 261, in execute
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
self.cursor.execute(mysql_string, tuple(sql_tuple))
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 250, in execute
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
self.errorhandler(self, exc, value)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 50, in
defaulterrorhandler
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
raise errorvalue
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 247, in execute
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** res
= self._query(query)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 411, in _query
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
rowcount = self._do_query(q)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 374, in _do_query
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
db.query(q)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 292, in query
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
_mysql.connection.query(self, query)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
_mysql_exceptions.OperationalError: (1050, "Table 'archive_day_barometer'
already exists")
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** During
handling of the above exception, another exception occurred:
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
Traceback (most recent call last):
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/home/weewx/bin/weewx/engine.py", line 897, in main
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
engine = StdEngine(config_dict)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/home/weewx/bin/weewx/engine.py", line 83, in __init__
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
self.loadServices(config_dict)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/home/weewx/bin/weewx/engine.py", line 144, in loadServices
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** obj
= weeutil.weeutil.get_object(svc)(self,config_dict)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/home/weewx/bin/weewx/wxservices.py", line 80, in __init__
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
engine.db_binder)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/home/weewx/bin/weewx/wxservices.py", line 123, in __init__
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
initialize=True)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/home/weewx/bin/weewx/manager.py", line 523, in get_manager
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
self.manager_cache[data_binding] = open_manager(manager_dict, initialize)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/home/weewx/bin/weewx/manager.py", line 673, in open_manager
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
manager_dict['schema'])
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/home/weewx/bin/weewx/manager.py", line 163, in open_with_create
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
dbmanager = cls(connection, table_name=table_name, schema=schema)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/home/weewx/bin/weewx/manager.py", line 811, in __init__
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
self._initialize_day_tables(schema)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/home/weewx/bin/weewx/manager.py", line 859, in _initialize_day_tables
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
cursor.execute(sql_create_str)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** File
"/home/weewx/bin/weedb/mysql.py", line 60, in guarded_fn
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
raise klass(e)
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: ****
weedb.TableExistsError: (1050, "Table 'archive_day_barometer' already exists")
Jan 7 21:33:13 vub1904-2 weewx[8705] CRITICAL weewx.engine: **** Exiting.
Jan 7 21:33:13 vub1904-2 systemd[1]: weewx.service: Main process exited,
code=exited, status=1/FAILURE
Jan 7 21:33:13 vub1904-2 systemd[1]: weewx.service: Failed with result
'exit-code'.
Jan 7 21:33:50 vub1904-2 xdg-desktop-por[1338]: Failed to get application
states: GDBus.Error:org.freedesktop.portal.Error.Failed: Could not get window
list: GDBus.Error:org.freedesktop.DBus.Error.AccessDenied: App introspection
not allowed
Jan 7 21:34:50 vub1904-2 xdg-desktop-por[1338]: Failed to get application
states: GDBus.Error:org.freedesktop.portal.Error.Failed: Could not get window
list: GDBus.Error:org.freedesktop.DBus.Error.AccessDenied: App introspection
not allowed
