Lock wait timeout exceeded: How to solve?

[eluser]gh0st[/eluser]
Hi there.

Thanks for your answer. I am using the CI sessions in Database mode. The live site does not appear to have a problem, and it only ever seems to affect my local version.

The data being stored isn't big, I'm just using it to store the CI sessions.

If it only affects local it may not be a big issue, but if it is affecting live sites it throws the whole question of whether databases can be used to store CI sessions.

I will review the situation and if there is an issue I will resolve it, but if there's another way around it that'd be great!