Jakets

Alright, I already had Notepad++ so I ran the search on the entire plugin directory. I got 10 hits for session_start. 9 were in SI CAPTCHA Anti-Spam Plugin and 1 was in Advertising Manager. Both of these were already disabled (i found the call in SI earlier today and disabled it), I went ahead and deleted them entirely. I also repaired the DB again and Optimized it as well as clearing the error log. I will get back to you guys if the error persists.

I’m not sure how to look through the sources efficiantly. But I did give it a go and look through the main file on each plugin. I only found the session_start function in 1 plugin. This was the Captcha plugin. I have disabled it for now, cleared my error log and repaired the db. I also deleted my tmp folder contents again. Now I will just wait and see. However, this was the only place I could find that function, I find it hard to imagine that 1 tiny Captcha plugin was doing this much damage.

Thanks for your help, I will report back in an hour or so, if its still occurring I’m not sure what to do besides go though plugins one at a time, which is not something I look forward too. I switched from b2evolution to WordPress for ease of use, I am starting to regret that decision…

@ apljdi: Ok, I will list the plugins. In the meantime I have been tweaking, repairing, optimizing the DB. I also removed one plugin that was causing me some problems, but I am still getting the error 28 like mad. It has changed slightly however, so if this helps the error now looks like this:

[26-Dec-2009 12:17:49] WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’, ‘post_tag’) AND tr.object_id IN (540, 455, 465, 388, 382, 349, 322, 313, 66, 135) ORDER BY t.name ASC made by require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_object_term_cache, wp_get_object_terms

The bolded part changes occasionally, with different numbers.

The plugins I am using are all the most current version available (no betas):

ACTIVE:
Avatars
Clean Archives Reloaded
Get Recent Comments
Highlight Author Comments
jQuery Comment Preview
MaxBlogPress Ping Optimizer
phpbb_recent_topics
ShareThis
SI CAPTCHA Anti-Spam
Sidebar Login
Twitter Tools
Twitter Tools – Bit.ly URLs
Who is Online
WP-ContactForm
WP-Polls
WP Authors

DEACTIVATED:
Advertising Manager
Akismet
GD Star Rating
Live Countdown Timer
Twitter Tools – Exclude Category
Twitter Tools – Hashtags

I really appreciate the help, this is killing my site. If it helps the site is FarmVille Fanatic

Here is a recent chat with my host:

Jake [2:59:45 PM]: I have an error: WordPress database error Got error 28 from storage engine for query SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (143) ORDER BY t.name ASC made by require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_object_term_cache, wp_get_object_terms
[3:00:16 PM]: i have talked with dennis
[3:00:23 PM]: i was told its my problem
[3:00:30 PM]: he told me to check with the WP community
[3:00:40 PM]: I have and multiple times i have been told it is a host issue
[3:00:44 PM]: please check this thread:
[3:00:53 PM]: http://wordpress.org/support/topic/344853?replies=1
[3:01:32 PM]: the error is filling my log, and has caused my site to be shut down before by you (the host)
Mike V [3:02:17 PM]: The first error as mentioned was space related, everything else is related to your wordpress install and not something we can really assist with.
Jake [3:02:36 PM]: im only talking about the wp error 28
[3:02:45 PM]: everywhere says it is on your end
[3:02:54 PM]: even the mysql site itslef
[3:03:00 PM]: i cannot fix this error
Mike V [3:03:07 PM]: Delete your log files.
[3:03:18 PM]: Or set up log rotation to delete them for you.
[3:03:30 PM]: Or allocate more space to your site from your control panel.
Jake [3:03:50 PM]: more space to my site?
[3:04:04 PM]: 147.41 / 25000 MB
[3:04:08 PM]: thats how much i am using
[3:04:17 PM]: it has to do with the tmp space
[3:04:50 PM]: please look at this: http://www.mysql.com/news-and-events/newsletter/2003-10/a0000000249.html
Mike V [3:05:28 PM]: Something like that we can't increase on a per site basis, and the limits exist as a mysql restriction for a reason.
Jake [3:05:29 PM]: the error happened less than 5 minutes after clearing my tmp folder and files
Mike V [3:05:44 PM]: You're generating too much information in a very short time then.
[3:05:57 PM]: We have hundreds of other wordpress sites on this server and none are having this issue.
Jake [3:06:18 PM]: then how am i supposed to fix this? my install is nothing special
Mike V [3:06:24 PM]: Apparently it is.
Jake [3:06:28 PM]: i have been told again and again by wp community it is a host issue
[3:06:41 PM]: and host tells me again and again its a wp error
[3:06:45 PM]: so im in a bind here
Mike V [3:06:53 PM]: And if it isn't something special, then uninstall and reinstall it.
[3:07:09 PM]: You have something in your install that's causing this.
Jake [3:07:53 PM]: is there no way to determine more than this? I dont really have a way to simply re-install it without destroying a lot of work
[3:08:14 PM]: and if it continues to happen and everyone else says it is a host issue...
[3:08:17 PM]: then what?
[3:08:37 PM]: other hosts can increase the tmp size
Mike V [3:08:45 PM]: The issue with everyone claiming its a host issue is that we'd have every other wordpress or mysql utilizing site generating similar errors.
Jake [3:09:08 PM]: well i talked to this guy:
[3:09:08 PM]: Alex P [1:54:36 AM]: Please hold on, I'm checking...
Jake [1:54:44 AM]: ok
Alex P [1:57:45 AM]: I've raised tmp_table_size for mysqld and you shouldn't experience such problems anymore.
[3:09:14 PM]: this is your own host support
[3:09:28 PM]: he didnt seem to have a problem with saying it could be raised
[3:09:31 PM]: and claimed it was
Mike V [3:09:35 PM]: I see the size increase.
[3:09:42 PM]: Its at the highest we'd permit.
Jake [3:09:46 PM]: you just said a bit ago you couldent do that
[3:10:07 PM]: Mike V [3:05:28 PM]: Something like that we can't increase on a per site basis, and the limits exist as a mysql restriction for a reason.
Mike V [3:10:32 PM]: He didn't increase it on a per site basis.
[3:10:37 PM]: He increased it server wide.
Jake [3:11:00 PM]: no one has been able to help me with this issue at all
Mike V [3:11:04 PM]: What its at right now is the highest we'll be able to adjust it.
Jake [3:11:06 PM]: is the tmp folder full?
Mike V [3:11:22 PM]: You have to realize that no one else was having issues with their wordpress install at the original limits.
[3:11:24 PM]: You were the only one.
Jake [3:11:26 PM]: i had it cleared and within minutes the error continured to appear
Mike V [3:11:32 PM]: This means something in your install is causing this issue.
[3:12:14 PM]: We've adjusted any limits as high as we can really permit without risking abuse or performance issues on the server.

Ok I talked to my host and he cleared the TMP folder, this is what he said about error 2:

Arkady [9:53:07 PM]: As I see there are a lot of session files created in tmp folder from your application, as example:
[9:53:08 PM]: -rw——- 1 jakets jakets 0 Dec 23 20:48 sess_93ab811165324db9b27fea766f75fb79
-rw——- 1 jakets jakets 0 Dec 23 20:50 sess_98615e2244dbc4474f28f2cc1800d2e5
-rw——- 1 jakets jakets 0 Dec 23 20:48 sess_9c8e56b1d8aee7ae37523aed1a749a9a
-rw——- 1 jakets jakets 0 Dec 23 20:49 sess_9e29fd37e5f1eb4d6b217187ac4d0ed9
-rw——- 1 jakets jakets 0 Dec 23 20:47 sess_9e430ea063ec4f10159a505e3b82f0c0
-rw——- 1 jakets jakets 0 Dec 23 20:48 sess_9e50dbce45f962f2f00f36b112c87d11
-rw——- 1 jakets jakets 0 Dec 23 20:49 sess_a2d3964d42fc345fb6f30f9fada1acd7
-rw——- 1 jakets jakets 0 Dec 23 20:48 sess_a35e6fabe147e0f2c87bde3aa68c585d
-rw——- 1 jakets jakets 0 Dec 23 20:49 sess_a4bc122e8be4532239f87a7df681bb13
-rw——- 1 jakets jakets 33 Dec 23 20:48 sess_a6efc621025cd5e337939c379c5f9087
-rw——- 1 jakets jakets 0 Dec 23 20:48 sess_ab12e67525beb08d5cba2120e65def09
-rw——- 1 jakets jakets 0 Dec 23 20:49 sess_aeeb348394e242606f3aab9852081f78
-rw——- 1 jakets jakets 0 Dec 23 20:50 sess_b1b5cf1a3865998b7f83028b777a37b9
-rw——- 1 jakets jakets 0 Dec 23 20:51 sess_b3e12a33e1aaf90fd9790cdd33c09c1f
-rw——- 1 jakets jakets 0 Dec 23 20:46 sess_bef6373ee29dd3299cbe61befaf472b2
-rw——- 1 jakets jakets 0 Dec 23 20:51 sess_bf185ebbc08f06a538197bc1846c7624
-rw——- 1 jakets jakets 0 Dec 23 20:47 sess_c35c01c02f34e42baa632182d65e6203
-rw——- 1 jakets jakets 0 Dec 23 20:49 sess_c41cc30f0cce3f2ac3fb64caa23d99a9
-rw——- 1 jakets jakets 33 Dec 23 20:50 sess_c6cf453eb0fc37da3cbc1b7a66108209
-rw——- 1 jakets jakets 0 Dec 23 20:45 sess_c713ba2f6c0fe043c92575edba785cb6
-rw——- 1 jakets jakets 0 Dec 23 20:45 sess_c7401ef8ac00ef4816436f35b56c7a0b
-rw——- 1 jakets jakets 0 Dec 23 20:52 sess_c8373e7a2815108a801e0ff109249cf7
-rw——- 1 jakets jakets 33 Dec 23 20:45 sess_c9db9fb3365574bfe7596febfdbd50de
-rw——- 1 jakets jakets 0 Dec 23 20:48 sess_caea8e52143bf584e645d83a0776ae3f
-rw——- 1 jakets jakets 0 Dec 23 20:49 sess_d08e1e776efa59b79811e5b414e96e32
-rw——- 1 jakets jakets 0 Dec 23 20:49 sess_d1d4a51861ecd797063324a0d8547e56
-rw——- 1 jakets jakets 0 Dec 23 20:47 sess_d369fed65607f441d2d4ecc534c8c67a
-rw——- 1 jakets jakets 0 Dec 23 20:47 sess_d5c90d8116f72bd09b4672a653bff8a0
-rw——- 1 jakets jakets 0 Dec 23 20:45 sess_d6a71a8226d075ba79ca27445d3239a3
-rw——- 1 jakets jakets 0 Dec 23 20:51 sess_d8306a2cd31b420f7f58bf8e0c4a542b
Jake [9:53:33 PM]: what causes this, why wouldn’t they delete themselves?
Arkady [9:54:18 PM]: Your application shouldn’t create so much files, so it would be better to consult with application developers