Statement timeout error

Hello! I have a script which upserts or deletes data from supabase tables. I'm running the script on a cron every X minutes. Some of the functionality includes running a method using

.rpc

.rpc

which deletes some rows. I get a

canceling statement due to statement timeout

canceling statement due to statement timeout

error.

I've read this article https://supabase.com/docs/guides/database/postgres/configuration but I don't understand what is usefull from it. Should I run this

alter role authenticator set statement_timeout = '15s';

alter role authenticator set statement_timeout = '15s';

? But I don't use any roles. I also don't have any RLS set up. The project is on Pro plan,

Database configuration | Supabase Docs

Updating the default configuration for your Postgres database.

Supabase•3y ago•

3 replies

apost

Statement timeout error

Hello! I have a script which upserts or deletes data from supabase tables. I'm running the script on a cron every X minutes. Some of the functionality includes running a method using

.rpc

.rpc

which deletes some rows. I get a

canceling statement due to statement timeout

canceling statement due to statement timeout

error.

I've read this article https://supabase.com/docs/guides/database/postgres/configuration but I don't understand what is usefull from it. Should I run this

alter role authenticator set statement_timeout = '15s';

alter role authenticator set statement_timeout = '15s';

? But I don't use any roles. I also don't have any RLS set up. The project is on Pro plan,

Database configuration | Supabase Docs

Updating the default configuration for your Postgres database.

Statement timeout error

Similar Threads

Statement timeout error

Similar Threads

Similar Threads

Similar Threads