Strapi MYSQL Deadlock issue

System Information
  • Strapi Version: 4.3.8
  • Operating System: MAC Monterey
  • Database: MYSQL
  • Node Version: 14.19.0
  • NPM Version: 6.14.16
  • Yarn Version: NA


I have created two single type collection in Strapi which fields as mentioned below

Single type collection 1 :


  • subcomponent1
    • rich text field
  • subcomponent2
    • rich text field1
    • rich text field2
  • subcomponent3
    • title
    • enum

Single type collection 2 is also using the same component with same structure mentioned above.

While adding content to these single type collection I am getting an error for Deadlock in MYSQL database.
Error : deadlock found when trying to get lock; try restarting transaction in mysql

Can someone help me with this issue ?

Thank you.