Calendars and Scheduled reports issue after version 6.0

Calendars and Scheduled reports issue after version 6.0

Since the upgrade to traccar 6.0 (actually running traccar 6.2) any scheduled report associated with a
daily calendar ending at:

At 11:59 PM

Does not get delivered.

No trace shown in the logs.
Tried to delete and recreate the calendar and the scheduled reports but nothing changes.

If I anticipate the end of the period at 11:45 PM,
I get the reports again

mysql entries:

MariaDB [traccar_db]> SELECT data FROM tc_calendars WHERE id=3;
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| data                                                                                                                                                                                                                                                             |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Traccar//NONSGML Traccar//EN
BEGIN:VEVENT
UID:00000000-0000-0000-0000-000000000000
DTSTART;TZID=Europe/Rome:20240604T000100
DTEND;TZID=Europe/Rome:20240604T235900
RRULE:FREQ=DAILY
SUMMARY:Event
END:VEVENT
END:VCALENDAR |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.009 sec)

MariaDB [traccar_db]> SELECT * from tc_reports;
+----+--------+--------------+------------+------------+
| id | type   | description  | calendarid | attributes |
+----+--------+--------------+------------+------------+
| 20 | events | TK913_events |          3 | {}         |
+----+--------+--------------+------------+------------+
1 row in set (0.002 sec)

Seems the server is not able to handle the process if it ends the next day.

All the time zones in traccar for server and users are set to the same timezone (Europe/Rome), accordingly to the
timezone of the OS.

Restarting the server after any change.

Regards,
francis3

Have you tried smaller interval? For example a report for 1 hour?

Thank you for your answer Anton.

Tried different intervals, and no issues.

The issue arises when the END time of the interval is too close to midnight,
as is 23:59

Tried to anticipate the END time of the interval and I get the reports with no problem.

Gonna try, as you suggest, a smaller interval of four hours
with END time of 23:59

MariaDB [traccar_db]> SELECT data FROM tc_calendars WHERE id=3;
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| data                                                                                                                                                                                                                                                             |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Traccar//NONSGML Traccar//EN
BEGIN:VEVENT
UID:00000000-0000-0000-0000-000000000000
DTSTART;TZID=Europe/Rome:20240604T200100
DTEND;TZID=Europe/Rome:20240604T235900
RRULE:FREQ=DAILY
SUMMARY:Event
END:VEVENT
END:VCALENDAR |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
(END)

regards,
francis3

Have you tried leaving at least 15 minutes to midnight?

Yes Anton.
It was my first try, as I said in the top message.
In that case everything is fine.
So ... not a big issue.

Just wanted to point out that since the releases 6.* there was not this problem.

And, for the record, the report with an interval of 4 hours
scheduled with the calendar modified yesterday evening
arrived just fine and shows in the logs ...

2024-06-05 00:11:34  INFO: user: 2, scheduled: events, from: 2024-06-04 20:01, to: 2024-06-04 23:59, devices: [4], groups: []

regards,
francis3