Hello team
hello! can you help me I am encountering these issues in my web project:
Error 500 on the patients table:
Complete error message:
json
{
"message": "failed to call url https://gvhqciupdfjatgvepaou.supabase.co/rest/v1/patients?select=* with status 500 and statusText undefined",
"error_type": "http_server_error",
"body": "{"code":"42P17","details":null,"hint":null,"message":"infinite recursion detected in policy for relation \"user_roles\""}",
"url": "https://gvhqciupdfjatgvepaou.supabase.co/rest/v1/patients?select=*",
"status": 500
}
"I am encountering a 500 error on the API route /patients?select=*. The error message mentions infinite recursion in the RLS policies configured for user_roles."
Recursion issue with user_roles:
Error message:
json
"infinite recursion detected in policy for relation "user_roles""
"The RLS policies on user_roles seem to cause an infinite loop that blocks API requests related to this table."
Issue with file uploads:
Error message:
perl
error insert into "objects" ("bucket_id", "metadata", "name", "owner", "owner_id", "user_metadata", "version") values ($1, DEFAULT, $2, $3, $4, DEFAULT, $5) - infinite recursion detected in policy for relation "user_roles"
"When uploading files to the bucket, I get an error related to inserting into the objects table. The error message again mentions infinite recursion with user_roles."
Error 500 on the patients table:
Complete error message:
json
{
"message": "failed to call url https://gvhqciupdfjatgvepaou.supabase.co/rest/v1/patients?select=* with status 500 and statusText undefined",
"error_type": "http_server_error",
"body": "{"code":"42P17","details":null,"hint":null,"message":"infinite recursion detected in policy for relation \"user_roles\""}",
"url": "https://gvhqciupdfjatgvepaou.supabase.co/rest/v1/patients?select=*",
"status": 500
}
"I am encountering a 500 error on the API route /patients?select=*. The error message mentions infinite recursion in the RLS policies configured for user_roles."
Recursion issue with user_roles:
Error message:
json
"infinite recursion detected in policy for relation "user_roles""
"The RLS policies on user_roles seem to cause an infinite loop that blocks API requests related to this table."
Issue with file uploads:
Error message:
perl
error insert into "objects" ("bucket_id", "metadata", "name", "owner", "owner_id", "user_metadata", "version") values ($1, DEFAULT, $2, $3, $4, DEFAULT, $5) - infinite recursion detected in policy for relation "user_roles"
"When uploading files to the bucket, I get an error related to inserting into the objects table. The error message again mentions infinite recursion with user_roles."
