Database Troubleshooting

Matching troubleshooting entries

• 42501 : permission denied for table http_request_queue

  42501

  Database

  Apr 8

• All about Supabase Egress

  PlatformDatabaseFunctionsStorageRealtimeAuthSupavisor

  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

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

  Database

  Apr 8

• Change Project Region

  PlatformDatabaseAuth

  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

  Apr 8

• Database API 42501 errors

  401 42501, 403 42501

  Database

  Apr 8

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

  Database

  Apr 8

• Deprecated RLS features

  Database

  Apr 8

• Disabling Prepared statements

  DatabaseSupavisor

  Apr 8

• Discovering and Interpreting API Errors in the Logs

  DatabasePlatform

  Apr 8

• 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

• 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

  Apr 8

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

  CliDatabase

  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

• High swap usage

  DatabasePlatform

  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

• Fixing 520 Errors in the Database REST API

  520

  Database

  Apr 8

• Grafana not displaying data

  Database

  Apr 8

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

  CliDatabaseStorage

  Apr 8

• High latency with supabase client

  DatabasePlatform

  Apr 8

• How can I revoke execution of a Postgres function?

  Database

  Apr 8

• How do I reset my Supabase database password?

  Database

  Apr 8

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

  DatabaseSupavisor

  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

  Apr 8

• How to change max database connections

  DatabaseSupavisorCli

  Apr 8

• 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 Interpret and Explore the Postgres Logs

  DatabasePlatform

  Apr 8

• How to View Database Metrics

  DatabasePlatform

  Apr 8

• Increase vector lookup speeds by applying an HSNW index

  DatabaseAiPlatform

  Apr 8

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

  Database

  Apr 8

• "insufficient privilege" when accessing pg_stat_statements

  Database

  Apr 8

• Interpreting Supabase Grafana CPU charts

  PlatformDatabase

  Apr 8

• Interpreting Supabase Grafana IO charts

  DatabasePlatform

  Apr 8

• 'Manually created databases are not visible in the Supabase Dashboard'

  Database

  Apr 8

• Memory and Swap usage explained

  DatabasePlatform

  Apr 8

• How to monitor Postgres and Supavisor connections

  DatabaseSupavisor

  Apr 8

• NEW variable is null in a trigger function.

  Database

  Apr 8

• Partitioning an existing table with same name

  Database

  Apr 8

• pg_cron debugging guide

  Database

  Apr 8

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

  PGRST106

  AuthDatabase

  Apr 8

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

  PlatformDatabase

  Apr 8

• Prisma Error Management

  Database

  Apr 8

• Project Status reports unhealthy services

  DatabaseStudio

  Apr 8

• Realtime: Handling Silent Disconnections in Background Applications

  CliDatabaseRealtime

  Apr 8

• Reload/refresh postgrest schema

  400 bad_request

  Database

  Apr 8

• Resolving 42P01: relation does not exist error

  42P01, 42501

  Database

  Apr 8

• Resolving 500 Status Authentication Errors

  500

  AuthDatabase

  Apr 8

• Resolving database hostname and managing your IP address

  Database

  Apr 8

• RLS Performance and Best Practices

  AuthDatabase

  Apr 8

• RLS Simplified

  DatabaseAuth

  Apr 8

• Running EXPLAIN ANALYZE on functions

  Database

  Apr 8

• 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

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

  Database

  Apr 8

• Steps to improve query performance with indexes

  DatabasePlatformCli

  Apr 8

• Supabase & Your Network: IPv4 and IPv6 compatibility

  DatabasePlatformSupavisor

  Apr 8

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

  AuthCliDatabaseSupavisor

  Apr 8

• Interpreting Supabase Grafana Memory Charts

  Database

  Apr 8

• 'Supabase project provisioned via Bolt not visible in dashboard'

  Database

  Apr 8

• Supavisor and Connection Terminology Explained

  SupavisorDatabase

  Apr 8

• Supavisor FAQ

  SupavisorDatabase

  Apr 8

• Transfer edge functions from one project to another

  CliDatabaseFunctions

  Apr 8

• Transferring from platform to self-hosted Supabase

  DatabaseSelf-hosting

  Apr 8

• Understanding Postgres EXPLAIN Output

  Database

  Apr 8

• Understanding Postgres Logging Levels and How They Impact Your Project

  Database

  Apr 8

• Understanding the Usage Summary on the Dashboard

  PlatformStudioDatabaseFunctions

  Apr 8

• Using SQLAlchemy with Supabase

  DatabaseSupavisorSelf-hosting

  Apr 8

• Webhook debugging guide

  Database

  Apr 8

• Why are there gaps in my Postgres id sequence?

  Database

  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

  Apr 8

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

  AuthDatabase

  Apr 8