[weewx-user] Re: Database vs MQTT published data

Are you sure you're not just seeing gaps in the 'graphs' of the data ? See if you're really missing intervals in the db by querying your db directly. -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receivi

[weewx-user] Re: Database vs MQTT published data

I am missing the data in mysql. See the two attachments. The last hour in phpmysql vs grafana. There are just 7 records in the last hour, but AFAIK my interceptor gets data every ~16 seconds - see the graph drawn by grafana using influxdb data. [image: 2021-01-26 14_36_41 chrome_daC10v9WCb.png] [i

[weewx-user] Re: Database vs MQTT published data

Hi, Are you really sure that the data in the Influxdb is complete? Maybe you have the following in your Grafana query in the grouping: GROUP BY time($__interval) fill(none) This simply fills possible gaps. Michael -- You received this message because you are subscribed to the Google Groups "w

[weewx-user] Re: Database vs MQTT published data

On Wednesday, January 27, 2021 at 4:33:25 PM UTC-8 lop...@gmail.com wrote: > As an extra info, weewx is failing to generate the html during these > periods, but interceptor and mqtt are able to function. > As Tom asked, we're going to need to see your syslogs with weewx debug=1 set in order to

[weewx-user] Re: Database vs MQTT published data

The dropouts have no pattern. I have a few days without any issues, and then for 24hrs mysql starts choking. At the beginning I didn't have the influx/grafana part. I've set it up for testing purposes, to see if mqtt is pushing out data even if the mysql is behaving. Previously I tried setting u

[weewx-user] Re: Database vs MQTT published data

If you continue to not do what we ask, we're eventually going to give up trying to help. Find a time period where you're getting data, then it stops, then it restarts. Query your weewx database and get us the archive table records for that period (sorry, I don't recall mysqld syntax for that, I

Re: [weewx-user] Re: Database vs MQTT published data

Hard to say without seeing the log. Is the MySQL server located on an unreliable network link? Unfortunately, WeeWX cannot recover from a MySQL write error (see issue #259 ). Take a look in your system log for any WeeWX errors, and in the MySQL log for an

Re: [weewx-user] Re: Database vs MQTT published data

Since 04:30AM the data stream is continuous again, see attachment. For the record, the dropouts were 30 minutes long, followed by a 30 minutes good data logs. The mysql server is running on the same raspberry pi as weewx. I think this rules out the possibility of having an unreliable network lin

Re: [weewx-user] Re: Database vs MQTT published data

On Tuesday, January 26, 2021 at 1:38:20 PM UTC-8 lop...@gmail.com wrote: > Since 04:30AM the data stream is continuous again, see attachment. For the > record, the dropouts were 30 minutes long, followed by a 30 minutes good > data logs. > The mysql server is running on the same raspberry pi as

Re: [weewx-user] Re: Database vs MQTT published data

Hello Zsolt Mate. I unfortunately do not have the solution to your problem, but on the other hand, I would have a question for you: Would it be possible to know how you did in the curves of speed and direction of the wind to indicate in the scale of Y the values "N", "W", "S" and "E" instead of "00