Fix (or explain how to) MySQL messages in error_log
[20-Jan-2011 05:24:43] WordPress database error MySQL server has gone away for query UPDATE wpblclinks SET url = '{url path to static page}', firstfailure = '0000-00-00 00:00:00', lastcheck = '2011-01-20 05:24:43', lastsuccess = '2011-01-20 05:24:43', lastcheckattempt = '2011-01-20 05:24:43', checkcount = 0, finalurl = '{same path}', redirectcount = 0, log = '=== HTTP code : 200 ===\n\nHTTP/1.1 200 OK\r\nDate: Thu, 20 Jan 2011 05:24:43 GMT\r\nServer: Apache modfcgid/2.3.5 modauthpassthrough/2.1 modbwlimited/1.4 FrontPage/5.0.2.2635\r\nX-Powered-By: PHP/5.2.15\r\nCache-Control: no-cache, must-revalidate, max-age=0\r\nPragma: no-cache\r\nExpires: Wed, 11 Jan 1984 05:00:00 GMT\r\nLast-Modified: Thu, 20 Jan 2011 03:36:17 GMT\r\nVary: Accept-Encoding\r\nContent-Type: text/html;charset=UTF-8\r\n\r\n\nLink is valid.', httpcode = 200, requestduration = 0.090698, timeout = 0, resulthash = '200|0|0|d9ec510e2c6d37a2ba2df7081db96d95', broken = 0, falsepositive = 0, mayrecheck = 1, beingchecked = 0, statustext = '', statuscode = '' WHERE linkid=14 made by doactionrefarray, calluserfuncarray, wsBrokenLinkChecker->croncheck_links, wsBrokenLinkChecker->work, blcLink->check, blcLink->save
-
Quibbler commented
More follow up:
[20-Jan-2011 05:24:55] WordPress database error MySQL server has gone away for query SELECT RELEASE_LOCK('blc_lock') made by do_action_ref_array, call_user_func_array, wsBrokenLinkChecker->cron_check_links, wsBrokenLinkChecker->work, wsBrokenLinkChecker->release_lock, WPMutex->release -
Quibbler commented
Follow up in case it helps
[20-Jan-2011 05:24:55] WordPress database error MySQL server has gone away for query SELECT links.*
FROM wp_blc_links AS links
WHERE
(
( last_check_attempt < '2011-01-19 05:24:55' )
OR
(
(broken = 1 OR being_checked = 1)
AND may_recheck = 1
AND check_count < 3
AND last_check_attempt < '2011-01-20 04:54:55'
)
)
AND EXISTS (
SELECT 1 FROM wp_blc_instances AS instances
WHERE
instances.link_id = links.link_id
AND ( instances.container_type IN ('dummy', 'page', 'post', 'comment', 'blogroll') )
AND ( instances.parser_type IN ('link', 'image', 'plaintext-url', 'metadata', 'url_field') )
)
ORDER BY last_check_attempt ASC
LIMIT 30 made by do_action_ref_array, call_user_func_array, wsBrokenLinkChecker->cron_check_links, wsBrokenLinkChecker->work, wsBrokenLinkChecker->get_links_to_check