Error Duplicate Entry for Database

jins-agridigital · April 18, 2022, 2:25am

I just upgraded to 0.42.4

Was working fine.

Now when I went to check out the models section in the admin, I get the following error which is preventing me to seeing any data across the entire product.

[38d323af-48ed-4f4a-80f4-939aba59b58a] 2022-04-18T12:12:47+10:00 ERROR metabase.server.middleware.log GET /api/database/6/metadata 500 57.6 ms (2 DB calls) 
{:via
 [{:type java.sql.BatchUpdateException,
   :message
   "(conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.MariaDbStatement executeBatchExceptionEpilogue "MariaDbStatement.java" 327]}
  {:type java.sql.SQLIntegrityConstraintViolationException,
   :message
   "(conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory createException "ExceptionFactory.java" 70]}
  {:type org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException,
   :message "Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException of "MariaDbSqlException.java" 34]}
  {:type java.sql.SQLException,
   :message "Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readErrorPacket "AbstractQueryProtocol.java" 1695]}],
 :trace
 [[org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readErrorPacket "AbstractQueryProtocol.java" 1695]
  [org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readPacket "AbstractQueryProtocol.java" 1557]
  [org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol getResult "AbstractQueryProtocol.java" 1520]
  [org.mariadb.jdbc.internal.protocol.AsyncMultiRead call "AsyncMultiRead.java" 132]
  [org.mariadb.jdbc.internal.protocol.AsyncMultiRead call "AsyncMultiRead.java" 67]
  [java.util.concurrent.FutureTask run "FutureTask.java" 264]
  [java.util.concurrent.ThreadPoolExecutor runWorker "ThreadPoolExecutor.java" 1128]
  [java.util.concurrent.ThreadPoolExecutor$Worker run "ThreadPoolExecutor.java" 628]
  [java.lang.Thread run "Thread.java" 829]],
 :cause "Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
 :message
 "(conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
 :sql-exception-chain
 ["BatchUpdateException:"
  "Message: (conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'"
  "SQLState: 23000"
  "Error Code: 1062"]}

I cant access the databases page or anything to do with tables.

Extra debug logs

[38d323af-48ed-4f4a-80f4-939aba59b58a] 2022-04-18T12:20:35+10:00 INFO metabase.driver.bigquery-cloud-sdk DB 6 had hardcoded dataset-id; changing to an inclusion pattern and updating table schemas
[38d323af-48ed-4f4a-80f4-939aba59b58a] 2022-04-18T12:20:35+10:00 ERROR metabase.server.middleware.log GET /api/database 500 21.9 ms (2 DB calls) 
{:via
 [{:type java.sql.BatchUpdateException,
   :message
   "(conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.MariaDbStatement executeBatchExceptionEpilogue "MariaDbStatement.java" 327]}
  {:type java.sql.SQLIntegrityConstraintViolationException,
   :message
   "(conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory createException "ExceptionFactory.java" 70]}
  {:type org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException,
   :message "Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException of "MariaDbSqlException.java" 34]}
  {:type java.sql.SQLException,
   :message "Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readErrorPacket "AbstractQueryProtocol.java" 1695]}],
 :trace
 [[org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readErrorPacket "AbstractQueryProtocol.java" 1695]
  [org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readPacket "AbstractQueryProtocol.java" 1557]
  [org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol getResult "AbstractQueryProtocol.java" 1520]
  [org.mariadb.jdbc.internal.protocol.AsyncMultiRead call "AsyncMultiRead.java" 132]
  [org.mariadb.jdbc.internal.protocol.AsyncMultiRead call "AsyncMultiRead.java" 67]
  [java.util.concurrent.FutureTask run "FutureTask.java" 264]
  [java.util.concurrent.ThreadPoolExecutor runWorker "ThreadPoolExecutor.java" 1128]
  [java.util.concurrent.ThreadPoolExecutor$Worker run "ThreadPoolExecutor.java" 628]
  [java.lang.Thread run "Thread.java" 829]],
 :cause "Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
 :message
 "(conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
 :sql-exception-chain
 ["BatchUpdateException:"
  "Message: (conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'"
  "SQLState: 23000"
  "Error Code: 1062"]}

[38d323af-48ed-4f4a-80f4-939aba59b58a] 2022-04-18T12:21:27+10:00 INFO metabase.driver.bigquery-cloud-sdk DB 6 had hardcoded dataset-id; changing to an inclusion pattern and updating table schemas
[38d323af-48ed-4f4a-80f4-939aba59b58a] 2022-04-18T12:21:27+10:00 ERROR metabase.server.middleware.log GET /api/util/bug_report_details 500 26.6 ms (2 DB calls) 
{:via
 [{:type java.sql.BatchUpdateException,
   :message
   "(conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.MariaDbStatement executeBatchExceptionEpilogue "MariaDbStatement.java" 327]}
  {:type java.sql.SQLIntegrityConstraintViolationException,
   :message
   "(conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory createException "ExceptionFactory.java" 70]}
  {:type org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException,
   :message "Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException of "MariaDbSqlException.java" 34]}
  {:type java.sql.SQLException,
   :message "Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readErrorPacket "AbstractQueryProtocol.java" 1695]}],
 :trace
 [[org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readErrorPacket "AbstractQueryProtocol.java" 1695]
  [org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readPacket "AbstractQueryProtocol.java" 1557]
  [org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol getResult "AbstractQueryProtocol.java" 1520]
  [org.mariadb.jdbc.internal.protocol.AsyncMultiRead call "AsyncMultiRead.java" 132]
  [org.mariadb.jdbc.internal.protocol.AsyncMultiRead call "AsyncMultiRead.java" 67]
  [java.util.concurrent.FutureTask run "FutureTask.java" 264]
  [java.util.concurrent.ThreadPoolExecutor runWorker "ThreadPoolExecutor.java" 1128]
  [java.util.concurrent.ThreadPoolExecutor$Worker run "ThreadPoolExecutor.java" 628]
  [java.lang.Thread run "Thread.java" 829]],
 :cause "Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
 :message
 "(conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
 :sql-exception-chain
 ["BatchUpdateException:"
  "Message: (conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'"
  "SQLState: 23000"
  "Error Code: 1062"]}

[38d323af-48ed-4f4a-80f4-939aba59b58a] 2022-04-18T12:21:29+10:00 DEBUG metabase.server.middleware.log GET /api/task/info 200 7.0 ms (0 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (46 total active threads) Queries in flight: 0 (0 queued)
[38d323af-48ed-4f4a-80f4-939aba59b58a] 2022-04-18T12:21:33+10:00 INFO metabase.driver.bigquery-cloud-sdk DB 6 had hardcoded dataset-id; changing to an inclusion pattern and updating table schemas
[38d323af-48ed-4f4a-80f4-939aba59b58a] 2022-04-18T12:21:33+10:00 ERROR metabase.server.middleware.log GET /api/database 500 24.5 ms (2 DB calls) 
{:via
 [{:type java.sql.BatchUpdateException,
   :message
   "(conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.MariaDbStatement executeBatchExceptionEpilogue "MariaDbStatement.java" 327]}
  {:type java.sql.SQLIntegrityConstraintViolationException,
   :message
   "(conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory createException "ExceptionFactory.java" 70]}
  {:type org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException,
   :message "Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException of "MariaDbSqlException.java" 34]}
  {:type java.sql.SQLException,
   :message "Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
   :at [org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readErrorPacket "AbstractQueryProtocol.java" 1695]}],
 :trace
 [[org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readErrorPacket "AbstractQueryProtocol.java" 1695]
  [org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol readPacket "AbstractQueryProtocol.java" 1557]
  [org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol getResult "AbstractQueryProtocol.java" 1520]
  [org.mariadb.jdbc.internal.protocol.AsyncMultiRead call "AsyncMultiRead.java" 132]
  [org.mariadb.jdbc.internal.protocol.AsyncMultiRead call "AsyncMultiRead.java" 67]
  [java.util.concurrent.FutureTask run "FutureTask.java" 264]
  [java.util.concurrent.ThreadPoolExecutor runWorker "ThreadPoolExecutor.java" 1128]
  [java.util.concurrent.ThreadPoolExecutor$Worker run "ThreadPoolExecutor.java" 628]
  [java.lang.Thread run "Thread.java" 829]],
 :cause "Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
 :message
 "(conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'",
 :sql-exception-chain
 ["BatchUpdateException:"
  "Message: (conn=978106) Duplicate entry '6-mystyler_react_native-usercelebrity' for key 'idx_uniq_table_db_id_schema_name'"
  "SQLState: 23000"
  "Error Code: 1062"]}

jins-agridigital · April 18, 2022, 2:35am

Looks like something about the dataset-id in the metabase DB being hardcoded? Not sure if this is a bug or how its supposed to work.

[38d323af-48ed-4f4a-80f4-939aba59b58a] 2022-04-18T12:21:27+10:00 INFO metabase.driver.bigquery-cloud-sdk DB 6 had hardcoded dataset-id; changing to an inclusion pattern and updating table schemas
[38d323af-48ed-4f4a-80f4-939aba59b58a] 2022-04-18T12:21:27+10:00 ERROR metabase.server.middleware.log GET /api/util/bug_report_details 500 26.6 ms (2 DB calls)

Trying to figure out a way to at least have it operational.

jins-agridigital · April 18, 2022, 2:39am

Confirming that when I revert back to 0.41.6, Metabase operates as expected with no errors.

[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:11+10:00 INFO metabase.plugins Loading plugins in /plugins...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:11+10:00 INFO metabase.util.files Extract file /modules/googleanalytics.metabase-driver.jar -> /plugins/googleanalytics.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:11+10:00 INFO metabase.util.files Extract file /modules/presto-jdbc.metabase-driver.jar -> /plugins/presto-jdbc.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:12+10:00 INFO metabase.util.files Extract file /modules/redshift.metabase-driver.jar -> /plugins/redshift.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:12+10:00 INFO metabase.util.files Extract file /modules/sparksql.metabase-driver.jar -> /plugins/sparksql.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:12+10:00 INFO metabase.util.files Extract file /modules/oracle.metabase-driver.jar -> /plugins/oracle.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:12+10:00 INFO metabase.util.files Extract file /modules/sqlite.metabase-driver.jar -> /plugins/sqlite.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:12+10:00 INFO metabase.util.files Extract file /modules/vertica.metabase-driver.jar -> /plugins/vertica.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:12+10:00 INFO metabase.util.files Extract file /modules/snowflake.metabase-driver.jar -> /plugins/snowflake.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:12+10:00 INFO metabase.util.files Extract file /modules/presto-common.metabase-driver.jar -> /plugins/presto-common.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:12+10:00 INFO metabase.util.files Extract file /modules/druid.metabase-driver.jar -> /plugins/druid.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:12+10:00 INFO metabase.util.files Extract file /modules/google.metabase-driver.jar -> /plugins/google.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:12+10:00 INFO metabase.util.files Extract file /modules/presto.metabase-driver.jar -> /plugins/presto.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:12+10:00 INFO metabase.util.files Extract file /modules/mongo.metabase-driver.jar -> /plugins/mongo.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:12+10:00 INFO metabase.util.files Extract file /modules/sqlserver.metabase-driver.jar -> /plugins/sqlserver.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:12+10:00 INFO metabase.util.files Extract file /modules/bigquery.metabase-driver.jar -> /plugins/bigquery.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:12+10:00 INFO metabase.util.files Extract file /modules/bigquery-cloud-sdk.metabase-driver.jar -> /plugins/bigquery-cloud-sdk.metabase-driver.jar
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :snowflake...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.driver.impl Registered driver :snowflake (parents: [:sql-jdbc]) 🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Metabase cannot initialize plugin Metabase Oracle Driver due to required dependencies. Metabase requires the Oracle JDBC driver in order to connect to Oracle databases, but we can't ship it as part of Metabase due to licensing restrictions. See https://metabase.com/docs/latest/administration-guide/databases/oracle.html for more details.

[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Metabase Oracle Driver dependency {:class oracle.jdbc.OracleDriver} satisfied? false
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Oracle Driver"]
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlserver...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.driver.impl Registered driver :sqlserver (parents: [:sql-jdbc]) 🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Plugin 'Metabase Google Analytics Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? false
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Google Analytics Driver"]
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :mongo...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.driver.impl Registered driver :mongo  🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :google...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.driver.impl Registered abstract driver :google  🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Metabase Google Analytics Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.initialize Dependencies satisfied; these plugins will now be loaded: ["Metabase Google Analytics Driver"]
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :googleanalytics...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.driver.impl Registered driver :googleanalytics (parents: [:google]) 🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sqlite...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.driver.impl Registered driver :sqlite (parents: [:sql-jdbc]) 🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :hive-like...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.driver.impl Registered abstract driver :hive-like (parents: [:sql-jdbc]) 🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :sparksql...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.driver.impl Registered driver :sparksql (parents: [:hive-like]) 🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Plugin 'Metabase Presto JDBC Driver' depends on plugin 'Presto Common Driver'
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? false
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Presto JDBC Driver"]
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto-common...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.driver.impl Registered abstract driver :presto-common  🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Metabase Presto JDBC Driver dependency {:plugin Presto Common Driver} satisfied? true
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.initialize Dependencies satisfied; these plugins will now be loaded: ["Metabase Presto JDBC Driver"]
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto-jdbc...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.driver.impl Registered driver :presto-jdbc (parents: [:presto-common]) 🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :redshift...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.driver.impl Registered driver :redshift (parents: [:postgres]) 🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :bigquery-cloud-sdk...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.driver.impl Registered driver :bigquery-cloud-sdk (parents: [:sql]) 🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Metabase Presto Driver dependency {:plugin Presto Common Driver} satisfied? true
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Plugin 'Metabase Presto Driver' depends on plugin 'Presto Common Driver'
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :presto...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.driver.impl Registered driver :presto (parents: [:presto-common]) 🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Plugin 'Metabase BigQuery Driver' depends on plugin 'Metabase Google Drivers Shared Dependencies'
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 WARN metabase.plugins.lazy-loaded-driver Warning: plugin manifest for :bigquery does not include connection properties
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Metabase BigQuery Driver dependency {:plugin Metabase Google Drivers Shared Dependencies} satisfied? true
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :bigquery...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.driver.impl Registered driver :bigquery (parents: [:sql :google]) 🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 DEBUG metabase.plugins.lazy-loaded-driver Registering lazy loading driver :druid...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.driver.impl Registered driver :druid  🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Metabase cannot initialize plugin Metabase Vertica Driver due to required dependencies. Metabase requires the Vertica JDBC driver in order to connect to Vertica databases, but we can't ship it as part of Metabase due to licensing restrictions. See https://metabase.com/docs/latest/administration-guide/databases/vertica.html for more details.

[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Metabase Vertica Driver dependency {:class com.vertica.jdbc.Driver} satisfied? false
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.plugins.dependencies Plugins with unsatisfied deps: ["Metabase Oracle Driver" "Metabase Vertica Driver"]
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.core Setting up and migrating Metabase DB. Please sit tight, this may take a minute...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:13+10:00 INFO metabase.db.setup Verifying mysql Database Connection ...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:14+10:00 INFO metabase.db.setup Successfully verified MySQL 5.7.36-google-log application database connection. ✅
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:14+10:00 INFO metabase.db.setup Running Database Migrations...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:14+10:00 INFO metabase.db.setup Setting up Liquibase...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:14+10:00 INFO metabase.db.setup Liquibase is ready.
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:14+10:00 INFO metabase.db.liquibase Checking if Database has unrun migrations...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:17+10:00 INFO metabase.db.liquibase Database has unrun migrations. Waiting for migration lock to be cleared...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:17+10:00 INFO metabase.db.liquibase Migration lock is cleared. Running migrations...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:17+10:00 INFO metabase.db.setup Database Migrations Current ...  ✅
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:17+10:00 INFO metabase.db.data-migrations Running all necessary data migrations, this may take a minute.
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:17+10:00 INFO metabase.db.data-migrations Finished running data migrations.
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:17+10:00 INFO metabase.events Starting events listener: :metabase.events.dependencies/Dependencies 👂
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:17+10:00 INFO metabase.events Starting events listener: :metabase.events.activity-feed/ActivityFeed 👂
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:17+10:00 INFO metabase.events Starting events listener: :metabase.events.metabot-lifecycle/MetaBotLifecycle 👂
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:17+10:00 INFO metabase.events Starting events listener: :metabase.events.last-login/LastLogin 👂
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:17+10:00 INFO metabase.events Starting events listener: :metabase.events.notifications/Notifications 👂
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:17+10:00 INFO metabase.events Starting events listener: :metabase.events.sync-database/Sync 👂
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:17+10:00 INFO metabase.events Starting events listener: :metabase.events.driver-notifications/DriverNotifications 👂
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:17+10:00 INFO metabase.events Starting events listener: :metabase.events.revision/Revisions 👂
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:17+10:00 INFO metabase.events Starting events listener: :metabase.events.view-log/ViewLog 👂
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:17+10:00 INFO metabase.task Initializing task SyncDatabases 📆
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:18+10:00 INFO metabase.task Initializing task CheckForNewVersions 📆
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:18+10:00 INFO metabase.task Initializing task SendAnonymousUsageStats 📆
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:18+10:00 INFO metabase.task Initializing task SendAbandomentEmails 📆
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:18+10:00 INFO metabase.task Initializing task SendPulses 📆
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:18+10:00 INFO metabase.task Initializing task SendFollowUpEmails 📆
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:18+10:00 INFO metabase.task Initializing task TaskHistoryCleanup 📆
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:27:18+10:00 INFO metabase.core Metabase Initialization COMPLETE
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:28:17+10:00 INFO metabase.metabot Starting MetaBot threads...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:28:17+10:00 INFO metabase.metabot.instance This instance will now handle MetaBot duties.
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:28:32+10:00 INFO metabase.driver.impl Initializing driver :sql...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:28:32+10:00 INFO metabase.driver.impl Initializing driver :sql-jdbc...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:28:32+10:00 INFO metabase.driver.impl Initializing driver :mysql...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:28:54+10:00 INFO metabase.util.i18n.impl Reading available locales from locales.clj...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:28:55+10:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 28.2 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 4/50 (3 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:28:55+10:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 621.2 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (3 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:28:56+10:00 DEBUG metabase.server.middleware.log GET /api/database 200 30.0 ms (4 DB calls) App DB connections: 1/4 Jetty threads: 4/50 (3 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:28:56+10:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 244.4 ms (4 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (3 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:28:57+10:00 DEBUG metabase.server.middleware.log GET /api/collection/root 200 24.4 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (3 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:28:57+10:00 DEBUG metabase.server.middleware.log GET /api/collection/root/items 200 50.1 ms (5 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:01+10:00 DEBUG metabase.server.middleware.log GET /api/setting 200 4.6 ms (0 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:02+10:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 20.4 ms (2 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:02+10:00 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 138.6 ms (11 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:05+10:00 DEBUG metabase.server.middleware.log GET /api/database/6 200 14.8 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:09+10:00 DEBUG metabase.server.middleware.log GET /api/database/6/metadata 200 3.8 s (339 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (49 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:20+10:00 DEBUG metabase.server.middleware.log PUT /api/table 200 27.6 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:28+10:00 DEBUG metabase.server.middleware.log PUT /api/table 200 18.1 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:29+10:00 DEBUG metabase.server.middleware.log PUT /api/table 200 21.8 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:31+10:00 DEBUG metabase.server.middleware.log PUT /api/table 200 17.1 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:34+10:00 DEBUG metabase.server.middleware.log GET /api/table/48909 200 25.2 ms (5 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:34+10:00 INFO metabase.driver.impl Initializing driver :bigquery-cloud-sdk...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:34+10:00 INFO metabase.plugins.classloader Added URL file:/plugins/bigquery-cloud-sdk.metabase-driver.jar to classpath
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:34+10:00 DEBUG metabase.plugins.init-steps Loading plugin namespace metabase.driver.bigquery-cloud-sdk...
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:34+10:00 INFO metabase.driver.impl Registered driver :bigquery-cloud-sdk (parents: [:sql]) 🚚
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:35+10:00 DEBUG metabase.server.middleware.log GET /api/table/48909/query_metadata 200 248.7 ms (9 DB calls) App DB connections: 1/4 Jetty threads: 4/50 (3 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:35+10:00 DEBUG metabase.server.middleware.log GET /api/database/6/idfields 200 190.0 ms (6 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (3 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:40+10:00 DEBUG metabase.server.middleware.log PUT /api/table/48909 200 17.6 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:43+10:00 DEBUG metabase.server.middleware.log GET /api/database/6/metadata 200 2.7 s (339 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:46+10:00 DEBUG metabase.server.middleware.log GET /api/table/48911 200 12.5 ms (5 DB calls) App DB connections: 1/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:47+10:00 DEBUG metabase.server.middleware.log GET /api/database/6/idfields 200 165.9 ms (6 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:47+10:00 DEBUG metabase.server.middleware.log GET /api/table/48911/query_metadata 200 25.1 ms (9 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:53+10:00 DEBUG metabase.server.middleware.log PUT /api/table/48911 200 13.6 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:55+10:00 DEBUG metabase.server.middleware.log GET /api/database/6/metadata 200 2.0 s (339 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:57+10:00 DEBUG metabase.server.middleware.log GET /api/table/48912 200 10.0 ms (5 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:58+10:00 DEBUG metabase.server.middleware.log GET /api/table/48912/query_metadata 200 22.4 ms (9 DB calls) App DB connections: 1/4 Jetty threads: 4/50 (3 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:29:58+10:00 DEBUG metabase.server.middleware.log GET /api/database/6/idfields 200 224.7 ms (6 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (3 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:30:03+10:00 DEBUG metabase.server.middleware.log PUT /api/table/48912 200 14.8 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:30:05+10:00 DEBUG metabase.server.middleware.log GET /api/table/46940 200 10.3 ms (5 DB calls) App DB connections: 2/4 Jetty threads: 4/50 (3 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:30:05+10:00 DEBUG metabase.server.middleware.log GET /api/table/46940/query_metadata 200 19.8 ms (9 DB calls) App DB connections: 1/4 Jetty threads: 5/50 (2 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:30:06+10:00 DEBUG metabase.server.middleware.log GET /api/database/6/idfields 200 185.3 ms (6 DB calls) App DB connections: 1/4 Jetty threads: 4/50 (2 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:30:06+10:00 DEBUG metabase.server.middleware.log GET /api/database/6/metadata 200 2.0 s (339 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (3 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:30:17+10:00 DEBUG metabase.server.middleware.log PUT /api/table/46940 200 14.2 ms (3 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:30:19+10:00 DEBUG metabase.server.middleware.log GET /api/database/6/metadata 200 2.2 s (339 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:30:26+10:00 DEBUG metabase.server.middleware.log GET /api/setting 200 1.6 ms (0 DB calls) App DB connections: 1/4 Jetty threads: 5/50 (2 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:30:26+10:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 27.4 ms (2 DB calls) App DB connections: 1/4 Jetty threads: 5/50 (2 idle, 0 queued) (51 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:30:26+10:00 DEBUG metabase.server.middleware.log GET /api/setup/admin_checklist 200 33.5 ms (11 DB calls) App DB connections: 0/4 Jetty threads: 5/50 (2 idle, 0 queued) (52 total active threads) Queries in flight: 0 (0 queued)
[ea894972-8f14-4702-9f74-6f799d6a169d] 2022-04-18T12:31:11+10:00 DEBUG metabase.server.middleware.log GET /api/util/bug_report_details 200 15.9 ms (1 DB calls) App DB connections: 0/4 Jetty threads: 3/50 (4 idle, 0 queued) (55 total active threads) Queries in flight: 0 (0 queued)

flamber · April 18, 2022, 8:55am

@jins-agridigital You have changed your BigQuery driver from the new driver to the old driver, and then back to the new driver again.
Edit the application database table metabase_database.details and remove "dataset-id":"(your-dataset-name)",
Remember to backup your application database first.

jins-agridigital · April 19, 2022, 11:28pm

Thanks @flamber

Im confused as I upgraded the BigQuery Driver to the new one in version 0.41.6

However when I upgrade to 0.42.4 is there assertion that the BigQuery Driver downgrades by default?

In terms of the application database, it is separately hosted and constantly backed up

flamber · April 20, 2022, 8:28am

@jins-agridigital Do what I wrote in previous comment, then everything will work.

metabase-gr8 · April 21, 2022, 1:22pm

I was upgrading from v0.41.2 to 0.42.4 and the upgrade failed. There were 2 main errors that I am listing down. One of them is fixed but the key duplication error is still there. I had to update big query driver but even after updating BQ driver, the Metabase main page was throwing an error saying "Please wait or refresh to check the issue".

I was reading in this discussion that we need to update " Edit the application database table metabase_database.details and remove "dataset-id":"(your-dataset-name)". Our's is a helm deployment and running on k8 setup. I don't see this option over there. Can you please help us in fixing this?

cause: "Duplicate entry '10-xxxx-NW_Reviewers' for key 'idx_uniq_table_db_id_schema_name'"
message: "(conn=510854) Duplicate entry '10-xxxx-NW_Reviewers' for key 'idx_uniq_table_db_id_schema_name'

flamber · April 21, 2022, 1:26pm

@metabase-gr8 So you are saying that you don't have the possibility to backup the Metabase application database? That doesn't sound correct.
Post "Diagnostic Info" from Admin > Troubleshooting.

metabase-gr8 · April 22, 2022, 1:38pm

I can backup the metabase db application which is called metabase. But what do I do after that?

flamber · April 22, 2022, 1:42pm

@metabase-gr8 If you have access to the application database, then you can change the data as I pointed out in Error Duplicate Entry for Database

metabase-gr8 · April 22, 2022, 2:33pm

Thanks. I have one last doubt. Do I need to remove the field - dataset-id in the table metabase_database.details after the upgrade? Will it be fine if I remove it before the upgrade?

flamber · April 22, 2022, 2:36pm

@metabase-gr8 You only need to remove the property if you are experiencing the problem outlined in this forum topic. It doesn't matter when you remove it, but Metabase should not be running.

Make a backup - and try - if it works, great, if it doesn't then provide more information. Backup is the key!

promisepreston · February 15, 2023, 11:40am

Hi, I'm having a similar issue.

I was running a metabase on docker using the H2 database. So right now I was to upgrade to another version. But the recommendation is that I upgrade to a production database, and I want to migrate to MySQL database.

I have backed up the database using the command below:

sudo docker cp metabase_metabase_1:/metabase.db/metabase.db.mv.db ./

When I tried running the migration using the command below:

export MB_DB_TYPE=mysql
export MB_DB_DBNAME=metabase
export MB_DB_PORT=3306
export MB_DB_USER=<username>
export MB_DB_PASS=<password>
export MB_DB_HOST=localhost
java -jar metabase.jar load-from-h2 ./metabase.db

I get the error below:

Caused by: java.sql.SQLIntegrityConstraintViolationException: (conn=182563) Duplicate entry '66-my_dev_db-role' for key 'metabase_table.idx_uniq_table_db_id_schema_name'

From your explanations, how can I view this H2 database backup tables to fix the issue?

TonyC · February 15, 2023, 1:00pm

Aren't you able to connect with an IDE such as Dbeaver which should be free. I use DataGrip but that's not free as far as i know

promisepreston · February 15, 2023, 1:15pm

Can I connect to the H2 database backup file using Dbeaver or DataGrip or do I first create a H2 database and then restore the database backup to it?

What I'm trying to do is first, create a H2 database and then restore the database backup to it. Then I can access it with a Database client tool like Dbeaver, but I'm running into a lot of errors.

If you have a way this can be achieved, please share, I will appreciate it.

TonyC · February 15, 2023, 1:27pm

I don't seem to understand. Your command is trying to load metabase with the backedup H2 database and that is why you are running into errors because of some duplicates you need to remove. But you should be able to connect to the H2 since that is just a file

promisepreston · February 15, 2023, 4:31pm

Thank you.
DBeaver Database client worked for me.

Luiggi · February 16, 2023, 12:34pm

@promisepreston get away from h2 as soon as you can, the more you stay with that db the more you can end up losing all your work