Strapi MYSQL Deadlock issue

Questions and Answers
1
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

Hello,

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

Single type collection 1 :

mainComponent

  • 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

Screenshot 2023-03-01 at 2.16.22 PM
Screenshot 2023-03-01 at 2.16.22 PM2966×456 297 KB

Can someone help me with this issue ?

Thank you.