mariadb locks

Posted by Roshan on Oct 02, 2023; 10:58am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/mariadb-locks-tp12077.html

Hello Erman,

deadlock was detected on a table on mariadb. We stopped/killed all sessions(same like oracle alter system kill session immediate...) on that table. still update showed locks on table(same like oracle).

But when we ran

SHOW ENGINE INNODB STATUS


no locks were displayed.

Why is this?
Thanks,
Roshan