Hi John,
how can i check the columns? Attached please find the db-columns currently
defined.
John Smith schrieb am Donnerstag, 4. Dezember 2025 um 14:20:20 UTC+1:
> If your system is doing that much work, are you missing DB columns to
> store previously calculated values that templates are asking for?
>
> On Fri, 5 Dec 2025 at 00:10, Zed <[email protected]> wrote:
>
>> Attached please find the requested log.
>>
>> When the service starts everything looks well and the system-load is low.
>> As soon as the first report is created, the process
>> "/home/weewx/weewx-venv/bin/python3
>> /home/weewx/weewx-venv/lib/python3.13/site-packages/weewxd.py
>> /home/weewx/weewx-data/weewx.conf" consumes 100% CPU of one kernel. It
>> stays at this level and the system-load rises to ~1.8.
>> Please note the messages:
>> "WARNING weewx.engine: Previous report thread has been running
>> 600.9363927841187 seconds. Launching report thread anyway."
>> I guess
>> "ERROR weewx.cheetahgenerator: Evaluation of template
>> /home/weewx/weewx-data/skins/Seasons/index.html.tmpl failed with exception
>> '<class 'FileNotFoundError'>'"
>> and the following messages are a result of a leftover of the pending
>> thread.
>>
>> Is there a way to monitor these report threads and gather more
>> information?
>>
>> Allover the configuration is as before and works well.
>>
>> I should mention, that i just migrated the system to Debian 13 Trixie.
>> Maybe this is relevant.
>> John Smith schrieb am Mittwoch, 3. Dezember 2025 um 00:43:07 UTC+1:
>>
>>> Is this line correct and the hostname listed in /etc/hosts or a LAN
>>> resolver?
>>>
>>> host = mariadb.local
>>>
>>> On Wed, 3 Dec 2025 at 10:40, John Smith <[email protected]> wrote:
>>>
>>>> Why didn't you copy your old config when you updated, or did it get
>>>> deleted somehow and there is no backup of it?
>>>>
>>>> On Wed, 3 Dec 2025 at 06:30, Zed <[email protected]> wrote:
>>>>
>>>>> The db is running on another RPI-4b 4GB in the home LAN.
>>>>> No errors in the db-log.
>>>>> I like mariadb. This worked perfectly for years.
>>>>> Right now the system load is high as i am migrating data. I will check
>>>>> again as soon as the load settels down again ...
>>>>>
>>>>> vince schrieb am Dienstag, 2. Dezember 2025 um 20:22:32 UTC+1:
>>>>>
>>>>>> Need more information.
>>>>>>
>>>>>>
>>>>>>
>>>>>> - What kind of system is running the db ?
>>>>>>
>>>>>>
>>>>>> - Where is this db system located - on your LAN ? On internet ?
>>>>>>
>>>>>>
>>>>>> - Are you seeing errors on the remote db server ?
>>>>>>
>>>>>>
>>>>>> - why do you need to use mariadb at all ?
>>>>>>
>>>>>> And also...
>>>>>>
>>>>>> - We need to see your 'current' logs from weewx startup through
>>>>>> 'two' full report cycles.
>>>>>>
>>>>>> If it was ok using sqlite3 as your db, and it is not ok using mariadb
>>>>>> as your db, the issue is likely a mariadb/weewx misconfiguration or a
>>>>>> network issue.
>>>>>>
>>>>>> If you (temporarily) switch back to sqlite3 and it is then ok again,
>>>>>> it is 'very' likely you have a mariadb/weewx misconfiguration or a
>>>>>> network
>>>>>> issue.
>>>>>>
>>>>>>
>>>>>> On Tuesday, December 2, 2025 at 11:09:41 AM UTC-8 Zed wrote:
>>>>>>
>>>>>>> @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/222b6e08-be18-4d64-99d2-af7c247186dfn%40googlegroups.com
>>>>>
>>>>> <https://groups.google.com/d/msgid/weewx-user/222b6e08-be18-4d64-99d2-af7c247186dfn%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/abff0369-6907-42f6-8a4b-98590b546bfdn%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/weewx-user/abff0369-6907-42f6-8a4b-98590b546bfdn%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/8fa7f23a-1d71-4929-9ccb-d112a003112bn%40googlegroups.com.
+----------------------------------+----------------------+-----------+-------------+----------------+
| TABLE_NAME | COLUMN_NAME | DATA_TYPE |
IS_NULLABLE | COLUMN_DEFAULT |
+----------------------------------+----------------------+-----------+-------------+----------------+
| archive | dateTime | int | NO
| NULL |
| archive | usUnits | int | NO
| NULL |
| archive | interval | int | NO
| NULL |
| archive | barometer | double | YES
| NULL |
| archive | pressure | double | YES
| NULL |
| archive | altimeter | double | YES
| NULL |
| archive | inTemp | double | YES
| NULL |
| archive | outTemp | double | YES
| NULL |
| archive | inHumidity | double | YES
| NULL |
| archive | outHumidity | double | YES
| NULL |
| archive | windSpeed | double | YES
| NULL |
| archive | windDir | double | YES
| NULL |
| archive | windGust | double | YES
| NULL |
| archive | windGustDir | double | YES
| NULL |
| archive | rainRate | double | YES
| NULL |
| archive | rain | double | YES
| NULL |
| archive | dewpoint | double | YES
| NULL |
| archive | windchill | double | YES
| NULL |
| archive | heatindex | double | YES
| NULL |
| archive | ET | double | YES
| NULL |
| archive | radiation | double | YES
| NULL |
| archive | UV | double | YES
| NULL |
| archive | extraTemp1 | double | YES
| NULL |
| archive | extraTemp2 | double | YES
| NULL |
| archive | extraTemp3 | double | YES
| NULL |
| archive | soilTemp1 | double | YES
| NULL |
| archive | soilTemp2 | double | YES
| NULL |
| archive | soilTemp3 | double | YES
| NULL |
| archive | soilTemp4 | double | YES
| NULL |
| archive | leafTemp1 | double | YES
| NULL |
| archive | leafTemp2 | double | YES
| NULL |
| archive | extraHumid1 | double | YES
| NULL |
| archive | extraHumid2 | double | YES
| NULL |
| archive | soilMoist1 | double | YES
| NULL |
| archive | soilMoist2 | double | YES
| NULL |
| archive | soilMoist3 | double | YES
| NULL |
| archive | soilMoist4 | double | YES
| NULL |
| archive | leafWet1 | double | YES
| NULL |
| archive | leafWet2 | double | YES
| NULL |
| archive | rxCheckPercent | double | YES
| NULL |
| archive | txBatteryStatus | double | YES
| NULL |
| archive | consBatteryVoltage | double | YES
| NULL |
| archive | hail | double | YES
| NULL |
| archive | hailRate | double | YES
| NULL |
| archive | heatingTemp | double | YES
| NULL |
| archive | heatingVoltage | double | YES
| NULL |
| archive | supplyVoltage | double | YES
| NULL |
| archive | referenceVoltage | double | YES
| NULL |
| archive | windBatteryStatus | double | YES
| NULL |
| archive | rainBatteryStatus | double | YES
| NULL |
| archive | outTempBatteryStatus | double | YES
| NULL |
| archive | inTempBatteryStatus | double | YES
| NULL |
| archive_day_altimeter | dateTime | int | NO
| NULL |
| archive_day_altimeter | min | double | YES
| NULL |
| archive_day_altimeter | mintime | int | YES
| NULL |
| archive_day_altimeter | max | double | YES
| NULL |
| archive_day_altimeter | maxtime | int | YES
| NULL |
| archive_day_altimeter | sum | double | YES
| NULL |
| archive_day_altimeter | count | int | YES
| NULL |
| archive_day_altimeter | wsum | double | YES
| NULL |
| archive_day_altimeter | sumtime | int | YES
| NULL |
| archive_day_barometer | dateTime | int | NO
| NULL |
| archive_day_barometer | min | double | YES
| NULL |
| archive_day_barometer | mintime | int | YES
| NULL |
| archive_day_barometer | max | double | YES
| NULL |
| archive_day_barometer | maxtime | int | YES
| NULL |
| archive_day_barometer | sum | double | YES
| NULL |
| archive_day_barometer | count | int | YES
| NULL |
| archive_day_barometer | wsum | double | YES
| NULL |
| archive_day_barometer | sumtime | int | YES
| NULL |
| archive_day_consBatteryVoltage | dateTime | int | NO
| NULL |
| archive_day_consBatteryVoltage | min | double | YES
| NULL |
| archive_day_consBatteryVoltage | mintime | int | YES
| NULL |
| archive_day_consBatteryVoltage | max | double | YES
| NULL |
| archive_day_consBatteryVoltage | maxtime | int | YES
| NULL |
| archive_day_consBatteryVoltage | sum | double | YES
| NULL |
| archive_day_consBatteryVoltage | count | int | YES
| NULL |
| archive_day_consBatteryVoltage | wsum | double | YES
| NULL |
| archive_day_consBatteryVoltage | sumtime | int | YES
| NULL |
| archive_day_dewpoint | dateTime | int | NO
| NULL |
| archive_day_dewpoint | min | double | YES
| NULL |
| archive_day_dewpoint | mintime | int | YES
| NULL |
| archive_day_dewpoint | max | double | YES
| NULL |
| archive_day_dewpoint | maxtime | int | YES
| NULL |
| archive_day_dewpoint | sum | double | YES
| NULL |
| archive_day_dewpoint | count | int | YES
| NULL |
| archive_day_dewpoint | wsum | double | YES
| NULL |
| archive_day_dewpoint | sumtime | int | YES
| NULL |
| archive_day_ET | dateTime | int | NO
| NULL |
| archive_day_ET | min | double | YES
| NULL |
| archive_day_ET | mintime | int | YES
| NULL |
| archive_day_ET | max | double | YES
| NULL |
| archive_day_ET | maxtime | int | YES
| NULL |
| archive_day_ET | sum | double | YES
| NULL |
| archive_day_ET | count | int | YES
| NULL |
| archive_day_ET | wsum | double | YES
| NULL |
| archive_day_ET | sumtime | int | YES
| NULL |
| archive_day_extraHumid1 | dateTime | int | NO
| NULL |
| archive_day_extraHumid1 | min | double | YES
| NULL |
| archive_day_extraHumid1 | mintime | int | YES
| NULL |
| archive_day_extraHumid1 | max | double | YES
| NULL |
| archive_day_extraHumid1 | maxtime | int | YES
| NULL |
| archive_day_extraHumid1 | sum | double | YES
| NULL |
| archive_day_extraHumid1 | count | int | YES
| NULL |
| archive_day_extraHumid1 | wsum | double | YES
| NULL |
| archive_day_extraHumid1 | sumtime | int | YES
| NULL |
| archive_day_extraHumid2 | dateTime | int | NO
| NULL |
| archive_day_extraHumid2 | min | double | YES
| NULL |
| archive_day_extraHumid2 | mintime | int | YES
| NULL |
| archive_day_extraHumid2 | max | double | YES
| NULL |
| archive_day_extraHumid2 | maxtime | int | YES
| NULL |
| archive_day_extraHumid2 | sum | double | YES
| NULL |
| archive_day_extraHumid2 | count | int | YES
| NULL |
| archive_day_extraHumid2 | wsum | double | YES
| NULL |
| archive_day_extraHumid2 | sumtime | int | YES
| NULL |
| archive_day_extraTemp1 | dateTime | int | NO
| NULL |
| archive_day_extraTemp1 | min | double | YES
| NULL |
| archive_day_extraTemp1 | mintime | int | YES
| NULL |
| archive_day_extraTemp1 | max | double | YES
| NULL |
| archive_day_extraTemp1 | maxtime | int | YES
| NULL |
| archive_day_extraTemp1 | sum | double | YES
| NULL |
| archive_day_extraTemp1 | count | int | YES
| NULL |
| archive_day_extraTemp1 | wsum | double | YES
| NULL |
| archive_day_extraTemp1 | sumtime | int | YES
| NULL |
| archive_day_extraTemp2 | dateTime | int | NO
| NULL |
| archive_day_extraTemp2 | min | double | YES
| NULL |
| archive_day_extraTemp2 | mintime | int | YES
| NULL |
| archive_day_extraTemp2 | max | double | YES
| NULL |
| archive_day_extraTemp2 | maxtime | int | YES
| NULL |
| archive_day_extraTemp2 | sum | double | YES
| NULL |
| archive_day_extraTemp2 | count | int | YES
| NULL |
| archive_day_extraTemp2 | wsum | double | YES
| NULL |
| archive_day_extraTemp2 | sumtime | int | YES
| NULL |
| archive_day_extraTemp3 | dateTime | int | NO
| NULL |
| archive_day_extraTemp3 | min | double | YES
| NULL |
| archive_day_extraTemp3 | mintime | int | YES
| NULL |
| archive_day_extraTemp3 | max | double | YES
| NULL |
| archive_day_extraTemp3 | maxtime | int | YES
| NULL |
| archive_day_extraTemp3 | sum | double | YES
| NULL |
| archive_day_extraTemp3 | count | int | YES
| NULL |
| archive_day_extraTemp3 | wsum | double | YES
| NULL |
| archive_day_extraTemp3 | sumtime | int | YES
| NULL |
| archive_day_hail | dateTime | int | NO
| NULL |
| archive_day_hail | min | double | YES
| NULL |
| archive_day_hail | mintime | int | YES
| NULL |
| archive_day_hail | max | double | YES
| NULL |
| archive_day_hail | maxtime | int | YES
| NULL |
| archive_day_hail | sum | double | YES
| NULL |
| archive_day_hail | count | int | YES
| NULL |
| archive_day_hail | wsum | double | YES
| NULL |
| archive_day_hail | sumtime | int | YES
| NULL |
| archive_day_hailRate | dateTime | int | NO
| NULL |
| archive_day_hailRate | min | double | YES
| NULL |
| archive_day_hailRate | mintime | int | YES
| NULL |
| archive_day_hailRate | max | double | YES
| NULL |
| archive_day_hailRate | maxtime | int | YES
| NULL |
| archive_day_hailRate | sum | double | YES
| NULL |
| archive_day_hailRate | count | int | YES
| NULL |
| archive_day_hailRate | wsum | double | YES
| NULL |
| archive_day_hailRate | sumtime | int | YES
| NULL |
| archive_day_heatindex | dateTime | int | NO
| NULL |
| archive_day_heatindex | min | double | YES
| NULL |
| archive_day_heatindex | mintime | int | YES
| NULL |
| archive_day_heatindex | max | double | YES
| NULL |
| archive_day_heatindex | maxtime | int | YES
| NULL |
| archive_day_heatindex | sum | double | YES
| NULL |
| archive_day_heatindex | count | int | YES
| NULL |
| archive_day_heatindex | wsum | double | YES
| NULL |
| archive_day_heatindex | sumtime | int | YES
| NULL |
| archive_day_heatingTemp | dateTime | int | NO
| NULL |
| archive_day_heatingTemp | min | double | YES
| NULL |
| archive_day_heatingTemp | mintime | int | YES
| NULL |
| archive_day_heatingTemp | max | double | YES
| NULL |
| archive_day_heatingTemp | maxtime | int | YES
| NULL |
| archive_day_heatingTemp | sum | double | YES
| NULL |
| archive_day_heatingTemp | count | int | YES
| NULL |
| archive_day_heatingTemp | wsum | double | YES
| NULL |
| archive_day_heatingTemp | sumtime | int | YES
| NULL |
| archive_day_heatingVoltage | dateTime | int | NO
| NULL |
| archive_day_heatingVoltage | min | double | YES
| NULL |
| archive_day_heatingVoltage | mintime | int | YES
| NULL |
| archive_day_heatingVoltage | max | double | YES
| NULL |
| archive_day_heatingVoltage | maxtime | int | YES
| NULL |
| archive_day_heatingVoltage | sum | double | YES
| NULL |
| archive_day_heatingVoltage | count | int | YES
| NULL |
| archive_day_heatingVoltage | wsum | double | YES
| NULL |
| archive_day_heatingVoltage | sumtime | int | YES
| NULL |
| archive_day_inHumidity | dateTime | int | NO
| NULL |
| archive_day_inHumidity | min | double | YES
| NULL |
| archive_day_inHumidity | mintime | int | YES
| NULL |
| archive_day_inHumidity | max | double | YES
| NULL |
| archive_day_inHumidity | maxtime | int | YES
| NULL |
| archive_day_inHumidity | sum | double | YES
| NULL |
| archive_day_inHumidity | count | int | YES
| NULL |
| archive_day_inHumidity | wsum | double | YES
| NULL |
| archive_day_inHumidity | sumtime | int | YES
| NULL |
| archive_day_inTemp | dateTime | int | NO
| NULL |
| archive_day_inTemp | min | double | YES
| NULL |
| archive_day_inTemp | mintime | int | YES
| NULL |
| archive_day_inTemp | max | double | YES
| NULL |
| archive_day_inTemp | maxtime | int | YES
| NULL |
| archive_day_inTemp | sum | double | YES
| NULL |
| archive_day_inTemp | count | int | YES
| NULL |
| archive_day_inTemp | wsum | double | YES
| NULL |
| archive_day_inTemp | sumtime | int | YES
| NULL |
| archive_day_inTempBatteryStatus | dateTime | int | NO
| NULL |
| archive_day_inTempBatteryStatus | min | double | YES
| NULL |
| archive_day_inTempBatteryStatus | mintime | int | YES
| NULL |
| archive_day_inTempBatteryStatus | max | double | YES
| NULL |
| archive_day_inTempBatteryStatus | maxtime | int | YES
| NULL |
| archive_day_inTempBatteryStatus | sum | double | YES
| NULL |
| archive_day_inTempBatteryStatus | count | int | YES
| NULL |
| archive_day_inTempBatteryStatus | wsum | double | YES
| NULL |
| archive_day_inTempBatteryStatus | sumtime | int | YES
| NULL |
| archive_day_leafTemp1 | dateTime | int | NO
| NULL |
| archive_day_leafTemp1 | min | double | YES
| NULL |
| archive_day_leafTemp1 | mintime | int | YES
| NULL |
| archive_day_leafTemp1 | max | double | YES
| NULL |
| archive_day_leafTemp1 | maxtime | int | YES
| NULL |
| archive_day_leafTemp1 | sum | double | YES
| NULL |
| archive_day_leafTemp1 | count | int | YES
| NULL |
| archive_day_leafTemp1 | wsum | double | YES
| NULL |
| archive_day_leafTemp1 | sumtime | int | YES
| NULL |
| archive_day_leafTemp2 | dateTime | int | NO
| NULL |
| archive_day_leafTemp2 | min | double | YES
| NULL |
| archive_day_leafTemp2 | mintime | int | YES
| NULL |
| archive_day_leafTemp2 | max | double | YES
| NULL |
| archive_day_leafTemp2 | maxtime | int | YES
| NULL |
| archive_day_leafTemp2 | sum | double | YES
| NULL |
| archive_day_leafTemp2 | count | int | YES
| NULL |
| archive_day_leafTemp2 | wsum | double | YES
| NULL |
| archive_day_leafTemp2 | sumtime | int | YES
| NULL |
| archive_day_leafWet1 | dateTime | int | NO
| NULL |
| archive_day_leafWet1 | min | double | YES
| NULL |
| archive_day_leafWet1 | mintime | int | YES
| NULL |
| archive_day_leafWet1 | max | double | YES
| NULL |
| archive_day_leafWet1 | maxtime | int | YES
| NULL |
| archive_day_leafWet1 | sum | double | YES
| NULL |
| archive_day_leafWet1 | count | int | YES
| NULL |
| archive_day_leafWet1 | wsum | double | YES
| NULL |
| archive_day_leafWet1 | sumtime | int | YES
| NULL |
| archive_day_leafWet2 | dateTime | int | NO
| NULL |
| archive_day_leafWet2 | min | double | YES
| NULL |
| archive_day_leafWet2 | mintime | int | YES
| NULL |
| archive_day_leafWet2 | max | double | YES
| NULL |
| archive_day_leafWet2 | maxtime | int | YES
| NULL |
| archive_day_leafWet2 | sum | double | YES
| NULL |
| archive_day_leafWet2 | count | int | YES
| NULL |
| archive_day_leafWet2 | wsum | double | YES
| NULL |
| archive_day_leafWet2 | sumtime | int | YES
| NULL |
| archive_day_outHumidity | dateTime | int | NO
| NULL |
| archive_day_outHumidity | min | double | YES
| NULL |
| archive_day_outHumidity | mintime | int | YES
| NULL |
| archive_day_outHumidity | max | double | YES
| NULL |
| archive_day_outHumidity | maxtime | int | YES
| NULL |
| archive_day_outHumidity | sum | double | YES
| NULL |
| archive_day_outHumidity | count | int | YES
| NULL |
| archive_day_outHumidity | wsum | double | YES
| NULL |
| archive_day_outHumidity | sumtime | int | YES
| NULL |
| archive_day_outTemp | dateTime | int | NO
| NULL |
| archive_day_outTemp | min | double | YES
| NULL |
| archive_day_outTemp | mintime | int | YES
| NULL |
| archive_day_outTemp | max | double | YES
| NULL |
| archive_day_outTemp | maxtime | int | YES
| NULL |
| archive_day_outTemp | sum | double | YES
| NULL |
| archive_day_outTemp | count | int | YES
| NULL |
| archive_day_outTemp | wsum | double | YES
| NULL |
| archive_day_outTemp | sumtime | int | YES
| NULL |
| archive_day_outTempBatteryStatus | dateTime | int | NO
| NULL |
| archive_day_outTempBatteryStatus | min | double | YES
| NULL |
| archive_day_outTempBatteryStatus | mintime | int | YES
| NULL |
| archive_day_outTempBatteryStatus | max | double | YES
| NULL |
| archive_day_outTempBatteryStatus | maxtime | int | YES
| NULL |
| archive_day_outTempBatteryStatus | sum | double | YES
| NULL |
| archive_day_outTempBatteryStatus | count | int | YES
| NULL |
| archive_day_outTempBatteryStatus | wsum | double | YES
| NULL |
| archive_day_outTempBatteryStatus | sumtime | int | YES
| NULL |
| archive_day_pressure | dateTime | int | NO
| NULL |
| archive_day_pressure | min | double | YES
| NULL |
| archive_day_pressure | mintime | int | YES
| NULL |
| archive_day_pressure | max | double | YES
| NULL |
| archive_day_pressure | maxtime | int | YES
| NULL |
| archive_day_pressure | sum | double | YES
| NULL |
| archive_day_pressure | count | int | YES
| NULL |
| archive_day_pressure | wsum | double | YES
| NULL |
| archive_day_pressure | sumtime | int | YES
| NULL |
| archive_day_radiation | dateTime | int | NO
| NULL |
| archive_day_radiation | min | double | YES
| NULL |
| archive_day_radiation | mintime | int | YES
| NULL |
| archive_day_radiation | max | double | YES
| NULL |
| archive_day_radiation | maxtime | int | YES
| NULL |
| archive_day_radiation | sum | double | YES
| NULL |
| archive_day_radiation | count | int | YES
| NULL |
| archive_day_radiation | wsum | double | YES
| NULL |
| archive_day_radiation | sumtime | int | YES
| NULL |
| archive_day_rain | dateTime | int | NO
| NULL |
| archive_day_rain | min | double | YES
| NULL |
| archive_day_rain | mintime | int | YES
| NULL |
| archive_day_rain | max | double | YES
| NULL |
| archive_day_rain | maxtime | int | YES
| NULL |
| archive_day_rain | sum | double | YES
| NULL |
| archive_day_rain | count | int | YES
| NULL |
| archive_day_rain | wsum | double | YES
| NULL |
| archive_day_rain | sumtime | int | YES
| NULL |
| archive_day_rainBatteryStatus | dateTime | int | NO
| NULL |
| archive_day_rainBatteryStatus | min | double | YES
| NULL |
| archive_day_rainBatteryStatus | mintime | int | YES
| NULL |
| archive_day_rainBatteryStatus | max | double | YES
| NULL |
| archive_day_rainBatteryStatus | maxtime | int | YES
| NULL |
| archive_day_rainBatteryStatus | sum | double | YES
| NULL |
| archive_day_rainBatteryStatus | count | int | YES
| NULL |
| archive_day_rainBatteryStatus | wsum | double | YES
| NULL |
| archive_day_rainBatteryStatus | sumtime | int | YES
| NULL |
| archive_day_rainRate | dateTime | int | NO
| NULL |
| archive_day_rainRate | min | double | YES
| NULL |
| archive_day_rainRate | mintime | int | YES
| NULL |
| archive_day_rainRate | max | double | YES
| NULL |
| archive_day_rainRate | maxtime | int | YES
| NULL |
| archive_day_rainRate | sum | double | YES
| NULL |
| archive_day_rainRate | count | int | YES
| NULL |
| archive_day_rainRate | wsum | double | YES
| NULL |
| archive_day_rainRate | sumtime | int | YES
| NULL |
| archive_day_referenceVoltage | dateTime | int | NO
| NULL |
| archive_day_referenceVoltage | min | double | YES
| NULL |
| archive_day_referenceVoltage | mintime | int | YES
| NULL |
| archive_day_referenceVoltage | max | double | YES
| NULL |
| archive_day_referenceVoltage | maxtime | int | YES
| NULL |
| archive_day_referenceVoltage | sum | double | YES
| NULL |
| archive_day_referenceVoltage | count | int | YES
| NULL |
| archive_day_referenceVoltage | wsum | double | YES
| NULL |
| archive_day_referenceVoltage | sumtime | int | YES
| NULL |
| archive_day_rxCheckPercent | dateTime | int | NO
| NULL |
| archive_day_rxCheckPercent | min | double | YES
| NULL |
| archive_day_rxCheckPercent | mintime | int | YES
| NULL |
| archive_day_rxCheckPercent | max | double | YES
| NULL |
| archive_day_rxCheckPercent | maxtime | int | YES
| NULL |
| archive_day_rxCheckPercent | sum | double | YES
| NULL |
| archive_day_rxCheckPercent | count | int | YES
| NULL |
| archive_day_rxCheckPercent | wsum | double | YES
| NULL |
| archive_day_rxCheckPercent | sumtime | int | YES
| NULL |
| archive_day_soilMoist1 | dateTime | int | NO
| NULL |
| archive_day_soilMoist1 | min | double | YES
| NULL |
| archive_day_soilMoist1 | mintime | int | YES
| NULL |
| archive_day_soilMoist1 | max | double | YES
| NULL |
| archive_day_soilMoist1 | maxtime | int | YES
| NULL |
| archive_day_soilMoist1 | sum | double | YES
| NULL |
| archive_day_soilMoist1 | count | int | YES
| NULL |
| archive_day_soilMoist1 | wsum | double | YES
| NULL |
| archive_day_soilMoist1 | sumtime | int | YES
| NULL |
| archive_day_soilMoist2 | dateTime | int | NO
| NULL |
| archive_day_soilMoist2 | min | double | YES
| NULL |
| archive_day_soilMoist2 | mintime | int | YES
| NULL |
| archive_day_soilMoist2 | max | double | YES
| NULL |
| archive_day_soilMoist2 | maxtime | int | YES
| NULL |
| archive_day_soilMoist2 | sum | double | YES
| NULL |
| archive_day_soilMoist2 | count | int | YES
| NULL |
| archive_day_soilMoist2 | wsum | double | YES
| NULL |
| archive_day_soilMoist2 | sumtime | int | YES
| NULL |
| archive_day_soilMoist3 | dateTime | int | NO
| NULL |
| archive_day_soilMoist3 | min | double | YES
| NULL |
| archive_day_soilMoist3 | mintime | int | YES
| NULL |
| archive_day_soilMoist3 | max | double | YES
| NULL |
| archive_day_soilMoist3 | maxtime | int | YES
| NULL |
| archive_day_soilMoist3 | sum | double | YES
| NULL |
| archive_day_soilMoist3 | count | int | YES
| NULL |
| archive_day_soilMoist3 | wsum | double | YES
| NULL |
| archive_day_soilMoist3 | sumtime | int | YES
| NULL |
| archive_day_soilMoist4 | dateTime | int | NO
| NULL |
| archive_day_soilMoist4 | min | double | YES
| NULL |
| archive_day_soilMoist4 | mintime | int | YES
| NULL |
| archive_day_soilMoist4 | max | double | YES
| NULL |
| archive_day_soilMoist4 | maxtime | int | YES
| NULL |
| archive_day_soilMoist4 | sum | double | YES
| NULL |
| archive_day_soilMoist4 | count | int | YES
| NULL |
| archive_day_soilMoist4 | wsum | double | YES
| NULL |
| archive_day_soilMoist4 | sumtime | int | YES
| NULL |
| archive_day_soilTemp1 | dateTime | int | NO
| NULL |
| archive_day_soilTemp1 | min | double | YES
| NULL |
| archive_day_soilTemp1 | mintime | int | YES
| NULL |
| archive_day_soilTemp1 | max | double | YES
| NULL |
| archive_day_soilTemp1 | maxtime | int | YES
| NULL |
| archive_day_soilTemp1 | sum | double | YES
| NULL |
| archive_day_soilTemp1 | count | int | YES
| NULL |
| archive_day_soilTemp1 | wsum | double | YES
| NULL |
| archive_day_soilTemp1 | sumtime | int | YES
| NULL |
| archive_day_soilTemp2 | dateTime | int | NO
| NULL |
| archive_day_soilTemp2 | min | double | YES
| NULL |
| archive_day_soilTemp2 | mintime | int | YES
| NULL |
| archive_day_soilTemp2 | max | double | YES
| NULL |
| archive_day_soilTemp2 | maxtime | int | YES
| NULL |
| archive_day_soilTemp2 | sum | double | YES
| NULL |
| archive_day_soilTemp2 | count | int | YES
| NULL |
| archive_day_soilTemp2 | wsum | double | YES
| NULL |
| archive_day_soilTemp2 | sumtime | int | YES
| NULL |
| archive_day_soilTemp3 | dateTime | int | NO
| NULL |
| archive_day_soilTemp3 | min | double | YES
| NULL |
| archive_day_soilTemp3 | mintime | int | YES
| NULL |
| archive_day_soilTemp3 | max | double | YES
| NULL |
| archive_day_soilTemp3 | maxtime | int | YES
| NULL |
| archive_day_soilTemp3 | sum | double | YES
| NULL |
| archive_day_soilTemp3 | count | int | YES
| NULL |
| archive_day_soilTemp3 | wsum | double | YES
| NULL |
| archive_day_soilTemp3 | sumtime | int | YES
| NULL |
| archive_day_soilTemp4 | dateTime | int | NO
| NULL |
| archive_day_soilTemp4 | min | double | YES
| NULL |
| archive_day_soilTemp4 | mintime | int | YES
| NULL |
| archive_day_soilTemp4 | max | double | YES
| NULL |
| archive_day_soilTemp4 | maxtime | int | YES
| NULL |
| archive_day_soilTemp4 | sum | double | YES
| NULL |
| archive_day_soilTemp4 | count | int | YES
| NULL |
| archive_day_soilTemp4 | wsum | double | YES
| NULL |
| archive_day_soilTemp4 | sumtime | int | YES
| NULL |
| archive_day_supplyVoltage | dateTime | int | NO
| NULL |
| archive_day_supplyVoltage | min | double | YES
| NULL |
| archive_day_supplyVoltage | mintime | int | YES
| NULL |
| archive_day_supplyVoltage | max | double | YES
| NULL |
| archive_day_supplyVoltage | maxtime | int | YES
| NULL |
| archive_day_supplyVoltage | sum | double | YES
| NULL |
| archive_day_supplyVoltage | count | int | YES
| NULL |
| archive_day_supplyVoltage | wsum | double | YES
| NULL |
| archive_day_supplyVoltage | sumtime | int | YES
| NULL |
| archive_day_txBatteryStatus | dateTime | int | NO
| NULL |
| archive_day_txBatteryStatus | min | double | YES
| NULL |
| archive_day_txBatteryStatus | mintime | int | YES
| NULL |
| archive_day_txBatteryStatus | max | double | YES
| NULL |
| archive_day_txBatteryStatus | maxtime | int | YES
| NULL |
| archive_day_txBatteryStatus | sum | double | YES
| NULL |
| archive_day_txBatteryStatus | count | int | YES
| NULL |
| archive_day_txBatteryStatus | wsum | double | YES
| NULL |
| archive_day_txBatteryStatus | sumtime | int | YES
| NULL |
| archive_day_UV | dateTime | int | NO
| NULL |
| archive_day_UV | min | double | YES
| NULL |
| archive_day_UV | mintime | int | YES
| NULL |
| archive_day_UV | max | double | YES
| NULL |
| archive_day_UV | maxtime | int | YES
| NULL |
| archive_day_UV | sum | double | YES
| NULL |
| archive_day_UV | count | int | YES
| NULL |
| archive_day_UV | wsum | double | YES
| NULL |
| archive_day_UV | sumtime | int | YES
| NULL |
| archive_day_wind | dateTime | int | NO
| NULL |
| archive_day_wind | min | double | YES
| NULL |
| archive_day_wind | mintime | int | YES
| NULL |
| archive_day_wind | max | double | YES
| NULL |
| archive_day_wind | maxtime | int | YES
| NULL |
| archive_day_wind | sum | double | YES
| NULL |
| archive_day_wind | count | int | YES
| NULL |
| archive_day_wind | wsum | double | YES
| NULL |
| archive_day_wind | sumtime | int | YES
| NULL |
| archive_day_wind | max_dir | double | YES
| NULL |
| archive_day_wind | xsum | double | YES
| NULL |
| archive_day_wind | ysum | double | YES
| NULL |
| archive_day_wind | dirsumtime | int | YES
| NULL |
| archive_day_wind | squaresum | double | YES
| NULL |
| archive_day_wind | wsquaresum | double | YES
| NULL |
| archive_day_windBatteryStatus | dateTime | int | NO
| NULL |
| archive_day_windBatteryStatus | min | double | YES
| NULL |
| archive_day_windBatteryStatus | mintime | int | YES
| NULL |
| archive_day_windBatteryStatus | max | double | YES
| NULL |
| archive_day_windBatteryStatus | maxtime | int | YES
| NULL |
| archive_day_windBatteryStatus | sum | double | YES
| NULL |
| archive_day_windBatteryStatus | count | int | YES
| NULL |
| archive_day_windBatteryStatus | wsum | double | YES
| NULL |
| archive_day_windBatteryStatus | sumtime | int | YES
| NULL |
| archive_day_windchill | dateTime | int | NO
| NULL |
| archive_day_windchill | min | double | YES
| NULL |
| archive_day_windchill | mintime | int | YES
| NULL |
| archive_day_windchill | max | double | YES
| NULL |
| archive_day_windchill | maxtime | int | YES
| NULL |
| archive_day_windchill | sum | double | YES
| NULL |
| archive_day_windchill | count | int | YES
| NULL |
| archive_day_windchill | wsum | double | YES
| NULL |
| archive_day_windchill | sumtime | int | YES
| NULL |
| archive_day_windDir | dateTime | int | NO
| NULL |
| archive_day_windDir | min | double | YES
| NULL |
| archive_day_windDir | mintime | int | YES
| NULL |
| archive_day_windDir | max | double | YES
| NULL |
| archive_day_windDir | maxtime | int | YES
| NULL |
| archive_day_windDir | sum | double | YES
| NULL |
| archive_day_windDir | count | int | YES
| NULL |
| archive_day_windDir | wsum | double | YES
| NULL |
| archive_day_windDir | sumtime | int | YES
| NULL |
| archive_day_windGust | dateTime | int | NO
| NULL |
| archive_day_windGust | min | double | YES
| NULL |
| archive_day_windGust | mintime | int | YES
| NULL |
| archive_day_windGust | max | double | YES
| NULL |
| archive_day_windGust | maxtime | int | YES
| NULL |
| archive_day_windGust | sum | double | YES
| NULL |
| archive_day_windGust | count | int | YES
| NULL |
| archive_day_windGust | wsum | double | YES
| NULL |
| archive_day_windGust | sumtime | int | YES
| NULL |
| archive_day_windGustDir | dateTime | int | NO
| NULL |
| archive_day_windGustDir | min | double | YES
| NULL |
| archive_day_windGustDir | mintime | int | YES
| NULL |
| archive_day_windGustDir | max | double | YES
| NULL |
| archive_day_windGustDir | maxtime | int | YES
| NULL |
| archive_day_windGustDir | sum | double | YES
| NULL |
| archive_day_windGustDir | count | int | YES
| NULL |
| archive_day_windGustDir | wsum | double | YES
| NULL |
| archive_day_windGustDir | sumtime | int | YES
| NULL |
| archive_day_windSpeed | dateTime | int | NO
| NULL |
| archive_day_windSpeed | min | double | YES
| NULL |
| archive_day_windSpeed | mintime | int | YES
| NULL |
| archive_day_windSpeed | max | double | YES
| NULL |
| archive_day_windSpeed | maxtime | int | YES
| NULL |
| archive_day_windSpeed | sum | double | YES
| NULL |
| archive_day_windSpeed | count | int | YES
| NULL |
| archive_day_windSpeed | wsum | double | YES
| NULL |
| archive_day_windSpeed | sumtime | int | YES
| NULL |
| archive_day__metadata | name | char | NO
| NULL |
| archive_day__metadata | value | text | YES
| NULL |
+----------------------------------+----------------------+-----------+-------------+----------------+
RC=0
