Try stopping weewxd before using wee_database. On Wed, Sep 9, 2020 at 12:48 PM [email protected] <[email protected]> wrote:
> I recently manually upgraded weewx from 3.8 to 4.1 on a debian system > using the .deb package. Since the upgrade I receive an error regarding the > main archive table (see log below). I know v4 began using an extended > database, and the extended schema is installed on the system. How do I fix > this issue? I am using the default weewx.archive in weewx.conf (MySQL) > > Thanks, > Jonathan > > > Sep 9 14:28:53 derby weewx[19034] INFO __main__: Starting up weewx > version 4.1.1 > Sep 9 14:28:53 derby weewx[19034] DEBUG weewx.engine: Station does not > support reading the time > Sep 9 14:28:53 derby weewx[19034] INFO weewx.engine: Using binding > 'wx_binding' to database 'weewx' > Sep 9 14:28:53 derby weewx[19034] INFO weewx.manager: Starting backfill > of daily summaries > Sep 9 14:28:53 derby weewx[19034] INFO weewx.engine: Starting main packet > loop. > Sep 9 14:28:53 derby weewx[19034] DEBUG weewx.manager: Daily summary > version is 2.0 > Sep 9 14:28:53 derby weewx[19034] DEBUG weewx.manager: Daily summary > version is 2.0 > Sep 9 14:28:54 derby weewxd: observerip: packet interval 1599679734 > Sep 9 14:29:10 derby weewxd: observerip: packet interval 17 > Sep 9 14:29:27 derby weewxd: observerip: packet interval 16 > Sep 9 14:29:43 derby weewxd: observerip: packet interval 17 > Sep 9 14:30:00 derby weewxd: observerip: packet interval 16 > Sep 9 14:30:03 derby wee_database[19076] ERROR weewx.manager: Cannot get > columns of table archive, and no schema specified > Sep 9 14:30:16 derby weewxd: observerip: packet interval 17 > Sep 9 14:30:17 derby weewx[19034] INFO weewx.manager: Added record > 2020-09-09 14:30:00 CDT (1599679800) to database 'weewx' > Sep 9 14:30:17 derby weewx[19034] INFO weewx.manager: Added record > 2020-09-09 14:30:00 CDT (1599679800) to daily summary in 'weewx' > Sep 9 14:30:17 derby weewx[19034] DEBUG weewx.reportengine: Running > reports for latest time in the database. > Sep 9 14:30:17 derby weewx[19034] DEBUG weewx.reportengine: Report > 'SeasonsReport' not enabled. Skipping. > Sep 9 14:30:17 derby weewx[19034] DEBUG weewx.reportengine: Report > 'SmartphoneReport' not enabled. Skipping. > Sep 9 14:30:17 derby weewx[19034] DEBUG weewx.reportengine: Report > 'MobileReport' not enabled. Skipping. > Sep 9 14:30:17 derby weewx[19034] DEBUG weewx.reportengine: Running > report 'StandardReport' > Sep 9 14:30:17 derby weewx[19034] DEBUG weewx.reportengine: Found > configuration file /etc/weewx/skins/Standard/skin.conf for report > 'StandardReport' > Sep 9 14:30:17 derby weewx[19034] INFO weewx.restx: Wunderground-PWS: > Published record 2020-09-09 14:30:00 CDT (1599679800) > Sep 9 14:30:18 derby weewx[19034] INFO weewx.restx: StationRegistry: > Published record 2020-09-09 14:30:00 CDT (1599679800) > Sep 9 14:30:18 derby weewxd: observerip: packet interval 1 > Sep 9 14:30:18 derby weewx[19034] DEBUG weewx.cheetahgenerator: Using > search list ['weewx.cheetahgenerator.Almanac', > 'weewx.cheetahgenerator.Station', 'weewx.cheetahgenerator.Current', > 'weewx.cheetahgenerator.Stats', 'weewx.cheetahgenerator.UnitInfo', > 'weewx.cheetahgenerator.Extras'] > Sep 9 14:30:18 derby weewx[19034] DEBUG weewx.manager: Daily summary > version is 2.0 > Sep 9 14:30:18 derby weewx[19034] INFO weewx.restx: PWSWeather: Published > record 2020-09-09 14:30:00 CDT (1599679800) > Sep 9 14:30:25 derby weewx[19034] DEBUG weewx.manager: Daily summary > version is 1.0 > Sep 9 14:30:27 derby weewx[19034] DEBUG weewx.manager: Daily summary > version is 2.0 > Sep 9 14:30:32 derby weewx[19034] INFO weewx.cheetahgenerator: Generated > 14 files for report StandardReport in 14.55 seconds > > -- > 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 on the web visit > https://groups.google.com/d/msgid/weewx-user/270aca04-8b8e-4ba1-93ac-59380b394dfen%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/270aca04-8b8e-4ba1-93ac-59380b394dfen%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 on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEB2%2Batszok1UUfBfD0fy6xm0eE%3Ds1r8qDqLR1fPybAgGQ%40mail.gmail.com.
