Database Troubleshooting

Matching troubleshooting entries

• 42501 : permission denied for table http_request_queue

  42501

  Database

• All about Supabase Egress

  PlatformDatabaseFunctionsStorageRealtimeAuthSupavisor

• Avoiding timeouts in long running queries

  DatabasePlatform

• Canceling statement due to "statement timeout"

  Database

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

  Database

• Change Project Region

  PlatformDatabaseAuth

• 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

• Database API 42501 errors

  401 42501, 403 42501

  Database

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

  Database

• Deprecated RLS features

  Database

  Feb 9

• Disabling Prepared statements

  DatabaseSupavisor

• Discovering and Interpreting API Errors in the Logs

  DatabasePlatform

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

  Database

  Feb 9

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

  Database

• Enabling the IPv4 add-on FAQ

  DatabasePlatformSupavisor

  Feb 9

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

  DatabaseCli

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

  Database

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

  DatabasePlatform

• Error: prepared statement "XXX" already exists

  Database

• High swap usage

  DatabasePlatform

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

  Database

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

  500

  DatabaseStudio

  Feb 9

• Fixing 520 Errors in the Database REST API

  520

  Database

• Grafana not displaying data

  Database

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

  CliDatabaseStorage

  Feb 9

• High latency with supabase client

  DatabasePlatform

• How can I revoke execution of a PostgreSQL function?

  DatabaseFunctions

• How do I reset my Supabase database password?

  Database

• How do I update connection pool settings in my dashboard?

  DatabaseSupavisor

• How long does it take to restore a database from a Point-in-Time backup (PITR)?

  Database

• How Postgres chooses which index to use

  Database

• How to change max database connections

  DatabaseSupavisorCli

• How to check if my queries are being blocked by other queries?

  Database

• How to delete a role in Postgres

  Database

• How to Interpret and Explore the Postgres Logs

  DatabasePlatform

• How to View Database Metrics

  DatabasePlatform

• Increase vector lookup speeds by applying an HSNW index

  DatabaseAiPlatform

• Inserting into Sequence/Serial Table Causes "duplicate key violates unique constraint" Error

  Database

• "insufficient privilege" when accessing pg_stat_statements

  Database

• Interpreting Supabase Grafana CPU charts

  PlatformDatabase

• Interpreting Supabase Grafana IO charts

  DatabasePlatform

• Memory and Swap usage explained

  DatabasePlatform

• How to monitor Postgres and Supavisor connections

  DatabaseSupavisor

• NEW variable is null in a trigger function.

  DatabaseFunctions

• Partitioning an existing table with same name

  Database

• pg_cron debugging guide

  Database

• PGRST106: "The schema must be one of the following..." error when querying an exposed schema

  PGRST106

  AuthDatabase

  Feb 9

• Prisma Error Management

  Database

• Project Status reports unhealthy services

  DatabaseStudio

  Feb 9

• Reload/refresh postgrest schema

  400 bad_request

  Database

• Resolving 42P01: relation does not exist error

  42P01, 42501

  Database

• Resolving 500 Status Authentication Errors

  500

  AuthDatabase

• Resolving database hostname and managing your IP address

  Database

• RLS Performance and Best Practices

  AuthDatabase

• RLS Simplified

  DatabaseAuth

• Seeing "no pg_hba.conf entry for host" errors in Postgres and they come from an IP address that I don't recognize

  DatabasePlatform

• Slow Execution of ALTER TABLE on Large Table when changing column type

  Database

• Steps to improve query performance with indexes

  DatabasePlatformCli

• Supabase & Your Network: IPv4 and IPv6 compatibility

  DatabasePlatformSupavisor

• Supabase CLI: "failed SASL auth" or "invalid SCRAM server-final-message"

  AuthCliDatabaseSupavisor

  Feb 9

• Interpreting Supabase Grafana Memory Charts

  Database

• Supavisor and Connection Terminology Explained

  SupavisorDatabase

• Supavisor FAQ

  SupavisorDatabase

• Transferring from cloud to self-host in Supabase

  DatabaseSelf-hosting

• Understanding PostgreSQL EXPLAIN Output

  Database

• Understanding PostgreSQL Logging Levels and How They Impact Your Project

  Database

• Understanding the Usage Summary on the Dashboard

  PlatformStudioDatabaseFunctions

• Using SQLAlchemy with Supabase

  DatabaseSupavisorSelf-hostingFunctions

• Webhook debugging guide

  Database

• Why are there gaps in my Postgres id sequence?

  Database

• Why do I see Auth & API requests in the dashboard? My app has no users

  AuthPlatformDatabaseRealtimeFunctions

• Why is my camelCase name not working in Postgres functions or RLS policies?

  Database

• Why is my select returning an empty data array and I have data in the table?

  DatabaseAuth

• Why is my service role key client getting RLS errors or not returning data?

  AuthDatabase