cockroachdb / cockroachdb/docs
sql: tzinfo can be inconsistent across nodes
- Dominant language
- HTML
- Stars
- 212
- Forks
- 476
- Avg merge
- 40m
- Merged PRs (30d)
- 3
Description
Jesse Seldess (jseldess) commented:
See https://github.com/cockroachdb/cockroach/issues/31978#issuecomment-437850407.
> CockroachDB relies on each node's tzinfo data for resolving named timezones like America/New_York and for applying daylight-savings rules. This can lead to inconsistent results across a cluster when coercing date/time strings into temporal types.
From @knz:
> until this issue is fixed, we should call out in the docs for operational matters that the OS database should be updated, and all nodes should be restarted when the timezone data changes (e.g. the definition of a timezone changes because of geopolitical matters, or some country decides to change their DST rules).
Jira Issue: DOC-202
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.