Troubleshooting guides by topic

Supabase and databases

PostgreSQL, RLS, authentication, storage and database permissions.

77 English guides in this category

CRM logs out after time: Supabase session expired

Ended session after resuming the phone or PWA. Fresh token, support 401 and back to login.

Read the solution

CRM shows only the first 100 leads — Supabase Pagination

Why don't some of the records reach React? Response limits Supabase, range, sorting and consistent counter.

Read the solution

CRM: Sales Rep Cannot See a Lead After It Is Unblocked

After removing the lead lock still invisible to the sales representative. The most common causes: RLS policies (USING/WIGHT CHECK), inappropriate claims JWT/role, no GRANT SELECT or frontend filter. Specific tests and corrective steps.

Read the solution

pgvector HNSW: filter search returns too few results

The tenant id filter used limits the number of results returned below the expected limit.

Read the solution

pgvector: Vector Dimension Mismatch

Semantic search rejects the question, because the dimension of the vector differs from the dimension of the column.

Read the solution

PostgreSQL 22001: Value Too Long for Column Type

Writing a longer description ends with a 22001 error instead of creating a record.

Read the solution

PostgreSQL 23505: Duplicate Key Violates Unique Constraint

Data insertion or synchronization stops at SQLSTATE 23505.

Read the solution

PostgreSQL 40001: Serialization Failure from Concurrent Updates

Two operations on the same data end in SQLSTATE 40001 error at a higher level of isolation.

Read the solution

PostgreSQL 40P01: Deadlock Detected During Concurrent Writes

During parallel recording of two records, one transaction ends with a deadlock detected error, although individual records work.

Read the solution

PostgreSQL: 22P02 invalid input syntax for type uuid

The API returns SQLSTATE 22P02 when the filter or INSERT has received text that is not a valid UUID.

Read the solution

PostgreSQL: 42P01 relation does not exist after migration

The application reports 42P01, although the table was created in a developer environment.

Read the solution

PostgreSQL: 57014 cancelling statement due to statement timeout

The query to the database is interrupted by code 57014, especially with a larger table.

Read the solution

Supabase Admin: createUser returns a refusal for an anon key

The administrative function tries to create users using a public client.

Read the solution

Supabase Auth: anonymous user sees ordinary account resources

The application treats an anonymously logged account as a full authenticated account.

Read the solution

Supabase Auth: captcha verification failed at registration

The form rejects the new user despite correct fields and acceptance of the rules.

Read the solution

Supabase Auth: Email not confirmed despite the correct password

Login rejects the correct data, but the account needs an address confirmation.

Read the solution

Supabase Auth: getSession is not enough to check your permissions

Endpoint accepts the session read with cookies as the final identity card.

Read the solution

Supabase Auth: Invalid Login Credentials for an Existing Account

Password login ends with refusal, although the form accepts entered data.

Read the solution

Supabase Auth: Logout does not close other sessions

After logging out the phone, the session on the second device still has access for a while.

Read the solution

Supabase Auth: magic link returns to the wrong address after clicking

The login link redirects to localhost or unexpected address instead of a production application.

Read the solution

Supabase Auth: OTP Has Expired

After opening an email with a login link, the system shows expired or invalid token.

Read the solution

Supabase Auth: Rate Limit Exceeded When Sending Codes

Multiple click “Send Code” ends with the refusal of another email.

Read the solution

Supabase Auth: redirect URL not allowed on password reset

The reset password clicks to an address Auth does not accept.

Read the solution

Supabase Auth: The invited user cannot set the password

The invitation link works, but there is no valid password setting screen when clicking.

Read the solution
All English guides
Supabase and databases — troubleshooting and solutions