Troubleshooting guides by topic

Supabase and databases

PostgreSQL, RLS, authentication, storage and database permissions.

77 English guides in this category

Supabase Storage: 409 Asset Already Exists during re-upload

The second upload of a file under the identical path returns the conflict instead of overwriting.

Read the solution

Supabase Storage: Bucket not found after changing the environment

The app tries to send a picture, but the bucket only exists at another instance.

Read the solution

Supabase Storage: CDN Shows an Outdated Image

The image under the same URL does not change immediately after saving a new version.

Read the solution

Supabase Storage: File Download 404 Caused by Case Sensitivity

The user sees the file name, but the download from its own path returns Not Found.

Read the solution

Supabase Storage: list() returns an empty folder despite saved files

The saved object can be downloaded on a known path, but the list does not show records.

Read the solution

Supabase Storage: MIME Type Not Allowed

The HEIC or PDF attachment is rejected before saving the file.

Read the solution

Supabase Storage: Resumable Upload Stops After Connection Loss

After the shipment is discontinued, the viewer starts the file again or reports a conflict.

Read the solution

Supabase Storage: Signed Upload URL Rejects the File

The client gets a signed address to upload, but the request cannot add a file.

Read the solution

Supabase Storage: Transform image returns error for HEIC

The attempt to generate a miniature from the photo ends with a refusal or an empty image.

Read the solution

Supabase Storage: Upload Exceeds File Size Limit

Loading a larger attachment ends with a size limit error.

Read the solution

Supabase Storage: user sees files of another folder

Storage policy allows you to read objects from the folder adjacent to the user folder.

Read the solution

Supabase upsert does not work: ON CONFLICT and no UNIQUE

Upsert errors in Supabase: unique key, onConflict, data conflicts and repeated webhooks.

Read the solution

Supabase Vault: a secret accessible by the public RPC

SQL returns private values from Vault to a public token client.

Read the solution

Supabase: Administrator sees record, user not — RLS diagnosis

How to compare SELECT roles and principles in the Supabase when the admin panel works and the sales representative's account shows voidness.

Read the solution

Supabase: DELETE does not remove the record, although it returns success

After clicking remove the item remains in the database, and the delete() request does not report an exception.

Read the solution

Supabase: INSERT Succeeds but SELECT Returns No Rows

Record saved, but invisible after refresh? Check separate INSERT and SELECT, Owner id and JWT policies.

Read the solution

Supabase: IPv4 Client Cannot Use Direct Database Connection

The driver outside the host reports a timeout at direct connection, even though the credentials are correct.

Read the solution

Supabase: new row Violates row-level security policy at INSERT

Trying to save a new record returns a row-level security policy error, although SELECT works.

Read the solution

Supabase: Password Recovery Opens Without a Session

Upon clicking the password change link, the page does not recognize recovery mode.

Read the solution

Supabase: Permission Denied for Schema public

The API request ends with a permission denied for scheme public, although RLS policies look correct.

Read the solution

Supabase: Refresh Token Expired — Troubleshooting

Diagnostic instruction regarding the situation when token refresh (refresh token) Supabase expired or is rejected. Includes a differential list of causes, specific tests and corrective steps, and methods of post-amendment performance verification.

Read the solution

Supabase: Restoring backup does not restore recent changes

Once the database has been recovered, some of the last records are absent.

Read the solution

Supabase: SELECT returns empty results despite valid authorization — RLS diagnostic

Analysis of the reasons why Row Level Security (RLS) in Supabase blocks SELECT queries despite the visible user session. It includes differentiation of rules, permission limits, verification of jwt and policies, and specific test steps for repair.

Read the solution

Supabase: signed file URL stops working — differentiation and repair

Signed URL with Supabase Storage ceases to work abruptly — causes include the link expired, changed bucket permissions, object removal, server time errors or CDN. Below is differential diagnosis and specific corrective steps.

Read the solution
All English guides
Supabase and databases — troubleshooting and solutions