changing the database: what's wrong?

[Paolo Benvenuto]

I moved the weather station to another location, so I thought it was right to move to another database for the new location.

In weewx.conf, in the [[archive_sqlite]] section, I changed the database_name value and restarted the weewx service.

I'm seeing that the new db file is used, and it's much smaller than the previous one.

However, the graphs generated by weewx still show all the old data, i.e. the data corresponding to date/times which should have no data in the new database.

I dropped and rebuilt the daily archives, but nothing changed.

What's wrong or missing?

[Thomas Keffer]

I just tried this and it worked for me.

Perhaps you are looking at old plots, from the old database? They will not be regenerated until at least an aggregation interval has passed. 

Remove all the files in your HTML directory and WeeWX will regenerate them all. This will guarantee that they are all fresh.

-tk

--
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.
For more options, visit https://groups.google.com/d/optout.

[Paolo Benvenuto]

Il giorno gio 27 set 2018 alle ore 20:37 Thomas Keffer <tke...@gmail.com> ha scritto:

I just tried this and it worked for me.

Perhaps you are looking at old plots, from the old database? They will not be regenerated until at least an aggregation interval has passed. 

Remove all the files in your HTML directory and WeeWX will regenerate them all. This will guarantee that they are all fresh.

I removed the old plots, but everything is like before: https://weewx.qumran2.net/

The database was changed this afternoon at about 3pm

 

-tk

On Thu, Sep 27, 2018 at 10:51 AM Paolo Benvenuto <paolo...@gmail.com> wrote:

I moved the weather station to another location, so I thought it was right to move to another database for the new location.

In weewx.conf, in the [[archive_sqlite]] section, I changed the database_name value and restarted the weewx service.

I'm seeing that the new db file is used, and it's much smaller than the previous one.

However, the graphs generated by weewx still show all the old data, i.e. the data corresponding to date/times which should have no data in the new database.

I dropped and rebuilt the daily archives, but nothing changed.

What's wrong or missing?

--
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.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to a topic in the Google Groups "weewx-user" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/weewx-user/vRn-sS51DD8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to weewx-user+...@googlegroups.com.

[Paolo Benvenuto]

this is all the stuff I get in syslog in one turn with debug=1:

Sep 27 21:02:16 raspberrypi weewx[10017]: manager: Added record 2018-09-27 21:02:00 CEST (1538074920) to database 'weewx.cornigliano.sdb'

Sep 27 21:02:16 raspberrypi weewx[10017]: manager: Added record 2018-09-27 21:02:00 CEST (1538074920) to daily summary in 'weewx.cornigliano.sdb'

Sep 27 21:02:16 raspberrypi weewx[10017]: restx: StationRegistry: wait interval (420 < 604800) has not passed for record 2018-09-27 21:02:00 CEST (1538074920)

Sep 27 21:02:16 raspberrypi weewx[10017]: restx: CWOP: wait interval (420 < 600) has not passed for record 2018-09-27 21:02:00 CEST (1538074920)

Sep 27 21:02:16 raspberrypi weewx[10017]: reportengine: Running reports for latest time in the database.

Sep 27 21:02:16 raspberrypi weewx[10017]: vantage: Requesting 200 LOOP packets.

Sep 27 21:02:16 raspberrypi weewx[10017]: restx: AWEKAS: wait interval (120 < 300) has not passed for record 2018-09-27 21:02:00 CEST (1538074920)

Sep 27 21:02:16 raspberrypi weewx[10017]: reportengine: Running report StandardReport

Sep 27 21:02:16 raspberrypi weewx[10017]: vantage: Gentle wake up of console successful

Sep 27 21:02:16 raspberrypi weewx[10017]: reportengine: Found configuration file /etc/weewx/skins/Standard/skin.conf for report StandardReport

Sep 27 21:02:16 raspberrypi weewx[10017]: cheetahgenerator: using search list ['weewx.cheetahgenerator.Almanac', 'weewx.cheetahgenerator.Station', 'weewx.cheetahgenerator.Current', 'weewx.cheetahgenerator.Stats', 'weewx.cheetahgenerator.UnitInfo', 'weewx.cheetahgenerator.Extras']

Sep 27 21:02:16 raspberrypi weewx[10017]: manager: Daily summary version is 2.0

Sep 27 21:02:16 raspberrypi weewx[10017]: restx: OWM: Failed upload attempt 1: HTTP Error 401: Unauthorized

Sep 27 21:02:17 raspberrypi weewx[10017]: restx: PWSWeather: Published record 2018-09-27 21:02:00 CEST (1538074920)

Sep 27 21:02:17 raspberrypi weewx[10017]: restx: Wunderground-PWS: Published record 2018-09-27 21:02:00 CEST (1538074920)

Sep 27 21:02:22 raspberrypi weewx[10017]: restx: OWM: Failed upload attempt 2: HTTP Error 401: Unauthorized

Sep 27 21:02:27 raspberrypi weewx[10017]: restx: OWM: Failed upload attempt 3: HTTP Error 401: Unauthorized

Sep 27 21:02:28 raspberrypi weewx[10017]: cheetahgenerator: Generated 17 files for report StandardReport in 11.94 seconds

Sep 27 21:02:28 raspberrypi weewx[10017]: manager: Daily summary version is 2.0

Sep 27 21:02:32 raspberrypi weewx[10017]: restx: OWM: Failed to publish record 2018-09-27 21:02:00 CEST (1538074920): Failed upload after 3 tries

Sep 27 21:02:35 raspberrypi weewx[10017]: imagegenerator: Generated 9 images for StandardReport in 6.31 seconds

Sep 27 21:02:35 raspberrypi weewx[10017]: copygenerator: copied 0 files to /var/www/html/weewx

Sep 27 21:02:35 raspberrypi weewx[10017]: reportengine: Running report FTP

Sep 27 21:02:35 raspberrypi weewx[10017]: reportengine: Found configuration file /etc/weewx/skins/Ftp/skin.conf for report FTP

Sep 27 21:02:35 raspberrypi weewx[10017]: ftpgenerator: FTP upload not requested. Skipped.

Sep 27 21:02:35 raspberrypi weewx[10017]: reportengine: Running report RSYNC

Sep 27 21:02:35 raspberrypi weewx[10017]: reportengine: Found configuration file /etc/weewx/skins/Rsync/skin.conf for report RSYNC

Sep 27 21:02:37 raspberrypi weewx[10017]: rsyncupload: rsync'd 26 files (134,460 bytes) in 2.08 seconds

weewx.cornigliano.sdb is the new db

Is there a way to get more info?

don Paolo Benvenuto

[Thomas Keffer]

The plots are as they should be. What you are seeing is the data downloaded from the logger in the Vantage Vue. For example, take the month plot of barometer:

You are seeing data from a few days ago, which were stored in the logger. If you want to remove that as well, you will have to clear the logger memory. Use the wee_device utility with the --clear-memory option.

-tk