Database Troubleshooting

Matching troubleshooting entries

• 42501 : permission denied for table http_request_queue

  42501

  Database

  Sep 9

• All about Supabase Egress

  PlatformDatabaseFunctionsStorageRealtimeAuthSupavisor

  Sep 16

• Avoiding timeouts in long running queries

  DatabasePlatform

  Oct 30

• Canceling statement due to "statement timeout"

  Database

  Sep 16

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

  Database

  Sep 9

• Change Project Region

  PlatformDatabaseAuth

  Mar 12

• 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 3

• Database API 42501 errors

  401 42501, 403 42501

  Database

  Sep 9

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

  Database

  Jan 18

• Deprecated RLS features

  Database

  Nov 5

• Disabling Prepared statements

  DatabaseSupavisor

  Feb 4

• Discovering and Interpreting API Errors in the Logs

  DatabasePlatform

  Sep 9

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

  Database

  Nov 5

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

  Database

  Sep 9

• Enabling the IPv4 add-on FAQ

  DatabasePlatformSupavisor

  Nov 5

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

  DatabaseCli

  Sep 9

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

  Database

  Feb 4

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

  DatabasePlatform

  Sep 9

• Error: prepared statement "XXX" already exists

  Database

  Jan 17

• High swap usage

  DatabasePlatform

  Sep 9

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

  Database

  Jan 18

• Fixing 520 Errors in the Database REST API

  520

  Database

  Sep 9

• Grafana not displaying data

  Database

  Sep 9

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

  CliDatabaseStorage

  Nov 5

• High latency with supabase client

  DatabasePlatform

  Feb 4

• How can I revoke execution of a PostgreSQL function?

  DatabaseFunctions

  Jan 17

• How do I reset my Supabase database password?

  Database

  Sep 9

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

  DatabaseSupavisor

  Sep 9

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

  Database

  Jan 18

• How Postgres chooses which index to use

  Database

  Feb 21

• How to change max database connections

  DatabaseSupavisorCli

  Sep 9

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

  Database

  Jan 17

• How to delete a role in Postgres

  Database

  Sep 9

• How to Interpret and Explore the Postgres Logs

  DatabasePlatform

  Sep 9

• How to View Database Metrics

  DatabasePlatform

  Sep 9

• Increase vector lookup speeds by applying an HSNW index

  DatabaseAiPlatform

  Oct 30

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

  Database

  Sep 9

• "insufficient privilege" when accessing pg_stat_statements

  Database

  Sep 16

• Interpreting Supabase Grafana CPU charts

  PlatformDatabase

  Sep 9

• Interpreting Supabase Grafana IO charts

  DatabasePlatform

  Sep 9

• Memory and Swap usage explained

  DatabasePlatform

  Feb 4

• How to monitor Postgres and Supavisor connections

  DatabaseSupavisor

  Aug 4

• NEW variable is null in a trigger function.

  DatabaseFunctions

  Jan 16

• Partitioning an existing table with same name

  Database

  Feb 4

• pg_cron debugging guide

  Database

  Sep 9

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

  PGRST106

  AuthDatabase

  Nov 5

• Prisma Error Management

  Database

  Sep 9

• Reload/refresh postgrest schema

  400 bad_request

  Database

  Oct 15

• Resolving 42P01: relation does not exist error

  42P01, 42501

  Database

  Sep 9

• Resolving 500 Status Authentication Errors

  500

  AuthDatabase

  Sep 9

• Resolving database hostname and managing your IP address

  Database

  Sep 9

• RLS Performance and Best Practices

  AuthDatabase

  Apr 4

• RLS Simplified

  DatabaseAuth

  Feb 21

• 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

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

  Database

  Sep 9

• Steps to improve query performance with indexes

  DatabasePlatformCli

  Sep 9

• Supabase & Your Network: IPv4 and IPv6 compatibility

  DatabasePlatformSupavisor

  Sep 9

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

  AuthCliDatabaseSupavisor

  Nov 5

• Interpreting Supabase Grafana Memory Charts

  Database

  Feb 21

• Supavisor and Connection Terminology Explained

  SupavisorDatabase

  Feb 4

• Supavisor FAQ

  SupavisorDatabase

  Oct 30

• Transferring from cloud to self-host in Supabase

  DatabaseSelf-hosting

  Jan 15

• Understanding PostgreSQL EXPLAIN Output

  Database

  Sep 9

• Understanding PostgreSQL Logging Levels and How They Impact Your Project

  Database

  Sep 9

• Understanding the Usage Summary on the Dashboard

  PlatformStudioDatabaseFunctions

  Sep 9

• Using SQLAlchemy with Supabase

  DatabaseSupavisorSelf-hostingFunctions

  Oct 30

• Webhook debugging guide

  Database

  Sep 9

• Why are there gaps in my Postgres id sequence?

  Database

  Feb 21

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

  AuthPlatformDatabaseRealtimeFunctions

  Feb 4

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

  Database

  Jan 15

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

  DatabaseAuth

  Feb 21

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

  AuthDatabase

  Feb 4