[SERVER-59701] Error when working with some timezones when using external timezones database Created: 01/Sep/21  Updated: 29/Oct/23  Resolved: 22/Sep/21

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: 5.0.2
Fix Version/s: 5.0.4, 5.1.0-rc0

Type: Bug Priority: Major - P3
Reporter: Maxim Zasorin Assignee: Mohammad Dashti (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
is depended on by DOCS-14814 'Etc/*' timezones are not supported Closed
Duplicate
is duplicated by SERVER-41948 MongoDB not supporting all standard t... Closed
Related
related to SERVER-60141 Upgrade timelib to 2021.09 or later Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Backport Requested:
v5.0
Steps To Reproduce:
  1. Install and run MongoDB according to the official tutorial
    1. Ubuntu 20.04
    2. or Amazon Linux
  2. Execute the following queries via the shell:

    test> db.data.insertOne({ dt: new ISODate() })
    {
      acknowledged: true,
      insertedId: ObjectId("612ecf6c7a7e22f6c7e00e53")
    }
    test> db.data.aggregate([
    ...     {
    .....         "$project": {
    .......             "dtTimezone": {
    .........                 "$dateToString": {
    ...........                     "date": "$dt",
    ...........                     "timezone": "Etc/UTC"
    ...........                 }
    .........             }
    .......         }
    .....     }
    ... ])
    MongoServerError: PlanExecutor error during aggregation :: caused by :: unrecognized time zone identifier: "Etc/UTC"
    test> db.data.aggregate([
    ...     {
    .....         "$project": {
    .......             "dtTimezone": {
    .........                 "$dateToString": {
    ...........                     "date": "$dt",
    ...........                     "timezone": "Europe/London"
    ...........                 }
    .........             }
    .......         }
    .....     }
    ... ])
    [
      {
        _id: ObjectId("612ecf6c7a7e22f6c7e00e53"),
        dtTimezone: '2021-09-01T01:55:08.009Z'
      }
    ]
    

Sprint: QE 2021-10-04
Participants:

 Description   

I get an error when executing queries with some timezones, such as Etc/UTC or Etc/GMT+12, while the same queries with other timezones, such as Europe/London, work correctly. The error occurs when specifying the processManagement.timeZoneInfo parameter, which is set by default to /usr/share/zoneinfo. When omitting this parameter and using the built-in database, the error does not occur. Downloading and using the timezone archive from the documentation, as advised in SERVER-41948, does not solve the problem.



 Comments   
Comment by Githook User [ 22/Sep/21 ]

Author:

{'name': 'Mohammad Dashti', 'email': 'mdashti@gmail.com', 'username': 'mdashti'}

Message: SERVER-59701 Avoid filtering out `Etc` timezone files when reading system tzfiles

(cherry picked from commit 22fa3b7067bc0d9d025dc9191fd42ca509fc879f)
Branch: v5.0
https://github.com/mongodb/mongo/commit/72a4d4a59438bc149a5d699a0d8e42fe1dad5311

Comment by Githook User [ 22/Sep/21 ]

Author:

{'name': 'Mohammad Dashti', 'email': 'mdashti@gmail.com', 'username': 'mdashti'}

Message: SERVER-59701 Avoid filtering out `Etc` timezone files when reading system tzfiles
Branch: master
https://github.com/mongodb/mongo/commit/22fa3b7067bc0d9d025dc9191fd42ca509fc879f

Comment by Maxim Zasorin [ 22/Sep/21 ]

@mohammad.dashti Thank you for your help and clarification.

Comment by Mohammad Dashti (Inactive) [ 22/Sep/21 ]

maximzasorin@gmail.com As mentioned above, "Etc/*" timezones are not currently supported and we're working on a fix. In the meanwhile, you can use alternative timezones, e.g., "UTC" instead of "Etc/UTC".

Comment by Ethan Zhang (Inactive) [ 22/Sep/21 ]

mohammad.dashti I suggest that we apply a custom change for this ticket and file another ticket for upgrading timelib where we could revert this custom change and do a full upgrade.

Comment by Mohammad Dashti (Inactive) [ 22/Sep/21 ]

I'd suggest creating a new ticket for the timelib upgrade and make this one depend on it.

Comment by Mohammad Dashti (Inactive) [ 22/Sep/21 ]

Changed the status to blocked before the next release of timelib, which depends on this PR: https://github.com/derickr/timelib/pull/117

Comment by Mohammad Dashti (Inactive) [ 22/Sep/21 ]

Apparently, when timelib reads the timezone files from a specified directory, it ignores the timezones under Etc.

This was introduced back in April 2017: https://github.com/derickr/timelib/commit/1ccf47679b50340328845223dea99647ee94e9eb#diff-1647992e5f575706b6799fce1eb3b55e30719e280a8cd565e656afbc792540afR45 and it's not specific to the recent update.

Most probably, it's an implementation mistake. I proposed a PR on the timelib repo to fix the issue: https://github.com/derickr/timelib/pull/117

Now, we can also apply the same change in our repo, or wait for the next release of timelib and then upgrade to the latest version of timelib. I'm in favor of waiting for the next release of timelib rather than applying a custom change. ethan.zhang, kyle.suarez (or other stakeholders on this ticket), can you please express your opinion?

Comment by Mohammad Dashti (Inactive) [ 21/Sep/21 ]

Hi All,

I could also reproduce this easily on Ubuntu 18.04.5 LTS. Then, looked into the list of timezones listed in each case.

Case 1: Here is the list of loaded timezones when using processManagement.timeZoneInfo parameter set (by default) to /usr/share/zoneinfo on Ubuntu 18.04.5 LTS:

America/Pangnirtung
America/Mazatlan
Australia/Tasmania
America/Argentina/Mendoza
America/Bogota
Asia/Krasnoyarsk
Jamaica
Africa/Harare
America/Recife
America/Paramaribo
Asia/Kabul
Asia/Almaty
America/Argentina/Catamarca
America/Anchorage
Africa/Lome
Africa/Mbabane
America/Rio_Branco
America/Thule
Asia/Pontianak
America/Iqaluit
Asia/Singapore
GMT0
Asia/Aqtobe
Europe/Kirov
America/Jujuy
America/Dawson_Creek
Australia/Victoria
Pacific/Pohnpei
Australia/Eucla
US/Samoa
SystemV/AST4ADT
Europe/Monaco
America/Tortola
America/Argentina/San_Luis
Pacific/Easter
Asia/Vientiane
Europe/Budapest
Pacific/Johnston
America/Toronto
America/Argentina/Jujuy
Asia/Jakarta
Egypt
Africa/Douala
America/Montserrat
Asia/Tokyo
Asia/Damascus
Antarctica/Davis
Pacific/Truk
Australia/Hobart
Africa/Windhoek
Africa/Khartoum
America/Belem
America/Indiana/Knox
America/Managua
Brazil/East
Europe/Sarajevo
Europe/Berlin
Europe/Zagreb
Chile/EasterIsland
Asia/Ho_Chi_Minh
Pacific/Galapagos
Asia/Dili
US/East-Indiana
Universal
America/Hermosillo
Europe/Malta
America/Kentucky/Louisville
America/Shiprock
Asia/Baku
Asia/Kolkata
SystemV/AST4
Australia/Canberra
Antarctica/Macquarie
Atlantic/Cape_Verde
Antarctica/Mawson
Africa/Malabo
America/Knox_IN
Pacific/Kwajalein
Asia/Shanghai
Asia/Manila
Atlantic/Canary
America/Port-au-Prince
Australia/Brisbane
GMT+0
Asia/Omsk
SystemV/YST9YDT
America/Guayaquil
Europe/Chisinau
Europe/Madrid
Asia/Anadyr
Australia/Broken_Hill
Chile/Continental
Antarctica/Palmer
Australia/South
America/Grenada
Asia/Khandyga
Europe/Vaduz
Pacific/Pago_Pago
America/Rainy_River
America/Blanc-Sablon
Indian/Antananarivo
Africa/Banjul
Canada/Atlantic
CET
America/Lima
Antarctica/Troll
America/Vancouver
Atlantic/Stanley
America/Fort_Nelson
Pacific/Honolulu
Canada/Pacific
Asia/Ulan_Bator
America/Nassau
Asia/Irkutsk
Brazil/West
Navajo
Australia/NSW
Asia/Tehran
Pacific/Chatham
America/Belize
Brazil/DeNoronha
America/Boise
America/Detroit
America/Curacao
Asia/Atyrau
Pacific/Tarawa
America/Buenos_Aires
Asia/Brunei
Asia/Kuching
US/Eastern
Asia/Tashkent
Asia/Oral
Asia/Kashgar
America/Porto_Velho
America/Argentina/Salta
Mexico/BajaSur
America/Edmonton
Antarctica/Syowa
America/Catamarca
America/Cuiaba
Europe/Tiraspol
Indian/Comoro
Europe/Helsinki
Europe/Luxembourg
Europe/Oslo
America/Goose_Bay
Europe/Saratov
Asia/Bangkok
Europe/Vilnius
America/Argentina/Buenos_Aires
America/Santa_Isabel
Asia/Kuwait
Indian/Mayotte
America/Porto_Acre
Canada/Yukon
America/Menominee
Europe/Skopje
Australia/LHI
US/Michigan
America/St_Thomas
US/Indiana-Starke
Africa/Asmera
Europe/Andorra
US/Aleutian
America/Argentina/Rio_Gallegos
Hongkong
Canada/Central
Asia/Saigon
Atlantic/St_Helena
America/Sitka
America/Matamoros
America/Argentina/Cordoba
Pacific/Tahiti
America/Resolute
Eire
America/Denver
Africa/Bissau
Africa/Tripoli
US/Central
Africa/Maputo
America/Maceio
Europe/Busingen
Asia/Karachi
Asia/Qatar
Pacific/Wake
America/Winnipeg
America/Chicago
America/Cayman
Europe/Copenhagen
Pacific/Chuuk
Asia/Baghdad
Asia/Katmandu
America/Indiana/Vincennes
Africa/Mogadishu
Australia/Currie
Africa/Conakry
Africa/Brazzaville
America/Havana
Africa/Algiers
America/Eirunepe
Pacific/Nauru
Asia/Sakhalin
Asia/Hovd
America/Virgin
America/Sao_Paulo
Africa/Kampala
Europe/Paris
Asia/Thimbu
America/Regina
Indian/Mauritius
Asia/Novosibirsk
CST6CDT
Asia/Yakutsk
Asia/Ashkhabad
Africa/Tunis
ROC
America/Argentina/Ushuaia
America/Boa_Vista
Europe/Sofia
MET
America/Godthab
Africa/Lusaka
America/Chihuahua
Europe/Zurich
US/Alaska
Pacific/Noumea
Asia/Gaza
Greenwich
Pacific/Saipan
America/North_Dakota/Center
Asia/Dubai
PST8PDT
Africa/Kinshasa
America/Aruba
America/Inuvik
Portugal
SystemV/CST6
America/Port_of_Spain
EET
US/Hawaii
Africa/Abidjan
Asia/Seoul
Arctic/Longyearbyen
America/Anguilla
Pacific/Efate
Pacific/Fakaofo
Japan
America/Bahia_Banderas
Australia/Perth
SystemV/PST8PDT
Pacific/Yap
Asia/Nicosia
Europe/Vatican
America/Barbados
America/Monterrey
Europe/Moscow
Asia/Muscat
Europe/Tallinn
Europe/Nicosia
EST5EDT
Asia/Chungking
Australia/West
Europe/Podgorica
Europe/Belfast
America/Montevideo
UCT
Asia/Choibalsan
Antarctica/South_Pole
Asia/Novokuznetsk
US/Pacific
Pacific/Kosrae
Europe/Ljubljana
Europe/Astrakhan
Turkey
Asia/Famagusta
America/Marigot
Pacific/Enderbury
Asia/Aden
America/Indiana/Marengo
Pacific/Fiji
Atlantic/Bermuda
Africa/Juba
America/Indiana/Indianapolis
America/Danmarkshavn
Asia/Beirut
SystemV/EST5
Pacific/Apia
Pacific/Samoa
America/Costa_Rica
Asia/Colombo
Antarctica/Vostok
America/North_Dakota/New_Salem
America/Panama
Mexico/General
Pacific/Midway
America/Argentina/La_Rioja
Asia/Qyzylorda
Antarctica/DumontDUrville
Africa/Bujumbura
Cuba
Australia/Darwin
Europe/Bucharest
Atlantic/Jan_Mayen
MST7MDT
Asia/Vladivostok
Europe/Volgograd
America/Santo_Domingo
GB-Eire
America/Martinique
Pacific/Guadalcanal
Asia/Harbin
Indian/Kerguelen
America/Guyana
America/Yellowknife
America/St_Lucia
Pacific/Kiritimati
Pacific/Ponape
Asia/Srednekolymsk
America/Glace_Bay
Asia/Hebron
Europe/Kiev
America/Cayenne
America/Creston
America/St_Barthelemy
America/Argentina/San_Juan
Africa/Nairobi
Europe/Riga
America/Metlakatla
Pacific/Wallis
Asia/Yerevan
Asia/Bishkek
Pacific/Pitcairn
Pacific/Bougainville
Australia/North
Asia/Hong_Kong
Africa/Dar_es_Salaam
Asia/Thimphu
America/Araguaina
Iceland
Africa/Johannesburg
Africa/Blantyre
America/Juneau
Asia/Bahrain
Africa/Gaborone
America/Mendoza
Antarctica/Rothera
America/Adak
SystemV/EST5EDT
America/Lower_Princes
America/North_Dakota/Beulah
Africa/Lagos
Asia/Dhaka
Africa/Kigali
HST
America/La_Paz
America/Santiago
Africa/Porto-Novo
America/Asuncion
America/Thunder_Bay
Africa/Addis_Ababa
Australia/Sydney
Europe/Brussels
Europe/Uzhgorod
America/St_Kitts
SystemV/MST7MDT
Asia/Urumqi
SystemV/HST10
Zulu
Africa/Asmara
America/Yakutat
Pacific/Port_Moresby
Europe/Gibraltar
Libya
America/Atka
Africa/Bamako
Africa/Libreville
America/Miquelon
America/Dawson
Asia/Qostanay
America/El_Salvador
America/Caracas
America/Ojinaga
America/Moncton
Pacific/Majuro
Pacific/Auckland
Asia/Chongqing
America/Merida
Africa/Ouagadougou
Antarctica/McMurdo
Australia/Melbourne
W-SU
Indian/Cocos
America/Atikokan
Europe/Prague
Africa/El_Aaiun
Australia/Adelaide
America/Phoenix
Europe/Warsaw
Europe/Bratislava
Australia/Queensland
Atlantic/Faroe
Africa/Niamey
GMT-0
WET
Pacific/Palau
Indian/Reunion
America/Cancun
Asia/Ulaanbaatar
America/Fortaleza
Canada/Saskatchewan
America/Rankin_Inlet
Asia/Kamchatka
America/New_York
Asia/Pyongyang
America/Coral_Harbour
Atlantic/Faeroe
America/Indiana/Petersburg
America/Ensenada
Atlantic/Reykjavik
Pacific/Tongatapu
Poland
America/Mexico_City
Asia/Ashgabat
America/Nipigon
Atlantic/Azores
Canada/Mountain
Europe/London
Asia/Makassar
Indian/Chagos
SystemV/PST8
Atlantic/South_Georgia
Europe/Rome
Asia/Ujung_Pandang
Antarctica/Casey
Europe/Belgrade
Africa/Maseru
Pacific/Gambier
Africa/Luanda
America/Cambridge_Bay
Europe/Ulyanovsk
America/Noronha
Kwajalein
Asia/Calcutta
Africa/Accra
Africa/Monrovia
Asia/Barnaul
America/Punta_Arenas
Indian/Maldives
Asia/Macau
Europe/Istanbul
Asia/Tel_Aviv
Australia/Yancowinna
America/Antigua
Europe/Dublin
America/Louisville
Asia/Tomsk
America/Bahia
Asia/Tbilisi
Asia/Kathmandu
Pacific/Norfolk
SystemV/CST6CDT
Europe/Tirane
America/Puerto_Rico
America/Dominica
NZ-CHAT
Europe/Samara
Asia/Riyadh
America/Nuuk
Pacific/Niue
America/Kralendijk
Europe/Lisbon
Indian/Mahe
Asia/Dacca
Africa/Timbuktu
America/Fort_Wayne
Africa/Lubumbashi
US/Arizona
Pacific/Rarotonga
Pacific/Marquesas
Canada/Newfoundland
Asia/Kuala_Lumpur
Africa/Freetown
America/Argentina/ComodRivadavia
Asia/Yangon
Pacific/Funafuti
Asia/Dushanbe
US/Mountain
Singapore
Africa/Djibouti
PRC
Asia/Macao
Africa/Sao_Tome
Asia/Amman
America/Los_Angeles
Australia/Lord_Howe
America/St_Vincent
Asia/Magadan
Brazil/Acre
Asia/Samarkand
America/Halifax
Europe/Kaliningrad
ROK
Europe/Minsk
Europe/Jersey
America/Rosario
Asia/Phnom_Penh
America/Tegucigalpa
Asia/Yekaterinburg
America/Nome
UTC
Europe/Isle_of_Man
Asia/Ust-Nera
America/Jamaica
SystemV/YST9
Europe/Stockholm
Africa/Bangui
America/Cordoba
Europe/San_Marino
GMT
Pacific/Guam
America/Scoresbysund
Africa/Dakar
America/Tijuana
America/St_Johns
Africa/Casablanca
America/Swift_Current
America/Guadeloupe
America/Campo_Grande
America/Argentina/Tucuman
Asia/Rangoon
Europe/Zaporozhye
America/Montreal
Asia/Jayapura
Asia/Aqtau
Europe/Guernsey
Africa/Nouakchott
Africa/Cairo
America/Manaus
America/Whitehorse
America/Indiana/Vevay
America/Kentucky/Monticello
Iran
Africa/Ndjamena
Asia/Jerusalem
Israel
Factory
Asia/Chita
EST
SystemV/MST7
Europe/Simferopol
Atlantic/Madeira
America/Indianapolis
America/Grand_Turk
Europe/Mariehamn
GB
Europe/Vienna
Africa/Ceuta
America/Guatemala
Europe/Athens
America/Indiana/Winamac
Mexico/BajaNorte
America/Indiana/Tell_City
Asia/Taipei
Australia/Lindeman
Canada/Eastern
Indian/Christmas
NZ
MST
Asia/Istanbul
America/Santarem
Europe/Amsterdam
Australia/ACT

Case 2: Here is the list of loaded timezones when using processManagement.timeZoneInfo parameter set to the extracted timezone archive from the documentation:

Africa/Ceuta
Asia/Rangoon
Indian/Chagos
CET
America/Kralendijk
Europe/Zurich
Asia/Ust-Nera
Asia/Thimphu
Australia/Perth
Asia/Baghdad
Antarctica/South_Pole
Mexico/BajaNorte
Asia/Dili
Asia/Srednekolymsk
Asia/Baku
Chile/EasterIsland
Antarctica/Mawson
America/St_Thomas
America/Punta_Arenas
America/Guayaquil
Pacific/Guadalcanal
Africa/Sao_Tome
Australia/Queensland
Indian/Mayotte
America/Jamaica
Australia/NSW
Europe/London
America/Argentina/Buenos_Aires
Australia/ACT
Asia/Kuwait
Iceland
Europe/Volgograd
Mexico/BajaSur
Pacific/Rarotonga
Pacific/Nauru
Europe/Tirane
America/Catamarca
Asia/Katmandu
Europe/Paris
America/Thunder_Bay
Pacific/Niue
Australia/Sydney
America/Santarem
America/Mexico_City
Asia/Irkutsk
America/Dawson_Creek
Pacific/Gambier
America/Dominica
America/Lima
America/Fort_Wayne
Asia/Bishkek
Pacific/Enderbury
Asia/Ashkhabad
Europe/Budapest
GB-Eire
Australia/Eucla
America/Cambridge_Bay
America/Merida
Europe/Bratislava
Africa/Monrovia
America/Danmarkshavn
America/Kentucky/Monticello
Africa/Windhoek
America/Nassau
Europe/Vienna
Europe/Jersey
Australia/Victoria
Atlantic/South_Georgia
Africa/Dar_es_Salaam
Indian/Reunion
Atlantic/Reykjavik
ROK
Asia/Muscat
America/Paramaribo
America/Godthab
America/La_Paz
Asia/Thimbu
Canada/Newfoundland
Asia/Tehran
America/Cayenne
PST8PDT
Asia/Qostanay
America/Indiana/Marengo
America/Ojinaga
Europe/Belgrade
Europe/Podgorica
Asia/Kuala_Lumpur
Africa/Ndjamena
Asia/Calcutta
Pacific/Kiritimati
Asia/Aden
Africa/Abidjan
Asia/Kuching
EST5EDT
Atlantic/Canary
America/Chicago
America/Port-au-Prince
America/Anchorage
US/Michigan
Pacific/Apia
America/Montevideo
Australia/North
Africa/Kampala
Asia/Bahrain
Asia/Ulan_Bator
Canada/Pacific
Africa/Mogadishu
Atlantic/Cape_Verde
Europe/Astrakhan
Europe/Chisinau
America/Indiana/Indianapolis
Asia/Damascus
Africa/Cairo
America/Argentina/Mendoza
Asia/Hong_Kong
Pacific/Easter
America/Cuiaba
Asia/Makassar
America/Scoresbysund
America/Fortaleza
America/St_Kitts
Africa/Niamey
Canada/Mountain
America/Argentina/Cordoba
UTC
US/Hawaii
Africa/Accra
Africa/Nairobi
US/Indiana-Starke
Asia/Dhaka
Africa/Brazzaville
US/East-Indiana
Arctic/Longyearbyen
America/New_York
Asia/Samarkand
America/Santa_Isabel
Canada/Atlantic
America/Halifax
America/Cayman
GMT0
NZ
Australia/Hobart
Europe/Berlin
America/Cordoba
Europe/Lisbon
America/Miquelon
America/Guyana
America/Bahia_Banderas
America/Metlakatla
Asia/Yangon
America/Swift_Current
Asia/Barnaul
Asia/Choibalsan
America/Tijuana
GMT+0
NZ-CHAT
Brazil/DeNoronha
America/Atikokan
Asia/Manila
America/Port_of_Spain
Australia/Broken_Hill
America/Boise
Singapore
Asia/Ho_Chi_Minh
America/Moncton
America/Regina
Asia/Tokyo
Asia/Ujung_Pandang
Africa/Algiers
Turkey
Pacific/Bougainville
Iran
America/Curacao
Antarctica/Rothera
America/St_Vincent
Europe/Brussels
America/Indiana/Vincennes
Asia/Jayapura
Asia/Tashkent
America/Matamoros
America/Shiprock
Atlantic/Faroe
America/St_Lucia
America/Grand_Turk
America/Winnipeg
America/Atka
W-SU
Antarctica/Davis
Europe/Vatican
America/Rainy_River
Europe/Andorra
Antarctica/Casey
Pacific/Noumea
America/Maceio
Africa/Khartoum
Australia/Currie
America/Indiana/Winamac
America/Blanc-Sablon
Pacific/Midway
America/Managua
Europe/Zagreb
Europe/San_Marino
Europe/Guernsey
Africa/Kigali
Europe/Rome
Europe/Athens
PRC
Africa/Bissau
Indian/Cocos
America/St_Barthelemy
Asia/Tel_Aviv
Europe/Saratov
Asia/Bangkok
Asia/Famagusta
GMT
GMT-0
US/Aleutian
Pacific/Auckland
Pacific/Wake
Africa/Libreville
Europe/Kaliningrad
WET
America/Porto_Velho
Poland
Asia/Karachi
Africa/Kinshasa
Europe/Nicosia
Australia/Canberra
America/Nome
Antarctica/McMurdo
Asia/Ulaanbaatar
ROC
Asia/Qyzylorda
Canada/Saskatchewan
Asia/Brunei
US/Alaska
Zulu
Asia/Novosibirsk
Africa/Lubumbashi
America/Argentina/Rio_Gallegos
Europe/Sofia
Atlantic/Faeroe
Pacific/Pago_Pago
Japan
Libya
Pacific/Tahiti
CST6CDT
MST
Indian/Mauritius
America/Fort_Nelson
America/Resolute
America/Indiana/Tell_City
America/Argentina/Salta
America/Bahia
America/Aruba
America/Belem
Africa/Maputo
Asia/Dacca
Pacific/Fiji
Europe/Warsaw
Atlantic/St_Helena
America/Montreal
US/Arizona
America/Antigua
Australia/South
America/Detroit
Europe/Malta
Factory
America/Bogota
Europe/Isle_of_Man
Asia/Seoul
Asia/Qatar
America/Guadeloupe
Europe/Amsterdam
Africa/Blantyre
Pacific/Chuuk
Africa/El_Aaiun
Europe/Ljubljana
America/Marigot
Indian/Mahe
Europe/Luxembourg
America/Inuvik
Antarctica/Macquarie
Antarctica/Troll
America/Rio_Branco
Africa/Malabo
Asia/Colombo
Europe/Madrid
Canada/Eastern
Asia/Vientiane
Pacific/Palau
Asia/Kabul
America/Yellowknife
America/Asuncion
US/Central
Europe/Dublin
Asia/Singapore
Australia/Yancowinna
America/Indiana/Knox
Asia/Macau
America/Coral_Harbour
Eire
Asia/Khandyga
Australia/Darwin
America/North_Dakota/Center
Asia/Omsk
Pacific/Marquesas
Europe/Bucharest
Europe/Copenhagen
Asia/Sakhalin
Asia/Macao
America/Araguaina
Africa/Dakar
Asia/Ashgabat
Antarctica/Palmer
America/Argentina/La_Rioja
America/Knox_IN
Australia/Adelaide
Asia/Kathmandu
Asia/Anadyr
Asia/Atyrau
Asia/Chongqing
America/Mazatlan
Greenwich
Indian/Maldives
America/Panama
Africa/Tunis
Europe/Samara
Brazil/Acre
Pacific/Truk
GB
America/Phoenix
America/Pangnirtung
America/Indiana/Vevay
Atlantic/Jan_Mayen
Atlantic/Azores
America/Creston
America/Argentina/Ushuaia
America/Denver
Australia/Melbourne
Europe/Skopje
America/Nipigon
Asia/Nicosia
America/Lower_Princes
Asia/Shanghai
Israel
America/Manaus
Europe/Kirov
Asia/Tbilisi
Europe/Busingen
Pacific/Tongatapu
Atlantic/Bermuda
Pacific/Samoa
Australia/West
Africa/Johannesburg
Africa/Juba
Europe/Riga
Europe/Moscow
Asia/Kolkata
Cuba
Europe/Prague
Universal
America/Tortola
Europe/Ulyanovsk
Canada/Central
America/Louisville
Indian/Christmas
America/Toronto
America/Belize
America/Anguilla
America/Indianapolis
Portugal
America/Sitka
Pacific/Fakaofo
Asia/Hovd
America/Caracas
Europe/Vilnius
Asia/Harbin
America/El_Salvador
America/Kentucky/Louisville
Europe/Tiraspol
Asia/Chita
Africa/Asmara
America/Indiana/Petersburg
America/Jujuy
Asia/Amman
America/Argentina/San_Juan
Australia/Lord_Howe
Pacific/Funafuti
America/Nuuk
Australia/Lindeman
EET
America/St_Johns
Europe/Belfast
America/Eirunepe
Antarctica/Vostok
Asia/Dushanbe
Atlantic/Stanley
Antarctica/DumontDUrville
America/Boa_Vista
Africa/Bamako
MET
EST
Pacific/Wallis
Africa/Casablanca
Asia/Istanbul
Africa/Mbabane
Pacific/Ponape
America/Tegucigalpa
Africa/Luanda
Chile/Continental
America/Iqaluit
America/Grenada
America/Mendoza
America/Barbados
Australia/Brisbane
Pacific/Chatham
Asia/Aqtobe
Pacific/Pohnpei
America/Sao_Paulo
America/Argentina/Catamarca
America/Martinique
America/Los_Angeles
Africa/Harare
America/Argentina/San_Luis
Asia/Pyongyang
America/Santiago
Africa/Porto-Novo
Asia/Beirut
America/Adak
Pacific/Kosrae
Asia/Almaty
America/Argentina/Jujuy
America/Monterrey
America/Montserrat
America/Campo_Grande
America/Vancouver
America/Menominee
Europe/Istanbul
America/Rankin_Inlet
Africa/Nouakchott
Africa/Bujumbura
America/Rosario
Pacific/Pitcairn
US/Pacific
Pacific/Saipan
Pacific/Johnston
Asia/Chungking
Jamaica
US/Mountain
America/Chihuahua
Africa/Bangui
Pacific/Guam
Australia/Tasmania
Asia/Aqtau
Asia/Yekaterinburg
Pacific/Galapagos
Africa/Gaborone
Europe/Monaco
Europe/Simferopol
Mexico/General
America/Argentina/Tucuman
Asia/Kamchatka
Europe/Oslo
HST
America/North_Dakota/Beulah
Brazil/West
Asia/Krasnoyarsk
Indian/Kerguelen
Pacific/Yap
Europe/Gibraltar
America/Argentina/ComodRivadavia
Hongkong
Africa/Douala
Africa/Maseru
Navajo
Asia/Saigon
America/Guatemala
Asia/Jerusalem
Egypt
Pacific/Norfolk
America/Santo_Domingo
Asia/Tomsk
Pacific/Honolulu
US/Samoa
Europe/Sarajevo
Indian/Comoro
US/Eastern
America/Havana
Africa/Addis_Ababa
Europe/Vaduz
Europe/Helsinki
America/Virgin
Africa/Banjul
Antarctica/Syowa
America/Glace_Bay
Africa/Lagos
America/Goose_Bay
Africa/Freetown
America/Thule
America/Porto_Acre
Europe/Minsk
America/Dawson
Asia/Phnom_Penh
Kwajalein
America/Yakutat
Africa/Lome
Australia/LHI
Pacific/Efate
Asia/Novokuznetsk
Africa/Lusaka
America/Whitehorse
Asia/Hebron
America/Recife
Africa/Djibouti
Africa/Ouagadougou
Asia/Gaza
Asia/Kashgar
America/Edmonton
Asia/Oral
Europe/Tallinn
America/Noronha
Asia/Jakarta
America/Costa_Rica
Africa/Asmera
Pacific/Kwajalein
UCT
Pacific/Majuro
Asia/Taipei
America/Puerto_Rico
Europe/Uzhgorod
Africa/Tripoli
America/Buenos_Aires
Europe/Kiev
Asia/Urumqi
Africa/Timbuktu
Europe/Zaporozhye
America/Hermosillo
Europe/Stockholm
Pacific/Port_Moresby
Canada/Yukon
Brazil/East
Asia/Yakutsk
America/Ensenada
Pacific/Tarawa
America/North_Dakota/New_Salem
Indian/Antananarivo
Asia/Vladivostok
Asia/Riyadh
Asia/Pontianak
Asia/Magadan
America/Cancun
Atlantic/Madeira
Europe/Mariehamn
America/Juneau
Africa/Conakry
Asia/Dubai
Asia/Yerevan
MST7MDT

Case 3: Here's the default list of timezones provided by the timelib library:

America/Grenada
US/Eastern
Asia/Yekaterinburg
Asia/Beirut
Antarctica/Mawson
America/Nuuk
Asia/Aqtau
America/Tortola
ROC
US/Michigan
Europe/Astrakhan
America/Dawson_Creek
America/Costa_Rica
Chile/Continental
Pacific/Johnston
Canada/Mountain
Pacific/Ponape
America/Toronto
Pacific/Funafuti
Pacific/Chatham
Africa/Juba
Europe/Stockholm
Europe/Kaliningrad
Asia/Barnaul
Asia/Tashkent
Asia/Manila
America/Ensenada
Europe/Amsterdam
Pacific/Samoa
America/Indiana/Marengo
America/Eirunepe
Asia/Jerusalem
America/Rainy_River
Europe/Podgorica
Etc/GMT
Atlantic/Jan_Mayen
MST
Factory
Asia/Chita
America/Guyana
Mexico/BajaSur
Brazil/East
Etc/GMT-5
America/Lower_Princes
America/Campo_Grande
Brazil/DeNoronha
Asia/Vladivostok
America/Kentucky/Monticello
Asia/Amman
America/Montevideo
America/Dominica
Eire
America/Mexico_City
Africa/Asmera
Asia/Aden
Asia/Qostanay
America/Hermosillo
America/Argentina/San_Luis
America/Atikokan
Africa/Bamako
America/Juneau
Etc/GMT+4
Africa/Bangui
Jamaica
Canada/Yukon
Asia/Ulan_Bator
Europe/Rome
Antarctica/Casey
Australia/Canberra
America/Rankin_Inlet
Africa/Malabo
Africa/Accra
Asia/Anadyr
Atlantic/Faroe
Mexico/BajaNorte
Europe/Paris
America/Merida
Turkey
Indian/Comoro
Africa/Tunis
America/Montserrat
America/Kentucky/Louisville
UCT
America/Pangnirtung
Etc/GMT+2
Africa/Lubumbashi
WET
Pacific/Pohnpei
America/Indiana/Vevay
Asia/Saigon
America/Danmarkshavn
America/Porto_Acre
America/St_Lucia
Asia/Bangkok
Africa/Casablanca
America/Knox_IN
Africa/Porto-Novo
Kwajalein
America/Cambridge_Bay
Europe/Gibraltar
US/East-Indiana
Europe/Andorra
Asia/Colombo
Asia/Kuwait
Europe/Madrid
America/Jujuy
US/Hawaii
America/Louisville
Asia/Kamchatka
US/Aleutian
Asia/Ulaanbaatar
Asia/Gaza
Zulu
America/Santiago
Europe/San_Marino
America/St_Vincent
America/Argentina/Tucuman
Etc/GMT+10
Australia/Tasmania
Asia/Makassar
America/Caracas
Etc/GMT-6
Africa/Mbabane
America/Miquelon
Africa/Dar_es_Salaam
ROK
America/Thunder_Bay
Europe/Brussels
Asia/Bahrain
CST6CDT
Canada/Newfoundland
Australia/Currie
Pacific/Tarawa
Europe/Ulyanovsk
America/Chihuahua
America/Argentina/Jujuy
Asia/Oral
Greenwich
Pacific/Midway
Asia/Jakarta
America/St_Barthelemy
Etc/GMT+8
Antarctica/Rothera
Africa/Ouagadougou
Europe/Oslo
Asia/Srednekolymsk
Pacific/Guam
Europe/Belfast
Pacific/Honolulu
Africa/Conakry
Europe/Warsaw
Europe/Zagreb
Asia/Novokuznetsk
Europe/London
America/Iqaluit
America/Fort_Nelson
Atlantic/Canary
America/Yellowknife
America/North_Dakota/Center
Asia/Yerevan
Africa/Maputo
Africa/Lagos
Antarctica/Palmer
America/Catamarca
Brazil/Acre
GMT
Pacific/Kosrae
Etc/GMT+0
Asia/Thimphu
America/Shiprock
Indian/Kerguelen
Europe/Vaduz
Africa/Johannesburg
America/Resolute
America/Yakutat
Asia/Yakutsk
EET
Indian/Mayotte
Pacific/Tongatapu
Europe/Jersey
Atlantic/Stanley
Etc/GMT+12
America/Inuvik
GMT+0
America/Manaus
W-SU
Asia/Phnom_Penh
US/Alaska
America/Argentina/San_Juan
America/Godthab
America/Argentina/Mendoza
Etc/GMT-11
Europe/Vienna
America/Fortaleza
Asia/Macao
Asia/Katmandu
America/Thule
America/Montreal
America/Cayman
Africa/Khartoum
Australia/NSW
Africa/Tripoli
America/St_Thomas
Europe/Tallinn
Pacific/Noumea
Africa/Bissau
Europe/Bratislava
US/Pacific
Europe/Istanbul
Etc/GMT-0
Etc/GMT+1
Asia/Chungking
America/Nome
America/Argentina/La_Rioja
Asia/Aqtobe
Asia/Seoul
Asia/Hovd
Africa/Kigali
Antarctica/Syowa
Pacific/Efate
America/Glace_Bay
Africa/Kampala
Europe/Busingen
US/Mountain
Pacific/Marquesas
Australia/Darwin
Africa/Nouakchott
Asia/Qatar
Australia/Brisbane
Etc/GMT-4
Antarctica/Macquarie
Australia/Broken_Hill
Africa/Abidjan
America/Cordoba
Africa/Nairobi
Africa/Addis_Ababa
America/Rosario
Asia/Nicosia
Asia/Dhaka
Europe/Vatican
Libya
Africa/Mogadishu
Europe/Monaco
America/Moncton
Australia/Lindeman
America/Phoenix
Europe/Budapest
America/Grand_Turk
Etc/GMT0
America/Belem
Africa/Luanda
Atlantic/South_Georgia
America/Bahia
Portugal
US/Arizona
Asia/Urumqi
Asia/Hong_Kong
Navajo
Canada/Central
Asia/Famagusta
Africa/Windhoek
Africa/Harare
Asia/Ashgabat
America/Paramaribo
America/Anchorage
America/Maceio
America/Guatemala
America/Mendoza
Etc/GMT+6
Europe/Tiraspol
Etc/GMT-3
America/Barbados
Australia/Eucla
America/Managua
Africa/Ndjamena
Asia/Yangon
Asia/Istanbul
CET
America/Monterrey
America/Sitka
Etc/GMT-7
Pacific/Gambier
Asia/Magadan
Pacific/Galapagos
Etc/GMT+11
Australia/Hobart
Asia/Qyzylorda
Asia/Thimbu
Atlantic/Reykjavik
Europe/Uzhgorod
Europe/Zaporozhye
America/Kralendijk
US/Samoa
Pacific/Auckland
Indian/Reunion
America/Coral_Harbour
PRC
America/Marigot
Indian/Antananarivo
Etc/GMT-8
America/Ojinaga
Europe/Skopje
Asia/Sakhalin
Asia/Chongqing
America/Halifax
Europe/Simferopol
Australia/Perth
America/Noronha
Canada/Pacific
America/Port_of_Spain
Asia/Tel_Aviv
Asia/Omsk
Egypt
Etc/Zulu
Etc/GMT+9
Arctic/Longyearbyen
America/Nassau
Australia/ACT
Europe/Sarajevo
Etc/Greenwich
America/Argentina/Cordoba
Antarctica/Vostok
Australia/Sydney
America/Detroit
Asia/Taipei
Pacific/Kiritimati
GMT0
Israel
HST
Indian/Cocos
America/Virgin
America/Cancun
America/Indiana/Indianapolis
America/Curacao
Pacific/Yap
Pacific/Pitcairn
Asia/Kathmandu
Etc/GMT-14
Pacific/Wake
America/Araguaina
America/St_Johns
Asia/Harbin
Africa/Timbuktu
Mexico/General
Indian/Mauritius
UTC
Europe/Ljubljana
Pacific/Truk
Pacific/Majuro
Canada/Saskatchewan
Europe/Berlin
America/Indiana/Petersburg
America/Boise
Pacific/Saipan
Atlantic/Azores
Asia/Tehran
America/Puerto_Rico
Asia/Baghdad
Europe/Helsinki
Pacific/Fakaofo
Atlantic/Faeroe
Asia/Calcutta
Etc/GMT-1
Asia/Kuala_Lumpur
Atlantic/St_Helena
Europe/Dublin
America/Jamaica
Europe/Copenhagen
Asia/Kuching
America/Havana
America/Regina
Etc/GMT+7
Europe/Malta
America/Chicago
Asia/Shanghai
Europe/Kirov
America/Asuncion
America/Guayaquil
Pacific/Easter
Africa/Bujumbura
Asia/Dacca
Pacific/Fiji
Europe/Riga
GB
Europe/Isle_of_Man
Africa/Djibouti
America/Metlakatla
Australia/Victoria
Europe/Moscow
Cuba
Asia/Pyongyang
Africa/Maseru
Europe/Zurich
Canada/Eastern
America/Anguilla
America/Indiana/Winamac
Africa/Asmara
Asia/Ust-Nera
America/La_Paz
Asia/Riyadh
Europe/Guernsey
America/Boa_Vista
Europe/Athens
Europe/Mariehamn
America/Punta_Arenas
Asia/Vientiane
Asia/Dili
America/Recife
America/Belize
Asia/Dushanbe
Europe/Kiev
Asia/Tokyo
America/Port-au-Prince
America/Menominee
Pacific/Tahiti
Etc/GMT+5
Pacific/Pago_Pago
Pacific/Norfolk
Australia/LHI
America/Indianapolis
Asia/Hebron
America/Bogota
Etc/GMT-13
Europe/Minsk
America/Argentina/Salta
America/Matamoros
Asia/Kashgar
America/Cuiaba
Africa/Cairo
Asia/Muscat
Europe/Vilnius
America/Edmonton
Atlantic/Bermuda
America/Whitehorse
GB-Eire
Europe/Sofia
Asia/Ho_Chi_Minh
America/Santarem
Africa/Libreville
Pacific/Niue
Asia/Singapore
America/Argentina/Buenos_Aires
America/Tijuana
Hongkong
Pacific/Palau
America/New_York
Europe/Volgograd
America/El_Salvador
Asia/Kabul
Pacific/Rarotonga
GMT-0
Canada/Atlantic
Pacific/Guadalcanal
Australia/South
America/Argentina/Rio_Gallegos
America/North_Dakota/New_Salem
America/Vancouver
Africa/Blantyre
Poland
Asia/Ujung_Pandang
Australia/Yancowinna
Europe/Tirane
Pacific/Wallis
MST7MDT
America/Indiana/Tell_City
Australia/Melbourne
America/Denver
Africa/Algiers
Etc/Universal
MET
Asia/Macau
Pacific/Chuuk
Europe/Bucharest
Asia/Karachi
Antarctica/Davis
PST8PDT
America/Buenos_Aires
EST5EDT
Africa/El_Aaiun
Europe/Saratov
America/Santo_Domingo
Asia/Almaty
Africa/Ceuta
Australia/Lord_Howe
Europe/Samara
Singapore
Atlantic/Madeira
Asia/Dubai
Africa/Kinshasa
America/Argentina/Catamarca
Pacific/Nauru
Pacific/Kwajalein
America/Adak
America/Bahia_Banderas
Universal
Pacific/Apia
America/Scoresbysund
Asia/Baku
Europe/Chisinau
America/Antigua
Australia/Adelaide
Africa/Niamey
Asia/Khandyga
America/Aruba
Africa/Lome
America/Sao_Paulo
Indian/Christmas
Africa/Sao_Tome
Europe/Luxembourg
America/Cayenne
Asia/Krasnoyarsk
Chile/EasterIsland
America/Panama
Europe/Belgrade
Asia/Pontianak
America/Porto_Velho
Etc/GMT-2
Antarctica/South_Pole
America/Rio_Branco
Indian/Maldives
Africa/Brazzaville
Etc/GMT-10
America/Guadeloupe
America/Argentina/Ushuaia
Asia/Brunei
Japan
America/Creston
America/Atka
America/Dawson
America/Swift_Current
America/Los_Angeles
America/Argentina/ComodRivadavia
Africa/Monrovia
Asia/Atyrau
America/Mazatlan
America/Tegucigalpa
Asia/Novosibirsk
Indian/Mahe
Africa/Douala
America/Winnipeg
Pacific/Enderbury
Africa/Gaborone
Australia/West
Asia/Kolkata
Asia/Damascus
Australia/Queensland
Asia/Rangoon
Iran
America/Indiana/Knox
Asia/Choibalsan
America/Goose_Bay
Asia/Bishkek
Africa/Banjul
Asia/Samarkand
America/Nipigon
America/Martinique
America/Fort_Wayne
Europe/Lisbon
Europe/Prague
NZ
America/St_Kitts
US/Indiana-Starke
Pacific/Bougainville
America/Blanc-Sablon
Europe/Nicosia
America/Indiana/Vincennes
US/Central
Etc/UCT
Asia/Jayapura
Africa/Dakar
America/Santa_Isabel
Etc/GMT+3
Antarctica/McMurdo
America/Lima
Etc/GMT-12
Africa/Lusaka
Etc/UTC
EST
NZ-CHAT
Asia/Tbilisi
America/North_Dakota/Beulah
Brazil/West
Africa/Freetown
Antarctica/DumontDUrville
Etc/GMT-9
Antarctica/Troll
Australia/North
Pacific/Port_Moresby
Indian/Chagos
Asia/Irkutsk
Iceland
Atlantic/Cape_Verde
Asia/Ashkhabad
Asia/Tomsk

As you see in the first two cases (which are the problematic cases mentioned in this ticket, the Etc/UTC timezone does not exist in the list of our loaded timezones. Now, there could be two reasons for this: 1) this timezone does not actually exist in the underlying files in the first two cases (which is unlikely), 2) timelib does not properly load all timezone in the given timezone directory (which is more likely). I will investigate further and report back.

Comment by Kyle Suarez [ 21/Sep/21 ]

mohammad.dashti, this looks related to your recent timezone work. Could you please take a look?

Comment by Joe Kanaan [ 16/Sep/21 ]

The fact that this works without the timezone parameter is suspicious so I am assigning this to the query execution team for further investigation.

Comment by Kelsey Schubert [ 13/Sep/21 ]

Thanks for the report, maximzasorin@gmail.com. I'm able to reproduce the issue on macOS as well. Passing this along for the team to investigate. Please continue to watch for updates.

Generated at Thu Feb 08 05:47:54 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.