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.
Was this helpful?
