forum.purplepixie.org

Hi Dave.

I sent the following email to your older x@xx.purplepixie.org address (I don't know your newer Gmail address) with a PDF attachment:

"I had an unusual event happen last night (see attached PDF). I am mystified by some of the graphs, particularly the flat-lines that are not RED, and the slowly increasing ping reply times. The only alerts that I received were for the failures of eff (pages 6-7 of the PDF) and the failure of GMA (page 9 of the PDF.)

If you'll remember I use a custom script to disable all alerts on all nodes during the night, then re-enable them in the morning so that testing continues but no alerts are issued. I noted today that alerting was OFF for all nodes and I had to manually run the script to re-enable them. Unfortunately I had cron output going to the bit bucket, so there are no log enties

Any insight you could give?

Thanks!"

Paul

Hi Paul,

Got the email - address hasn't changed, just hosting. I've just moved so sorry for the delay.

The big gaps are where testing isn't being performed at all. Let me have a better look over the weekend and I'll get back to you with some ideas.

Regards,

Dave.

Hi Dave.

my script reports this:

Too many connections in /opt/freenats/server/base/nats.db.inc.php on line 39 Cannot connect to MySQL server

I have emailed you a copy of "show processlist;" from mysql, but I do not know how to troubleshoot a 'too many connections' error. Could you assist me?

Thank you!

Paul

Dave, I've increased my max_globalconnections from the default of 100 to 150. Any advice?

Thanks!

Paul

BTW for anyone reading this was traced to a MySQL corruption.

To repair your MySQL why not try my amazingly poor myrep software - http://www.purplepixie.org/myrep