Server updated to 3.8.2 last week and caused the following: Aug 23 11:50:02 john-PS583AA-ABA-a1020n weewx[19269]: **** 'outTemp' Aug 23 11:50:02 john-PS583AA-ABA-a1020n weewx[19269]: **** Traceback (most recent call last): Aug 23 11:50:02 john-PS583AA-ABA-a1020n weewx[19269]: **** File "/usr/share/weewx/weewx/engine.py", line 877, in main Aug 23 11:50:02 john-PS583AA-ABA-a1020n weewx[19269]: **** engine.run() Aug 23 11:50:02 john-PS583AA-ABA-a1020n weewx[19269]: **** File "/usr/share/weewx/weewx/engine.py", line 191, in run Aug 23 11:50:02 john-PS583AA-ABA-a1020n weewx[19269]: **** self.dispatchEvent(weewx.Event(weewx.NEW_LOOP_PACKET, packet=packet)) Aug 23 11:50:02 john-PS583AA-ABA-a1020n weewx[19269]: **** File "/usr/share/weewx/weewx/engine.py", line 224, in dispatchEvent Aug 23 11:50:02 john-PS583AA-ABA-a1020n weewx[19269]: **** callback(event) Aug 23 11:50:02 john-PS583AA-ABA-a1020n weewx[19269]: **** File "/usr/share/weewx/user/weewxwd3.py", line 146, in new_loop_packet Aug 23 11:50:02 john-PS583AA-ABA-a1020n weewx[19269]: **** wd_data['humidex'] = weewx.wxformulas.humidexC(data_metricwx['outTemp'], Aug 23 11:50:02 john-PS583AA-ABA-a1020n weewx[19269]: **** KeyError: 'outTemp' Aug 23 11:50:02 john-PS583AA-ABA-a1020n weewx[19269]: **** Exiting.
This was fixed by replacing weewxwd3.py from the following fork: https://github.com/gjr80/weewx-weewx-wd -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** (1665, 'Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.') Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** Traceback (most recent call last): Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** File "/usr/share/weewx/weewx/engine.py", line 877, in main Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** engine.run() Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** File "/usr/share/weewx/weewx/engine.py", line 202, in run Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** self.dispatchEvent(weewx.Event(weewx.POST_LOOP)) Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** File "/usr/share/weewx/weewx/engine.py", line 224, in dispatchEvent Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** callback(event) Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** File "/usr/share/weewx/weewx/engine.py", line 570, in post_loop Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** self._software_catchup() Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** File "/usr/share/weewx/weewx/engine.py", line 634, in _software_catchup Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** self.engine.dispatchEvent(weewx.Event(weewx.NEW_ARCHIVE_RECORD, record=record, origin='software')) Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** File "/usr/share/weewx/weewx/engine.py", line 224, in dispatchEvent Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** callback(event) Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** File "/usr/share/weewx/user/weewxwd3.py", line 254, in new_archive_record Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** dbmanager.addRecord(event.record) Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** File "/usr/share/weewx/weewx/manager.py", line 245, in addRecord Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** self._addSingleRecord(record, cursor, log_level) Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** File "/usr/share/weewx/weewx/manager.py", line 1190, in _addSingleRecord Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** super(DaySummaryManager, self)._addSingleRecord(record, cursor, log_level=log_level) Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** File "/usr/share/weewx/weewx/manager.py", line 291, in _addSingleRecord Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** cursor.execute(sql_insert_stmt, value_list) Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** File "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** raise klass(e) Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** DatabaseError: (1665, 'Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.') Aug 23 12:10:51 john-PS583AA-ABA-a1020n weewx[30694]: **** Exiting. This was fixed by enabling roy-based binary logging in my.cnf: https://confluence.atlassian.com/jirakb/mysql-binary-logging-problem-with-innodb-when-creating-a-workflow-196116927.html ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- The automatic update also did not import existing configuration changes from weewx.conf and instead performed a backup of the existing config file and replaced weewx.conf with the stock .dist version. -- 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.
