Triggers: Trigger not running on the scheduled time

[madclaws]

Describe the bug For Arogyaworld (org_id: 233), the trigger didn't run on expected time, instead it ran after ~15hrs. This caused a flow to not update the contact variable next_message_date, due to that the flow stopped working as expected for many contacts (message missing on oct 31).

Observations msg_id - 104062045 send_at - 2024-10-31 19:02:06 UTC (ideally - ~2024-10-31 3:30:00 UTC)

The trigger didn't start on 2024-11-31 3:30:00 UTC but on 2024-10-31 19:02:06 UTC message_broadcast_id - 21536664

Expected behavior Trigger should run on scheduled time

[AkhileshNegi]

Flow ID: 22000 Flow Name: week 1 flow Trigger ID: 5233 Trigger Name: week 1 flow_18/9/2024_9:00AM

Trigger:

User:

Checking code for trigger logs:

Checking logs in logflare: Don't have logs for the month of October

"executing trigger: week 1 flow_18/9/2024_9:00AM" t:2024-10-{20..31}T00:00:00 c:count(*) c:group_by(t::day)`

Don't have much logs for the month of November

"executing trigger: week 1 flow_18/9/2024_9:00AM" t:2024-11-{01..15}T00:00:00 c:count(*) c:group_by(t::day)

[madclaws]

In above logs, we can't see the trigger which ran on Nov 8th, but in message_broadcasts_table we can see it.

{
  "id": "29340",
  "flow_id": "29340",
  "flow_name": "week 1 flow",
  "group_id": "10719",
  "group_name": "Week 1- BIAL Staff",
  "status": null,
  "message_id": null,
  "user_id": "1909",
  "user_phone": "919xxxxxxxx0",
  "broadcast_type": "flow",
  "message_params": "{}",
  "started_at": "2024-11-08T09:00:07",
  "completed_at": "2024-11-08T09:01:01",
  "inserted_at": "2024-11-08T09:00:07",
  "updated_at": "2024-11-08T09:00:07",
  "bq_uuid": "d36909d8-5b8f-497b-8739-e929de503d1b",
  "bq_inserted_at": "2024-11-09T09:00:00.907153"
}