Hi, Craig – I had exactly the same issue! I’m actually using MariaDB (the “real” OpenSource database derived from MySQL).
I fixed it by stopping maria, editing the my.cnf file (/etc/mysql/my.cnf) and changing the line that read binlog_format = row to binlog_format = mixed and then restarting maria I honestly have NO idea what that does – that’s tomorrow’s research project. Clay Jackson From: weewx-user@googlegroups.com [mailto:weewx-user@googlegroups.com] On Behalf Of Craig Thom Sent: Sunday, March 12, 2017 7:48 PM To: weewx-user <weewx-user@googlegroups.com> Subject: [weewx-user] Re: 3.7.0 with MySQL quitting with database error I forgot to say I installed initially and upgraded using the .deb package using apt-get I saved my old weewx.conf and am now using the new one. I then edited it for all the personal data and site updates and restarted weewx. Next I change the database to MySQL if this works. On Sunday, March 12, 2017 at 10:18:45 PM UTC-4, Craig Thom wrote: I am running on Raspbian on a Raspberry Pi. I kept my old weewx.conf file. The only edit I made was to set Wunderground Rapidfire to 'TRUE', but after I set it back to false I got the same error. This log was captured after I rebooted the Pi. Mar 12 22:03:56 weatherpi weewx[608]: engine: retrying.. Mar 12 22:03:56 weatherpi weewx[608]: engine: Using configuration file /etc/weewx/weewx.conf Mar 12 22:03:56 weatherpi weewx[608]: engine: Loading station type AcuRite (weewx.drivers.acurite) Mar 12 22:03:56 weatherpi weewx[608]: acurite: driver version is 0.24 Mar 12 22:03:56 weatherpi weewx[608]: acurite: R2 will be decoded using sensor constants Mar 12 22:03:56 weatherpi weewx[608]: engine: StdConvert target unit is 0x1 Mar 12 22:03:56 weatherpi weewx[608]: wxcalculate: The following values will be calculated: barometer=prefer_hardware, windchill=prefer_hardware, dewpoint=prefer_hardware, appTemp=prefer_hardware, rainRate=prefer_hardware, windrun=prefer_hardware, heatindex=prefer_hardware, maxSolarRad=prefer_hardware, humidex=prefer_hardware, pressure=prefer_hardware, inDewpoint=prefer_hardware, ET=prefer_hardware, altimeter=prefer_hardware, cloudbase=prefer_hardware Mar 12 22:03:56 weatherpi weewx[608]: wxcalculate: The following algorithms will be used for calculations: altimeter=aaNOAA, maxSolarRad=RS Mar 12 22:03:56 weatherpi weewx[608]: engine: Archive will use data binding wx_binding Mar 12 22:03:56 weatherpi weewx[608]: engine: Record generation will be attempted in 'hardware' Mar 12 22:03:56 weatherpi weewx[608]: engine: Using archive interval of 300 seconds (specified in weewx configuration) Mar 12 22:03:56 weatherpi weewx[608]: engine: Using binding 'wx_binding' to database 'weewx' Mar 12 22:03:56 weatherpi weewx[608]: manager: Starting backfill of daily summaries Mar 12 22:03:56 weatherpi weewx[608]: forecast: MainThread: Zambretti: forecast version 3.2.14 Mar 12 22:03:56 weatherpi weewx[608]: forecast: MainThread: Zambretti: interval=3600 max_age=604800 winddir_period=1800 pressure_period=10800 hemisphere=NORTH lower_pressure=950.0 upper_pressure=1050.0 Mar 12 22:03:56 weatherpi weewx[608]: restx: StationRegistry: Station will be registered Mar 12 22:03:56 weatherpi weewx[608]: restx: Wunderground-RF: Data for station KKYLOUIS186 will be posted Mar 12 22:03:56 weatherpi weewx[608]: restx: PWSWeather: Data for station HEDORAH will be posted Mar 12 22:03:56 weatherpi weewx[608]: restx: CWOP: Data for station FW0615 will be posted Mar 12 22:03:56 weatherpi weewx[608]: restx: WOW: Data for station cf9ccbbc-a8f8-e611-93ff-0003ff599b64 will be posted Mar 12 22:03:56 weatherpi weewx[608]: restx: AWEKAS: Posting not enabled. Mar 12 22:03:56 weatherpi weewx[608]: engine: Starting up weewx version 3.7.0 Mar 12 22:03:56 weatherpi weewx[608]: engine: Starting main packet loop. Mar 12 22:05:27 weatherpi weewx[608]: engine: Caught unrecoverable exception in engine: Mar 12 22:05:27 weatherpi weewx[608]: **** (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.') Mar 12 22:05:27 weatherpi weewx[608]: **** Traceback (most recent call last): Mar 12 22:05:27 weatherpi weewx[608]: **** File "/usr/share/weewx/weewx/engine.py", line 880, in main Mar 12 22:05:27 weatherpi weewx[608]: **** engine.run() Mar 12 22:05:27 weatherpi weewx[608]: **** File "/usr/share/weewx/weewx/engine.py", line 201, in run Mar 12 22:05:27 weatherpi weewx[608]: **** self.dispatchEvent(weewx.Event(weewx.POST_LOOP)) Mar 12 22:05:27 weatherpi weewx[608]: **** File "/usr/share/weewx/weewx/engine.py", line 223, in dispatchEvent Mar 12 22:05:27 weatherpi weewx[608]: **** callback(event) Mar 12 22:05:27 weatherpi weewx[608]: **** File "/usr/share/weewx/weewx/engine.py", line 571, in post_loop Mar 12 22:05:27 weatherpi weewx[608]: **** self._software_catchup() Mar 12 22:05:27 weatherpi weewx[608]: **** File "/usr/share/weewx/weewx/engine.py", line 638, in _software_catchup Mar 12 22:05:27 weatherpi weewx[608]: **** self.engine.dispatchEvent(weewx.Event(weewx.NEW_ARCHIVE_RECORD, record=record, origin='software')) Mar 12 22:05:27 weatherpi weewx[608]: **** File "/usr/share/weewx/weewx/engine.py", line 223, in dispatchEvent Mar 12 22:05:27 weatherpi weewx[608]: **** callback(event) Mar 12 22:05:27 weatherpi weewx[608]: **** File "/usr/share/weewx/weewx/engine.py", line 591, in new_archive_record Mar 12 22:05:27 weatherpi weewx[608]: **** dbmanager.addRecord(event.record, accumulator=self.old_accumulator) Mar 12 22:05:27 weatherpi weewx[608]: **** File "/usr/share/weewx/weewx/manager.py", line 240, in addRecord Mar 12 22:05:27 weatherpi weewx[608]: **** self._addSingleRecord(record, cursor, log_level) Mar 12 22:05:27 weatherpi weewx[608]: **** File "/usr/share/weewx/weewx/manager.py", line 1172, in _addSingleRecord Mar 12 22:05:27 weatherpi weewx[608]: **** super(DaySummaryManager, self)._addSingleRecord(record, cursor, log_level=log_level) Mar 12 22:05:27 weatherpi weewx[608]: **** File "/usr/share/weewx/weewx/manager.py", line 290, in _addSingleRecord Mar 12 22:05:27 weatherpi weewx[608]: **** cursor.execute(sql_insert_stmt, value_list) Mar 12 22:05:27 weatherpi weewx[608]: **** File "/usr/share/weewx/weedb/mysql.py", line 46, in guarded_fn Mar 12 22:05:27 weatherpi weewx[608]: **** raise klass(e) Mar 12 22:05:27 weatherpi weewx[608]: **** 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.') Mar 12 22:05:27 weatherpi weewx[608]: **** Exiting. -- 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 <mailto:weewx-user+unsubscr...@googlegroups.com> . For more options, visit https://groups.google.com/d/optout. -- 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. For more options, visit https://groups.google.com/d/optout.
