Troubleshooting

Search or browse our troubleshooting guides for solutions to common Supabase issues.

42501 : permission denied for table http_request_queue
42501
Database
Apr 8
FDW Wrappers error: 'component verification failed'
HV000
Platform
Jul 24
All about Supabase Egress
PlatformDatabaseFunctionsStorageRealtimeAuthSupavisor
Apr 8
An "invalid response was received from the upstream server" error when querying auth
Auth
Apr 8
App Store Rejection: 'TLS error' in IPv6-only environments
Platform
Apr 8
Are all features available in self-hosted Supabase?
Self-hosting
May 14
Auth error: {401: invalid claim: missing sub}
401, 403
Auth
Apr 20
Auth error: '500: Database error querying schema'
500
AuthDatabase
Jul 24
Auth error: 503 AuthRetryableFetchError
503
Auth
Jul 24
Auth Hooks: 'Invalid payload' when anonymous users attempt phone changes
500
AuthCli
Apr 8
Autovacuum Stalled Due to Inactive Replication Slot
Database
Apr 8
Avoiding timeouts in long running queries
DatabasePlatform
Apr 8
Canceling statement due to "statement timeout"
Database
Apr 8
Can’t Access Supabase Project When Using Lovable Cloud
Ai
Jul 7
Certain operations are too complex to perform directly using the client libraries.
Database
Apr 21
Change email associated with Supabase account
PlatformAuth
Apr 8
Change Project Region
PlatformDatabaseAuth
Apr 29
Check usage for monthly active users (MAU)
AuthPlatform
Apr 30
'Cloudflare Origin Error 1016' on Custom Domain
1016
Platform
Apr 8
Converted GitHub account to organization / GitHub Account was deleted - Lost Supabase account access
Auth
Apr 8
Customizing Emails by Language
Auth
Apr 8
Errors when creating / updating / deleting users
500 unexpected_failure, 500 unexpected_failure, 500 unexpected_failure, 500 unexpected_failure, 500 unexpected_failure, 500 unexpected_failure, 500 unexpected_failure,
AuthDatabaseStudio
May 22
Database API 42501 errors
401 42501, 403 42501
Database
Apr 28
Database Error: remaining connection slots are reserved for non-replication superuser connections
Database
Apr 8
Database error saving new user
500 unexpected_failure, 500 unexpected_failure
AuthStudio
Jun 11
Deprecated RLS features
Database
Apr 8
Disabling Prepared statements
DatabaseSupavisor
Jun 29
Discovering and Interpreting API Errors in the Logs
DatabasePlatform
Jun 19
Disk size not shrinking after deleting data
DatabaseStorage
Jul 24
Do I need to expose "security definer" Functions in Row Level Security Policies?
Database
Apr 8
How to download logical backups in Supabase with physical backups enabled?
Database
Apr 8
Edge Function 401 error response
401
Functions
Jul 24
Edge Function 404 error response
404 NOT_FOUND
Functions
May 27
Edge Function 500 error response
500
Functions
Jul 24
Edge Function 503 error response
503 BOOT_ERROR
Functions
Jul 24
Edge Function 504 error response
504
Functions
Jul 24
546 - WORKER_RESOURCE_LIMIT Exceeded / WORKER_LIMIT Exceeded
546, 546
Functions
Jul 7
Edge Function bundle size issues
Functions
Jul 15
Understanding Edge Function CPU limits
Functions
Apr 8
Edge Function dependency analysis
Functions
Jun 29
Edge Function error: 'Rate limit exceeded for trace'
Functions
Jul 24
Edge Function deploy failed due to an internal error
500, 500
Functions
Apr 8
Monitoring Edge Function resource usage
Functions
Apr 8
Edge Function shutdown reasons explained
546,
Functions
Jun 29
Edge Function takes too long to respond
Functions
Apr 8
Edge Function 'wall clock time limit reached'
546
Functions
Jun 17
Edge Functions worker timeouts and WebSocket drops
Functions
Jul 24
Email/Password Login Disabled for Supabase Accounts Created via Vercel Marketplace
Auth
Apr 8
Email template not updating
templatemailer_template_body_parse_error
AuthStudio
Apr 8
Enabling the IPv4 add-on FAQ
DatabasePlatformSupavisor
Apr 8
Error: "Connection refused" when trying to connect to Supabase database
DatabaseCli
Apr 8
Error: index row size exceeds btree version 4 maximum for index
Database
Jun 29
Error: 'invalid byte sequence for encoding 'UTF8': 0x00' when accessing Triggers or Webhooks
CliDatabase
Apr 8
Error: "Invalid TOTP code entered"
Auth
Apr 8
error: no pg_hba.conf entry for host "xx.xxx.xxx.xxx", user "postgres", database "postgres", SSL off
DatabasePlatform
Apr 8
Error: prepared statement "XXX" already exists
Database
Apr 8
Error: relation 'supabase_migrations.schema_migrations' does not exist
CliDatabase
Jul 24
'Error: 'Target organization is not managed by Vercel Marketplace' during project transfer'
Platform
Apr 8
High Disk I/O
Platform
Jun 15
High RAM usage
Platform
Jun 15
High swap usage
DatabasePlatform
Jun 17
Failed to Fetch in dashboard and other areas -- browser extension
Studio
Apr 8
Failed to restore from backup: All subscriptions and replication slots must be dropped before a backup can be restored.
Database
Apr 8
Failed to retrieve tables
DatabaseStudio
Apr 8
Error: Failed to run sql query: Connection terminated due to connection timeout
500
DatabaseStudio
Apr 8
Fetch requests to API endpoints aren't showing the session
Auth
Apr 8
Fixing 520 Errors in the Database REST API
520
Database
Apr 8
Forbidden resource error from the CLI
403
CliPlatform
Apr 8
Get detailed Storage metrics with the AWS CLI
CliStorageStudio
Apr 8
Google Auth fails for some users
500 server_error, 401 UNAUTHENTICATED
Auth
Jun 8
Grafana not displaying data
Database
Apr 20
High CPU and Slow Queries with `ERROR: must be a superuser to terminate superuser process`
CliDatabaseStorage
Jun 29
High CPU usage
Platform
Jun 15
High latency with supabase client
DatabasePlatform
Jun 29
How can I revoke execution of a Postgres function?
Database
Apr 8
How do I check GoTrue/API version of a Supabase project?
AuthPlatform
Apr 20
How do I make the cookies HttpOnly?
Auth
Apr 8
How do I reset my Supabase database password?
Database
May 13
How do I update connection pool settings in my dashboard?
DatabaseSupavisor
Apr 8
How do you troubleshoot Next.js - Supabase Auth issues?
Auth
Apr 8
How long does it take to restore a database from a Point-in-Time backup (PITR)?
Database
Apr 8
How Postgres chooses which index to use
Database
Jun 29
How to bypass modification limits
Platform
Apr 8
How to change max database connections
DatabaseSupavisorCli
Jun 29
How to check if my queries are being blocked by other queries?
Database
Apr 8
How to delete a role in Postgres
Database
Apr 8
How to delete Vercel linked projects
Platform
Apr 8
How to Interpret and Explore the Postgres Logs
DatabasePlatform
Jun 29
How to Migrate from Supabase Auth Helpers to SSR package
Auth
Jun 17
How to View Database Metrics
DatabasePlatform
Jun 15
Diagnose HTTP API issues
5xx,
Platform
Jun 16
HTTP status codes
402, 540, 544, 546
Platform
Jun 15
I am not receiving password reset emails for Supabase dashboard
AuthPlatform
Apr 8
Identifying Lovable backend: Lovable Cloud or Supabase
Ai
Jul 7
Importing Stripe or other modules from esm.sh on Deno Edge Functions throws an error
Functions
Apr 8
Increase vector lookup speeds by applying an HSNW index
DatabaseAiPlatform
Jun 17
Inserting into Sequence/Serial Table Causes "duplicate key violates unique constraint" Error
Database
Jun 29
Inspecting edge function environment variables
FunctionsCli
Jun 29
"insufficient privilege" when accessing pg_stat_statements
Database
Apr 8
Interpreting Supabase Grafana CPU charts
PlatformDatabase
Jun 19
Interpreting Supabase Grafana IO charts
DatabasePlatform
Jun 29
Issues serving Edge Functions locally
FunctionsCli
Apr 8
"JWT Expired" Error in Supabase Dashboard
Studio
Apr 8
Keeping your 2 Free projects after upgrading to Pro
Platform
Jun 29
Kong stops responding under heavy load in local development
CliSelf-hostingStorage
Jul 24
Lost access/Forgot the MFA device
AuthPlatform
Apr 8
Managing GitHub Integration in Supabase Studio
Platform
Jul 24
Manually created databases are not visible in the Supabase Dashboard
Database
Jun 17
Memory and Swap usage explained
DatabasePlatform
Apr 8
Migrating Auth Users Between Supabase Projects
Auth
Apr 8
How to monitor Postgres and Supavisor connections
DatabaseSupavisor
Jun 15
Why are my Supabase branches empty?
Branching
Apr 8
NEW variable is null in a trigger function.
Database
Apr 8
Next.js 13/14 stale data when changing RLS or table data.
AuthPlatform
Apr 8
No toast messages on the Dashboard
Studio
Apr 8
Not receiving Auth emails from the Supabase project
AuthPlatform
Jun 29
OAuth sign in isn't redirecting on the server side
Auth
Jun 17
OTP Verification Failures: 'token has expired' or 'otp_expired' errors
403, otp_expired
AuthCli
Apr 8
Partitioning an existing table with same name
Database
Apr 8
Pausing Pro-Projects
PlatformCliStorage
Jun 29
Performing administration tasks on the server side with a secret key
AuthPlatform
Jun 17
`pg_cron launcher crashes with 'duplicate key value violates unique constraint'`
Platform
Apr 8
pg_cron debugging guide
Database
Jun 19
PGRST106: "The schema must be one of the following..." error when querying an exposed schema
PGRST106
AuthDatabase
Apr 8
PKCE Flow errors: 'cannot parse response' or '#ZgotmplZ' in magic link emails
#ZgotmplZ, cannot parse response
AuthCli
Jun 16
PostgREST error: 400 'column example_table.example_column does not exist' when using OR operators
400
PlatformApi
Jul 24
PostgREST error: {PGRST002: Could not query the database for the schema cache}
PGRST002
Database
Jul 24
PostgREST not recognizing new columns, tables, views or functions
PlatformDatabase
Apr 8
PostgREST not recognizing the objects(tables/functions/views) in a schema even after adding it to the exposed schemas
DatabasePlatform
Jul 24
PowerBI Service error: 'The remote certificate is invalid according to the validation procedure'
AuthDatabaseStorage
Jul 24
Prisma Error Management
Database
Jun 19
Project Status reports unhealthy services
DatabaseStudio
May 6
rclone error: 's3 protocol error: received listing v1 with IsTruncated set, no NextMarker and no Contents'
Storage
Apr 8
Realtime "Concurrent Peak Connections" quota
RealtimeSelf-hosting
Apr 8
Realtime connections giving `TIMED_OUT` errors
Realtime
Apr 8
Debug Realtime with Logger and Log Levels
Realtime
Apr 8
Realtime: Handling Silent Disconnections in Background Applications
CliDatabaseRealtime
Apr 8
Understanding and Monitoring Realtime Heartbeats
Realtime
Jun 16
Realtime: Project suspended for exceeding quotas
Realtime
Jun 18
Fixing the TooManyChannels Error
Realtime
Apr 8
Realtime: WarnSendingBroadcastMessage when broadcasting from the database
Realtime
Reload/refresh postgrest schema
400 bad_request
Database
Apr 8
Postgres error 'relation objects does not exist' during Storage uploads
42P01, 500
AuthDatabaseStorage
Jul 24
Resolving 42P01: relation does not exist error
42P01, 42501
Database
Jun 29
Resolving 500 Status Authentication Errors
500
AuthDatabase
Jun 29
Resolving 'cannot execute UPDATE in a read-only transaction' on transaction pooler connections
DatabaseSupavisor
Jul 24
Resolving database hostname and managing your IP address
Database
Apr 8
How To Restore a Project Paused for More Than 1 Year
Platform
Jul 24
RLS Performance and Best Practices
AuthDatabase
Jul 7
RLS Simplified
DatabaseAuth
Jun 17
Rotating Anon, Service, and JWT Secrets
AuthPlatform
Jun 29
Running EXPLAIN ANALYZE on functions
Database
Jun 29
'Scan error on column confirmation_token: converting NULL to string is unsupported' during Auth login
500
Auth
Apr 8
schema "pg_pgrst_no_exposed_schemas" does not exist
DatabasePlatform
Jul 24
Security of Anonymous Sign-ins
AuthPlatform
Jun 29
Seeing "no pg_hba.conf entry for host" errors in Postgres and they come from an IP address that I don't recognize
DatabasePlatform
Apr 8
Should I set a shorter Max-Age parameter on the cookies?
Auth
Apr 8
Slow Execution of ALTER TABLE on Large Table when changing column type
Database
Apr 8
Implementing soft deletes with supabase-js
Jun 29
SSO Error: "You do not have permissions to join this organization" or prompts to create new organization
Platform
Apr 8
Steps to improve query performance with indexes
DatabasePlatformCli
Jun 29
Storage error: 403 Forbidden: 'new row violates row-level security policy' on upload
403
AuthDatabaseStorage
Jul 24
RLS policy causes infinite recursion
DatabaseStorage
Jul 24
Supabase & Your Network: IPv4 and IPv6 compatibility
DatabasePlatformSupavisor
Jun 19
Supabase CLI: "failed SASL auth" or "invalid SCRAM server-final-message"
AuthCliDatabaseSupavisor
May 11
Supabase dashboard not loading/ Project not loading on dashboard
Studio
Apr 8
Interpreting Supabase Grafana Memory Charts
Database
Jun 29
Supabase project provisioned via Bolt not visible in dashboard
Database
Apr 8
Supabase Storage: Inefficient folder operations and hierarchical RLS challenges
Storage
Apr 8
Supavisor and Connection Terminology Explained
SupavisorDatabase
Jun 29
Supavisor error: 'Circuit breaker open' after password rotation
DatabaseSupavisor
Jul 24
Supavisor FAQ
SupavisorDatabase
Jun 29
Database: "Error: too many connections for database "postgres""
Database
Jul 24
Identifying Dashboard SQL Editor Activity by User
Database
Jul 24
Transfer edge functions from one project to another
CliDatabaseFunctions
Apr 8
Transferring from platform to self-hosted Supabase
DatabaseSelf-hosting
Apr 8
Troubleshooting 'CONNECT_TIMEOUT' or hanging queries in Serverless Functions
CONNECT_TIMEOUT
DatabaseFunctionsSupavisor
Jul 24
Unable to call Edge Function
Functions
Apr 8
Unable to deploy Edge Function
Functions
Apr 8
Understanding Postgres EXPLAIN Output
Database
Jun 29
Understanding Postgres Logging Levels and How They Impact Your Project
Database
Jun 29
Understanding the Usage Summary on the Dashboard
PlatformStudioDatabaseFunctions
Jun 29
`Unexpected behavior with 'auth.updateUser({ phone })': Phone linked to incorrect user ID`
Auth
Jul 24
UNUSED_EXTERNAL_IMPORT build warning with Vite, Rollup, or Nuxt
Platform
Apr 8
Upload file size restrictions
Storage
Apr 8
Using Google SMTP with Supabase Custom SMTP
AuthPlatform
Apr 28
Using SQLAlchemy with Supabase
DatabaseSupavisorSelf-hosting
Apr 8
Vercel Integration: Environment variables explained
Platform
Jul 24
Webhook debugging guide
Database
Jun 29
Why am I being redirected to the wrong url when using auth redirectTo option?
Auth
Apr 8
Why are there gaps in my Postgres id sequence?
Database
Apr 8
Why can't I upload/list/etc my public bucket?
Storage
Apr 8
Why do I see Auth & API requests in the dashboard? My app has no users
AuthPlatformDatabaseRealtime
Apr 8
Why is my camelCase name not working in Postgres functions or RLS policies?
Database
Apr 8
Why is my select returning an empty data array and I have data in the table?
DatabaseAuth
Jun 29
Why is my service role key client getting RLS errors or not returning data?
AuthDatabase
Apr 28
Why is my supabase API call not returning?
AuthPlatform
Apr 8
Why Supabase Edge Functions cannot provide static egress IPs for allow listing
AuthFunctionsPlatformSelf-hosting
Apr 8
Will backups be accessible from the dashboard immediately after upgrading to a paid plan?
Platform
Apr 8

Troubleshooting

Matching troubleshooting entries

42501 : permission denied for table http_request_queue

FDW Wrappers error: 'component verification failed'

All about Supabase Egress

An "invalid response was received from the upstream server" error when querying auth

App Store Rejection: 'TLS error' in IPv6-only environments

Are all features available in self-hosted Supabase?

Auth error: {401: invalid claim: missing sub}

Auth error: '500: Database error querying schema'

Auth error: 503 AuthRetryableFetchError

Auth Hooks: 'Invalid payload' when anonymous users attempt phone changes

Autovacuum Stalled Due to Inactive Replication Slot

Avoiding timeouts in long running queries

Canceling statement due to "statement timeout"

Can’t Access Supabase Project When Using Lovable Cloud

Certain operations are too complex to perform directly using the client libraries.

Change email associated with Supabase account

Change Project Region

Check usage for monthly active users (MAU)

'Cloudflare Origin Error 1016' on Custom Domain

Converted GitHub account to organization / GitHub Account was deleted - Lost Supabase account access

Customizing Emails by Language

Errors when creating / updating / deleting users

Database API 42501 errors

Database Error: remaining connection slots are reserved for non-replication superuser connections

Database error saving new user

Deprecated RLS features

Disabling Prepared statements

Discovering and Interpreting API Errors in the Logs

Disk size not shrinking after deleting data

Do I need to expose "security definer" Functions in Row Level Security Policies?

How to download logical backups in Supabase with physical backups enabled?

Edge Function 401 error response

Edge Function 404 error response

Edge Function 500 error response

Edge Function 503 error response

Edge Function 504 error response

546 - WORKER_RESOURCE_LIMIT Exceeded / WORKER_LIMIT Exceeded

Edge Function bundle size issues

Understanding Edge Function CPU limits

Edge Function dependency analysis

Edge Function error: 'Rate limit exceeded for trace'

Edge Function deploy failed due to an internal error

Monitoring Edge Function resource usage

Edge Function shutdown reasons explained

Edge Function takes too long to respond

Edge Function 'wall clock time limit reached'

Edge Functions worker timeouts and WebSocket drops

Email/Password Login Disabled for Supabase Accounts Created via Vercel Marketplace

Email template not updating

Enabling the IPv4 add-on FAQ

Error: "Connection refused" when trying to connect to Supabase database

Error: index row size exceeds btree version 4 maximum for index

Error: 'invalid byte sequence for encoding 'UTF8': 0x00' when accessing Triggers or Webhooks

Error: "Invalid TOTP code entered"

error: no pg_hba.conf entry for host "xx.xxx.xxx.xxx", user "postgres", database "postgres", SSL off

Error: prepared statement "XXX" already exists

Error: relation 'supabase_migrations.schema_migrations' does not exist

'Error: 'Target organization is not managed by Vercel Marketplace' during project transfer'

High Disk I/O

High RAM usage

High swap usage

Failed to Fetch in dashboard and other areas -- browser extension

Failed to restore from backup: All subscriptions and replication slots must be dropped before a backup can be restored.

Failed to retrieve tables

Error: Failed to run sql query: Connection terminated due to connection timeout

Fetch requests to API endpoints aren't showing the session

Fixing 520 Errors in the Database REST API

Forbidden resource error from the CLI

Get detailed Storage metrics with the AWS CLI

Google Auth fails for some users

Grafana not displaying data

High CPU and Slow Queries with `ERROR: must be a superuser to terminate superuser process`

High CPU usage

High latency with supabase client

How can I revoke execution of a Postgres function?

How do I check GoTrue/API version of a Supabase project?

How do I make the cookies HttpOnly?

How do I reset my Supabase database password?