why libchdb.so and clickhouse can run on arm64 linux, but cannot run on docker above it

[l1t1]

chsql call libchdb.so

./chsql
Error running bgClickHouseLocal: Poco::Exception. Code: 1000, e.code() = 0, Exception: Could not determine local time zone: filesystem error: in weakly_canonical: Operation not permitted ["/usr/share/zoneinfo/"], Stack trace (when copying this message, always include the lines below):

0. Poco::Exception::Exception(String&&, int) @ 0x00000000178e9858
1. DateLUT::DateLUT() @ 0x000000000fbfa1d8
2. DateLUT::getInstance() @ 0x000000000fbf8b10
3. OwnPatternFormatter::OwnPatternFormatter(bool) @ 0x000000000ff02898
4. Loggers::buildLoggers(Poco::Util::AbstractConfiguration&, Poco::Logger&, String const&) @ 0x000000000fefc0d8
5. DB::LocalServer::processConfig() @ 0x000000000fe19a70
6. DB::LocalServer::main(std::vector<String, std::allocator<String>> const&) @ 0x000000000fe18308
7. Poco::Util::Application::run() @ 0x00000000179be79c
8. void* std::__thread_proxy[abi:ne190107]<std::tuple<std::unique_ptr<std::__thread_struct, std::default_delete<std::__thread_struct>>, connect_chdb::$_0>>(void*) @ 0x000000000fe28a78
9. ? @ 0x000000000007ee90
10. ? @ 0x00000000000e7b1c
 (version 25.5.2.1)

Query thread terminated with error: bgClickHouseLocal Code: 36. DB::Exception: Error running bgClickHouseLocal: Poco::Exception. Code: 1000, e.code() = 0, Exception: Could not determine local time zone: filesystem error: in weakly_canonical: Operation not permitted ["/usr/share/zoneinfo/"], Stack trace (when copying this message, always include the lines below):

0. Poco::Exception::Exception(String&&, int) @ 0x00000000178e9858
1. DateLUT::DateLUT() @ 0x000000000fbfa1d8
2. DateLUT::getInstance() @ 0x000000000fbf8b10
3. OwnPatternFormatter::OwnPatternFormatter(bool) @ 0x000000000ff02898
4. Loggers::buildLoggers(Poco::Util::AbstractConfiguration&, Poco::Logger&, String const&) @ 0x000000000fefc0d8
5. DB::LocalServer::processConfig() @ 0x000000000fe19a70
6. DB::LocalServer::main(std::vector<String, std::allocator<String>> const&) @ 0x000000000fe18308
7. Poco::Util::Application::run() @ 0x00000000179be79c
8. void* std::__thread_proxy[abi:ne190107]<std::tuple<std::unique_ptr<std::__thread_struct, std::default_delete<std::__thread_struct>>, connect_chdb::$_0>>(void*) @ 0x000000000fe28a78
9. ? @ 0x000000000007ee90
10. ? @ 0x00000000000e7b1c
 (version 25.5.2.1)
. (BAD_ARGUMENTS)
Aborted (core dumped)

clickhouse

./clickhouse
Poco::Exception. Code: 1000, e.code() = 0, Exception: Could not determine local time zone: filesystem error: in canonical: Operation not permitted ["/usr/share/zoneinfo/"] [""], Stack trace (when copying this message, always include the lines below):

0. Poco::Exception::Exception(String&&, int) @ 0x000000001518b494
1. DateLUT::DateLUT() @ 0x000000000b490458
2. DateLUT::getInstance() @ 0x000000000b48ecd0
3. OwnPatternFormatter::OwnPatternFormatter(bool) @ 0x000000000b782434
4. Loggers::buildLoggers(Poco::Util::AbstractConfiguration&, Poco::Logger&, String const&) @ 0x000000000b77b95c
5. DB::LocalServer::processConfig() @ 0x000000000b6a55d8
6. DB::LocalServer::main(std::vector<String, std::allocator<String>> const&) @ 0x000000000b6a3e38
7. Poco::Util::Application::run() @ 0x000000001526537c
8. mainEntryClickHouseLocal(int, char**) @ 0x000000000b6ad500
9. main @ 0x0000000006d5afd4
10. ? @ 0x0000000000027740
11. ? @ 0x0000000000027818
 (version 25.2.1.2150 (official build))

in arm64 linux

./chsql2
Connected to in-memory database successfully
chDB client (type '.exit' to quit, '.help' for help)
chdb> .format PrettyCompact
Output format set to: PrettyCompact
chdb> select * from file('foods.csv')limit 4;
   ┌─category───┬─calories─┬─fats_g─┬─sugars_g─┐
1. │ vegetables │       45 │    0.5 │        2 │
2. │ seafood    │      150 │      5 │        0 │
3. │ meat       │      100 │      5 │        0 │
4. │ fruit      │       60 │      0 │       11 │
   └────────────┴──────────┴────────┴──────────┘

[auxten]

It's a docker image issue. the tzdata is missing. Please refer to ClickHouse/ClickHouse#3157

[l1t1]

but it runs well in amd64 linux +docker, also tz and tzdir is empty

wsl
root@DESKTOP-59T6U68:/mnt/c/Users/lt/Downloads# docker exec -it gcc bash
root@6ae32a5ffcde:/# echo $TZ

root@6ae32a5ffcde:/# ls -la /etc/localtime
lrwxrwxrwx 1 root root 27 Mar 17 00:00 /etc/localtime -> /usr/share/zoneinfo/Etc/UTC
root@6ae32a5ffcde:/# strings /etc/localtime
TZif2
TZif2
UTC0
root@6ae32a5ffcde:/# cd /par
root@6ae32a5ffcde:/par# ./clickhouse
ClickHouse local version 25.6.1.457 (official build).

:) \q
Bye.
root@6ae32a5ffcde:/par# echo $TZDIR

[wudidapaopao]

If tz and tzdir are not set, the system can still work properly by default, as it will check /etc/localtime and /usr/share/zoneinfo/ to determine the time zone. On the machine where the error occurs, you can verify whether there are permissions to view the file /etc/localtime and the subdirectories under /usr/share/zoneinfo/.

[l1t1]

I did as ClickHouse/ClickHouse#3157 said, still got errors

dpkg-reconfigure tzdata
debconf: unable to initialize frontend: Dialog
debconf: (No usable dialog-like program is installed, so the dialog based frontend cannot be used. at /usr/share/perl5/Debconf/FrontEnd/Dialog.pm line 78.)
debconf: falling back to frontend: Readline
Configuring tzdata
------------------

Please select the geographic area in which you live. Subsequent configuration questions will narrow this down by presenting a list of cities, representing the time zones in which they are
located.

  1. Africa  2. America  3. Antarctica  4. Arctic  5. Asia  6. Atlantic  7. Australia  8. Europe  9. Indian  10. Pacific  11. US  12. Etc
Geographic area: 5

Please select the city or region corresponding to your time zone.

  1. Aden      9. Baghdad   17. Chita       25. Dushanbe     33. Irkutsk    41. Kashgar       49. Macau         57. Omsk        65. Riyadh         73. Tashkent     81. Urumqi
  2. Almaty    10. Bahrain  18. Choibalsan  26. Famagusta    34. Istanbul   42. Kathmandu     50. Magadan       58. Oral        66. Sakhalin       74. Tbilisi      82. Ust-Nera
  3. Amman     11. Baku     19. Chongqing   27. Gaza         35. Jakarta    43. Khandyga      51. Makassar      59. Phnom_Penh  67. Samarkand      75. Tehran       83. Vientiane
  4. Anadyr    12. Bangkok  20. Colombo     28. Harbin       36. Jayapura   44. Kolkata       52. Manila        60. Pontianak   68. Seoul          76. Tel_Aviv     84. Vladivostok
  5. Aqtau     13. Barnaul  21. Damascus    29. Hebron       37. Jerusalem  45. Krasnoyarsk   53. Muscat        61. Pyongyang   69. Shanghai       77. Thimphu      85. Yakutsk
  6. Aqtobe    14. Beirut   22. Dhaka       30. Ho_Chi_Minh  38. Kabul      46. Kuala_Lumpur  54. Nicosia       62. Qatar       70. Singapore      78. Tokyo        86. Yangon
  7. Ashgabat  15. Bishkek  23. Dili        31. Hong_Kong    39. Kamchatka  47. Kuching       55. Novokuznetsk  63. Qostanay    71. Srednekolymsk  79. Tomsk        87. Yekaterinburg
  8. Atyrau    16. Brunei   24. Dubai       32. Hovd         40. Karachi    48. Kuwait        56. Novosibirsk   64. Qyzylorda   72. Taipei         80. Ulaanbaatar  88. Yerevan
Time zone: Shanghai


Current default time zone: 'Asia/Shanghai'
Local time is now:      Fri Jul 18 15:52:36 CST 2025.
Universal Time is now:  Fri Jul 18 07:52:36 UTC 2025.

root@66d4e20ec1d7:/# /par/clickhouse
Poco::Exception. Code: 1000, e.code() = 0, Exception: Could not determine local time zone: filesystem error: in canonical: Operation not permitted ["/usr/share/zoneinfo/"] [""], Stack trace (when copying this message, always include the lines below):

set TZ env var aslo useless

TZ=":Pacific/Fiji" /par/clickhouse
Poco::Exception. Code: 1000, e.code() = 0, Exception: Could not determine time zone from TZ variable value: ':Pacific/Fiji': filesystem error: in canonical: Operation not permitted ["/usr/share/zoneinfo/"] [""], Stack trace (when copying this message, always include the lines below):

[wudidapaopao]

Does 'docker run --privileged' work?