citusdata / citusdata/pg_cron

NTP error: pg_cron reset schedule

Open
#105 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
3.9k
Forks
260
Avg merge
5d 5h
Merged PRs (30d)
1

Description

Today, Our database have issues relate to ntp so some records have wrong timestamp.

I also notice that pg_cron will not auto reset to current ntp time and it will not run until 8 hours later (wrong time cause).

How do i reset it manually ?

Contributor guide

No contributing guide indexed for this repository

Research direction

The issue names no files or tests. Start by reproducing pg_cron scheduling after the system clock is corrected by NTP, then inspect the scheduler's handling of time changes. Done should establish whether a manual reset is supported and either document the procedure or define the required behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.