metabase-clickhouse-driver
metabase-clickhouse-driver copied to clipboard
Unable to start docker container with this plugin
Unable to start this with docker
Versions
METABASE_VERSION: "v0.48.2"
METABASE_CLICKHOUSE_DRIVER_VERSION: "1.3.2"
Here are the logs when it starts. Somehow it is not able to extract the zip it seems
metabase | 2024-02-18 18:36:49,591 INFO metabase.plugins :: Loading plugins in /plugins...
metabase | 2024-02-18 18:36:50,699 INFO util.files :: Extract file /modules/druid.metabase-driver.jar -> /plugins/druid.metabase-driver.jar
metabase | 2024-02-18 18:36:50,735 INFO util.files :: Extract file /modules/sqlite.metabase-driver.jar -> /plugins/sqlite.metabase-driver.jar
metabase | 2024-02-18 18:36:50,931 INFO util.files :: Extract file /modules/snowflake.metabase-driver.jar -> /plugins/snowflake.metabase-driver.jar
metabase | 2024-02-18 18:36:52,016 INFO util.files :: Extract file /modules/googleanalytics.metabase-driver.jar -> /plugins/googleanalytics.metabase-driver.jar
metabase | 2024-02-18 18:36:52,051 INFO util.files :: Extract file /modules/redshift.metabase-driver.jar -> /plugins/redshift.metabase-driver.jar
metabase | 2024-02-18 18:36:52,070 INFO util.files :: Extract file /modules/oracle.metabase-driver.jar -> /plugins/oracle.metabase-driver.jar
metabase | 2024-02-18 18:36:52,076 INFO util.files :: Extract file /modules/sqlserver.metabase-driver.jar -> /plugins/sqlserver.metabase-driver.jar
metabase | 2024-02-18 18:36:52,102 INFO util.files :: Extract file /modules/sparksql.metabase-driver.jar -> /plugins/sparksql.metabase-driver.jar
metabase | 2024-02-18 18:36:52,260 INFO util.files :: Extract file /modules/presto-jdbc.metabase-driver.jar -> /plugins/presto-jdbc.metabase-driver.jar
metabase | 2024-02-18 18:36:52,404 INFO util.files :: Extract file /modules/bigquery-cloud-sdk.metabase-driver.jar -> /plugins/bigquery-cloud-sdk.metabase-driver.jar
metabase | 2024-02-18 18:36:52,862 INFO util.files :: Extract file /modules/mongo.metabase-driver.jar -> /plugins/mongo.metabase-driver.jar
metabase | 2024-02-18 18:36:52,912 INFO util.files :: Extract file /modules/vertica.metabase-driver.jar -> /plugins/vertica.metabase-driver.jar
metabase | 2024-02-18 18:36:52,916 INFO util.files :: Extract file /modules/athena.metabase-driver.jar -> /plugins/athena.metabase-driver.jar
metabase | 2024-02-18 18:36:54,125 ERROR metabase.core :: Metabase Initialization FAILED
metabase | java.util.zip.ZipException: zip END header not found
metabase | at jdk.zipfs/jdk.nio.zipfs.ZipFileSystem.zerror(Unknown Source)
metabase | at jdk.zipfs/jdk.nio.zipfs.ZipFileSystem.findEND(Unknown Source)
metabase | at jdk.zipfs/jdk.nio.zipfs.ZipFileSystem.initCEN(Unknown Source)
metabase | at jdk.zipfs/jdk.nio.zipfs.ZipFileSystem.<init>(Unknown Source)
metabase | at jdk.zipfs/jdk.nio.zipfs.ZipFileSystemProvider.newFileSystem(Unknown Source)
metabase | at java.base/java.nio.file.FileSystems.newFileSystem(Unknown Source)
metabase | at metabase.util.files$file_exists_in_archive_QMARK_.invokeStatic(files.clj:157)
metabase | at metabase.util.files$file_exists_in_archive_QMARK_.doInvoke(files.clj:154)
metabase | at clojure.lang.RestFn.invoke(RestFn.java:423)
metabase | at metabase.plugins$has_manifest_QMARK_.invokeStatic(plugins.clj:156)
metabase | at metabase.plugins$has_manifest_QMARK_.invoke(plugins.clj:155)
metabase | at clojure.core$sort_by$fn__6045.invoke(core.clj:3132)
metabase | at clojure.lang.AFunction.compare(AFunction.java:51)
metabase | at java.base/java.util.TimSort.countRunAndMakeAscending(Unknown Source)
metabase | at java.base/java.util.TimSort.sort(Unknown Source)
metabase | at java.base/java.util.Arrays.sort(Unknown Source)
metabase | at clojure.core$sort.invokeStatic(core.clj:3116)
metabase | at clojure.core$sort_by.invokeStatic(core.clj:3120)
metabase | at clojure.core$sort_by.invokeStatic(core.clj:3120)
metabase | at clojure.core$sort_by.invoke(core.clj:3120)
metabase | at metabase.plugins$init_plugins_BANG_.invokeStatic(plugins.clj:164)
metabase | at metabase.plugins$init_plugins_BANG_.invoke(plugins.clj:158)
metabase | at metabase.plugins$load_BANG_.invokeStatic(plugins.clj:174)
metabase | at metabase.plugins$load_BANG_.invoke(plugins.clj:170)
metabase | at metabase.plugins$load_plugins_BANG_.invokeStatic(plugins.clj:201)
metabase | at metabase.plugins$load_plugins_BANG_.invoke(plugins.clj:180)
metabase | at metabase.core$init_BANG__STAR_.invokeStatic(core.clj:107)
metabase | at metabase.core$init_BANG__STAR_.invoke(core.clj:97)
metabase | at metabase.core$init_BANG_.invokeStatic(core.clj:154)
metabase | at metabase.core$init_BANG_.invoke(core.clj:149)
metabase | at metabase.core$start_normally.invokeStatic(core.clj:166)
metabase | at metabase.core$start_normally.invoke(core.clj:160)
metabase | at metabase.core$entrypoint.invokeStatic(core.clj:199)
metabase | at metabase.core$entrypoint.doInvoke(core.clj:193)
metabase | at clojure.lang.RestFn.invoke(RestFn.java:397)
metabase | at clojure.lang.AFn.applyToHelper(AFn.java:152)
metabase | at clojure.lang.RestFn.applyTo(RestFn.java:132)
metabase | at clojure.lang.Var.applyTo(Var.java:705)
metabase | at clojure.core$apply.invokeStatic(core.clj:667)
metabase | at clojure.core$apply.invoke(core.clj:662)
metabase | at metabase.bootstrap$_main.invokeStatic(bootstrap.clj:31)
metabase | at metabase.bootstrap$_main.doInvoke(bootstrap.clj:28)
metabase | at clojure.lang.RestFn.invoke(RestFn.java:397)
metabase | at clojure.lang.AFn.applyToHelper(AFn.java:152)
metabase | at clojure.lang.RestFn.applyTo(RestFn.java:132)
metabase | at metabase.bootstrap.main(Unknown Source)
metabase | 2024-02-18 18:36:54,751 INFO metabase.core :: Metabase Shutting Down ...
metabase | 2024-02-18 18:36:54,764 INFO metabase.server :: Shutting Down Embedded Jetty Webserver
Is it possible that you are trying to launch Metabase with the driver as a ZIP archive (and not JAR as Metabase expects)?
Assuming you have clickhouse.metabase-driver.jar (not zip), users.xml, and config.xml in the same directory as the following docker-compose.yml:
version: '3.8'
services:
clickhouse:
image: 'clickhouse/clickhouse-server:24.1-alpine'
container_name: docker-test-metabase-clickhouse-server
ports:
- '8123:8123'
- '9000:9000'
ulimits:
nofile:
soft: 262144
hard: 262144
volumes:
- './config.xml:/etc/clickhouse-server/config.xml'
- './users.xml:/etc/clickhouse-server/users.xml'
metabase:
image: metabase/metabase:v0.48.1
container_name: docker-test-metabase-with-clickhouse-driver
environment:
'MB_HTTP_TIMEOUT': '5000'
'JAVA_TIMEZONE': 'UTC'
ports:
- '3000:3000'
volumes:
- './clickhouse.metabase-driver.jar:/plugins/clickhouse.jar'
(or just use ClickHouse started elsewhere, then remove it from this compose file), it works:
> docker logs docker-test-metabase-with-clickhouse-driver | grep clickhouse
2024-02-18 18:56:57,629 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :clickhouse...
2024-02-18 18:56:57,629 INFO driver.impl :: Registered driver :clickhouse (parents: [:sql-jdbc]) 🚚
If you need sample config.xml or users.xml for ClickHouse, the ones that are used for the driver tests are here: https://github.com/ClickHouse/metabase-clickhouse-driver/tree/master/.docker/clickhouse/single_node