Hi, I've got a custom error handler setup which emails me any error messages that come through on my system. In the last day I've been bombarded with error messages saying "MySQL server has gone away", but when ever I open the site up there are no issues what so ever. I am able to browse through the whole system and retrieve any information. Is there any reason why these errors might be happening? One thing I thought it might be down to is I did a hard reboot the other day which caused problems with temp file in MySQL, but since then I have restarted MySQL, Apache and done a soft reboot of my server. Although, at the same time I might have fixed it and these emails are just very delayed in getting to me. Any suggestions would be greatly appreciated.
Oddly enough I have read this page already, but I can't see any thing that would be causing it. There are 2 cronjobs that I'm running which seem to be causing the problems, but when I run them manually I don't get any problems. I've had to turn the cronjobs off for now to make sure it is actually them causing the issue.
Thankyou very much for the help, I was able to pin point the problem. I had a terrible piece of SQL that was returning 25259861 rows instead of just one. I was attempting to run this every second or so within a cronjob so not surprised the server went loopy. So it looks like it might be the packet too large problem that was causing the server to go away.