fix integrity errors issue by adding MySQL transaction isolation level

TNL-367