I'm running a container with the postgres image and a container with the metabase image,
docker run -it -d -e "MB_DB_FILE=/path/metabase.db.mv.db" --name postgres
-p port:5432
-e POSTGRES_USER=userbd
-e POSTGRES_PASSWORD=passwordbd
--network metanet
postgres:14
docker run -it -d --name metabase-origin
-p port:3000
-e MB_DB_TYPE=postgres
-e MB_DB_DBNAME=metabase
-e MB_DB_PORT=5432
-e MB_DB_USER=userbd
-e MB_DB_PASS=passwordbd
-e MB_DB_HOST=postgres
--network metanet
metabase/metabase-enterprise:v1.44.4
I upload a backup of my official base to my bank in the container, I use a truncate table in the tables to make the pg_restore of the backup and mirror my bank in the container perfectly.
However when I run the dump instruction according to the serialization manual it gives me an error.
docker run --rm --name metabase-dump
-e MB_DB_CONNECTION_URI="postgres://postgres:5432/metabase?user=userbd&password=passwordbd"
-e "MB_DB_FILE=/mnt/sharedfolder/metabase.db.mv.db"
-v "/mnt/sharedfolder/metabase_data:/target"
--network metanet
metabase/metabase-enterprise:v1.44.4 "dump /target"
I tried without -e "MB_DB_FILE=/mnt/sharedfolder/metabase.db.mv.db" \
but i got the same error,
Usage of Metabase Enterprise Edition features are subject to the Metabase Commercial License. See https://www.metabase.com/license/commercial/ for details.
2022-10-06 14:35:02,401 INFO db.setup :: Verifying postgres Database Connection ...
2022-10-06 14:35:03,027 INFO db.setup :: Successfully verified PostgreSQL 14.5 (Debian 14.5-1.pgdg110+1) application database connection.
2022-10-06 14:35:03,033 INFO db.setup :: Running Database Migrations...
2022-10-06 14:35:03,037 INFO db.setup :: Setting up Liquibase...
2022-10-06 14:35:03,466 INFO db.setup :: Liquibase is ready.
2022-10-06 14:35:03,467 INFO db.liquibase :: Checking if Database has unrun migrations...
2022-10-06 14:35:06,550 INFO db.liquibase :: Database has unrun migrations. Waiting for migration lock to be cleared...
2022-10-06 14:35:06,853 INFO db.liquibase :: Migration lock is cleared. Running migrations...
liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set migrations/000_migrations.yaml::v44.00-000::dpsutton:
Reason: liquibase.exception.DatabaseException: ERROR: relation "persisted_info" already exists [Failed SQL: (0) CREATE TABLE "public"."persisted_info" ("id" INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL, "database_id" INTEGER NOT NULL, "card_id" INTEGER NOT NULL, "question_slug" TEXT NOT NULL, "table_name" TEXT NOT NULL, "definition" TEXT, "query_hash" TEXT, "active" BOOLEAN DEFAULT FALSE NOT NULL, "state" TEXT NOT NULL, "refresh_begin" TIMESTAMP with time zone NOT NULL, "refresh_end" TIMESTAMP with time zone, "state_change_at" TIMESTAMP with time zone, "error" TEXT, "created_at" TIMESTAMP with time zone DEFAULT NOW() NOT NULL, "creator_id" INTEGER NOT NULL, CONSTRAINT "persisted_info_pkey" PRIMARY KEY ("id"), CONSTRAINT "fk_persisted_info_card_id" FOREIGN KEY ("card_id") REFERENCES "public"."report_card"("id") ON DELETE CASCADE, CONSTRAINT "fk_persisted_info_ref_creator_id" FOREIGN KEY ("creator_id") REFERENCES "public"."core_user"("id"), CONSTRAINT "fk_persisted_info_database_id" FOREIGN KEY ("database_id") REFERENCES "public"."metabase_database"("id") ON DELETE CASCADE, UNIQUE ("card_id"))]
at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:126)
at liquibase.Liquibase.lambda$null$0(Liquibase.java:265)
at liquibase.Scope.lambda$child$0(Scope.java:180)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:179)
at liquibase.Scope.child(Scope.java:158)
at liquibase.Scope.child(Scope.java:243)
at liquibase.Liquibase.lambda$update$1(Liquibase.java:264)
at liquibase.Scope.lambda$child$0(Scope.java:180)
at liquibase.Scope.child(Scope.java:189)
at liquibase.Scope.child(Scope.java:179)
at liquibase.Scope.child(Scope.java:158)
at liquibase.Liquibase.runInScope(Liquibase.java:2405)
at liquibase.Liquibase.update(Liquibase.java:211)
at liquibase.Liquibase.update(Liquibase.java:197)
at liquibase.Liquibase.update(Liquibase.java:193)
at metabase.db.liquibase$migrate_up_if_needed_BANG_.invokeStatic(liquibase.clj:142)
at metabase.db.liquibase$migrate_up_if_needed_BANG_.invoke(liquibase.clj:130)
at metabase.db.setup$fn__35433$migrate_BANG___35438$fn__35439$fn__35440.invoke(setup.clj:66)
at metabase.db.liquibase$fn__30951$do_with_liquibase__30956$fn__30957.invoke(liquibase.clj:59)
at metabase.db.liquibase$fn__30951$do_with_liquibase__30956.invoke(liquibase.clj:51)
at metabase.db.setup$fn__35433$migrate_BANG___35438$fn__35439.invoke(setup.clj:61)
at metabase.db.setup$fn__35433$migrate_BANG___35438.invoke(setup.clj:40)
at metabase.db.setup$fn__35492$run_schema_migrations_BANG___35497$fn__35498.invoke(setup.clj:119)
at metabase.db.setup$fn__35492$run_schema_migrations_BANG___35497.invoke(setup.clj:113)
at metabase.db.setup$fn__35544$setup_db_BANG___35549$fn__35550$fn__35553$fn__35554.invoke(setup.clj:145)
at metabase.util$do_with_us_locale.invokeStatic(util.clj:716)
at metabase.util$do_with_us_locale.invoke(util.clj:702)
at metabase.db.setup$fn__35544$setup_db_BANG___35549$fn__35550$fn__35553.invoke(setup.clj:143)
at metabase.db.setup$fn__35544$setup_db_BANG___35549$fn__35550.invoke(setup.clj:142)
at metabase.db.setup$fn__35544$setup_db_BANG___35549.invoke(setup.clj:136)
at metabase.db$setup_db_BANG_$fn__35579.invoke(db.clj:65)
at metabase.db$setup_db_BANG_.invokeStatic(db.clj:60)
at metabase.db$setup_db_BANG_.invoke(db.clj:51)
at metabase_enterprise.serialization.cmd$dump.invokeStatic(cmd.clj:186)
at metabase_enterprise.serialization.cmd$dump.invoke(cmd.clj:181)
at clojure.lang.Var.invoke(Var.java:388)
at metabase.cmd$dump.invokeStatic(cmd.clj:161)
at metabase.cmd$dump.doInvoke(cmd.clj:155)
at clojure.lang.RestFn.invoke(RestFn.java:423)
at metabase.cmd$dump.invokeStatic(cmd.clj:158)
at metabase.cmd$dump.invoke(cmd.clj:155)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.RestFn.applyTo(RestFn.java:132)
at clojure.core$apply.invokeStatic(core.clj:667)
at clojure.core$apply.invoke(core.clj:662)
at metabase.cmd$run_cmd$fn__87573.invoke(cmd.clj:227)
at metabase.cmd$run_cmd.invokeStatic(cmd.clj:227)
at metabase.cmd$run_cmd.invoke(cmd.clj:218)
at clojure.lang.Var.invoke(Var.java:388)
at metabase.core$run_cmd.invokeStatic(core.clj:167)
at metabase.core$run_cmd.invoke(core.clj:165)
at metabase.core$_main.invokeStatic(core.clj:189)
at metabase.core$_main.doInvoke(core.clj:184)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at metabase.core.main(Unknown Source)
If anyone has any suggestions on what I can do, thanks in advance.