How to fix StorageApiError: resource_already_exists in Supabase

const { data, error } = await supabase.storage
  .from('bucket-name')
  .upload('path/to/file.jpg', file, {
    upsert: true  // Allows overwriting existing files
  });

if (error) {
  console.error('Upload error:', error.message);
} else {
  console.log('File uploaded successfully:', data);
}

const filePath = 'path/to/file.jpg';

// List files to check if it exists
const { data: existingFiles, error: listError } = await supabase.storage
  .from('bucket-name')
  .list('path/to');

if (listError) {
  console.error('List error:', listError.message);
  return;
}

const fileExists = existingFiles.some(f => f.name === 'file.jpg');

if (fileExists) {
  // Delete the old file first
  const { error: deleteError } = await supabase.storage
    .from('bucket-name')
    .remove([filePath]);
  
  if (deleteError) {
    console.error('Delete error:', deleteError.message);
    return;
  }
}

// Now upload the new file
const { data, error } = await supabase.storage
  .from('bucket-name')
  .upload(filePath, file);

if (error) {
  console.error('Upload error:', error.message);
} else {
  console.log('File uploaded:', data);
}

import { v4 as uuidv4 } from 'uuid';

const originalFileName = file.name;
const timestamp = new Date().getTime();
const fileExtension = originalFileName.split('.').pop();

// Option 1: Timestamp-based
const uniquePath = `uploads/${timestamp}-${originalFileName}`;

// Option 2: UUID-based (recommended)
const uniqueId = uuidv4();
const uniquePath = `uploads/${uniqueId}.${fileExtension}`;

const { data, error } = await supabase.storage
  .from('bucket-name')
  .upload(uniquePath, file);  // No upsert needed, path is always unique

if (error) {
  console.error('Upload error:', error.message);
} else {
  console.log('File uploaded:', data);
  return uniquePath;  // Return the unique path for storage
}

-- In Supabase SQL Editor, add an UPDATE policy
create policy "Allow users to update their own files"
on storage.objects
for update
to authenticated
using ( auth.uid()::text = owner_id )
with check ( auth.uid()::text = owner_id );

-- Or for development (allow all - be careful in production)
create policy "Allow upsert for all users"
on storage.objects
for update
using ( true )
with check ( true );

async function uploadWithDebug(bucketName, filePath, file) {
  console.log(`Attempting upload to: ${bucketName}/${filePath}`);
  
  const { data, error } = await supabase.storage
    .from(bucketName)
    .upload(filePath, file, {
      upsert: false  // Set to false to see if file exists
    });

  if (error) {
    console.error('Upload failed:', {
      message: error.message,
      status: error.status,
      statusCode: error.statusCode,
      cause: error.cause
    });
    
    // Check if it's specifically the "resource already exists" error
    if (error.message.includes('resource_already_exists') || error.status === 409) {
      console.log('File already exists at this path. Retry with upsert: true');
      
      // Retry with upsert
      const { data: retryData, error: retryError } = await supabase.storage
        .from(bucketName)
        .upload(filePath, file, {
          upsert: true
        });
      
      if (retryError) {
        console.error('Upsert also failed:', retryError);
      } else {
        console.log('File upserted successfully:', retryData);
        return retryData;
      }
    }
  } else {
    console.log('File uploaded successfully:', data);
    return data;
  }
}