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

Attachment: weewx_log_extract
Description: Binary data

Reply via email to