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 solutionCRM 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 solutionCRM: 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 solutionpgvector HNSW: filter search returns too few results
The tenant id filter used limits the number of results returned below the expected limit.
Read the solutionpgvector: Vector Dimension Mismatch
Semantic search rejects the question, because the dimension of the vector differs from the dimension of the column.
Read the solutionPostgreSQL 22001: Value Too Long for Column Type
Writing a longer description ends with a 22001 error instead of creating a record.
Read the solutionPostgreSQL 23505: Duplicate Key Violates Unique Constraint
Data insertion or synchronization stops at SQLSTATE 23505.
Read the solutionPostgreSQL 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 solutionPostgreSQL 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 solutionPostgreSQL: 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 solutionPostgreSQL: 42P01 relation does not exist after migration
The application reports 42P01, although the table was created in a developer environment.
Read the solutionPostgreSQL: 57014 cancelling statement due to statement timeout
The query to the database is interrupted by code 57014, especially with a larger table.
Read the solutionSupabase Admin: createUser returns a refusal for an anon key
The administrative function tries to create users using a public client.
Read the solutionSupabase Auth: anonymous user sees ordinary account resources
The application treats an anonymously logged account as a full authenticated account.
Read the solutionSupabase Auth: captcha verification failed at registration
The form rejects the new user despite correct fields and acceptance of the rules.
Read the solutionSupabase Auth: Email not confirmed despite the correct password
Login rejects the correct data, but the account needs an address confirmation.
Read the solutionSupabase Auth: getSession is not enough to check your permissions
Endpoint accepts the session read with cookies as the final identity card.
Read the solutionSupabase Auth: Invalid Login Credentials for an Existing Account
Password login ends with refusal, although the form accepts entered data.
Read the solutionSupabase 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 solutionSupabase 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 solutionSupabase Auth: OTP Has Expired
After opening an email with a login link, the system shows expired or invalid token.
Read the solutionSupabase Auth: Rate Limit Exceeded When Sending Codes
Multiple click “Send Code” ends with the refusal of another email.
Read the solutionSupabase Auth: redirect URL not allowed on password reset
The reset password clicks to an address Auth does not accept.
Read the solutionSupabase 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