How to fix email_conflict_identity_not_deletable: Cannot delete identity because of email conflict in Supabase

const { data: { user }, error } = await supabase.auth.getUser();

if (user?.identities) {
  user.identities.forEach(identity => {
    console.log(`Provider: ${identity.provider}`);
    console.log(`Identity ID: ${identity.id}`);
    console.log(`Email: ${identity.email || 'No email'}`);
    console.log(`Identity data:`, identity);
  });
}

// Also check the user's primary email
console.log(`Primary email: ${user?.email}`);

// Using the Admin API (requires service_role key)
import { createClient } from "@supabase/supabase-js";

const adminClient = createClient(
  process.env.SUPABASE_URL,
  process.env.SUPABASE_SERVICE_ROLE_KEY
);

const { data: users } = await adminClient.auth.admin.listUsers();
const conflictUser = users.find(u => u.email === '[email protected]');
console.log('User with conflicting email:', conflictUser);

// Option A: Update your current user's email to something unique
const { data, error } = await supabase.auth.updateUser({
  email: '[email protected]'
});

if (error) {
  console.error('Error updating email:', error);
} else {
  console.log('Email updated successfully');
  // User will receive a confirmation email
}

// Option B: If you have admin access, update the other user
const adminClient = createClient(
  process.env.SUPABASE_URL,
  process.env.SUPABASE_SERVICE_ROLE_KEY
);

await adminClient.auth.admin.updateUserById('other-user-id', {
  email: '[email protected]'
});

const { data, error } = await supabase.auth.unlinkIdentity({
  identity_id: 'identity-to-unlink'
});

if (error) {
  if (error.message.includes('email_conflict_identity_not_deletable')) {
    console.error('Email conflict still exists. Verify all emails are unique.');
  } else {
    console.error('Different error occurred:', error);
  }
} else {
  console.log('Identity unlinked successfully');
  // Refresh user data
  const { data: { user: updatedUser } } = await supabase.auth.getUser();
  console.log('Updated user identities:', updatedUser?.identities);
}

// Using Admin API
const adminClient = createClient(
  process.env.SUPABASE_URL,
  process.env.SUPABASE_SERVICE_ROLE_KEY
);

// 1. Identify both user accounts
const user1Id = 'primary-account-id';
const user2Id = 'secondary-account-id';

// 2. Migrate any data from user2 to user1 in your custom tables
await supabase
  .from('user_profiles')
  .update({ user_id: user1Id })
  .eq('user_id', user2Id);

await supabase
  .from('user_posts')
  .update({ user_id: user1Id })
  .eq('user_id', user2Id);

// 3. Delete the secondary account
await adminClient.auth.admin.deleteUser(user2Id);

console.log('Account migration completed');