A A A
Forum Scope


Match



Forum Options



Min search length: 3 characters / Max search length: 84 characters
Forum Login
Lost password?
Avatar
John Logsdon
12 Posts
(Offline)
1
Jun 16, 2012 - 6:21 am
Print

After a weeks’s running with about 200 members I have had a curious database access issue that traces back to SP.

Platform:  Ubuntu 10.04, Mysql  Ver 14.14 Distrib 5.1.63

php5 5.3.2-1ubuntu4.15 with Suhosin-Patch and eAccelerator. (memory_limit = 128M)

Wordpress version 3.3.2 (yes I know I should move to 3.4 but it’s only been out few days!).

Apache/2.2.14 currently using mod_php .

Simple:Press version 5.1.1 with plugins admin-bar  font-resize  online  plupload  post-preview  post-rating  private-messaging  quicktags-bbcode  subscriptions  tinymce-richtext  watches

/var/log/syslog reported at 7:02 this morning:

WordPress database error MySQL server has gone away for query SELECT  * FROM wp4_sfforums WHERE forum_rss_private=0 made by require, require_once, include, suffusion_content, do_action, call_user_func_array, suffusion_excerpt_or_content, get_template_part, locate_template, load_template, require, the_content, apply_filters, call_user_func_array, sp_render_forum, sp_process_template, sp_load_template, include, sp_load_template, include, sp_AllRSSButton, spdb_table, spdb_select

followed by:

 WordPress database error MySQL server has gone away for query UPDATE wp4_sftrack#015#012#011#011#011   SET notification=’a:2:{i:0;i:1;i:1;s:22:”Invalid database query”;}’#015#012#011#011#011   WHERE id=1540 made by require, require_once, include, suffusion_content, do_action, call_user_func_array, suffusion_excerpt_or_content, get_template_part, locate_template, load_template, require, the_content, apply_filters, call_user_func_array, sp_render_forum, sp_process_template, sp_load_template, include, sp_load_template, include,

with the last message repeated lots of times then PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in […] wp-includes/wp-db.php on line 1549

These message were repeated for about 50 minutes as people are finding the site very slow to load then a whole slew (about 450) of undefined variables are reported from the two files in wp-content/sp-resources/forum-themes/default/styles/.

This is a puzzle.  The system showed no signs of running out of memory and was running other sites (except they probably slowed a bit) without problems.  It had been running for about a week.

Can you suggest any fix?  This is a new site that is already taking a lot of traffic so I want to make sure it is robust.

TIA

Avatar
Yellow Swordfish
Glinton, England

16436 Posts
(Offline)
2
Jun 16, 2012 - 8:11 am
Print

I think you need to go and repair your database.

MySQL tables really need to be optimised on a regular basis to stop what is called ‘overflow’ and the need for the engine to start to create temporary storage spaces. Failure to deal with this will eventually result in a dramatic slowdown in performance and data errors.

I would recommend you install the wp-dbmanager plugin that will allow you to run an optimisation of the db on a scheduled basis – say once a week. But it also has repair and check options you can use instantly.

andy-signature.png
YELLOW
SWORDFISH
Avatar
John Logsdon
12 Posts
(Offline)
3
Jun 16, 2012 - 9:49 am
Print

Thanks for that -I never thought of this!  smile

There was no other indication, only the occasional overhead but there are a lot of tables in that particular database.

I’ve now done it with phpmyadmin. I’ll keep my fingers crossed and cron a weekly job using one of the tools.

Avatar
Mr Papa
Simi Valley, CA

19448 Posts
(Offline)
4
Jun 16, 2012 - 1:26 pm
Print

as will we… 😉

Forum Timezone: America/New_York
All RSSShow Stats
Administrators: Blues Dancer, Simple Press, SP Community Support, Marcus (Simple:Press)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 630
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Newest Members:
Lorena Affleck
samantardh
PatrickAlawl
Hannelore Gaither
Margarito Nowacki
Elwood Mcclendon
samantaerx
Larue Cordeaux
Jerrold Stockman
Forum Stats:
Groups: 7
Forums: 17
Topics: 10071
Posts: 79393

 

Member Stats:
Guest Posters: 608
Members: 16976
Moderators: 0
Admins: 4

Most Users Ever Online
1170
Currently Online
Guest(s)
1
Currently Browsing this Page

1 Guest(s)