I am trying to receive data via MQTT on a separate Weewx installation. Works so far quite neatly, only with the weather data I always missing entries in the database, although they were received via MQTT. E.g. 1612159200 there is an entry in the database in the "Produktiv weewx". In the test version this entry is missing. Why is this the case? I still added the syslog from the relevant area.
weewx:
MariaDB [(none)]> select datetime,
dateti -> from_unixtime(datetime),
-> rain,
-> rainrate
e > -> from weewx.archive
-> where datetime > 1612154700 and datetime < 1612163400
-> order by datetime;
+------------+-------------------------+--------------------+---------------------+
| datetime | from_unixtime(datetime) | rain | rainrate
|
+------------+-------------------------+--------------------+---------------------+
| 1612155000 | 2021-02-01 05:50:00 | 0 |
0 |
| 1612155300 | 2021-02-01 05:55:00 | 0 |
0 |
| 1612155600 | 2021-02-01 06:00:00 | 0 |
0 |
| 1612155900 | 2021-02-01 06:05:00 | 0 |
0 |
| 1612156200 | 2021-02-01 06:10:00 | 0 |
0 |
| 1612156500 | 2021-02-01 06:15:00 | 0 |
0 |
| 1612156800 | 2021-02-01 06:20:00 | 0 |
0 |
| 1612157100 | 2021-02-01 06:25:00 | 0 |
0 |
| 1612157400 | 2021-02-01 06:30:00 | 0.0705555556000022 |
0.141111111200004
|
| 1612157700 | 2021-02-01 06:35:00 | 0 |
0.282222222400009
|
| 1612158000 | 2021-02-01 06:40:00 | 0 |
0.282222222400009
|
| 1612158300 | 2021-02-01 06:45:00 | 0 |
0.136245210813797
|
| 1612158600 | 2021-02-01 06:50:00 | 0 |
0 |
| 1612158900 | 2021-02-01 06:55:00 | 0 |
0 |
| 1612159200 | 2021-02-01 07:00:00 | 0.0705555556000022 |
0.263407407573341
|
| 1612159500 | 2021-02-01 07:05:00 | 0 |
0.282222222400009
|
| 1612159800 | 2021-02-01 07:10:00 | 0 |
0.282222222400009
|
| 1612160100 | 2021-02-01 07:15:00 | 0 |
0.00973180077241409 |
| 1612160400 | 2021-02-01 07:20:00 | 0.070555555599995 |
0.0376296296533307
|
| 1612160700 | 2021-02-01 07:25:00 | 0 |
0.28222222239998
|
| 1612161000 | 2021-02-01 07:30:00 | 0 |
0.28222222239998
|
| 1612161300 | 2021-02-01 07:35:00 | 0 |
0.243295019310328
|
| 1612161600 | 2021-02-01 07:40:00 | 0 |
0 |
| 1612161900 | 2021-02-01 07:45:00 | 0.0705555556000022 |
0.194636015448282
|
| 1612162200 | 2021-02-01 07:50:00 | 0 |
0.282222222400009
|
| 1612162500 | 2021-02-01 07:55:00 | 0 |
0.282222222400009
|
| 1612162800 | 2021-02-01 08:00:00 | 0 |
0.0846666667200026
|
| 1612163100 | 2021-02-01 08:05:00 | 0 |
0 |
+------------+-------------------------+--------------------+---------------------+
28 rows in set (0.002 sec)
MariaDB [(none)]>
weewx-test:
MariaDB [(none)]> select datetime,
-> from_unixtime(datetime),
-> rain,
-> rainrate
-> from weewx.archive
-> where datetime > 1612154700 and datetime < 1612163400
-> order by datetime;
+------------+-------------------------+--------------------+--------------------+
| datetime | from_unixtime(datetime) | rain | rainrate
|
+------------+-------------------------+--------------------+--------------------+
| 1612155000 | 2021-02-01 05:50:00 | 0 |
0 |
| 1612155300 | 2021-02-01 05:55:00 | 0 |
0 |
| 1612155600 | 2021-02-01 06:00:00 | 0 |
0 |
| 1612155900 | 2021-02-01 06:05:00 | 0 |
0 |
| 1612156200 | 2021-02-01 06:10:00 | 0 |
0 |
| 1612156500 | 2021-02-01 06:15:00 | 0 |
0 |
| 1612156800 | 2021-02-01 06:20:00 | 0 |
0 |
| 1612157100 | 2021-02-01 06:25:00 | 0 |
0 |
| 1612157400 | 2021-02-01 06:30:00 | 0.0705555556000022 |
0.151190476285719
|
| 1612157700 | 2021-02-01 06:35:00 | 0 |
0.282222222400009
|
| 1612158000 | 2021-02-01 06:40:00 | 0 |
0.282222222400009
|
| 1612158300 | 2021-02-01 06:45:00 | 0 |
0.125432098844448
|
| 1612158600 | 2021-02-01 06:50:00 | 0 |
0 |
| 1612158900 | 2021-02-01 06:55:00 | 0 |
0 |
| 1612159200 | 2021-02-01 07:00:00 | 0 |
0.282222222400009
|
| 1612159500 | 2021-02-01 07:05:00 | 0 |
0.282222222400009
|
| 1612159800 | 2021-02-01 07:10:00 | 0 |
0.282222222400009
|
| 1612160100 | 2021-02-01 07:15:00 | 0 |
0 |
| 1612160400 | 2021-02-01 07:20:00 | 0.070555555599995 |
0.0418106996148119 |
| 1612160700 | 2021-02-01 07:25:00 | 0 |
0.28222222239998
|
| 1612161000 | 2021-02-01 07:30:00 | 0 |
0.28222222239998
|
| 1612161300 | 2021-02-01 07:35:00 | 0 |
0.240411522785168
|
| 1612161600 | 2021-02-01 07:40:00 | 0 |
0 |
| 1612161900 | 2021-02-01 07:45:00 | 0.0705555556000022 |
0.20905349807408
|
| 1612162200 | 2021-02-01 07:50:00 | 0 |
0.282222222400009
|
| 1612162500 | 2021-02-01 07:55:00 | 0 |
0.282222222400009
|
| 1612162800 | 2021-02-01 08:00:00 | 0 |
0.0627160494222241 |
| 1612163100 | 2021-02-01 08:05:00 | 0 |
0 |
+------------+-------------------------+--------------------+--------------------+
28 rows in set (0.001 sec)
--
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/300fde45-3a22-41a4-89e4-0dd99e00f485n%40googlegroups.com.
<<attachment: syslog.zip>>
