Cron job workflows connecting to postgresql are failing at random intervals

Questions
,
#1

We have twenty cron jobs actively running at an interval of 5 to 9 mins each. We notice that these cron jobs fail at random intervals of a day. Sometimes it does not happen but sometimes it happens frequently. What is the best way to troubleshoot at which point of the workflow we receive the error?

Workflow setup is simple → Cron configured for every 5 minutes → postgreSQL node runs one delete Query and one insert query.

It does not throw any specific error message for now, it simply mentions that workflow has failed. Any pointers to understand how to configure the failure for the workflow will also help us.

Please share the workflow

Information on your n8n setup

  • n8n version:0.214.0
  • Database you’re using (default:PostgreSQL):
  • Running n8n with the execution process [own(default)]:
  • Running n8n via [npm]:
#2

Hey @vibinchander,

Do you already have execution logging enabled for your workflows? It might be worth checking the console output of n8n as well as it may show something there but I would probably start with an upgrade to see if that helps and maybe swapping from every X to Cron to see if that helps.