Database shows no data from 3pm onwards today but live data OK. **solved**

Moderator: Mattk

Post Reply
gcams
Senior Boarder
Senior Boarder
Posts: 46
Joined: Sat Feb 04, 2012 5:06 pm

Database shows no data from 3pm onwards today but live data OK. **solved**

Post by gcams »

There appears to be an issue recalling historical data from meteoplug just now. My graphs only show data up to 3:05pm today (UK time) and it's currently 9:02pm (UK time). However the real-time display is performing normally and the server logs show data being received.
Screen Shot 2019-12-29 at 20.52.13.png
Screen Shot 2019-12-29 at 20.52.13.png (63.86 KiB) Viewed 586 times
The problem is also evident trying to inspect the data in the control panel:
Screen Shot 2019-12-29 at 20.58.32.png
Screen Shot 2019-12-29 at 20.58.32.png (83.6 KiB) Viewed 586 times
Is there something wrong with the database just now?

UPDATE: I've just noticed in the meteoplug server logs that the "UPDATEDB" job is not running after 4:10pm server time (3:10pm Uk time) which marries perfectly with when my data stopped being updated into the meteoplug db. So definitely looks like something is wrong on the meteoplug server:

Code: Select all

info: Dec 29 16:10:10 omega IMPORT XX:XX:XX:XX:XX:XX: 333 records imported (20191229150009 - 20191229151008) in 0s
info: Dec 29 16:10:10 omega UPDATEDB XX:XX:XX:XX:XX:XX: time 0s/0.009s [2019-12-29 15:00:09 - 2019-12-29 15:10:08]: 4 sensors, 40 selects (323+276 rows), 48 inserts, 10 live updates
info: Dec 29 16:20:09 omega LOGRAW XX:XX:XX:XX:XX:XX: WAN IP X.X.X.X: 328 records into 20191229162009-XX:XX:XX:XX:XX:XX-20191229151010-20191229152008-328
info: Dec 29 16:20:09 omega IMPORTLOOP : /home/boris/meteoplug/data/raw/20191229162009-XX:XX:XX:XX:XX:XX-20191229151010-20191229152008-328
info: Dec 29 16:30:09 omega LOGRAW XX:XX:XX:XX:XX:XX: WAN IP X.X.X.X: 331 records into 20191229163009-XX:XX:XX:XX:XX:XX-20191229152010-20191229153008-331
info: Dec 29 16:30:10 omega IMPORTLOOP : /home/boris/meteoplug/data/raw/20191229163009-XX:XX:XX:XX:XX:XX-20191229152010-20191229153008-331
info: Dec 29 16:40:09 omega LOGRAW XX:XX:XX:XX:XX:XX: WAN IP X.X.X.X: 328 records into 20191229164009-XX:XX:XX:XX:XX:XX-20191229153010-20191229154008-328
info: Dec 29 16:40:10 omega IMPORTLOOP : /home/boris/meteoplug/data/raw/20191229164009-XX:XX:XX:XX:XX:XX-20191229153010-20191229154008-328
info: Dec 29 16:50:09 omega LOGRAW XX:XX:XX:XX:XX:XX: WAN IP X.X.X.X: 328 records into 20191229165009-XX:XX:XX:XX:XX:XX-20191229154010-20191229155008-328
info: Dec 29 16:50:10 omega IMPORTLOOP : /home/boris/meteoplug/data/raw/20191229165009-XX:XX:XX:XX:XX:XX-20191229154010-20191229155008-328
info: Dec 29 17:00:09 omega LOGRAW XX:XX:XX:XX:XX:XX: WAN IP X.X.X.X: 339 records into 20191229170009-XX:XX:XX:XX:XX:XX-20191229155010-20191229160008-339
info: Dec 29 17:00:10 omega IMPORTLOOP : /home/boris/meteoplug/data/raw/20191229170009-XX:XX:XX:XX:XX:XX-20191229155010-20191229160008-339
info: Dec 29 17:10:09 omega LOGRAW XX:XX:XX:XX:XX:XX: WAN IP X.X.X.X: 327 records into 20191229171009-XX:XX:XX:XX:XX:XX-20191229160010-20191229161008-327
info: Dec 29 17:10:10 omega IMPORTLOOP : /home/boris/meteoplug/data/raw/20191229171009-XX:XX:XX:XX:XX:XX-20191229160010-20191229161008-327
info: Dec 29 17:20:09 omega LOGRAW XX:XX:XX:XX:XX:XX: WAN IP X.X.X.X: 324 records into 20191229172009-XX:XX:XX:XX:XX:XX-20191229161010-20191229162008-324
info: Dec 29 17:20:09 omega IMPORTLOOP : /home/boris/meteoplug/data/raw/20191229172009-XX:XX:XX:XX:XX:XX-20191229161010-20191229162008-324
info: Dec 29 17:30:09 omega LOGRAW XX:XX:XX:XX:XX:XX: WAN IP X.X.X.X: 324 records into 20191229173009-XX:XX:XX:XX:XX:XX-20191229162010-20191229163008-324
info: Dec 29 17:30:10 omega IMPORTLOOP : /home/boris/meteoplug/data/raw/20191229173009-XX:XX:XX:XX:XX:XX-20191229162010-20191229163008-324
info: Dec 29 17:40:09 omega LOGRAW XX:XX:XX:XX:XX:XX: WAN IP X.X.X.X: 327 records into 20191229174009-XX:XX:XX:XX:XX:XX-20191229163010-20191229164006-327
info: Dec 29 17:40:10 omega IMPORTLOOP : /home/boris/meteoplug/data/raw/20191229174009-XX:XX:XX:XX:XX:XX-20191229163010-20191229164006-327
info: Dec 29 17:50:09 omega LOGRAW XX:XX:XX:XX:XX:XX: WAN IP X.X.X.X: 334 records into 20191229175009-XX:XX:XX:XX:XX:XX-20191229164010-20191229165008-334
info: Dec 29 17:50:10 omega IMPORTLOOP : /home/boris/meteoplug/data/raw/20191229175009-XX:XX:XX:XX:XX:XX-20191229164010-20191229165008-334
info: Dec 29 18:00:09 omega LOGRAW XX:XX:XX:XX:XX:XX: WAN IP X.X.X.X: 330 records into 20191229180009-XX:XX:XX:XX:XX:XX-20191229165010-20191229170008-330
info: Dec 29 18:00:10 omega IMPORTLOOP : /home/boris/meteoplug/data/raw/20191229180009-XX:XX:XX:XX:XX:XX-20191229165010-20191229170008-330
info: Dec 29 18:10:09 omega LOGRAW XX:XX:XX:XX:XX:XX: WAN IP X.X.X.X: 323 records into 20191229181009-XX:XX:XX:XX:XX:XX-20191229170010-20191229171008-323
info: Dec 29 18:10:10 omega IMPORTLOOP : /home/boris/meteoplug/data/raw/20191229181009-XX:XX:XX:XX:XX:XX-20191229170010-20191229171008-323

References:
https://www.fifeweather.co.uk/index.php/dynamic-graphs

Rutishauser
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: Wed Dec 11, 2019 5:25 am

Re: Database shows no data from 3pm onwards today but live data OK

Post by Rutishauser »

In der Tat sind die Aufzeichnungen seit etwa 16 Uhr nicht mehr intakt. :(
Die Live-Charts hingegen laufen.

https://www.meteoplug.com/cgi-bin/meteo ... 2a2f393935

bubulino
Junior Boarder
Junior Boarder
Posts: 33
Joined: Tue Mar 30, 2010 3:24 pm
Location: Bolken, Switzerland

Re: Database shows no data from 3pm onwards today but live data OK

Post by bubulino »

Bei mir auch: Ausfall aller Messtationen.
Läuft aber seit 22:35 Uhr wieder.

LG, MBR

grwkak
Senior Boarder
Senior Boarder
Posts: 70
Joined: Thu Jan 30, 2014 2:15 am

Re: Database shows no data from 3pm onwards today but live data OK

Post by grwkak »

I just noticed the same thing - 10am EST until 16:30 I have a huge gap in data.

Guy

grwkak
Senior Boarder
Senior Boarder
Posts: 70
Joined: Thu Jan 30, 2014 2:15 am

Re: Database shows no data from 3pm onwards today but live data OK

Post by grwkak »

Currently no uploads - getting 502 Bad gateway errors.

Post Reply