Intermittently (not every night) my last entries are at 2355hrs. Checking the log I find this INFO weewx.engine: Shutting down StdReport thread 2024-11-12T00:00:17.137603+11:00 boronia weewxd[1154387]: CRITICAL __main__: Caught unrecoverable exception: 2024-11-12T00:00:17.137788+11:00 boronia weewxd[1154387]: CRITICAL __main__: **** (1213, 'Deadlock found when trying to get lock; try restarting transaction')
mariadb from 11.4.2-MariaDB, client 15.2 for debian-linux-gnu (x86_64) using EditLine wrapper weewx v5.1.0 (debian packages) Debian GNU/Linux trixie Linux 6.9.8-amd64 Vantage Pro My initial searching suggests this may be a bug, but my knowledge of databases is very poor, so I will leave that decision to others. What workarounds can be suggested to restart the station without my intervention? -- 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 visit https://groups.google.com/d/msgid/weewx-user/0fc8ba70-388f-4e56-8dc1-ea88f09e8c5dn%40googlegroups.com.
# WEEWX CONFIGURATION FILE # # Copyright (c) 2009-2015 Tom Keffer <tkef...@gmail.com> # See the file LICENSE.txt for your rights. ############################################################################## # This section is for general configuration information. # Set to 1 for extra debug info, otherwise comment it out or set to zero debug = 0 # Root directory of the weewx data file hierarchy for this station WEEWX_ROOT = / # Whether to log successful operations log_success = True # Whether to log unsuccessful operations log_failure = True # How long to wait before timing out a socket (FTP, HTTP) connection socket_timeout = 20 # Do not modify this. It is used when installing and updating weewx. version = 4.10.2 ############################################################################## # This section is for information about the station. [Station] # Description of the station location location = "xxx NSW" # Latitude and longitude in decimal degrees latitude = -34 longitude = 140 # Altitude of the station, with unit it is in. This is downloaded from # from the station if the hardware supports it. altitude = 130, meter # Set to type of station hardware. There must be a corresponding stanza # in this file with a 'driver' parameter indicating the driver to be used. station_type = Vantage #station_type = Simulator # The start of the rain year (1=January; 10=October, etc.). This is # downloaded from the station if the hardware supports it. rain_year_start = 1 # Start of week (0=Monday, 6=Sunday) week_start = 6 # If you have a website, you may specify an URL station_url = http://www.billiau.net/weewx ############################################################################## [CC3000] # This section is for RainWise MarkIII weather stations and CC3000 logger. # Serial port such as /dev/ttyS0, /dev/ttyUSB0, or /dev/cuaU0 port = /dev/ttyUSB0 # The station model, e.g., CC3000 or CC3000R model = CC3000 # The driver to use: driver = weewx.drivers.cc3000 [FineOffsetUSB] # This section is for the Fine Offset series of weather stations. # The station model, e.g., WH1080, WS1090, WS2080, WH3081 model = WS2080 # The polling mode can be PERIODIC or ADAPTIVE polling_mode = PERIODIC # How often to poll the station for data, in seconds polling_interval = 60 # The pressure calibration offset, in hPa (millibars) pressure_offset = 0 # The driver to use: driver = weewx.drivers.fousb [Simulator] # This section for the weewx weather station simulator # The time (in seconds) between LOOP packets. loop_interval = 2.5 # The simulator mode can be either 'simulator' or 'generator'. # Real-time simulator. Sleep between each LOOP packet. mode = simulator # Generator. Emit LOOP packets as fast as possible (useful for testing). #mode = generator # The start time. If not specified, the default is to use the present time. #start = 2011-01-01 00:00 # The driver to use: driver = weewx.drivers.simulator [TE923] # This section is for the Hideki TE923 series of weather stations. # The station model, e.g., 'Meade TE923W' or 'TFA Nexus' model = TE923 # The driver to use: driver = weewx.drivers.te923 # The default configuration associates the channel 1 sensor with outTemp # and outHumidity. To change this, or to associate other channels with # specific columns in the database schema, use the following maps. [[sensor_map]] # Map the remote sensors to columns in the database schema. outTemp = t_1 outHumidity = h_1 extraTemp1 = t_2 extraHumid1 = h_2 extraTemp2 = t_3 extraHumid2 = h_3 extraTemp3 = t_4 # WARNING: the following are not in the default schema extraHumid3 = h_4 extraTemp4 = t_5 extraHumid4 = h_5 [[battery_map]] txBatteryStatus = batteryUV windBatteryStatus = batteryWind rainBatteryStatus = batteryRain outTempBatteryStatus = battery1 # WARNING: the following are not in the default schema extraBatteryStatus1 = battery2 extraBatteryStatus2 = battery3 extraBatteryStatus3 = battery4 extraBatteryStatus4 = battery5 [Ultimeter] # This section is for the PeetBros Ultimeter series of weather stations. # Serial port such as /dev/ttyS0, /dev/ttyUSB0, or /dev/cuaU0 port = /dev/ttyUSB0 # The station model, e.g., Ultimeter 2000, Ultimeter 100 model = Ultimeter # The driver to use: driver = weewx.drivers.ultimeter ############################################################################## [Vantage] # This section is for a Davis VantagePro2, VantageVue or WeatherLinkIP # Connection type: serial or ethernet # serial (the classic VantagePro) # ethernet (the WeatherLinkIP) type = serial # If the connection type is serial, a port must be specified: # Debian, Ubuntu, Redhat, Fedora, and SuSE: # /dev/ttyUSB0 is a common USB port name # /dev/ttyS0 is a common serial port name # BSD: # /dev/cuaU0 is a common serial port name port = /dev/vantage # If the connection type is ethernet, an IP Address/hostname is required: host = 1.2.3.4 ###################################################### # The rest of this section rarely needs any attention. # You can safely leave it "as is." ###################################################### # Serial baud rate (usually 19200) baudrate = 19200 # TCP port (when using the WeatherLinkIP) tcp_port = 22222 # TCP send delay (when using the WeatherLinkIP): tcp_send_delay = 1 # The type of LOOP packet to request: 1 = LOOP1; 2 = LOOP2; 3 = both loop_request = 1 # The id of your ISS station (usually 1) iss_id = 1 # How long to wait for a response from the station before giving up (in # seconds; must be greater than 2) timeout = 5 # How long to wait before trying again (in seconds) wait_before_retry = 1.2 # How many times to try before giving up: max_tries = 4 # The driver to use: driver = weewx.drivers.vantage [WMR100] # This section is for the Oregon Scientific WMR100 # The station model, e.g., WMR100, WMR100N, WMRS200 model = WMR100 # How long a wind record can be used to calculate wind chill (in seconds) stale_wind = 30 # The driver to use: driver = weewx.drivers.wmr100 [WMR200] # This section is for the Oregon Scientific WMR200 # The station model, e.g., WMR200, WMR200A, Radio Shack W200 model = WMR200 # The driver to use: driver = weewx.drivers.wmr200 [WMR9x8] # This section is for the Oregon Scientific WMR918/968 # Connection type. For now, 'serial' is the only option. type = serial # Serial port such as /dev/ttyS0, /dev/ttyUSB0, or /dev/cuaU0 port = /dev/ttyUSB0 # The station model, e.g., WMR918, Radio Shack 63-1016 model = WMR968 # The driver to use: driver = weewx.drivers.wmr9x8 [WS1] # This section is for the ADS WS1 series of weather stations. # Serial port such as /dev/ttyS0, /dev/ttyUSB0, or /dev/cuaU0 port = /dev/ttyUSB0 # The driver to use: driver = weewx.drivers.ws1 ############################################################################## [WS23xx] # This section is for the La Crosse WS-2300 series of weather stations. # Serial port such as /dev/ttyS0, /dev/ttyUSB0, or /dev/cuaU0 port = /dev/vpro # The station model, e.g., 'LaCrosse WS2317' or 'TFA Primus' model = Vantage # The pressure calibration offset, in hPa (millibars) pressure_offset = -12 # The driver to use: driver = weewx.drivers.ws23xx [WS28xx] # This section is for the La Crosse WS-2800 series of weather stations. # Radio frequency to use between USB transceiver and console: US or EU # US uses 915 MHz, EU uses 868.3 MHz. Default is US. transceiver_frequency = US # The station model, e.g., 'LaCrosse C86234' or 'TFA Primus' model = LaCrosse WS28xx # The pressure calibration offset, in hPa (millibars) pressure_offset = 0 # The driver to use: driver = weewx.drivers.ws28xx ############################################################################## # This section is for uploading data to Internet sites [StdRESTful] [[StationRegistry]] # To register this weather station with weewx, set this to true register_this_station = true [[AWEKAS]] # This section is for configuring posts to AWEKAS. # If you wish to do this, set the option 'enable' to true, # and specify a username and password. enable = true username = xxxxxx password = xxxxxx log_success = True log_failure = True [[CWOP]] # This section is for configuring posts to CWOP. # If you wish to do this, set the option 'enable' to true, # and specify the station ID (e.g., CW1234). enable = true station = xxxxx post_interval = 600 log_success = True log_failure = True server_list = xxxxxx # If this is an APRS (radio amateur) station, uncomment # the following and replace with a passcode (e.g., 12345). passcode = xxxxxx [[PWSweather]] # This section is for configuring posts to PWSweather.com. # If you wish to do this, set the option 'enable' to true, # and specify a station and password. enable = true station = xxxxxx password = xxxxxx log_success = True log_failure = True [[WOW]] # This section is for configuring posts to WOW. # If you wish to do this, set the option 'enable' to true, # and specify a station and password. enable = true station = xxxxx password = xxxxx log_success = True log_failure = True [[Wunderground]] # This section is for configuring posts to the Weather Underground. # If you wish to do this, set the option 'enable' to true, # and specify a station (e.g., 'KORHOODR3') and password. enable = false station = "" password = "" # Set the following to True to have weewx use the WU "Rapidfire" # protocol. Not all hardware can support it. See the User's Guide. rapidfire = False # If you plan on using wunderfixer, set the following # to your API key: api_key = replace_me [[Windy]] api_key = xxxxxx ############################################################################## # This section specifies what reports, using which skins, to generate. [StdReport] # Where the skins reside, relative to WEEWX_ROOT SKIN_ROOT = /etc/weewx/skins # Where the generated reports should go, relative to WEEWX_ROOT HTML_ROOT = /var/www/html/weewx # The database binding indicates which data should be used in reports. data_binding = wx_binding #### # Each of the following subsections defines a report that will be run. # See the customizing guide to change the units, plot types and line # colors, modify the fonts, display additional sensor data, and other # customizations. Many of those changes can be made here by overriding # parameters, or by modifying templates within the skin itself. [[StandardReport]] # See the customizing guide to change the units, plot types and line # colors, modify the fonts, display additional sensor data, and other # customizations. Many of those changes can be made here by overriding # parameters, or by modifying templates within the skin itself. # The StandardReport uses the 'Standard' skin, which contains the # images, templates and plots for the report. skin = Mine enable = True [[[Units]]] [[[[Groups]]]] group_altitude = meter group_speed2 = meter_per_second2 group_pressure = hPa group_rain = mm group_rainrate = mm_per_hour group_temperature = degree_C group_degree_day = degree_C_day group_speed = km_per_hour [[Data]] HTML_ROOT = /var/www/html/weewx/ skin = Data [[[Units]]] [[[[Groups]]]] group_altitude = meter group_speed2 = km_per_hour2 group_pressure = mbar group_rain = mm group_rainrate = mm_per_hour group_degree_day = degree_C_day group_temperature = degree_C group_speed = km_per_hour [[Inigo]] HTML_ROOT = /var/www/html/weewx/ skin = Inigo [[[Units]]] [[[[Groups]]]] group_altitude = meter group_speed2 = km_per_hour2 group_pressure = mbar group_rain = mm group_rainrate = mm_per_hour group_degree_day = degree_C_day group_temperature = degree_C group_speed = km_per_hour [[SeasonsReport]] # The SeasonsReport uses the 'Seasons' skin, which contains the # images, templates and plots for the report. skin = Seasons enable = false [[SmartphoneReport]] # The SmartphoneReport uses the 'Smartphone' skin, and the images and # files are placed in a dedicated subdirectory. skin = Smartphone enable = false HTML_ROOT = public_html/smartphone [[MobileReport]] # The MobileReport uses the 'Mobile' skin, and the images and files # are placed in a dedicated subdirectory. skin = Mobile enable = false HTML_ROOT = public_html/mobile [[uradmon]] HTML_ROOT = /var/www/html/weewx/uradmon skin = uradmon enable = true lang = en # a reminder that the unit outputs METRIC. You can # change this to suit your setup. Options are US, # METRIC, METRICWX unit_system = METRIC [[[Units]]] [[[[Groups]]]] group_altitude = meter group_speed2 = km_per_hour2 group_pressure = hPa group_rain = mm group_rainrate = mm_per_hour group_degree_day = degree_C_day group_temperature = degree_C group_speed = km_per_hour # These are the default units from the uradmon # unit and driver. Change these to suit your needs # Pressure options are 'inHg', 'mmHg', 'mbar', or 'hPa' group_urad_pressure = hPa # Time options are second', 'day ', 'hour, group_elapsed = day # Radiation options are 'cpm' or 'micro_sievert' group_ion_radiation = micro_sievert [[xstats]] skin = xstats HTML_ROOT = /var/www/html/weewx/xstats [[FTP]] # FTP'ing the results to a webserver is treated as just another report, # albeit one with an unusual report generator! skin = Ftp # If you wish to use FTP, uncomment and fill out the next four lines. #user = replace with the ftp username #password = replace with the ftp password #server = replace with the ftp server name, e.g, www.threefools.org #path = replace with the ftp destination directory (e.g., /weather) # Set to True for a secure FTP (SFTP) connection. Not all servers # support this. secure_ftp = False # To upload files from something other than what HTML_ROOT is set # to above, specify a different HTML_ROOT here. #HTML_ROOT = /var/www/weewx # Most FTP servers use port 21 port = 21 # Set to 1 to use passive mode, zero for active mode passive = 1 max_tries = 3 [[RSYNC]] # rsync'ing to a webserver is treated as just another report # skin = Rsync # If you wish to use rsync, you must configure passwordless ssh using # public/private key authentication from the user account that weewx # runs as to the user account on the remote machine where the files # will be copied. # # The following three lines determine where files will be sent. # server = # path = /var/www/weewx/ # user = www-data # Rsync can be configured to remove files from the remote server if # they don't exist under HTML_ROOT locally. USE WITH CAUTION: if you # make a mistake in the remote path, you could could unintentionally # cause unrelated files to be deleted. Set to 1 to enable remote file # deletion, zero to allow files to accumulate remotely. # delete = 0 #### ############################################################################## # This service acts as a filter, converting the unit system coming from # the hardware to a unit system in the database. [StdConvert] # The target_unit affects only the unit system in the database. Once # chosen it cannot be changed without converting the entire database. # Modification of target_unit after starting weewx will result in # corrupt data - the database will contain a mix of US and METRIC data. # # The value of target_unit does not affect the unit system for # reporting - reports can display US, Metric, or any combination of units. # # In most cases, target_unit should be left as the default: US # # In particular, those migrating from a standard wview installation # should use US since that is what the wview database contains. # DO NOT MODIFY THIS VALUE UNLESS YOU KNOW WHAT YOU ARE DOING! target_unit = METRIC # Options are 'US', 'METRICWX', or 'METRIC' ############################################################################## # This section can adjust data using calibration expressions. [StdCalibrate] [[Corrections]] # For each type, an arbitrary calibration expression can be given. # It should be in the units defined in the StdConvert section. # Example: foo = foo + 0.2 ############################################################################## # This section is for quality control checks. If units are not specified, # values must be in the units defined in the StdConvert section. [StdQC] [[MinMax]] barometer = 990, 1340, hPa outTemp = -10, 50, degree_C inTemp = 0, 50, degree_C outHumidity = 0, 100 inHumidity = 0, 100 windSpeed = 0, 100, km_per_hour rain = 0, 360, mm pressure = 24, 34.5, inHg ############################################################################## # This section controls the origin of derived values. [StdWXCalculate] [[Calculations]] # Derived quantities are calculated by this service. Possible values are: # hardware - use the value provided by hardware # software - use the value calculated by weewx # prefer_hardware - use value provide by hardware if available, # otherwise use value calculated by weewx pressure = prefer_hardware barometer = prefer_hardware altimeter = prefer_hardware windchill = prefer_hardware heatindex = prefer_hardware dewpoint = prefer_hardware inDewpoint = prefer_hardware rainRate = prefer_hardware maxSolarRad = prefer_hardware cloudbase = prefer_hardware humidex = prefer_hardware appTemp = prefer_hardware ET = prefer_hardware windrun = prefer_hardware ############################################################################## # For hardware that supports it, this section controls how often the # onboard clock gets updated. [StdTimeSynch] # How often to check the weather station clock for drift (in seconds) clock_check = 14400 # How much it can drift before we will correct it (in seconds) max_drift = 5 ############################################################################## # This section is for configuring the archive service. [StdArchive] # If the station hardware supports data logging then the archive interval # will be downloaded from the station. Otherwise, specify it (in seconds). archive_interval = 300 # How long to wait (in seconds) before processing new archive data. Must # be greater than zero. archive_delay = 15 # If possible, new archive records are downloaded from the station # hardware. If the hardware does not support this, then new archive # records will be generated in software. # Set the following to "software" to force software record generation. record_generation = hardware # Whether to include LOOP data in hi/low statistics loop_hilo = True # The data binding used to save archive records data_binding = wx_binding ############################################################################## # This section binds a data store to a database. [DataBindings] [[wx_binding]] # The database must match one of the sections in [Databases]. # This is likely to be the only option you would want to change. database = archive_mysql # The name of the table within the database table_name = archive # The manager handles aggregation of data for historical summaries manager = weewx.wxmanager.WXDaySummaryManager # The schema defines the structure of the database. # It is *only* used when the database is created. schema = schemas.wview.schema [[uradmon_binding]] manager = weewx.manager.DaySummaryManager schema = user.uradmon.schema table_name = archive database = uradmon_mysql ############################################################################## # This section defines various databases. [Databases] # A SQLite database is simply a single file [[archive_sqlite]] database_type = SQLite database_name = weewx.sdb # MySQL [[archive_mysql]] database_type = MySQL database_name = weewx2020 [[uradmon_sqlite]] database_name = uradmon.sdb database_type = SQLite [[uradmon_mysql]] database_name = uradmon2020 database_type = MySQL ############################################################################## # This section defines defaults for the different types of databases. [DatabaseTypes] # Defaults for SQLite databases [[SQLite]] driver = weedb.sqlite # Directory in which the database files are located SQLITE_ROOT = /var/lib/weewx # Defaults for MySQL databases [[MySQL]] driver = weedb.mysql # The host where the database is located host = localhost # The user name for logging in to the host user = xxxxx # The password for the user name password = xxxxxx ############################################################################## # This section configures the internal weewx engine. [Engine] # The following section specifies which services should be run and in what order. [[Services]] prep_services = weewx.engine.StdTimeSynch, data_services = , process_services = weewx.engine.StdConvert, weewx.engine.StdCalibrate, weewx.engine.StdQC, weewx.wxservices.StdWXCalculate, user.uradmon.UradMon xtype_services = weewx.wxxtypes.StdWXXTypes, weewx.wxxtypes.StdPressureCooker, weewx.wxxtypes.StdRainRater, weewx.wxxtypes.StdDelta archive_services = weewx.engine.StdArchive, restful_services = weewx.restx.StdStationRegistry, weewx.restx.StdWunderground, weewx.restx.StdPWSweather, weewx.restx.StdCWOP, weewx.restx.StdWOW, weewx.restx.StdAWEKAS, user.windy.Windy report_services = weewx.engine.StdPrint, weewx.engine.StdReport ############################################################################## # Options for extension 'uradmon' [UradMon] urad_debug = True data_binding = uradmon_binding uradmon_address = xxxxxx dbm_check = False
weewx_log_extract
Description: Binary data