error message that says mysql_real_escape_string() expects parameter 2....

[emanuele]

Error logs:
[...]
Then, my account suspended.

The hosting said that my account is getting high mysql activity,

The problem is that all the errors are the result of the high mysql activity, not the cause.
So:
(something) caused high mysql activity that caused multiple errors *and* account suspended.
NOT:
multiple errors caused high mysql activity that cause account suspended.

What mods do you have installed? (including code modifications you did by yourself if any)

[PokémonS]

Splitted into different topic: http://www.simplemachines.org/community/index.php?topic=491264.0

[SimpleJoe]

Thank you Arantor for the original fix. I just hope this has been implemented in 2.0.3, or if not then in the next release, no reason Subs-Db-mysql.php should go into some loop that quickly takes up gigabytes of log space.

[Arantor]

Considering that I posted this prior to 2.0 final, survey would suggest the answer is no.

Thing is, this is a set of circumstances that only seems to present on very heavily overladen servers...

[charlottezweb]

Thing is, this is a set of circumstances that only seems to present on very heavily overladen servers...

I would disagree with the use of the word "only" above.  I'm sure it's most often the case but I see it from time to time on servers way under capacity.

[Arantor]

I have not seen it present on anything other than shared servers. Load is not necessarily what you're calling load.

[charlottezweb]

I have not seen it present on anything other than shared servers. Load is not necessarily what you're calling load.

Fair enough but I wasn't referring to just load either.

[Arantor]

Here's the thing, what capacity are you referring to, exactly?

[charlottezweb]

I'm looking at it overall -- apache status vs. capacity, concurrrent users, mysql activity vs capacity, etc... 

I still haven't been able to wrap my head around how this occurs on a single smf install on a server when other smf installs on the same server (with equal or more activity) face no issues.

[SimpleJoe]

Speaking for the server where I saw it occur, the server load is usually about a .5 to 1.5 and there were other forums running with no issues. It's a cPanel Linux server with everything updated. The two forums I saw this occur on were getting a lot of spam-bot registrations at the time, so maybe that has something to do with it.

[Fiery]

I am running into this also, on a VPS.  tens of thousands of errors....

[Arantor]

And the fix is documented pages back...

Maybe it will be added to the next trunk version, will have to see.

[Fiery]

I was hoping it would get put into smf by default....

[Arantor]

Well, it hasn't thus far for whatever reason.

I have nudged the moderators about this, hopefully it'll get rolled in to the next version because while I still think it's a fringe case, it *is* happening more than before.

[emanuele]

It is already in 2.1...I think.

[Arantor]

It probably is, but I'm inclined to say it should be in 2.0.4 if/when that happens. I see no reason why the same thing couldn't conceivably happen to at least PGSQL either, though I should imagine SQLite would be theoretically immune to this particular bug.