I am using cron jobs(postgres inbuilt functionality) with stored procedures, it seems like they are not running as expected, if you see the above graph few hours per day they seem doesn't run at all.
Don't see any error logs or any logs at all to debug.
n
Needle
05/16/2022, 3:41 AM
Hello @d33pu!
This thread has been automatically created from your message in #843999948717555735 a few seconds ago.
We have already mentioned the @User so that they can see your message and help you as soon as possible!
Want to unsubscribe from this thread?
Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates.
Want to change the title?
Use the ``/title`` command!
We have solved your problem?
Click the button below to archive it.
d
d33pu
05/16/2022, 3:42 AM
For more context cron job are suppose to be run every minute
g
garyaustin
05/16/2022, 4:04 AM
The API requests will be those coming thru PostgREST. Are your chron functions making http requests back to the API?
You can also generate log entries to the postgres log under database, by using:
raise log 'my message'
in your functions.
n
Needle
05/16/2022, 4:04 AM
deepu (2022-05-16)
d
d33pu
05/17/2022, 4:43 AM
apologies I only use cron jobs and insert json directly into table
d33pu
05/17/2022, 4:43 AM
thanks for tip on "log" 👍
d33pu
05/17/2022, 4:44 AM
API requests from the client is directly using default CRUD API(I guess you're referring the same thing PostgREST)