Strange data line in database

Post Reply
User avatar
magical46
Observer
Observer
Posts: 49
Joined: Mon Aug 21, 2017 2:19 pm
Location: Farnham, Surrey, UK
Contact:

Strange data line in database

Post by magical46 » Sat Dec 21, 2019 11:44 am

Hi, I am using a "fine offset" type weather station which as with most of these occasionally throws a wobbly and gives me some ridiculous spikes, something I just have to live with. I go into the database editing and delete the affected lines, no problem. However I have noticed recently when doing this that every hour(whether there is a spike or not) there is a line of data on the hour e.g. 08:00:00 followed by a second line of the same data at , for example, 08:00:30. Now if there is a spike on the hour then deleting that line also deletes the hour +30 second line. It doesn't appear to affect anything, I just don't thing the second line should be there.
I do have WD sending a tweet to twitter on the hour but have tried turning that off as I thought that may cause the issue but that made no difference.
Any thoughts?
Image

User avatar
MonyMony
Forecaster
Forecaster
Posts: 192
Joined: Sun Aug 20, 2017 12:54 pm
Location: Elkton, Maryland, US
Station model: Davis Pro 2
Software: WeatherCat/Meteobridge
Contact:

Re: Strange data line in database

Post by MonyMony » Thu Jan 02, 2020 1:06 pm

Hum... besides saying 'that's weird', I'm having a hard time coming up a scenario that would cause this. Meteotemplate should only write to the database every few minutes based off of a cache of data received from the API uploads. My only guess is to check to see if you have any custom scheduled jobs (like a cron job) that might be triggering the database upload but I'm not even sure what to suggest to look for.
Image

User avatar
magical46
Observer
Observer
Posts: 49
Joined: Mon Aug 21, 2017 2:19 pm
Location: Farnham, Surrey, UK
Contact:

Re: Strange data line in database

Post by magical46 » Sat Jan 25, 2020 9:55 pm

I have WD uploading to twitter every hour, thought that maybe it but I tried switching that off but still got the "spurious" data line
Image

User avatar
Jolumarali
Professional
Professional
Posts: 251
Joined: Sun Aug 20, 2017 2:06 pm
Location: Lignerolles
Station model: Vantage Vue
Software: WlIP
Contact:

Re: Strange data line in database

Post by Jolumarali » Sun Jan 26, 2020 6:29 am

hello
Personally for Twitter I send every hour with Weathercloud.com

José Luis
Image
Station météo amateur Lignerolles
OS : Windows 11 Famille
Vantage Vue
Weatherlink 2.0 (WlIP)
Meteotemplate 18.0 Papaya

https://meteo-lignerolles.fr

José Luis

andyk1
Professional
Professional
Posts: 433
Joined: Tue Feb 27, 2018 10:56 pm
Location: OKLAHOMA, USA
Station model: Ecowitt WS90
Software: Meteobridge/GW2000B
Contact:

Re: Strange data line in database

Post by andyk1 » Fri Jan 31, 2020 1:16 am

Check to make sure you are only updating once. One cron job... etc. Not sure how you have your system setup or how you are feeding your data... Meteobridge or Ecowitt etc.

Strangely, the first time I replied to it didn't work.
Image

Post Reply