Publication date: October 29, 2020
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.
This public issue is tracked as #56116.
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 the
- Confirm the fix by executing the above SQL statement.
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.