When selecting with a shared lock, e.g. Entity::find().lock_shared(), the generated query looks like SELECT ... FROM ... FOR SHARE, but MariaDB only supports the syntax SELECT ... FROM ... LOCK IN SHARE MODE (see https://mariadb.com/kb/en/select/). This is basically the old syntax for MySQL, so this issue might also occur with an old MySQL server. The current MySQL version supports both variants.
When selecting with a shared lock, e.g.
Entity::find().lock_shared()
, the generated query looks likeSELECT ... FROM ... FOR SHARE
, but MariaDB only supports the syntaxSELECT ... FROM ... LOCK IN SHARE MODE
(see https://mariadb.com/kb/en/select/). This is basically the old syntax for MySQL, so this issue might also occur with an old MySQL server. The current MySQL version supports both variants.