Re: Mysql Deadlock explanation

[Akex Mythos]

Hi Rick.

Finally i found query that lock insert's.

It was update for closing older session.

Like this:

update session
set closed=now(),state_id=2 where id < 123456

And this update and insert was in one transaction.

I remove transaction wrap and now it work ok.