Database

Database Troubleshooting

Search or browse troubleshooting guides for common database issues, including connection problems, query optimization, and configuration.

42501 : permission denied for table http_request_queue
42501
Database
Sep 9, 2025
All about Supabase Egress
PlatformDatabaseFunctionsStorageRealtimeAuthSupavisor
Nov 18, 2025
Avoiding timeouts in long running queries
DatabasePlatform
Oct 30, 2025
Canceling statement due to "statement timeout"
Database
Sep 16, 2025
Certain operations are too complex to perform directly using the client libraries.
Database
Sep 9, 2025
Change Project Region
PlatformDatabaseAuth
Mar 12, 2025
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
Nov 10, 2025
Database API 42501 errors
401 42501, 403 42501
Database
Sep 9, 2025
Database Error: remaining connection slots are reserved for non-replication superuser connections
Database
Jan 18, 2025
Deprecated RLS features
Database
Jan 22
Disabling Prepared statements
DatabaseSupavisor
Feb 4, 2025
Discovering and Interpreting API Errors in the Logs
DatabasePlatform
Sep 9, 2025
Do I need to expose "security definer" Functions in Row Level Security Policies?
Database
Jan 22
How to download logical backups in Supabase with physical backups enabled?
Database
Nov 27, 2025
Enabling the IPv4 add-on FAQ
DatabasePlatformSupavisor
Jan 22
Error: "Connection refused" when trying to connect to Supabase database
DatabaseCli
Sep 9, 2025
Error: index row size exceeds btree version 4 maximum for index
Database
Dec 4, 2025
error: no pg_hba.conf entry for host "xx.xxx.xxx.xxx", user "postgres", database "postgres", SSL off
DatabasePlatform
Sep 9, 2025
Error: prepared statement "XXX" already exists
Database
Jan 17, 2025
High swap usage
DatabasePlatform
Jan 20
Failed to restore from backup: All subscriptions and replication slots must be dropped before a backup can be restored.
Database
Jan 18, 2025
Error: Failed to run sql query: Connection terminated due to connection timeout
500
DatabaseStudio
Jan 17
Fixing 520 Errors in the Database REST API
520
Database
Sep 9, 2025
Grafana not displaying data
Database
Sep 9, 2025
High CPU and Slow Queries with `ERROR: must be a superuser to terminate superuser process`
CliDatabaseStorage
Nov 4, 2025
High latency with supabase client
DatabasePlatform
Feb 4, 2025
How can I revoke execution of a PostgreSQL function?
DatabaseFunctions
Jan 17, 2025
How do I reset my Supabase database password?
Database
Sep 9, 2025
How do I update connection pool settings in my dashboard?
DatabaseSupavisor
Sep 9, 2025
How long does it take to restore a database from a Point-in-Time backup (PITR)?
Database
Jan 18, 2025
How Postgres chooses which index to use
Database
Feb 21, 2025
How to change max database connections
DatabaseSupavisorCli
Sep 9, 2025
How to check if my queries are being blocked by other queries?
Database
Jan 17, 2025
How to delete a role in Postgres
Database
Sep 9, 2025
How to Interpret and Explore the Postgres Logs
DatabasePlatform
Sep 9, 2025
How to View Database Metrics
DatabasePlatform
Nov 18, 2025
Increase vector lookup speeds by applying an HSNW index
DatabaseAiPlatform
Oct 30, 2025
Inserting into Sequence/Serial Table Causes "duplicate key violates unique constraint" Error
Database
Sep 9, 2025
"insufficient privilege" when accessing pg_stat_statements
Database
Sep 16, 2025
Interpreting Supabase Grafana CPU charts
PlatformDatabase
Sep 9, 2025
Interpreting Supabase Grafana IO charts
DatabasePlatform
Sep 9, 2025
Memory and Swap usage explained
DatabasePlatform
Feb 4, 2025
How to monitor Postgres and Supavisor connections
DatabaseSupavisor
Nov 18, 2025
NEW variable is null in a trigger function.
DatabaseFunctions
Jan 16, 2025
Partitioning an existing table with same name
Database
Feb 4, 2025
pg_cron debugging guide
Database
Nov 18, 2025
PGRST106: "The schema must be one of the following..." error when querying an exposed schema
PGRST106
AuthDatabase
Nov 4, 2025
Prisma Error Management
Database
Sep 9, 2025
Project Status reports unhealthy services
DatabaseStudio
Nov 16, 2025
Realtime: Handling Silent Disconnections in Background Applications
CliDatabaseRealtime
Jan 22
Reload/refresh postgrest schema
400 bad_request
Database
Oct 15, 2025
Resolving 42P01: relation does not exist error
42P01, 42501
Database
Sep 9, 2025
Resolving 500 Status Authentication Errors
500
AuthDatabase
Sep 9, 2025
Resolving database hostname and managing your IP address
Database
Sep 9, 2025
RLS Performance and Best Practices
AuthDatabase
Apr 4, 2025
RLS Simplified
DatabaseAuth
Feb 21, 2025
Running EXPLAIN ANALYZE on functions
DatabaseFunctions
Jan 22
Seeing "no pg_hba.conf entry for host" errors in Postgres and they come from an IP address that I don't recognize
DatabasePlatform
Feb 4, 2025
Slow Execution of ALTER TABLE on Large Table when changing column type
Database
Sep 9, 2025
Steps to improve query performance with indexes
DatabasePlatformCli
Nov 18, 2025
Supabase & Your Network: IPv4 and IPv6 compatibility
DatabasePlatformSupavisor
Sep 9, 2025
Supabase CLI: "failed SASL auth" or "invalid SCRAM server-final-message"
AuthCliDatabaseSupavisor
Nov 4, 2025
Interpreting Supabase Grafana Memory Charts
Database
Nov 28, 2025
'Supabase project provisioned via Bolt not visible in dashboard'
Database
Jan 22
Supavisor and Connection Terminology Explained
SupavisorDatabase
Feb 4, 2025
Supavisor FAQ
SupavisorDatabase
Oct 30, 2025
Transfer edge functions from one project to another
CliDatabaseFunctions
Jan 22
Transferring from cloud to self-host in Supabase
DatabaseSelf-hosting
Jan 15, 2025
Understanding PostgreSQL EXPLAIN Output
Database
Sep 9, 2025
Understanding PostgreSQL Logging Levels and How They Impact Your Project
Database
Sep 9, 2025
Understanding the Usage Summary on the Dashboard
PlatformStudioDatabaseFunctions
Sep 9, 2025
Using SQLAlchemy with Supabase
DatabaseSupavisorSelf-hostingFunctions
Oct 30, 2025
Webhook debugging guide
Database
Sep 9, 2025
Why are there gaps in my Postgres id sequence?
Database
Feb 21, 2025
Why do I see Auth & API requests in the dashboard? My app has no users
AuthPlatformDatabaseRealtimeFunctions
Feb 4, 2025
Why is my camelCase name not working in Postgres functions or RLS policies?
Database
Jan 15, 2025
Why is my select returning an empty data array and I have data in the table?
DatabaseAuth
Feb 21, 2025
Why is my service role key client getting RLS errors or not returning data?
AuthDatabase
Feb 4, 2025