Hi guys!
I’m trying to migrate my H2 data to Postgres/MySQL. Both DBs are deployed on the AWS RDS. My Metabase version is v0.24.1. I’ve tried with the v0.26.2 too.
- MySQL is 5.6.27
- Postgres is 9.6.2
And both create some tables but does not inserts any data and are giving me the same error below.
I’ve already tried this and this guy seems to have the same problem.
Any idea of what is causing this?
java -jar metabase.jar load-from-h2 metabase.db.mv.db
11-22 23:55:56 INFO metabase.util :: Loading Metabase...
11-22 23:56:05 INFO util.encryption :: DB details encryption is DISABLED for this Metabase instance. ?
11-22 23:56:23 INFO metabase.db :: Verifying postgres Database Connection ...
11-22 23:56:23 DEBUG metabase.driver :: Registered driver :postgres ?
11-22 23:56:23 INFO metabase.db :: Verify Database Connection ... ?
11-22 23:56:23 INFO metabase.db :: Running Database Migrations...
11-22 23:56:23 INFO metabase.db :: Setting up Liquibase...
11-22 23:56:23 INFO metabase.db :: Liquibase is ready.
11-22 23:56:23 INFO metabase.db :: Checking if Database has unrun migrations...
11-22 23:56:27 INFO metabase.db :: Database Migrations Current ... ?
com.mchange.v2.cfg.DelayedLogItem [ level -> FINE, text -> "The configuration file for resource identifier 'hocon:/reference,/application,/c3p0,/' could not be found. Skipping.", exception -> null]
Temporarily disabling DB constraints...
[OK]
org.h2.jdbc.JdbcSQLException: A file path that is implicitly relative to the current working directory is not allowed in the database URL "jdbc:h2:metabase.db.mv.db;IFEXISTS=TRUE". Use an absolute path, ~/name, ./name, or the baseDir setting instead. [90011-194]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.engine.ConnectionInfo.getName(ConnectionInfo.java:400)
at org.h2.engine.Engine.openSession(Engine.java:49)
at org.h2.engine.Engine.openSession(Engine.java:176)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:154)
at org.h2.engine.Engine.createSession(Engine.java:137)
at org.h2.engine.Engine.createSession(Engine.java:27)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:354)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:116)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:100)
at org.h2.Driver.connect(Driver.java:69)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at clojure.java.jdbc$get_connection.invokeStatic(jdbc.clj:272)
at clojure.java.jdbc$get_connection.invoke(jdbc.clj:193)
at metabase.cmd.load_from_h2$load_data_BANG_.invokeStatic(load_from_h2.clj:141)
at metabase.cmd.load_from_h2$load_data_BANG_.invoke(load_from_h2.clj:140)
at metabase.cmd.load_from_h2$load_from_h2_BANG_$fn__39488.invoke(load_from_h2.clj:215)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:613)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:585)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:629)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:585)
at clojure.java.jdbc$db_transaction_STAR_.invokeStatic(jdbc.clj:598)
at clojure.java.jdbc$db_transaction_STAR_.invoke(jdbc.clj:585)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invokeStatic(load_from_h2.clj:212)
at metabase.cmd.load_from_h2$load_from_h2_BANG_.invoke(load_from_h2.clj:205)
at clojure.lang.Var.invoke(Var.java:379)
at metabase.core$load_from_h2.invokeStatic(core.clj:210)
at metabase.core$load_from_h2.invoke(core.clj:203)
at clojure.lang.AFn.applyToHelper(AFn.java:154)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:646)
at clojure.core$apply.invoke(core.clj:641)
at metabase.core$run_cmd$fn__40258.invoke(core.clj:264)
at metabase.core$run_cmd.invokeStatic(core.clj:264)
at metabase.core$run_cmd.doInvoke(core.clj:263)
at clojure.lang.RestFn.applyTo(RestFn.java:139)
at clojure.core$apply.invokeStatic(core.clj:648)
at clojure.core$apply.invoke(core.clj:641)
at metabase.core$_main.invokeStatic(core.clj:278)
at metabase.core$_main.doInvoke(core.clj:274)
at clojure.lang.RestFn.applyTo(RestFn.java:137)
at metabase.core.main(Unknown Source)
Command failed with exception: A file path that is implicitly relative to the current working directory is not allowed in the database URL "jdbc:h2:metabase.db.mv.db;IFEXISTS=TRUE". Use an absolute path, ~/name, ./name, or the baseDir setting instead. [90011-194]