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"]}