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 link. I've restarted weewex after setting the debug flag to 1. I'll keep an eye on the server and check the log when it happens again.
/var/log/mysql/error.log is empty [image: 2021-01-27 10_29_04 chrome_Wf7wVUdOQL.png] On Wednesday, January 27, 2021 at 12:35:03 AM UTC+13 [email protected] wrote: > 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 <https://github.com/weewx/weewx/issues/259>). > > Take a look in your system log for any WeeWX errors, and in the MySQL log > for any database errors. > > On Mon, Jan 25, 2021 at 5:45 PM Zsolt Máté <[email protected]> wrote: > >> 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] >> [image: 2021-01-26 14_37_31 chrome_YnEe2grkwc.png] >> >> On Tuesday, January 26, 2021 at 2:08:22 PM UTC+13 vince wrote: >> >>> 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 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/fd9dab82-7f31-450e-9f0c-44e1d136e6a4n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/fd9dab82-7f31-450e-9f0c-44e1d136e6a4n%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/08529f65-a866-430f-b05d-a8cda42de4e9n%40googlegroups.com.
