Database Troubleshooting

Matching troubleshooting entries

• 42501 : permission denied for table http_request_queue

  42501

  Database

  Feb 21

• All about Supabase Egress

  PlatformDatabaseFunctionsStorageRealtimeAuthSupavisor

  Aug 13

• Avoiding timeouts in long running queries

  DatabasePlatform

  Apr 21

• Canceling statement due to "statement timeout"

  Database

  Feb 4

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

  Database

  Feb 21

• Change Project Region

  PlatformDatabaseAuth

  Mar 12

• Database API 42501 errors

  401 42501, 403 42501

  Database

  Jun 5

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

  Database

  Jan 18

• Deprecated RLS features

  Database

  Aug 26

• Disabling Prepared statements

  DatabaseSupavisor

  Feb 4

• Discovering and Interpreting API Errors in the Logs

  DatabasePlatform

  Feb 21

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

  Database

  Aug 26

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

  Database

  Feb 21

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

  DatabaseCli

  Aug 5

• 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

  Jan 18

• Error: prepared statement "XXX" already exists

  Database

  Jan 17

• High swap usage

  DatabasePlatform

  Feb 3

• 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

  Jan 17

• Grafana not displaying data

  Database

  Feb 4

• 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

  Aug 4

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

  DatabaseSupavisor

  Aug 4

• 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

  Feb 21

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

  Database

  Jan 17

• How to delete a role in Postgres

  Database

  Feb 21

• How to Interpret and Explore the Postgres Logs

  DatabasePlatform

  Feb 21

• How to View Database Metrics

  DatabasePlatform

  Jan 17

• Increase vector lookup speeds by applying an HSNW index

  DatabaseAiPlatform

  Apr 21

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

  Database

  Jan 16

• "insufficient privilege" when accessing pg_stat_statements

  Database

  Jan 16

• Interpreting Supabase Grafana CPU charts

  PlatformDatabase

  Jan 17

• Interpreting Supabase Grafana IO charts

  DatabasePlatform

  Apr 21

• 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

  Feb 21

• Prisma Error Management

  Database

  Apr 21

• Resolving 42P01: relation does not exist error

  42P01, 42501

  Database

  Jan 16

• Resolving 500 Status Authentication Errors

  500

  AuthDatabase

  Feb 21

• Resolving database hostname and managing your IP address

  Database

  Apr 21

• 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

  Jan 17

• Steps to improve query performance with indexes

  DatabasePlatformCli

  Feb 21

• Supabase & Your Network: IPv4 and IPv6 compatibility

  DatabasePlatformSupavisor

  Aug 4

• Interpreting Supabase Grafana Memory Charts

  Database

  Feb 21

• Supavisor and Connection Terminology Explained

  SupavisorDatabase

  Feb 4

• Supavisor FAQ

  SupavisorDatabase

  Aug 4

• Transferring from cloud to self-host in Supabase

  DatabaseSelf-hosting

  Jan 15

• Understanding PostgreSQL EXPLAIN Output

  Database

  Feb 21

• Understanding PostgreSQL Logging Levels and How They Impact Your Project

  Database

  Feb 21

• Understanding the Usage Summary on the Dashboard

  PlatformStudioDatabaseFunctions

  Jan 18

• Using SQLAlchemy with Supabase

  DatabaseSupavisorSelf-hostingFunctions

  Apr 21

• Webhook debugging guide

  Database

  Feb 21

• 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