Wow yesterday was a day that I would like to never remember again. Sure there were good parts like Katie finally coming home after a week away for work but most of the day involved frustration and confusion over a problem that is still not solved.

I have been posting about it on and off for two weeks now. The troubles I have had since that day I upgraded to WP 2.5. Everything worked like a dream before I hit that little button and ever since WordPress has been less than usable. I am losing valuable page views with all of the down time and mots of all it just drives me crazy that nobody can figure it out. I can’t be the only one, why does WordPress roll out untested upgrades? Can’t they just wait a little longer or do they need to stroke their ego that much?

Adding to the misery of seeing Cuzoogle down for 10 hours yesterday was the Raptors game. Yep they lost and are now down 3-1 in the series. It is hard to really blame anyone for the loss because it was the standard reasons why they lost. Can’t rebound or hit the big shots when needed. I feel this team needs a nice 10 point lead with 8-9 minutes left if they want to win. If it is closer than that they will lose.

I found the officiating brutal (the last two games) and it all seemed to go sour when Jamario Moon strained his groin and had to leave the game.

Most likely the series ends tomorrow and Cuzoogle will fall into summer mode with a more set routine of posting and features.

Back to my WP issues.

Finally around 8pm last night the site popped up live and seemed to be working. I checked everything out and left it just happy it was there.

This is the problem I have had for weeks.

When trying to write a new post I get script errors and the who application hangs. I click on write and it all stalls. After stopping the script I can write like I am now but there are pauses. The image uploader won’t work unless I save the post first. I can’t do anything from here without getting the script error and stopping it. What this is doing is generating a lot of processes on my server and if it hits 25 or more I get shut down.

I went back to WP 2.3 last week and everything seemed to work okay again and I was happy except I knew I would have to go back up again just to get all of the new security features.

This is where I recruited someone who knows a lot more about all of this back end stuff. Bryan of GrandmasterB fame took on the problem and I think he has become just as obsessed about it as I am.

We have searched high and low on google, tried various things and nothing to date.

Then WP 2.5.1 came out the other day and it seemed the problem was close to being solved. It had a lot of bug fixes and I was sure one of them would be what I was experiencing.

So on Friday night Bryan and I stayed up for hours doing a fresh install of WP. I thank him for doing it because my DB was rather large and it took awhile.

Finally it was all done, the blog was back up and guess what, the issue was still there.

Here is the email I got from Hostgator about the issue. Keep in mind it took 2 weeks and about 15 support people there to get this info.

Dear Customer,
The internal server errors are most likely coming from the fact that you are reaching more than 25 running processes:
[root@gator370 ~]# ps aux | grep cusdenm
cusdenm 10370 0.0 0.5 33524 23424 ? SN 09:12 0:09 /usr/bin/php post.php
cusdenm 10590 0.0 0.4 27972 17856 ? SN 09:12 0:00 /usr/bin/php wp-cron.php
cusdenm 10948 0.0 0.4 29552 19340 ? SN 09:13 0:00 /usr/bin/php admin-ajax.php
cusdenm 11238 0.0 0.4 27808 17444 ? SN 09:13 0:00 /usr/bin/php index.php
cusdenm 11299 0.0 0.4 27624 17372 ? SN 09:13 0:00 /usr/bin/php index.php
cusdenm 11301 0.0 0.4 27624 17372 ? SN 09:13 0:00 /usr/bin/php index.php
cusdenm 11505 0.0 0.4 27632 17376 ? SN 09:14 0:00 /usr/bin/php index.php
cusdenm 11537 0.0 0.4 27632 17372 ? SN 09:14 0:00 /usr/bin/php index.php
cusdenm 11742 0.0 0.4 27904 17620 ? SN 09:14 0:00 /usr/bin/php index.php
cusdenm 11778 0.0 0.4 27632 17380 ? SN 09:14 0:00 /usr/bin/php index.php
cusdenm 11934 0.0 0.4 27736 17440 ? SN 09:14 0:00 /usr/bin/php index.php
cusdenm 12109 0.0 0.4 27640 17384 ? SN 09:14 0:00 /usr/bin/php index.php
cusdenm 12321 0.0 0.4 27628 17372 ? SN 09:15 0:00 /usr/bin/php index.php
cusdenm 12542 0.0 0.4 27632 17372 ? SN 09:15 0:00 /usr/bin/php index.php
cusdenm 12740 0.0 0.4 27636 17384 ? SN 09:15 0:00 /usr/bin/php index.php
cusdenm 12742 0.0 0.4 27628 17368 ? SN 09:15 0:00 /usr/bin/php index.php
cusdenm 12813 0.0 0.4 27736 17440 ? SN 09:15 0:00 /usr/bin/php index.php
cusdenm 12977 0.0 0.4 27632 17376 ? SN 09:16 0:00 /usr/bin/php index.php
cusdenm 13169 0.0 0.4 27636 17384 ? SN 09:16 0:00 /usr/bin/php index.php
cusdenm 13208 0.0 0.4 27628 17372 ? SN 09:16 0:00 /usr/bin/php index.php
cusdenm 13226 0.0 0.4 27628 17376 ? SN 09:16 0:00 /usr/bin/php index.php
cusdenm 13276 0.0 0.4 27632 17380 ? SN 09:16 0:00 /usr/bin/php index.php
cusdenm 13289 0.0 0.4 27636 17384 ? SN 09:16 0:00 /usr/bin/php index.php
cusdenm 13312 0.0 0.4 27632 17372 ? SN 09:16 0:00 /usr/bin/php index.php
cusdenm 14222 0.0 0.4 27660 17504 ? SN 17:55 0:00 /usr/bin/php index.php
[root@gator370 ~]# ps aux | grep cusdenm | grep -v root | wc -l
25

We have a process limit of 25 processes.
Additionally, we have the same limit on MySQL connections (Actually I think the MySQL limit is 30).
You are nearly exceeding this:
[root@gator370 /home/cusdenm/public_html/wp

-content/plugins]# mysqladmin proc | grep cusdenm
| 1678052 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32932 | Locked | SELECT ID FROM wp_posts WHERE post_parent = 1216 |
| 1678058 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32980 | Writing to net | SELECT `ID`, `post_author`, `post_date`, `post_date_gmt`, `post_status`, `post_name`, `post_modified |
| 1678141 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32843 | Locked | SELECT * FROM wp_posts, wp_postmeta WHERE wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key |
| 1678328 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32932 | Locked | UPDATE wp_posts SET `post_author` = ‘1′, `post_date` = ‘2008-04-26 10:12:32′, `post_date_gmt` = ‘200 |
| 1678462 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32908 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND |
| 1678495 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32903 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=’2008′ AND MONTH(wp_posts |
| 1678497 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32903 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=’2008′ AND MONTH(wp_posts |
| 1678617 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32883 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=’2008′ AND MONTH(wp_posts |
| 1678630 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32880 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=’2008′ AND MONTH(wp_posts |
| 1678695 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32869 | Locked | SELECT DISTINCT p.ID, p.post_title, p.post_date, p.comment_count, count(t_r.object_id) as cnt FROM w |
| 1678708 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32866 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND |
| 1678788 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32850 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND |
| 1678877 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32837 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=’2008′ AND MONTH(wp_posts |
| 1678944 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32827 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=’2007′ AND MONTH(wp_posts |
| 1679058 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32813 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=’2007′ AND MONTH(wp_posts |
| 1679187 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32792 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=’2008′ AND MONTH(wp_posts |
| 1679188 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32791 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=’2007′ AND MONTH(wp_posts |
| 1679219 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32784 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND |
| 1679295 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32769 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=’2008′ AND MONTH(wp_posts |
| 1679411 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32749 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND |
| 1679435 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32746 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=’2007′ AND MONTH(wp_posts |
| 1679443 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32744 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND |
| 1679465 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32739 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND |
| 1679473 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32737 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=’2008′ AND MONTH(wp_posts |
| 1679484 | cusdenm | localhost | cusdenm_wrdp1 | Query | 32735 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)=’2006′ AND MONTH(wp_posts |
| 1856540 | cusdenm_wrdp1 | localhost | cusdenm_wrdp1 | Query | 1598 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AND |

Here are the problems inherent.
1) You are running WP-Cron, which can spawn a significant number of processes, depending on what is running. If you need cron, use crontab, which is available through your cPanel. If you need information on how to trigger scripts via cron, let us know.

2) You are running a significant number of plugins… 62 to be exact:
[root@gator370 /home/cusdenm/public_html/wp-content/plugins]# ls | wc -l
62
There are bound to be some conflicts… there always are (I am an experienced WordPress user, having used it since before version 1.3, and having written plugins for the system).

3) Something you have installed is locking MySQL tables. This is bad. If even a single php process stalls (and apparently, most are), or a single DB query doesn’t return, then the remainder of your MySQL queries will stall, and the remainder of your php scripts will stall. WordPress does not lock tables by default, so this must be coming from a plugin. Find out which one, and disable it.

Your issues are not related to the WordPress core, nor are they related to our server, or our MySQL installation. They are related to the plugins you are running (almost assuredly). Unfortunately, we cannot assist, specifically, with third party script issues; however, the information I’ve provided should put you on the right track, or at least give you some idea of what to ask after in the WP forums.

I have killed your PHP and MySQL processes so your site is responding, again.

Thanks for being a HostGator customer!

Yep I admit I had a lot of plugins but I never knew there was a limit. That is something I have learned now, only use what you really need.

I have since downsized to about 25 plugins and the problem is still there. I am next going to delete and reinstall each one as this forum post suggests.

I don’t feel that confident it will work but what else can I do?

Basically it feels like if I get 30 people on my blog at once it is going to shutdown and that does not make for a good profit. I want to go back to getting linked by SI.com and Digg etc..

Wordpress.org drives me crazy because they don’t have support. They have forums where you have to go on a wild goose chase hoping someone used the same wording as you. Their members or so-called experts have a very high and mighty attitude and never understand how a person like me could be so dumb.

I have five threads on the go and only one has any activity. So it is not my host’s issue, not WordPress’s problem so what is going on?

It makes blogging a chore rather than fun. I hate taking twice as long to do anything. I hate having to do somthing 10 times when I only need to do it once.

Everytime I upgrade and then downgrade and upgrade again something is not working or lost or needs fixing. Tell me why 2.5 is the way to go?

When I was using WP 2.3 I never had to deal with any of this. Hell I am almost ready to go back to Blogger.

So yep a bad day for me but I am trying to be positive about it and hope I can figure it out.

Suggestions, tips, ideas are welcome.

Stop the insanity.

Popularity: 1% [?]

If you enjoyed this post, make sure you subscribe to my RSS feed!