why I can't find locked table?
Your queries are equivalent to the following:

UNLOCK TABLES;
lock tables hive.NEXT_COMPACTION_QUEUE_ID write;
UNLOCK TABLES;
lock tables hive.NEXT_LOCK_ID write;
UNLOCK TABLES;
lock tables hive.NEXT_TXN_ID write;



  LOCK TABLES implicitly releases any table locks held by the current session before acquiring new locks.
  
  &mdash;&nbsp;http://dev.mysql.com/doc/refman/5.7/en/lock-tables.html


The correct way to lock multiple tables is in a single statement:

lock tables hive.NEXT_COMPACTION_QUEUE_ID write,
            hive.NEXT_LOCK_ID write,
            hive.NEXT_TXN_ID write;