Metabase not showing any error

Get Help
1

Hi Team,

We have recently migrated our metabase backend database from H2 to mysql ,now when i am doing query on bigquery datasource it not giving any error when there is any issue with query .it's only showing the screen "Doing Science".
Previously with H2 database it was working fine.
Please help on this.

2

Hi @raviranjan
Post "Diagnostic Info" from Admin > Troubleshooting.
Check the log for errors - Admin > Troubleshooting > Logs.

3

Hi @flamber
Below is the error we are getting.if we execute same query in bigquery console it is showing the result in sec.
[5c6d49a3-3058-4b53-b1a2-079409a28e9d] 2021-09-03T15:56:00+05:30 ERROR metabase.models.field-values Error fetching field values
clojure.lang.ExceptionInfo: Timed out after 20.0 mins. {:status :timed-out, :type :timed-out}
at metabase.query_processor.context.default$default_timeoutf.invokeStatic(default.clj:90)
at metabase.query_processor.context.default$default_timeoutf.invoke(default.clj:86)
at metabase.query_processor.context$timeoutf.invokeStatic(context.clj:98)
at metabase.query_processor.context$timeoutf.invoke(context.clj:93)
at metabase.query_processor.reducible$wire_up_context_channels_BANG_$fn__37407$state_machine__8588__auto____37416$fn__37418.invoke(reducible.clj:24)
at metabase.query_processor.reducible$wire_up_context_channels_BANG_$fn__37407$state_machine__8588__auto____37416.invoke(reducible.clj:18)
at clojure.core.async.impl.ioc_macros$run_state_machine.invokeStatic(ioc_macros.clj:973)
at clojure.core.async.impl.ioc_macros$run_state_machine.invoke(ioc_macros.clj:972)
at clojure.core.async.impl.ioc_macros$run_state_machine_wrapped.invokeStatic(ioc_macros.clj:977)
at clojure.core.async.impl.ioc_macros$run_state_machine_wrapped.invoke(ioc_macros.clj:975)
at clojure.core.async$ioc_alts_BANG_$fn__8803.invoke(async.clj:385)
at clojure.core.async$do_alts$fn__8743$fn__8746.invoke(async.clj:254)
at clojure.core.async.impl.channels.ManyToManyChannel$fn__3515.invoke(channels.clj:265)
at clojure.lang.AFn.run(AFn.java:22)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

4

@raviranjan

  1. You say that you "recently migrated", but "now" you cannot query BigQuery - what is the time span between "recently" and "now", since I really don't think it has anything to do with migrating.
  2. Post "Diagnostic Info" from Admin > Troubleshooting.
  3. There must be other errors, since that error comes from the specific query