Technical Advisory 56116

On this page Carat arrow pointing down

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 2020a from the golang development tree to each CockroachDB node.
  • Perform a rolling restart of all CockroachDB processes, setting the ZONEINFO environment variable to the path of the file.
  • 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.

Yes No
On this page

Yes No