Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-25039

MDL BF-BF conflict because of foreign key

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4(EOL)
    • 10.4(EOL)
    • Galera, Tests
    • None

    Description

      Attachments

        Activity

          wadewds Yanjun Wu added a comment -

          My environment has the same problem.Log info:

          我的标题

          2022-05-20 16:39:15 13 [Note] WSREP: MDL BF-BF conflict
          schema: placement
          request: (13 seqno 4835 wsrep (toi, exec, committed) cmd 0 2 CREATE INDEX resource_provider_traits_resource_provider_trait_idx ON resource_provider_traits (resource_provider_id, trait_id))
          granted: (14 seqno 4836 wsrep (high priority, exec, executing) cmd 0 161 INSERT INTO traits (created_at, name) VALUES ('2022-05-20 08:39:14.189107', 'VGPU_NVIDIA_EQUAL_SHARE'),('2022-05-20 08:39:14.189114', 'HW_CPU_X86_AVX512ER'),('2022-05-20 08:39:14.189116', 'HW_NIC_OFFLOAD_RX'),('2022-05-20 08:39:14.189119', 'HW_CPU_X86_AESNI'),('2022-05-20 08:39:14.189121', 'HW_GPU_RESOLUTION_W3840H2160'),('2022-05-20 08:39:14.189123', 'COMPUTE_ACCELERATORS'),('2022-05-20 08:39:14.189125', 'HW_GPU_API_DIRECT3D_V9_0L'),('2022-05-20 08:39:14.189127', 'HW_GPU_API_OPENGL_V3_0'),('2022-05-20 08:39:14.189129', 'VNPU_CAMBRICON_VMLU270_S4_8G'),('2022-05-20 08:39:14.189132', 'HW_CPU_X86_AVX512VBMI2'),('2022-05-20 08:39:14.189134', 'HW_CPU_X86_INTEL_PCID'),('2022-05-20 08:39:14.189136', 'HW_NIC_
          2022-05-20 16:39:15 13 [ERROR] Aborting

          wadewds Yanjun Wu added a comment - My environment has the same problem.Log info: 我的标题 2022-05-20 16:39:15 13 [Note] WSREP: MDL BF-BF conflict schema: placement request: (13 seqno 4835 wsrep (toi, exec, committed) cmd 0 2 CREATE INDEX resource_provider_traits_resource_provider_trait_idx ON resource_provider_traits (resource_provider_id, trait_id)) granted: (14 seqno 4836 wsrep (high priority, exec, executing) cmd 0 161 INSERT INTO traits (created_at, name) VALUES ('2022-05-20 08:39:14.189107', 'VGPU_NVIDIA_EQUAL_SHARE'),('2022-05-20 08:39:14.189114', 'HW_CPU_X86_AVX512ER'),('2022-05-20 08:39:14.189116', 'HW_NIC_OFFLOAD_RX'),('2022-05-20 08:39:14.189119', 'HW_CPU_X86_AESNI'),('2022-05-20 08:39:14.189121', 'HW_GPU_RESOLUTION_W3840H2160'),('2022-05-20 08:39:14.189123', 'COMPUTE_ACCELERATORS'),('2022-05-20 08:39:14.189125', 'HW_GPU_API_DIRECT3D_V9_0L'),('2022-05-20 08:39:14.189127', 'HW_GPU_API_OPENGL_V3_0'),('2022-05-20 08:39:14.189129', 'VNPU_CAMBRICON_VMLU270_S4_8G'),('2022-05-20 08:39:14.189132', 'HW_CPU_X86_AVX512VBMI2'),('2022-05-20 08:39:14.189134', 'HW_CPU_X86_INTEL_PCID'),('2022-05-20 08:39:14.189136', 'HW_NIC_ 2022-05-20 16:39:15 13 [ERROR] Aborting

          HI Yanjun,

          Can you provide information how tables `resource_provider_traits` and `traits` are defined ?

          mkaruza Mario Karuza (Inactive) added a comment - HI Yanjun, Can you provide information how tables `resource_provider_traits` and `traits` are defined ?

          People

            seppo Seppo Jaakola
            jplindst Jan Lindström (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.