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 [email protected]. For more options, visit https://groups.google.com/d/optout.
