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)

Most upvoted comments

Thank you! I could reproduce too!