Archived Forum

Hello jostor, looks like there was an issue with the hosting company on the head emoncms.org was on https://forum.bytemark.co.uk/comments.php?DiscussionID=4706&page=1#Item_0

Im working on it now.

The server seems to be running particularly slow, the mysql processes are stacking up not completing fast enough, and so were getting a too many connections error. Taking it up with bigv now.

When the websites completely down data will not be being logged. if its unresponsive in the browser to normal page views, data logging can be inconsistent with some packets getting through.

It seems that several feed tables may have got corrupted when the head went down, mysql is currently running repairs on the tables which could take a while. I have stopped apache (the web server) so that it can complete these operations. WIll update with progress.

I think its hopefully back to normal now, repairs finished, server loads reducing

Thanks for taking care to fix emoncms back up and running !!

Thanks!

Hello !

Is emoncms.org down again?

I receive "too many connections" message continuosly...

Thanks...

Me too.  Seems to have gone down about an hour ago.

I want emoncms to be successful and reliable.  Would more donations help?

And here....

Woohoo, it's back up.

I admire Trystan for doing this for free so I just made a donation.  I urge the rest of you to do so too here.  If the server is going down due to "too many connections" there must be a lot of you out there.

Emoncms graphs seem to be auto ranging to strange values like +-10e32 at the moment making graphs appear as a straight line.

Thanks David, that's much appreciated.

ngbod: will take a look at the graphs

ngbod: Which graphs are causing this large values error?

It's my main dashboard which has a multigraph on it. The large value axis seems to have cleared now but only one of the four feeds is displaying.  The other three feeds are still being saved but havent been displayed since 10pm on the night before the last outage     http://emoncms.org/ngbod&id=4502    My other graphs in different dashboards are displaying ok though!

I also checked mad dads graphs in the showcase forum http://emoncms.org/sedlescombe&id=5340   and his are showing the same high value problem, see screenshot.

Ok I can see the problem, not sure what's causing it at the moment, I will look into it.

Ok it was a problem with phptimeseries, after the recent outage some phptimeseries feeds that where being written to at the time did not complete a full write and so the file append started off at an incorrect position the next time a datapoint was written. I have put together a script that works through the phptimeseries feeds checking and fixing the error while also converting the feed to timestore.

It will take a while to work through all feeds and I'm not sure how many feeds are effected by this but your feeds and dashboard David are now working and even better than before now that they are using timestore which has the nice averaging feature.

Thanks Trystan,

It's working great now, and super fast as well.

Hi Trystan, how is your script progressing? I ask as I have some phptimeseries feeds that are still misbehaving.

Tim

So do I.

Hello Tim, most of your feeds are now converted to timestore, let me know how you find it.

Trystan hopefully a little hiccup but no data is displayed in the multi-graphs.

The feeds were there when I first logged in but now seem to have disappeared from the feeds page. 

mad_data, your feeds are now converted.

teebee, multigraphs seem to load ok for me, can you send a screenshot?, is it a particular multigraph?

Oops I was checking from work when I saw you had converted the feeds and used IE which doesn't like the multigraphs which I had forgotten. So yes all looks good now. 

Thanks for  whatever you did to resolve the original feed issue.

Tim

Hi,

emoncms.org stopped working today at 6.00 eet = 4.00 gmt. Normal reboot does not seem to help.

anything particular going on with emoncms.org ?

Looks like my raspi gateway is down - no telnet, no emon gateway user interface - maybe somekind of auto update happened on raspi package ...

SD card looked damaged, I guess martin has more than a clue about whats going on...

http://harizanov.com/2013/08/rock-solid-rfm2pi-gateway-solution/

I've been getting these errors recently too. Are there still issues?

at 22, 23, 26 and 28:th of december different times.

From my log:

INFO:root:EmonCMS response: Can't connect to database, please verify credentials/configuration in settings.php<br />Error message: <b>Too many connections</b>

This should no longer be an issue now as of yesterday morning emoncms.org is on a more powerfully server, the mysql connections are closing much faster than before and so they should not pile up as they where doing. I will do a blog post about it soon