Cron tasks executed twice and at wrong local time

[RamonBeast]

Steps to reproduce:

1. Create a cron task
2. Set the mask time at: 0 0 * * * with 0 offset
3. Task is executed twice: once at midnight UTC and once at midnight UTC + (or -) local time offset. So if the local time is UTC+3 the second execution will happen at 03:00AM local time

Expected behavior:
One execution at the correct time.

Actual behavior:
Tasks are executed twice, once at utc_time and the second at utc_time + tz_offset

Environment info:

• System info: happens on all environments for me
• InfluxDB version: 2.5.1

This issue, in similar forms, has been reported several times at #20922, #20353, #23257 one user went to extreme lengths to try and address it by himself in this Daily task in different timezone thread in the community forum. All these issues seems to stem from the same place, but no answer has ever been given, though the issue seem to persist since at least 2020.

[linc5403]

Still no answer has ever been given...

[RamonBeast]

And none is expected for the next 2-3 years I guess.

Meanwhile my workaround has been to create a separate script that every day removes unwanted data points, not efficient, not clean but that's how it is.