errors from power outage

82 views
Skip to first unread message

GCC Observatory

unread,
Nov 18, 2020, 3:58:44 PM11/18/20
to weewx-user
Had a power outage the other night and did some weird things to my Davis station once power was restored... 

did a "wee_device --dump" and "wee_device --clear-memory" and removed a couple of odd entries in the database by hand.  Things look back to mostly normal, except for below.  

I did "wee_database --drop-daily/--rebuild-daily" but still having the problem.  

Also upgraded from 4.1 to 4.2 after the power outage, and don't know if the upgrade is the cause of the problem below or not...

Thanks in advance...

------------------------------------




Nov 18 15:45:24 localhost weewx[16767] ERROR weewx.reportengine:         ****  NoTableError: no such table: archive_day_wind
Nov 18 15:45:24 localhost weewx[16767] ERROR weewx.reportengine:         ****  Generator terminated
Nov 18 15:45:24 localhost weewx[16767] INFO weewx.reportengine: Copied 0 files to /var/www/weewx/skins/standard
Nov 18 15:45:25 localhost weewx[16767] INFO weewx.cheetahgenerator: Generated 17 files for report Belchertown in 1.08 seconds
Nov 18 15:45:25 localhost weewx[16767] INFO weewx.reportengine: Copied 2 files to /var/www/weewx
Nov 18 15:45:28 localhost weewx[16767] ERROR weewx.restx: AWEKAS: Failed to publish record 2020-11-18 15:45:00 EST (1605732300): Server returned 'Luftfeuchte administrativ gesperrt - Transfer OK'
Nov 18 15:45:30 localhost weewx[16767] INFO weewx.restx: WeatherCloud: Published record 2020-11-18 15:45:00 EST (1605732300)
Nov 18 15:48:51 localhost vncserver-x11[992]: Connections: connected: 10.16.106.76::57086
Nov 18 15:48:51 localhost vncserver-x11[992]: Connections: authenticated: 10.16.106.76::57086, as (anonymous) (d permissions)
Nov 18 15:50:01 localhost CRON[11511]: (root) CMD (nice -2 /home/talon/bwcs2/bin/bwcs2_cron_5min.csh >> /home/talon/bwcs2/bin/bwcs2_cron_5min.log 2>&1)
Nov 18 15:50:01 localhost CRON[11513]: (root) CMD (nice -2 /home/talon/local/bin/domyallsky.sh >> /home/talon/allsky/domyallsky.log 2>&1)
Nov 18 15:50:21 localhost weewxd: onewire: sensor0 found value of 44.6
Nov 18 15:50:21 localhost weewxd: onewire: /var/www/weewx/onewire.txt removed
Nov 18 15:50:22 localhost weewxd: onewire: sensor1 found value of 45.1625
Nov 18 15:50:23 localhost weewxd: onewire: sensor2 found value of 45.8375
Nov 18 15:50:23 localhost weewx[16767] INFO weewx.manager: Added record 2020-11-18 15:50:00 EST (1605732600) to database 'weewx.sdb'
Nov 18 15:50:23 localhost weewx[16767] INFO weewx.manager: Added record 2020-11-18 15:50:00 EST (1605732600) to daily summary in 'weewx.sdb'
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: Generate failed with exception '<class 'NameMapper.NotFound'>'
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: **** Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: **** Reason: cannot find 'raw' while searching for 'day.wind.count.raw'
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****  Traceback (most recent call last):
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/cheetahgenerator.py", line 323, in generate
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****      unicode_string = compiled_template.respond()
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py", line 430, in respond
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****  NotFound: cannot find 'raw' while searching for 'day.wind.count.raw'
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.restx: AWEKAS: Failed to publish record 2020-11-18 15:50:00 EST (1605732600): Server returned 'Luftfeuchte administrativ gesperrt - Transfer OK'
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: Generate failed with exception '<class 'NameMapper.NotFound'>'
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: **** Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y.txt.tmpl
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: **** Reason: cannot find 'raw' while searching for 'month.wind.count.raw'
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****  Traceback (most recent call last):
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/cheetahgenerator.py", line 323, in generate
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****      unicode_string = compiled_template.respond()
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y_txt_tmpl.py", line 861, in respond
Nov 18 15:50:23 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****  NotFound: cannot find 'raw' while searching for 'month.wind.count.raw'
Nov 18 15:50:23 localhost weewx[16767] INFO weewx.cheetahgenerator: Generated 6 files for report SeasonsReport in 0.46 seconds
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine: Caught unrecoverable exception in generator 'weewx.imagegenerator.ImageGenerator'
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****  no such table: archive_day_wind
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****  Traceback (most recent call last):
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/reportengine.py", line 196, in run
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      obj.start()
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/reportengine.py", line 281, in start
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      self.run()
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/imagegenerator.py", line 41, in run
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      self.genImages(self.gen_ts)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/imagegenerator.py", line 180, in genImages
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      aggregate_interval=aggregate_interval)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/xtypes.py", line 86, in get_series
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      aggregate_interval)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/xtypes.py", line 628, in get_series
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      aggregate_interval)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/xtypes.py", line 140, in get_series
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      agg_vt = get_aggregate(obs_type, stamp, do_aggregate, db_manager)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/xtypes.py", line 102, in get_aggregate
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      **option_dict)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/xtypes.py", line 796, in get_aggregate
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      row = db_manager.getSql(sql, timespan)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/manager.py", line 426, in getSql
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      _cursor.execute(sql, sqlargs)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weedb/sqlite.py", line 37, in guarded_fn
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      raise weedb.NoTableError(e)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****  NoTableError: no such table: archive_day_wind
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****  Generator terminated
Nov 18 15:50:24 localhost weewx[16767] INFO weewx.reportengine: Copied 0 files to /var/www/weewx/skins/seasons
Nov 18 15:50:24 localhost weewx[16767] INFO weewx.cheetahgenerator: Generated 6 files for report SmartphoneReport in 0.02 seconds
Nov 18 15:50:24 localhost weewx[16767] INFO weewx.imagegenerator: Generated 6 images for report SmartphoneReport in 0.08 seconds
Nov 18 15:50:24 localhost weewx[16767] INFO weewx.reportengine: Copied 0 files to /var/www/weewx/skins/smartphone
Nov 18 15:50:24 localhost weewx[16767] INFO weewx.cheetahgenerator: Generated 1 files for report MobileReport in 0.01 seconds
Nov 18 15:50:24 localhost weewx[16767] INFO weewx.imagegenerator: Generated 4 images for report MobileReport in 0.05 seconds
Nov 18 15:50:24 localhost weewx[16767] INFO weewx.reportengine: Copied 0 files to /var/www/weewx/skins/mobile
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: Generate failed with exception '<class 'NameMapper.NotFound'>'
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: **** Ignoring template /etc/weewx/skins/Standard/NOAA/NOAA-%Y-%m.txt.tmpl
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: **** Reason: cannot find 'raw' while searching for 'day.wind.count.raw'
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****  Traceback (most recent call last):
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/cheetahgenerator.py", line 323, in generate
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****      unicode_string = compiled_template.respond()
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_Standard_NOAA_NOAA__Y__m_txt_tmpl.py", line 430, in respond
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****  NotFound: cannot find 'raw' while searching for 'day.wind.count.raw'
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: Generate failed with exception '<class 'NameMapper.NotFound'>'
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: **** Ignoring template /etc/weewx/skins/Standard/NOAA/NOAA-%Y.txt.tmpl
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: **** Reason: cannot find 'raw' while searching for 'month.wind.count.raw'
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****  Traceback (most recent call last):
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/cheetahgenerator.py", line 323, in generate
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****      unicode_string = compiled_template.respond()
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_Standard_NOAA_NOAA__Y_txt_tmpl.py", line 861, in respond
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.cheetahgenerator: ****  NotFound: cannot find 'raw' while searching for 'month.wind.count.raw'
Nov 18 15:50:24 localhost weewx[16767] INFO weewx.cheetahgenerator: Generated 12 files for report StandardReport in 0.38 seconds
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine: Caught unrecoverable exception in generator 'weewx.imagegenerator.ImageGenerator'
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****  no such table: archive_day_wind
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****  Traceback (most recent call last):
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/reportengine.py", line 196, in run
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      obj.start()
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/reportengine.py", line 281, in start
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      self.run()
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/imagegenerator.py", line 41, in run
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      self.genImages(self.gen_ts)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/imagegenerator.py", line 180, in genImages
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      aggregate_interval=aggregate_interval)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/xtypes.py", line 86, in get_series
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      aggregate_interval)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/xtypes.py", line 628, in get_series
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      aggregate_interval)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/xtypes.py", line 140, in get_series
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      agg_vt = get_aggregate(obs_type, stamp, do_aggregate, db_manager)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/xtypes.py", line 102, in get_aggregate
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      **option_dict)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/xtypes.py", line 796, in get_aggregate
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      row = db_manager.getSql(sql, timespan)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weewx/manager.py", line 426, in getSql
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      _cursor.execute(sql, sqlargs)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****    File "/usr/share/weewx/weedb/sqlite.py", line 37, in guarded_fn
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****      raise weedb.NoTableError(e)
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****  NoTableError: no such table: archive_day_wind
Nov 18 15:50:24 localhost weewx[16767] ERROR weewx.reportengine:         ****  Generator terminated
Nov 18 15:50:24 localhost weewx[16767] INFO weewx.reportengine: Copied 0 files to /var/www/weewx/skins/standard
Nov 18 15:50:25 localhost weewx[16767] INFO weewx.cheetahgenerator: Generated 17 files for report Belchertown in 1.05 seconds
Nov 18 15:50:25 localhost weewx[16767] INFO weewx.reportengine: Copied 2 files to /var/www/weewx

vince

unread,
Nov 18, 2020, 4:01:13 PM11/18/20
to weewx-user
The lack of the archive_day_wind table tells me perhaps your --rebuild-daily didn't complete

GCC Observatory

unread,
Nov 18, 2020, 4:09:50 PM11/18/20
to weewx-user
I thought so too, but I redropped and rebuilt the dailies and still the same...

vince

unread,
Nov 18, 2020, 5:19:31 PM11/18/20
to weewx-user
Try ".schema | sudo sqlite3 /var/lib/weewx/weewx.sdb" and see if you get all the various tables that are expected there, if I recall the path to the database correctly there....

GCC Observatory

unread,
Nov 18, 2020, 5:44:09 PM11/18/20
to weewx-user
I'm not aware of the ".schema" command you mention...

John Kline

unread,
Nov 18, 2020, 5:48:17 PM11/18/20
to weewx...@googlegroups.com
There should be an echo in front of that .schema.
Also, you don’t need the sudo.

echo .schema | sqlite3 /var/lib/weewx/weewx.sdb

On Nov 18, 2020, at 2:44 PM, GCC Observatory <gccobse...@gmail.com> wrote:

I'm not aware of the ".schema" command you mention...
--
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+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/55fd7f56-4db8-4934-af38-3767382f8c66n%40googlegroups.com.

GCC Observatory

unread,
Nov 18, 2020, 5:52:48 PM11/18/20
to weewx-user
ah... that makes more sense...

here's the output - I don't notice anything out of the norm:


CREATE TABLE archive (`dateTime` INTEGER NOT NULL UNIQUE PRIMARY KEY, `usUnits` INTEGER NOT NULL, `interval` INTEGER NOT NULL, `barometer` REAL, `pressure` REAL, `altimeter` REAL, `inTemp` REAL, `outTemp` REAL, `inHumidity` REAL, `outHumidity` REAL, `windSpeed` REAL, `windDir` REAL, `windGust` REAL, `windGustDir` REAL, `rainRate` REAL, `rain` REAL, `dewpoint` REAL, `windchill` REAL, `heatindex` REAL, `ET` REAL, `radiation` REAL, `UV` REAL, `extraTemp1` REAL, `extraTemp2` REAL, `extraTemp3` REAL, `soilTemp1` REAL, `soilTemp2` REAL, `soilTemp3` REAL, `soilTemp4` REAL, `leafTemp1` REAL, `leafTemp2` REAL, `extraHumid1` REAL, `extraHumid2` REAL, `soilMoist1` REAL, `soilMoist2` REAL, `soilMoist3` REAL, `soilMoist4` REAL, `leafWet1` REAL, `leafWet2` REAL, `rxCheckPercent` REAL, `txBatteryStatus` REAL, `consBatteryVoltage` REAL, `hail` REAL, `hailRate` REAL, `heatingTemp` REAL, `heatingVoltage` REAL, `supplyVoltage` REAL, `referenceVoltage` REAL, `windBatteryStatus` REAL, `rainBatteryStatus` REAL, `outTempBatteryStatus` REAL, `inTempBatteryStatus` REAL, `appTemp` REAL, `windrun` REAL, `cloudbase` REAL, `owTemp0` REAL, `owTemp1` REAL, `owTemp2` REAL);
CREATE TABLE archive_day_barometer (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_pressure (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_altimeter (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_inTemp (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_outTemp (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_inHumidity (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_outHumidity (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_windSpeed (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_windDir (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_windGust (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_windGustDir (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_rainRate (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_rain (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_dewpoint (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_windchill (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_heatindex (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_ET (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_radiation (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_UV (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_extraTemp1 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_extraTemp2 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_extraTemp3 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_soilTemp1 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_soilTemp2 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_soilTemp3 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_soilTemp4 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_leafTemp1 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_leafTemp2 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_extraHumid1 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_extraHumid2 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_soilMoist1 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_soilMoist2 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_soilMoist3 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_soilMoist4 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_leafWet1 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_leafWet2 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_rxCheckPercent (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_txBatteryStatus (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_consBatteryVoltage (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_hail (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_hailRate (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_heatingTemp (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_heatingVoltage (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_supplyVoltage (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_referenceVoltage (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_windBatteryStatus (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_rainBatteryStatus (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_outTempBatteryStatus (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_inTempBatteryStatus (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_appTemp (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_windrun (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_cloudbase (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_owTemp0 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_owTemp1 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day_owTemp2 (dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY, min REAL, mintime INTEGER, max REAL, maxtime INTEGER, sum REAL, count INTEGER, wsum REAL, sumtime INTEGER);
CREATE TABLE archive_day__metadata (name CHAR(20) NOT NULL UNIQUE PRIMARY KEY, value TEXT);


Tom Keffer

unread,
Nov 18, 2020, 5:59:07 PM11/18/20
to weewx-user
See if this thread helps.

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/6c33df06-3a11-4373-a37d-cee76f572e89n%40googlegroups.com.

GCC Observatory

unread,
Nov 18, 2020, 6:23:01 PM11/18/20
to weewx-user
The fix mentioned in that thread fixed the problem... thanks!
Reply all
Reply to author
Forward
0 new messages