I am using mysql, not sqlite. But I retried and now, I can see the
records in the archive table...
I don't know what changed but I probably missed something, sorry.
Thank you for your help
Le 26. 09. 17 à 14:57, Thomas Keffer a écrit :
If you do not have it already, install the utility sqlite3
sudo apt-get install sqlite3
Then check the database
sqlite3 /var/lib/weewx/weewx.sdb
sqlite> select dateTime,
datetime(dateTime,'unixepoch','localtime') from archive;
This will show you what records are in the database.
-tk
On Tue, Sep 26, 2017 at 5:27 AM, Lilian ROBERT
<[email protected] <mailto:[email protected]>> wrote:
Le 26. 09. 17 à 13:02, mwall a écrit :
i'm not sure what question you are asking.
are you saying that weewx has completed its read of historical
records, but none (some?) of those records were added?
or are you saying that weewx has started its read of historical
records, but you do not see any records?
for the latter, just be patient.
for the former, (and perhaps the latter), you might have to
remove the latest n records from the database. when it does
'catchup' during startup, weewx will only add historical records
that are newer than the latest record in the database.
m
I will try to be clear. It is a fresh install with an "old"
station. One hour ago, the archive table was empty. First, I get
an error (see my first message). After an updade of the wmr200
driver, I restarted weewx. Immediately, a record (the older ?
15/6/2014 à 17:24:16) appeared in the archive table. Weewx
continued (and is always continuing) to treat station's records.
But no more records are inserted in the archive table. My question
is why, why the only the first and not the others.
Sep 26 13:54:55 raspberrypi weewx[2085]: wmr200: MainThread: D
adjust_rain rain_total:72.14 Archive Data.rain_total_last:72.14
rain_interval:0.00
Sep 26 13:54:55 raspberrypi weewx[2085]: wmr200: MainThread: D
genStartup() Yielding received archive record cnt:396 after
requested timestamp:1402948906 pkt_interval:60 pkt:2014-06-17
04:38:26 CEST (1402972706)
Sep 26 13:54:55 raspberrypi weewx[2085]: manager: Added record
2014-06-17 04:38:26 CEST (1402972706) to database 'weewx'
Sep 26 13:54:56 raspberrypi weewx[2085]: manager: Added record
2014-06-17 04:38:26 CEST (1402972706) to daily summary in 'weewx'
Sep 26 13:54:56 raspberrypi weewx[2085]: wmr200: MainThread: D
Queuing archive packet rx:2090 archive_queue_len:1
Sep 26 13:54:56 raspberrypi weewx[2085]: wmr200: MainThread: I
genStartup() Still receiving archive packets cnt:396 len:1
Sep 26 13:54:56 raspberrypi weewx[2085]: wmr200: MainTh
Thanks
--
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/W2u8w-Z8x9I/unsubscribe
<https://groups.google.com/d/topic/weewx-user/W2u8w-Z8x9I/unsubscribe>.
To unsubscribe from this group and all its topics, send an email
to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout
<https://groups.google.com/d/optout>.
--
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]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout
<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/W2u8w-Z8x9I/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
[email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
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].
For more options, visit https://groups.google.com/d/optout.
