添加链接
link管理
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement . We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account
  • We found some unexpected return from Strapi which return Internal Errors
  • After check logs we found that our database (AWS-RDS) trigger ER_LOCK_DEADLOCK: Deadlock
  • Steps to reproduce the behavior

  • Create Single type
  •   "collectionName": "components_campaign_hero_carousels",
      "info": {
        "displayName": "HeroCarousel",
        "description": ""
      "options": {},
      "attributes": {
        "name": {
          "type": "string",
          "required": true
        "remark": {
          "type": "text",
          "private": true
        "actionLink": {
          "type": "enumeration",
          "enum": [
            "URL",
            "Component"
          "required": true,
          "default": "URL"
        "urlLink": {
          "type": "string"
        "activeOn": {
          "type": "datetime",
          "required": true
        "expiresAt": {
          "type": "datetime",
          "required": true
        "imageWeb": {
          "type": "media",
          "multiple": false,
          "required": true,
          "allowedTypes": [
            "images"
        "imageMobile": {
          "type": "media",
          "multiple": false,
          "required": true,
          "allowedTypes": [
            "images"
    
  • Fill data from Content Manager 3-4 row
  • Try to save data
  • Edit of change sequence and try to save again
  • Strapi Can't save and return 500, I found log in system
  • [2023-01-10 07:30:37.881] [31merror[39m: delete from `files_related_morphs` where (`related_id` = 34 and `related_type` = ‘campaign.hero-carousel’ and `field` = ‘imageWeb’) - ER_LOCK_DEADLOCK: Deadlock found when trying to get lock; try restarting transaction
    

    Expected behavior

    It should not trigger any ER_LOCK_DEADLOCK

    Screenshots

    Additional context

  • We use ECS as our cluster with running 2 tasks
  • We use RDS as our database with running on MySQL 8.0
  • Hello :) Thank you for the report and the steps to reproduce ! It's a known issue since #15202. We already released multiple fixes but they seem to not have been enough. We are working on a more solid fix that I hope will be released for the next release :)
    If it's ok for you I'll close this issue in favor of #15202 :)