Race condition in insert

Hello, I have the following snippet:

const { data: prompt, error } = await supabase
    .from("prompts")
    .insert({ name, description })
    .select("*")
    .single();
  if (error) {
    throw new Error(error.message);
  }
  const { data: version, error: versionError } = await supabase
    .from("prompt_versions")
    .insert({
      prompt_id: prompt.id,
      content,
    });
  if (versionError) {
    throw new Error(versionError.message);
  }
  return prompt;
}

const { data: prompt, error } = await supabase
    .from("prompts")
    .insert({ name, description })
    .select("*")
    .single();
  if (error) {
    throw new Error(error.message);
  }
  const { data: version, error: versionError } = await supabase
    .from("prompt_versions")
    .insert({
      prompt_id: prompt.id,
      content,
    });
  if (versionError) {
    throw new Error(versionError.message);
  }
  return prompt;
}

The important piece is to note that

prompt_id

prompt_id

on the

prompt_versions

prompt_versions

table is a foreign key to the

id

id

column of

prompts

prompts

.

About 1 times out of 10 I get an error inserting the prompt version that it violates the foreign key constraint because the prompt doesn't exist. The prompt is however inserted successfully, Given the flakiness of the error, I'm positive it's a race condition.

I'm thinking this shouldn't happen since the routine to insert the prompt completes successfully and is awaited. Please let me know if I'm missing something here.

Race condition in insert

Hello, I have the following snippet:

const { data: prompt, error } = await supabase
    .from("prompts")
    .insert({ name, description })
    .select("*")
    .single();
  if (error) {
    throw new Error(error.message);
  }
  const { data: version, error: versionError } = await supabase
    .from("prompt_versions")
    .insert({
      prompt_id: prompt.id,
      content,
    });
  if (versionError) {
    throw new Error(versionError.message);
  }
  return prompt;
}

const { data: prompt, error } = await supabase
    .from("prompts")
    .insert({ name, description })
    .select("*")
    .single();
  if (error) {
    throw new Error(error.message);
  }
  const { data: version, error: versionError } = await supabase
    .from("prompt_versions")
    .insert({
      prompt_id: prompt.id,
      content,
    });
  if (versionError) {
    throw new Error(versionError.message);
  }
  return prompt;
}

The important piece is to note that

prompt_id

prompt_id

on the

prompt_versions

prompt_versions

table is a foreign key to the

id

id

column of

prompts

prompts

Race condition in insert

Similar Threads

Race condition in insert

Similar Threads

Similar Threads

Similar Threads