1

cockroach DB issue to start : Fail to initialize the node: unable to load named timezone.

I downloaded the zoneinfo.zip and unziped and configured the environment variable ZONEINFO and given into the path like C:\Program Files\timezone\zoneinfo but still facing the same. screenshot attached.enter image description here

Alok
  • 11
  • 1
  • 1
    Please [don't use images of text](https://meta.stackoverflow.com/questions/303812/discourage-screenshots-of-code-and-or-errors), put the text directly in the question. – Marc Sep 30 '20 at 11:15

1 Answers1

2

You're using the latest beta version on Windows. It's a good idea to read the installation instructions when doing this.

The install page for 20.2.0-beta2 on Windows has a section detailing how to setup the timezone database on Windows.

Quoting:

To ensure that CockroachDB can use location-based names as time zone identifiers, download Go's official zoneinfo.zip and set the ZONEINFO environment variable to point to the zip file.

Make sure of two things:

  • set the environment variable in the same powershell session as the one in which you are running Cockroach
  • the environment variable should point to the zip file, not the extracted contents.

You can also make it permanent, see this answer for how to do so.

Marc
  • 19,394
  • 6
  • 47
  • 51