Database Troubleshooting

Matching troubleshooting entries

• 42501 : permission denied for table http_request_queue

  42501

  Database

• All about Supabase Egress

  PlatformDatabaseFunctionsStorageRealtimeAuthSupavisor

• Auth error: '500: Database error querying schema'

  500

  AuthDatabase

  Aug 7

• Autovacuum Stalled Due to Inactive Replication Slot

  Database

• 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

• Disabling Prepared statements

  DatabaseSupavisor

• Discovering and Interpreting API Errors in the Logs

  DatabasePlatform

• Disk size not shrinking after deleting data

  DatabaseStorage

  Aug 7

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

  Database

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

  Database

• Enabling the IPv4 add-on FAQ

  DatabasePlatformSupavisor

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

  DatabaseCli

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

  Database

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

  CliDatabase

• 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

• Error: relation 'supabase_migrations.schema_migrations' does not exist

  CliDatabase

  Aug 7

• High swap usage

  DatabasePlatform

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

  Database

• Failed to retrieve tables

  DatabaseStudio

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

  500

  DatabaseStudio

• 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

• High latency with supabase client

  DatabasePlatform

• How can I revoke execution of a Postgres function?

  Database

• 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

• Manually created databases are not visible in the Supabase Dashboard

  Database

• Memory and Swap usage explained

  DatabasePlatform

• How to monitor Postgres and Supavisor connections

  DatabaseSupavisor

• NEW variable is null in a trigger function.

  Database

• 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

• PostgREST error: {PGRST002: Could not query the database for the schema cache}

  PGRST002

  Database

  Aug 7

• PostgREST not recognizing new columns, tables, views or functions

  PlatformDatabase

• PostgREST not recognizing the objects(tables/functions/views) in a schema even after adding it to the exposed schemas

  DatabasePlatform

  Aug 7

• PowerBI Service error: 'The remote certificate is invalid according to the validation procedure'

  AuthDatabaseStorage

  Aug 7

• Prisma Error Management

  Database

• Project Status reports unhealthy services

  DatabaseStudio

• Realtime: Handling Silent Disconnections in Background Applications

  CliDatabaseRealtime

• Reload/refresh postgrest schema

  400 bad_request

  Database

• Postgres error 'relation objects does not exist' during Storage uploads

  42P01, 500

  AuthDatabaseStorage

  Aug 7

• Resolving 42P01: relation does not exist error

  42P01, 42501

  Database

• Resolving 500 Status Authentication Errors

  500

  AuthDatabase

• Resolving 'cannot execute UPDATE in a read-only transaction' on transaction pooler connections

  DatabaseSupavisor

  Aug 7

• Resolving database hostname and managing your IP address

  Database

• RLS Performance and Best Practices

  AuthDatabase

• RLS Simplified

  DatabaseAuth

• Running EXPLAIN ANALYZE on functions

  Database

• schema "pg_pgrst_no_exposed_schemas" does not exist

  DatabasePlatform

  Aug 7

• 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

• Storage error: 403 Forbidden: 'new row violates row-level security policy' on upload

  403

  AuthDatabaseStorage

  Aug 7

• RLS policy causes infinite recursion

  DatabaseStorage

  Aug 7

• Supabase & Your Network: IPv4 and IPv6 compatibility

  DatabasePlatformSupavisor

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

  AuthCliDatabaseSupavisor

• Interpreting Supabase Grafana Memory Charts

  Database

• Supabase project provisioned via Bolt not visible in dashboard

  Database

• Supavisor and Connection Terminology Explained

  SupavisorDatabase

• Supavisor error: 'Circuit breaker open' after password rotation

  DatabaseSupavisor

  Aug 7

• Supavisor FAQ

  SupavisorDatabase

• Database: "Error: too many connections for database "postgres""

  Database

  Aug 7

• Identifying Dashboard SQL Editor Activity by User

  Database

  Aug 7

• Transfer edge functions from one project to another

  CliDatabaseFunctions

• Transferring from platform to self-hosted Supabase

  DatabaseSelf-hosting

• Troubleshooting 'CONNECT_TIMEOUT' or hanging queries in Serverless Functions

  CONNECT_TIMEOUT

  DatabaseFunctionsSupavisor

  Aug 7

• Understanding Postgres EXPLAIN Output

  Database

• Understanding Postgres Logging Levels and How They Impact Your Project

  Database

• Understanding the Usage Summary on the Dashboard

  PlatformStudioDatabaseFunctions

• Using SQLAlchemy with Supabase

  DatabaseSupavisorSelf-hosting

• 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

  AuthPlatformDatabaseRealtime

• 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