delta/mariadb-git.git/mysql-test/t/udf_debug_sync.test, branch 10.2-merge github.com: MariaDB/server.git MDEV-5616 - Deadlock between CREATE/DROP FUNCTION and SELECT from view 2014-02-13T12:41:08+00:00 Sergey Vojtovich svoj@mariadb.org 2014-02-13T12:41:08+00:00 e2a99f1863a7a4d5d6d22c9f39de3b255c959f98 Deadlock happened due to mixed lock order. CREATE/DROP function: wrlock(THR_LOCK_udf) -> lock(LOCK_open) SELECT from view: lock(LOCK_open) -> rdlock(THR_LOCK_udf) Fixed CREATE/DROP function so that LOCK_open does not intersect with wrlock(THR_LOCK_udf). 10.0 is not affected: it doesn't hold LOCK_open while opening view. 
Deadlock happened due to mixed lock order.
CREATE/DROP function: wrlock(THR_LOCK_udf) -> lock(LOCK_open)
SELECT from view: lock(LOCK_open) -> rdlock(THR_LOCK_udf)

Fixed CREATE/DROP function so that LOCK_open does not intersect with
wrlock(THR_LOCK_udf).

10.0 is not affected: it doesn't hold LOCK_open while opening view.