CODE EXAMPLE FOR SQL

was not locked with lock tables

If in one session, you locked one table but want to select from another table, you must either lock that table too or unlock all tables.