I have three blogs that I just upgraded to 2.01 this weekend and everything worked fine for 2 days then yesterday on 2 of my blogs I started getting this error WordPress database error: [MySQL client run out of memory] when editing or inserting a new post.
All are the same except for the themes more or less and have the same plugins. The major difference is that the 2 that are displaying this problem have 7000+ and 10,000+ records in wp_posts.
What I am trying to determine is if this is a wordpress problem or a host/mysql problem. Has anyone else seen this?
This is the error I get (and for the life of me I can't figure out why there are so many select statements)
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2635' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2634' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2633' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2632' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2631' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2630' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2629' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2628' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2627' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2626' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2625' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2624' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2623' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2622' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2621' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2620' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2619' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_posts WHERE ID = '2618' LIMIT 1