Support Forum
Support Forum
Offline
Current Disk Usage
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 15G 1.7G 13G 13% /
/dev/sda7 206G 63G 132G 33% /var
/dev/sda6 4.9G 171M 4.5G 4% /tmp
/dev/sda2 39G 8.4G 29G 23% /usr
/dev/sda1 996M 53M 892M 6% /boot
tmpfs 500M 1.9M 499M 1% /dev/shm
/dev/sdb1 2.7T 105G 2.5T 5% /problem-with-post-edit-buttonome
none 12G 732K 12G 1% /var/spool/exim
tmpfs 2.0G 8.0K 2.0G 1% /var/mysqltmp
Offline
I think Andy meant the temp table in mysql... hopefully he will still be back by today...
Visit Cruise Talk Central and Mr Papa's World
Offline
Temporary data
Variable Value Description
Created_tmp_disk_tables 2.8 M The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based.
Created_tmp_files 2.7 k How many temporary files mysqld has created.
Created_tmp_tables 4.9 M The number of in-memory temporary tables created automatically by the server while executing statements.
Offline
Well if the sql engine problem has not continued then I think you have to go back to look at the php error logs on the server.
One other thing that may be worth looking into. Can you discover if there is any consistent factor about where topics stop displaying. I.e., is the next or previous post posted by the same user? Anything else that might be a common factor?
 |
YELLOW
SWORDFISH
|
Offline
They all stop loading in the same place, some more examples below. These example topics are within this section. Doesn't matter if your logged in or out. Seems like most are broken, with very few actually loading.
http://www.ps3blog.net/communi.....-features/
http://www.ps3blog.net/communi.....s3blognet/
http://www.ps3blog.net/communi.....oll-ideas/
http://www.ps3blog.net/communi.....n-userbar/
http://www.ps3blog.net/communi.....-fighting/
http://www.ps3blog.net/communi.....-currents/
http://www.ps3blog.net/communi.....ing-setup/
Checked the server error logs today and here are some items related to sp:
[27-Feb-2012 04:24:03] WordPress database error MySQL server has gone away for query UPDATE `wp_sfoptions` SET `option_value` = 'a:10:{s:7:"dayflag";s:2:"23";s:8:"hourflag";s:2:"13";s:9:"maxonline";s:3:"349";s:11:"membercount";s:4:"2213";s:10:"guestcount";i:140;s:9:"fourofour";b:1;s:12:"showtopcount";s:1:"5";s:12:"shownewcount";s:1:"0";s:9:"statslist";a:7:{i:0;O:8:"stdClass":5:{s:7:"user_id";s:2:"59";s:12:"display_name";s:4:"Tosh";s:5:"posts";s:3:"979";s:5:"admin";s:1:"1";s:9:"moderator";s:1:"0";}i:1;O:8:"stdClass":5:{s:7:"user_id";s:3:"363";s:12:"display_name";s:3:"Jay";s:5:"posts";s:3:"478";s:5:"admin";s:1:"1";s:9:"moderator";s:1:"0";}i:2;O:8:"stdClass":5:{s:7:"user_id";s:3:"624";s:12:"display_name";s:4:"EdEN";s:5:"posts";s:3:"631";s:5:"admin";s:1:"0";s:9:"moderator";s:1:"0";}i:3;O:8:"stdClass":5:{s:7:"user_id";s:3:"475";s:12:"display_name";s:3:"oly";s:5:"posts";s:3:"504";s:5:"admin";s:1:"0";s:9:"moderator";s:1:"0";}i:4;O:8:"stdClass":5:{s:7:"user_id";s:2:"63";s:12:"display_name";s:5:"Eddie";s:5:"posts";s:3:"353";s:5:"admin";s:1:"0";s:9:"moderator";s:1:"0";}i:5;O:8:"stdClass":5:{s:7:"user_id";s:4:"1555";s:12:"display_name";s:5:"Pedro";s:5:"posts";s:3:"290";s:5:"admin";s:1:"0";s:9:"moderator";s:1:"0";}i:6;O:8:"stdClass":5:{s:7:"user_id";s:4:"1578";s:12:"display_name";s:11:"Beastxjason";s:5:"posts";s:3:"217";s:5:"admin";s:1:"0";s:9:"moderator";s:1:"0";}}s:11:"newuserlist";a:5:{i:0;a:2:{s:2:"id";s:4:"2653";s:4:"name";s:11:"shimano6000";}i:1;a:2:{s:2:"id";s:4:"2564";s:4:"name";s:6:"evanac";}i:2;a:2:{s:2:"id";s:4:"2652";s:4:"name";s:13:"rubi12ponting";}i:3;a:2:{s:2:"id";s:4:"2647";s:4:"name";s:8:"slacker6";}i:4;a:2:{s:2:"id";s:4:"2637";s:4:"name";s:7:"ToshSan";}}}' WHERE `option_name` = 'sfcontrols' made by require, require_once, do_action, call_user_func_array, sp_404, sp_update_option
Offline
So you clearly have some DB problems (out of memory there and lost connections). Whether that accounts for this issue is another matter of course.
1 - Error Log Test
So if you clear out the SP error log (toolbox) then run one of these disappeared topics and then go back to the error log - is there an entry of any sort?
2 - Data Test
Go to the toolbox > Data Inspector and turn on the option to inspect the 'Topic View Data' - 'spTopicView' and then again run of the disappeared topics. Do you see a dump of the data displayed anywhere?
|
YELLOW
SWORDFISH
|
Offline
Was busy all day at work. So didn't get a chance to look at it until now. I cleared the SP error log. Then tried one of the broken threads and it works now. I haven't changed anything either. Hopefully it doesn't happen again, lol. If it does I'll see what I can find using the data test and sp error log.
Offline
sounds promising... if not mysterious...
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)