@vince
attached please find the diag-log.
WeeWX is running on a RPI-4b 4GB. Right now the load is high because i'm
migrating data.
Normaly is works perfectly well since years.
vince schrieb am Dienstag, 2. Dezember 2025 um 18:10:37 UTC+1:
> If it broke when you switched from (local) sqlite to (remote) mariadb,
> you likely have network or configuration issues in your mariadb setup
> between the weewx system and that other system.
>
> What kind of pi are you running on ? What kind of system is running the
> db ? Are you seeing errors on the remote db server ?
>
> As Tom said, we need to see your 'current' logs from weewx startup through
> 'two' full report cycles.
>
> You might also attach the 'current' output of "*weectl diag
> --output=filename*" after checking the output file has no
> usernames/passwords in it. Weectl is pretty good about obfuscating such
> things but it can't be perfect in all cases.
>
> On Tuesday, December 2, 2025 at 8:17:04 AM UTC-8 Tom Keffer wrote:
>
>> It's possible your reports are taking too long to process. Easy to do
>> with a RPi.
>>
>> But it's hard to say without seeing a log.
>>
>> On Tue, Dec 2, 2025 at 7:56 AM Zed <[email protected]> wrote:
>>
>>> Hm, now i'm suffering:
>>>
>>> "INFO weewx.engine: Launch of report thread aborted: existing report
>>> thread still running"
>>>
>>> How can i figure out, what's wrong?
>>>
>>> Zed schrieb am Dienstag, 2. Dezember 2025 um 16:28:48 UTC+1:
>>>
>>>> @John Smith You made my day! Looks like i'm getting old ;-)
>>>> John Smith schrieb am Dienstag, 2. Dezember 2025 um 11:25:07 UTC+1:
>>>>
>>>>> You didn't configure weeWX for MariaDB
>>>>>
>>>>> Added record 2025-12-01 23:05:00 CET (1764626700) to database 'weewx.sdb'
>>>>>
>>>>>
>>>>> Specifically this section:
>>>>>
>>>>>
>>>>> [DataBindings]
>>>>> [[wx_binding]]
>>>>> database = archive_sqlite
>>>>> table_name = archive
>>>>> manager = weewx.manager.DaySummaryManager
>>>>> schema = weewx.schemas.wview_extended.schema
>>>>>
>>>>>
>>>>> On Tue, 2 Dec 2025 at 21:03, Zed <[email protected]> wrote:
>>>>>
>>>>>> I had to upgrade my VEnv-installation from 4.9.1 to 5.2.0.
>>>>>> The data is stored in mariadb since ever.
>>>>>> Now in the reports i see the the values since the upgrade but none
>>>>>> before. Not in the view week, month or year.
>>>>>> The database backup contains several hundreds of thousand of records.
>>>>>> So i guess the data is still there.
>>>>>> What causes the old data to be hidden?
>>>>>>
>>>>>> S. issues #1043
>>>>>> <https://github.com/weewx/weewx/issues/1043#issue-3683018851>
>>>>>>
>>>>>> --
>>>>>> 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].
>>>>>> To view this discussion visit
>>>>>> https://groups.google.com/d/msgid/weewx-user/b1f919c7-439a-42f8-b952-1e96fc5a5366n%40googlegroups.com
>>>>>>
>>>>>> <https://groups.google.com/d/msgid/weewx-user/b1f919c7-439a-42f8-b952-1e96fc5a5366n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>>>> .
>>>>>>
>>>>> --
>>> 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].
>>>
>> To view this discussion visit
>>> https://groups.google.com/d/msgid/weewx-user/c779e7ed-b1b6-4a1d-97eb-31abdb5406a5n%40googlegroups.com
>>>
>>> <https://groups.google.com/d/msgid/weewx-user/c779e7ed-b1b6-4a1d-97eb-31abdb5406a5n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>>
--
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].
To view this discussion visit
https://groups.google.com/d/msgid/weewx-user/70552350-e523-456f-a56a-b39efa4c5c0fn%40googlegroups.com.
System info
Platform: Linux-6.12.47+rpt-rpi-v8-aarch64-with-glibc2.41
Python Version: 3.13.5
Load Information
1 minute load average: 4.91
5 minute load average: 4.64
15 minute load average: 4.66
General Weewx info
Weewx version 5.2.0 detected.
Currently installed extensions
Extension Name Version Description
bme280wx 1.0 Add bme280 sensor readings to loop packet data
csv 0.11 Emit loop or archive data in CSV format.
mqtt 0.24 Upload weather data to MQTT server.
sdr 0.96b1 Capture data from rtl_433
Archive info
Database name: weewx
Table name: archive
Version 4.0
Unit system: 17 (METRICWX)
First good timestamp: 2012-12-27 12:29:00 CET (1356607740)
Last good timestamp: 2025-12-02 18:50:00 CET (1764697800)
Number of records: 680615
weewx (weewx.conf) is set to use an archive interval of 300 seconds.
The station hardware was not interrogated to determine the archive interval.
Supported SQL keys
dateTime usUnits interval
barometer pressure altimeter
inTemp outTemp inHumidity
outHumidity windSpeed windDir
windGust windGustDir rainRate
rain dewpoint windchill
heatindex ET radiation
UV extraTemp1 extraTemp2
extraTemp3 soilTemp1 soilTemp2
soilTemp3 soilTemp4 leafTemp1
leafTemp2 extraHumid1 extraHumid2
soilMoist1 soilMoist2 soilMoist3
soilMoist4 leafWet1 leafWet2
rxCheckPercent txBatteryStatus consBatteryVoltage
hail hailRate heatingTemp
heatingVoltage supplyVoltage referenceVoltage
windBatteryStatus rainBatteryStatus outTempBatteryStatus
inTempBatteryStatus
Databases configured in weewx.conf:
archive_sqlite:
database_name weewx.sdb
driver weedb.sqlite
SQLITE_ROOT /home/weewx/weewx-data/archive
archive_mysql:
database_name weewx
driver weedb.mysql
host mariadb.local
user weewx
password ***
--- Start configuration file /home/weewx/weewx-data/weewx.conf ---
# WEEWX CONFIGURATION FILE
#
# Copyright (c) 2009-2024 Tom Keffer <[email protected]>
# 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
# debug = 1
# Whether to log successful operations. May get overridden below.
log_success = True
# Whether to log unsuccessful operations. May get overridden below.
log_failure = True
# This configuration file was created by ...
version = 5.2.0
config_path = /home/weewx/weewx-data/weewx.conf
WEEWX_ROOT = /home/weewx/weewx-data
##############################################################################
# This section is for information about the station.
[Station]
# Description of the station location, such as your town.
location = ***
# Latitude in decimal degrees. Negative for southern hemisphere.
latitude = ***
# Longitude in decimal degrees. Negative for western hemisphere.
longitude = ***
# Altitude of the station, with the unit it is in. This is used only
# if the hardware cannot supply a value.
altitude = 130, meter # Choose 'foot' or 'meter' for unit
# Set to type of station hardware. There must be a corresponding stanza
# in this file, which includes a value for the 'driver' option.
station_type = SDR
# If you have a website, you may specify an URL. The URL is required if you
# intend to register your station. The URL must include the scheme, for
# example, "http://"; or "https://";
#station_url = https://www.example.com
# 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 = 0
##############################################################################
[SDR]
# This section is for the software-defined radio driver.
# The driver to use
driver = user.sdr
cmd = /usr/local/bin/rtl_433 -Y classic -s 250k -f 868.272M -R 119 -g auto
-M utc -F json
log_lines = False
log_unknown_sensors = True
log_unmapped_sensors = True
[[sensor_map]]
outHumidity = humidity.125.Bresser5in1Packet
outTemp = temperature.125.Bresser5in1Packet
windDir = wind_dir.125.Bresser5in1Packet
rain_total = rain_total.125.Bresser5in1Packet
windSpeed = wind_speed.125.Bresser5in1Packet
windGust = gust_speed.125.Bresser5in1Packet
outTempBatteryStatus = battery.125.Bresser5in1Packet
##############################################################################
# This section is for uploading data to Internet sites
[StdRESTful]
# Uncomment and change to override logging for uploading services.
# log_success = True
# log_failure = True
[[StationRegistry]]
# To register this weather station at weewx.com, set this to true, and
# set option 'station_url', located in the [Station] section above.
register_this_station = False
[[AWEKAS]]
# This section is for configuring posts to AWEKAS.
# If you wish to post to AWEKAS, set the option 'enable' to true, then
# specify a username and password.
# Use quotes around the password to guard against parsing errors.
enable = false
username = XXXXXX
password = XXXXXX
[[CWOP]]
# This section is for configuring posts to CWOP.
# If you wish to post to CWOP, set the option 'enable' to true,
# then specify the station ID (e.g., CW1234).
enable = false
station = XXXXXX
# If this is an APRS (radio amateur) station, specify the
# passcode (e.g., 12345). Otherwise, ignore.
passcode = XXXXXX
[[PWSweather]]
# This section is for configuring posts to PWSweather.com.
# If you wish to post to PWSweather.com, set the option 'enable' to
# true, then specify a station and password.
# Use quotes around the password to guard against parsing errors.
enable = false
station = XXXXXX
password = XXXXXX
[[WOW]]
# This section is for configuring posts to WOW (wow.metoffice.gov.uk).
# If you wish to post to WOW, set the option 'enable' to true, then
# specify a station and password.
# Use quotes around the password to guard against parsing errors.
enable = false
station = XXXXXX
password = XXXXXX
[[WOW-BE]]
# This section is for configuring WeeWX to upload to WOW-BE
(wow.meteo.be)
# If you wish to post to WOW-BE, set the option 'enable' to true, then
# specify a station and password.
# Use quotes around the password to guard against parsing errors.
enable = false
station = XXXXXX
password = XXXXXX
[[Wunderground]]
# This section is for configuring posts to the Weather Underground.
# If you wish to post to the Weather Underground, set the option
# 'enable' to true, then specify a station (e.g., 'KORHOODR3'). Use
# the station key (find it at
# https://www.wunderground.com/member/devices) for the password.
enable = false
station = XXXXXX
password = XXXXXX
# 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
# Configuration for uploading LOOP data to an MQTT broker
[[MQTT]]
# Enable/disable this service
enable = true
server_url = XXXXXX
topic = weather
# topic = weewx
unit_system = METRIC
[[[tls]]]
# CA certificates file (mandatory)
ca_certs = XXXXXX
# PEM encoded client certificate file (optional)
certfile = XXXXXX
# private key file (optional)
keyfile = XXXXXX
# Certificate requirements imposed on the broker (optional).
# Options are 'none', 'optional' or 'required'.
# Default is 'required'.
# cert_reqs = required
# cert_reqs = optional
# SSL/TLS protocol (optional).
# Options include sslv2, sslv23, sslv3, tls, tlsv1, tlsv11,
# tlsv12.
# Default is 'tlsv12'
# Not all options are supported by all systems.
# OpenSSL version till 1.0.0.h supports sslv2, sslv3 and tlsv1
# OpenSSL >= 1.0.1 supports tlsv11 and tlsv12
# OpenSSL >= 1.1.1 support TLSv1.3 (use tls_version = tls)
# Check your OpenSSL protocol support with:
# openssl s_client -help 2>&1 > /dev/null | egrep
"\-(ssl|tls)[^a-z]"
# tls_version = tlsv12
tls_version = tls
# Allowable encryption ciphers (optional).
# To specify multiple cyphers, delimit with commas and enclose
# in quotes.
#ciphers =
##############################################################################
# This section specifies what reports, using which skins, to generate.
[StdReport]
# Where the skins reside, relative to WEEWX_ROOT
SKIN_ROOT = skins
# Where the generated reports should go, relative to WEEWX_ROOT
HTML_ROOT = public_html
# Uncomment and change to override logging for reports.
log_success = True
log_failure = True
# 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.
[[SeasonsReport]]
# The SeasonsReport uses the 'Seasons' skin, which contains the
# images, templates and plots for the report.
skin = Seasons
enable = true
lang = de
[[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
[[StandardReport]]
# This is the old "Standard" skin. By default, it is not enabled.
skin = Standard
enable = false
[[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, set "enable" to "true", then fill out the
# next four lines.
# Use quotes around the password to guard against parsing errors.
enable = false
user = XXXXXX
password = XXXXXX
server = XXXXXX # The ftp server name, e.g, www.myserver.org
path = replace_me # The destination directory, e.g., /weather
# Set to True for an FTP over TLS (FTPS) 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 = public_html
# Most FTP servers use port 21.
port = 21
# Set to 1 to use passive mode, zero for active mode
passive = 1
[[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 to the user account on the remote machine where the files
# will be copied.
#
# If you wish to use rsync, set "enable" to "true", then
# fill out server, user, and path.
# The server should appear in your .ssh/config file.
# The user is the username used in the identity file.
# The path is the destination directory, such as /var/www/html/weather.
# Be sure that the user has write permissions on the destination!
enable = true
server = XXXXXX
user = XXXXXX
path = /var/www/html/weewx
# To upload files from something other than what HTML_ROOT is set
# to above, specify a different HTML_ROOT here.
#HTML_ROOT = public_html
# 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
# Options in the [[Defaults]] section below will apply to all reports.
# What follows are a few of the more popular options you may want to
# uncomment, then change.
[[Defaults]]
# Which language to use for all reports. Not all skins support all
# languages. You can override this for individual reports.
# lang = en
# Which unit system to use for all reports. Choices are 'us', 'metric',
# or 'metricwx'. You can override this for individual reports.
unit_system = metricwx
[[[Units]]]
# Option "unit_system" above sets the general unit system, but
# overriding specific unit groups is possible. These are popular
# choices. Uncomment and set as appropriate. The unit is always
# in the singular, e.g., 'mile_per_hour', NOT 'miles_per_hour'
[[[[Groups]]]]
# group_altitude = meter # Options are 'foot'
or 'meter'
# group_pressure = mbar # Options are 'inHg',
'mmHg', 'mbar', or 'hPa'
# group_rain = mm # Options are 'inch',
'cm', or 'mm'
group_rain = cm # Options are 'inch', 'cm', or 'mm'
# group_rainrate = mm_per_hour # Options are
'inch_per_hour', 'cm_per_hour', or 'mm_per_hour'
group_rainrate = cm_per_hour # Options are 'inch_per_hour',
'cm_per_hour', or 'mm_per_hour'
# group_temperature = degree_C # Options are
'degree_C', 'degree_F', or 'degree_K'
# The following line is used to keep the above lines indented
# properly. It can be ignored.
unused = unused
# Uncommenting the following section frequently results in more
# attractive formatting of times and dates, but may not work in
# your locale.
[[[[TimeFormats]]]]
# day = %H:%M
# week = %H:%M on %A
# month = %d-%b-%Y %H:%M
# year = %d-%b-%Y %H:%M
# rainyear = %d-%b-%Y %H:%M
# current = %d-%b-%Y %H:%M
# ephem_day = %H:%M
# ephem_year = %d-%b-%Y %H:%M
# The following line is used to keep the above lines indented
# properly. It can be ignored.
unused = unused
[[[Labels]]]
# Users frequently change the labels for these observation types.
[[[[Generic]]]]
# inHumidity = Inside Humidity
# inTemp = Inside Temperature
# outHumidity = Outside Humidity
# outTemp = Outside Temperature
# extraTemp1 = Temperature1
# extraTemp2 = Temperature2
# extraTemp3 = Temperature3
# The following line is used to keep the above lines indented
# properly. It can be ignored.
unused = unused
##############################################################################
# This service converts 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 = METRICWX # 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 = 26, 32.5, inHg
pressure = 24, 34.5, inHg
outTemp = -40, 120, degree_F
inTemp = 10, 120, degree_F
outHumidity = 0, 100
inHumidity = 0, 100
windSpeed = 0, 120, mile_per_hour
rain = 0, 10, inch
##############################################################################
# This section controls the origin of derived values.
[StdWXCalculate]
[[Calculations]]
# How to calculate derived quantities. 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
altimeter = prefer_hardware
appTemp = prefer_hardware
barometer = prefer_hardware
cloudbase = prefer_hardware
dewpoint = prefer_hardware
ET = prefer_hardware
heatindex = prefer_hardware
humidex = prefer_hardware
inDewpoint = prefer_hardware
maxSolarRad = prefer_hardware
rainRate = prefer_hardware
windchill = 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
# 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
record_generation = software
# Whether to include LOOP data in hi/low statistics.
loop_hilo = True
# Uncomment and change to override logging for archive operations.
log_success = True
log_failure = 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_sqlite
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.manager.DaySummaryManager
# The schema defines the structure of the database.
# It is *only* used when the database is created.
schema = weewx.schemas.wview_extended.schema
##############################################################################
# This section defines various databases.
[Databases]
# A SQLite database is simply a single file.
[[archive_sqlite]]
database_name = weewx.sdb
database_type = SQLite
# MySQL
[[archive_mysql]]
database_name = weewx
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 database files are located, relative to WEEWX_ROOT
SQLITE_ROOT = archive
# Defaults for MySQL databases.
[[MySQL]]
driver = weedb.mysql
# The host where the database is located.
# host = localhost
host = mariadb.local
# The user name for logging in to the host.
user = XXXXXX
# Use quotes around the password to guard against parsing errors.
password = XXXXXX
##############################################################################
# This section configures the internal weewx engine.
[Engine]
# This section specifies which services should be run and in what order.
[[Services]]
prep_services = weewx.engine.StdTimeSynch
data_services = user.bme280wx.Bme280wx,
process_services = weewx.engine.StdConvert, weewx.engine.StdCalibrate,
weewx.engine.StdQC, weewx.wxservices.StdWXCalculate, user.csv.CSV
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.StdWOWBE, weewx.restx.StdAWEKAS, user.mqtt.MQTT
report_services = weewx.engine.StdPrint, weewx.engine.StdReport
[CSV]
filename = /tmp/data.csv
[Bme280wx]
# i2c_port = 1
# i2c_address = 0x76
# usUnits = US
usUnits = METRICWX
