Publication date: October 29, 2020
Description
All currently-released versions of the Go runtime incorrectly interpret the daylight-savings flag in "slim" versions of zoneinfo that are used by some OS distributions. This can result in incorrect local date-time calculations for any version of CockroachDB that is running on an OS image that distributes "slim" zoneinfo files.
- Users of official CockroachDB Docker images are not affected.
- Users of our reference Kubernetes configurations are not affected.
- Users of CockroachCloud are not affected.
Statement
This public issue is tracked as #56116.
Mitigation
Execute the following SQL statement to determine if your cluster is affected:
SET TIME ZONE UTC; -- The default for cockroach sql
SELECT '2020-10-29 15:30'::TIMESTAMPTZ AT TIME ZONE 'Europe/Berlin' AT TIME ZONE 'UTC';
If a value other than 2020-10-29 16:30:00+00:00 is returned, you are affected by this Go runtime bug and should perform the following remediation:
- Download zoneinfo.zip 2020a from the golang development tree to each CockroachDB node.
- Perform a rolling restart of all CockroachDB processes, setting the
ZONEINFOenvironment variable to the path of thezoneinfo.zipfile. - Confirm the fix by executing the above SQL statement.
Impact
Any clusters impacted by this issue may produce incorrect results when performing date/time calculations that involve values in timezones and time periods for which daylight savings are in effect.
Questions about any technical alert can be directed to our support team.
