I've noticed this for a while now but I seem to get errors like this consistently when I post something:
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_bnbposts WHERE ID = '1094' LIMIT 1
WordPress database error: [MySQL client run out of memory]
SELECT * FROM wp_bnbposts WHERE ID = '1093' LIMIT 1
Now bearing in mind I have more than 3000 posts on this blog, I was leaning towards thinking that that might have something to do with it. Is this correct?
Is there something I can do to stop these errors? Incidentally, the post still gets posted...
What plugin do you have activated that uses a table named wp_bnbposts? That's not a "core" WP table.
Maybe worthwhile running a check (or repair) on your tables. Please backup your database before doing anything.
Another suggestion might be to approach your host to request a change to another server if the problem persists.
Pardon my dumb response! I'd guess that wp_bnb is your "prefix".
Sorry for the short delay in responding - yes the wp_bnb is our prefix, not sure why we did this but its too late to go back regardless.
What's your setup? Specifics please. The reason why I ask is it appears there was a recent "bug" with FreeBSD where the default open file handles limit was set too low. That might be what you're hitting.