PDA

View Full Version : Cron Error's?


webtime
06-24-2007, 03:27 PM
This is a copy of my emails this morning, I have forward this to host to find out, what resources are on my vps, and how they are divided among the users.If this is not the script error, then the sql server is dropping out?

I have made notes please read
Jun 24, 2007 12:53 AM
Dear Admin,

Link was submitted to Addus Web Directory Directory. Please check it.

Jun 24, 2007 2:00 AM <------about 150 these------>

<PRE>2006: MySQL server has gone away</PRE>Error occured. Please see
the logs or report an error to the administrator

Jun 24, 2007 2:41 AM
Dear Admin,

Link was submitted to Addus Web Directory Directory. Please check it.

Jun 24, 2007 4:00 AM

Error occured. Please see the logs or report an error to the administrator

Jun 24, 2007 4:00 AM
3 links checked
=========================
0 broken links
0 non-reciprocal links
0 links PageRank not updated
----------------------------A script I uploaded earlier that day------------
[newmailcgi] Recently Uploaded CGI scripts that send email on server.xxxxxxx.net
Date: Jun 24, 2007 5:21 AM
Below are the recently upload scripts that contain code to send email. You may
wish to inspect them to ensure they are not sending out SPAM
---------------------------------------------------------------------
Jun 24, 2007 5:21 AM
This message was created automatically by mail delivery software.

A message that you sent could not be delivered to one or more of its
recipients. This is a permanent error. The following address(es) failed:

Jun 24, 2007 6:00 AM

Error occured. Please see the logs or report an error to the administrator

Jun 24, 2007 6:06 AM
SQL Server's error: MySQL server has gone away

SQL Query: SELECT `t1`.*, `t1`.`comments_active` `comments`, `t2`.`crossed`, '0'
`id_editor_edit` FROM `v2103_link_categories` `t2` LEFT JOIN `v2103_links` `t1`
ON `t1`.`id` = `t2`.`id_link` LEFT JOIN `v2103_editors` `t4` ON `t1`.`id_editor`
= `t4`.`id` WHERE `t2`.`id_category` = '13' AND `t1`.`status` =
'active' GROUP BY `t1`.`id` ORDER BY `t1`.`featured` DESC, `t1`.`sponsored`
DESC, `t1`.`date` DESC LIMIT 0, 10

Jun 24, 2007 6:06 AM
SQL Server's error: MySQL server has gone away

SQL Query: SELECT * FROM v2103_admins

Jun 24, 2007 6:10 AM <------------------about 400 of these-------->
SQL Server's error: MySQL server has gone away

SQL Query: SELECT * FROM v2103_admins

Jun 24, 2007 7:34 AM
Dear Admin,

Link was submitted to Addus Web Directory Directory. Please check it.

Jun 24, 2007 10:00 AM

Error occured. Please see the logs or report an error to the administrator

This what I found when I check at 11.15 am (eastern usa)

Any ideas, I'm starting to wonder if the server isn't dropping out, because I see no-one, with these error's listed, or they are not being posted?

But I seen a server failed and was restarted automatically, one a month.I think that a reboot of the system.

Thanks.

webtime
06-24-2007, 06:25 PM
Update : I sent the post above to my host and this is the reply:

One of the monitoring systems we have shows a spike in load sometime
between 5-5:30 this morning, how I have no way of knowing what caused
it. Based on the error messages you included, I suspect that the
failcounts in /proc/user_beancounters are more relevant to the problem.
There are a number of failcounts in the numfile limit. This is the
maximum number of files that can be opened (actively being read from or
written to) at one time. A shortage in this limit would prevent
programs from opening connections to the mysql engine. The way to be
sure would be to check the user_benacounters file afterwards if the
problem occurs again. If the failcount has increased (numfile is
currently at 504), then this would be the problem.

The mail scripts are something you can check if you wish. The email is
sent by cpanel to the administrative email address so the admin knows
what is running on the system.

Anybody got a solution ( not sure if i understand all of the answer) But they keep leaning to the directory uses to many functions call at one time. What I'm going to try is change the cron run times off the hr and more to a off time :20
Thanks