cockroachdb / cockroachdb/docs

sql: tzinfo can be inconsistent across nodes

Open
#4,025 3 comments 0 reactions 0 assignees View on GitHub
P-2
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.