Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
SPF filling the error_log
Avatar
Bill Murray
Member
Free Members
sp_UserOfflineSmall Offline
Oct 4, 2011 - 8:33 am

I had to deactivate SPF due to a rapidly growing error log. On both the front end and back end, everything seems fine.  However, the site started to get very slow, and I noticed that the error_log was filling up with contents similar to what I pasted below.  In a 6 hour span, the error_log got to 48 Mb with similar content.  Before I observed it the first time, the log was approaching 100 Mb.  Before deactivating, my apache status panel was full of cron entries; after deactivating, they are all gone.

One other oddity:

When clicking to the plugins menu choice, I got this (I shortened URL):

Fatal error: Cannot run code from this file in conjunction with non encoded files in ../wp-includes/version.php on line 201

I have no info to connect the 2, but other than SPF, the site config hasn't really changed.

I am running WP 3.2.1 multi-site with W3 Total Cache, which hasn't changed since I first installed SPF 5.0.  The error_log situation only started happening with my SVN update from Sunday, but it might have been going on from my just prior update and I didn't notice.

Any thoughts?

 

Portion of error_log below:

[04-Oct-2011 05:13:08] WordPress database error MySQL server has gone away for query UPDATE `wp_options` SET `option_value` = 'a:29:{i:1317704780;a:1:{s:14:\"sph_stats_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317705288;a:1:{s:25:\"w3_cdn_cron_queue_process\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:25:\"w3_cdn_cron_queue_process\";s:4:\"args\";a:0:{}s:8:\"interval\";i:900;}}}i:1317705527;a:1:{s:14:\"sph_stats_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317705604;a:1:{s:14:\"sph_stats_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317706704;a:1:{s:14:\"sph_stats_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317707185;a:1:{s:14:\"sph_stats_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317707815;a:1:{s:14:\"sph_stats_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317708125;a:1:{s:14:\"sph_stats_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317708202;a:3:{s:18:\"w3_dbcache_cleanup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:18:\"w3_dbcache_cleanup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}s:22:\"w3_objectcache_cleanup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:22:\"w3_objectcache_cleanup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}s:18:\"w3_pgcache_cleanup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:18:\"w3_pgcache_cleanup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317708359;a:1:{s:18:\"w3_cdn_cron_upload\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:18:\"w3_cdn_cron_upload\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317708380;a:1:{s:14:\"sph_stats_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317721263;a:1:{s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1317736525;a:1:{s:21:\"dbmanager_cron_backup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:16:\"dbmanager_backup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317738290;a:1:{s:21:\"update_network_counts\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1317738459;a:1:{s:10:\"polls_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1317740066;a:1:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1317740780;a:1:{s:26:\"sph_transient_cleanup_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317743884;a:1:{s:24:\"akismet_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317744927;a:1:{s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1317745127;a:1:{s:26:\"sph_transient_cleanup_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317749904;a:1:{s:26:\"sph_transient_cleanup_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317751402;a:1:{s:17:\"w3_minify_cleanup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:17:\"w3_minify_cleanup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317752404;a:1:{s:26:\"sph_transient_cleanup_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317761815;a:1:{s:26:\"sph_transient_cleanup_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317772925;a:1:{s:26:\"sph_transient_cleanup_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317776389;a:1:{s:19:\"wp_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317779185;a:1:{s:26:\"sph_transient_cleanup_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317822925;a:1:{s:23:\"dbmanager_cron_optimize\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:18:\"dbmanager_optimize\";s:4:\"args\";a:0:{}s:8:\"interval\";i:259200;}}}s:7:\"version\";i:2;}' WHERE `option_name` = 'cron' made by call_user_func_array, wp_reschedule_event, wp_schedule_event, _set_cron_array, update_option, W3_Db->update, W3_Db_Nocache->query, W3_Db->query_nocache
[04-Oct-2011 05:13:08] WordPress database error MySQL server has gone away for query UPDATE `wp_options` SET `option_value` = 'a:28:{i:1317705288;a:1:{s:25:\"w3_cdn_cron_queue_process\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:25:\"w3_cdn_cron_queue_process\";s:4:\"args\";a:0:{}s:8:\"interval\";i:900;}}}i:1317705527;a:1:{s:14:\"sph_stats_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317705604;a:1:{s:14:\"sph_stats_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317706704;a:1:{s:14:\"sph_stats_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317707185;a:1:{s:14:\"sph_stats_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317707815;a:1:{s:14:\"sph_stats_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317708125;a:1:{s:14:\"sph_stats_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317708202;a:3:{s:18:\"w3_dbcache_cleanup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:18:\"w3_dbcache_cleanup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}s:22:\"w3_objectcache_cleanup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:22:\"w3_objectcache_cleanup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}s:18:\"w3_pgcache_cleanup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:18:\"w3_pgcache_cleanup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317708359;a:1:{s:18:\"w3_cdn_cron_upload\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:18:\"w3_cdn_cron_upload\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317708380;a:1:{s:14:\"sph_stats_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:6:\"hourly\";s:4:\"args\";a:0:{}s:8:\"interval\";i:3600;}}}i:1317721263;a:1:{s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1317736525;a:1:{s:21:\"dbmanager_cron_backup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:16:\"dbmanager_backup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317738290;a:1:{s:21:\"update_network_counts\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1317738459;a:1:{s:10:\"polls_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1317740066;a:1:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1317740780;a:1:{s:26:\"sph_transient_cleanup_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317743884;a:1:{s:24:\"akismet_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317744927;a:1:{s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1317745127;a:1:{s:26:\"sph_transient_cleanup_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317749904;a:1:{s:26:\"sph_transient_cleanup_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317751402;a:1:{s:17:\"w3_minify_cleanup\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:17:\"w3_minify_cleanup\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317752404;a:1:{s:26:\"sph_transient_cleanup_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317761815;a:1:{s:26:\"sph_transient_cleanup_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317772925;a:1:{s:26:\"sph_transient_cleanup_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317776389;a:1:{s:19:\"wp_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317779185;a:1:{s:26:\"sph_transient_cleanup_cron\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}i:1317822925;a:1:{s:23:\"dbmanager_cron_optimize\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:18:\"dbmanager_optimize\";s:4:\"args\";a:0:{}s:8:\"interval\";i:259200;}}}s:7:\"version\";i:2;}' WHERE `option_name` = 'cron' made by wp_unschedule_event, _set_cron_array, update_option, W3_Db->update, W3_Db_Nocache->query, W3_Db->query_nocache
[04-Oct-2011 05:13:08] WordPress database error MySQL server has gone away for query SELECT  * FROM wp_sfforums ORDER BY group_id made by do_action_ref_array, call_user_func_array, sp_cron_generate_stats, sp_get_stats_counts, spdb_table, spdb_select, W3_Db->query
[04-Oct-2011 05:13:08] WordPress database error MySQL server has gone away for query SHOW TABLES LIKE 'wp_sferrorlog' made by do_action_ref_array, call_user_func_array, sp_cron_generate_stats, sp_get_stats_counts, spdb_table, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, W3_Db->query
[04-Oct-2011 05:13:08] WordPress database error MySQL server has gone away for query SHOW TABLES LIKE 'wp_sferrorlog' made by do_action_ref_array, call_user_func_array, sp_cron_generate_stats, sp_get_stats_counts, spdb_table, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, W3_Db->query
[04-Oct-2011 05:13:08] WordPress database error MySQL server has gone away for query SHOW TABLES LIKE 'wp_sferrorlog' made by do_action_ref_array, call_user_func_array, sp_cron_generate_stats, sp_get_stats_counts, spdb_table, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, W3_Db->query
[04-Oct-2011 05:13:08] WordPress database error MySQL server has gone away for query SHOW TABLES LIKE 'wp_sferrorlog' made by do_action_ref_array, call_user_func_array, sp_cron_generate_stats, sp_get_stats_counts, spdb_table, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, W3_Db->query
[04-Oct-2011 05:13:08] WordPress database error MySQL server has gone away for query SHOW TABLES LIKE 'wp_sferrorlog' made by do_action_ref_array, call_user_func_array, sp_cron_generate_stats, sp_get_stats_counts, spdb_table, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, W3_Db->query
[04-Oct-2011 05:13:08] WordPress database error MySQL server has gone away for query SHOW TABLES LIKE 'wp_sferrorlog' made by do_action_ref_array, call_user_func_array, sp_cron_generate_stats, sp_get_stats_counts, spdb_table, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, W3_Db->query
[04-Oct-2011 05:13:08] WordPress database error MySQL server has gone away for query SHOW TABLES LIKE 'wp_sferrorlog' made by do_action_ref_array, call_user_func_array, sp_cron_generate_stats, sp_get_stats_counts, spdb_table, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, W3_Db->query
[04-Oct-2011 05:13:08] WordPress database error MySQL server has gone away for query SHOW TABLES LIKE 'wp_sferrorlog' made by do_action_ref_array, call_user_func_array, sp_cron_generate_stats, sp_get_stats_counts, spdb_table, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, W3_Db->query
[04-Oct-2011 05:13:08] WordPress database error MySQL server has gone away for query SHOW TABLES LIKE 'wp_sferrorlog' made by do_action_ref_array, call_user_func_array, sp_cron_generate_stats, sp_get_stats_counts, spdb_table, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, W3_Db->query

Avatar
Bill Murray
Member
Free Members
sp_UserOfflineSmall Offline
Oct 4, 2011 - 12:38 pm

You can ignore the part about:

Fatal error: Cannot run code from this file in conjunction with non encoded files in ../wp-includes/version.php on line 201

I had installed APC but had forgotten to disable Zend, and that was triggering that error on many backend pages.  Too many late night kills my RAM.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 5, 2011 - 12:02 am

error code 28 means the mysql server has gone away...  once the mysql server is not reachable, you will get tons of errors...

Avatar
Bill Murray
Member
Free Members
sp_UserOfflineSmall Offline
Oct 9, 2011 - 9:52 am

I'm back!  I get the point about the mySQL server going away.  I come at least that far 🙂 

I deactivated SPF and saw no problems.  So I reactivated, and here is a sample of what I see.  Note that the end was manually cut off my me.  On the query, the string is huge and it repeats.  See the pattern of spdb_select, sp_construct_database_error, sp_write_error.  Once that starts, it just repeats and repeats.  If that is the actual query, it is no wonder the mySQL went away.  So, my questions are: is that the actual query and if not, what is causing it to go haywire?

 

[09-Oct-2011 14:30:48] WordPress database error MySQL server has gone away for query SHOW TABLES LIKE 'wp_sferrorlog' made by do_action_ref_array, call_user_func_array, sp_cron_generate_stats, sp_get_stats_counts, spdb_table, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error, spdb_select, sp_construct_database_error, sp_write_error ...

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 9, 2011 - 11:14 am

I dont know... obviously some queries require more db cpu/time than others... if the mysql server is hanging by a thread, its possible a query can put it over the edge... but still points back to a weak mysql server...

I think there is a way to monitor the mysql server and report back on long queries and see if any trend... I would google for how to do that...

Avatar
Bill Murray
Member
Free Members
sp_UserOfflineSmall Offline
Oct 9, 2011 - 6:49 pm

Before I get into checking the mySQL server, which I think is fine, can you confirm that the query is right? 

Can you explain why the query appears to repeat endlessly 3 items?  I've seen a lot of queries, and I have never seen one that repeats to the degree this query does. 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 9, 2011 - 7:01 pm

Depends on what you mean by correct... wink

yes, that is one of our queries...  I dont know what you mean by endlessly... that is a query as part of trying to write out an error to the error log...  I assume you do have an sferrorlog table?

so without knowing more information, only way I could see some sort of repetitive loop is if the trying to generate the error itself was causing an error generation...

do you know what the original error it was trying to generate was?

Avatar
Bill Murray
Member
Free Members
sp_UserOfflineSmall Offline
Oct 9, 2011 - 7:15 pm

Yes, I do have an sferrorlog table.  However, there are no errors in the log.

You say that is one of your queriers - you have the query repeating those 3 elements?  That seems odd.

I just have a couple of posts in my forum, and I didn't get any new posts today.  So the error, whatever it was, could have only occurred with someone just viewing the forum. 

Could it have occurred updating stats?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 9, 2011 - 7:27 pm

No, thats not what quite what I said.... about repeating...

there is not builit in repeating...  the query:

    $success = spdb_select('var', "SHOW TABLES LIKE '".SFERRORLOG."'");

happens once when generating an error message for the log...  I did hypothesize that perhaps the act of trying to write to the error log is itself generating an error...  and so its possible it could do the query again...

Avatar
Bill Murray
Member
Free Members
sp_UserOfflineSmall Offline
Oct 9, 2011 - 7:48 pm

Your hypothesis that the act of trying to write to the error log is generating an error could be correct, since there are no errors in the log.

But let's imagine it does the query again.  It is as if the query is not duplicated exactly, but for each successive duplication of the query, the components in the array are duplicated, so that the query grows and grows, almost like the federal debt.

Btw, my sferrorlog has 4 fields: id, error_date, error_type, error_text.  I am assuming the structure did not change.

Are the stats updated automatically?  Given my forum has virtually no activity, could updating the stats be the source of the problem?

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 649
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 618
Members: 17348
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10120
Posts: 79607