strapi-plugin-navigation: ER_LOCK_DEADLOCK: Deadlock found when trying to get lock; try restarting transaction
Hi team, i got this problem when using strapi 4.4.7 and 4.5.0, but do not now what is it. My db is: mariadb:10.7.3
UPDATE
navigations_localizations_links
as a,
(
SELECT id
, ROW_NUMBER() OVER (PARTITION BY navigation_id
ORDER BY navigation_order
) AS src_order
FROM navigations_localizations_links
WHERE navigation_id
= 1
) AS b
SET navigation_order
= b.src_order
WHERE b.id = a.id - ER_LOCK_DEADLOCK: Deadlock found when trying to get lock; try restarting transaction
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Reactions: 4
- Comments: 18 (3 by maintainers)
Thank you! I could reproduce too!