[MDEV-25039] MDL BF-BF conflict because of foreign key Created: 2021-03-03  Updated: 2023-02-01

Status: Open
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Seppo Jaakola
Resolution: Unresolved Votes: 0
Labels: None


 Description   


 Comments   
Comment by Yanjun Wu [ 2022-05-23 ]

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

Comment by Mario Karuza (Inactive) [ 2022-05-24 ]

HI Yanjun,

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

Generated at Thu Feb 08 09:34:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.