Metabase crashes as soon as dashboard loads

mparsons · November 12, 2019, 11:01am

Hi,

I created a dashboard yesterday and everything worked fine when I was viewing and interacting. As soon as I went away from the dashboard and loaded it up again, Metabase crashed and went back to the home screen. Now every time I load the dashboard it does the same thing.

Any help would be much appreciated! Here is the stack trace:

{:status :failed,
 :class java.sql.SQLException,
 :error
 "[Amazon](500051) ERROR processing query/statement. Error: Execution of prepared query failed , Query: -- Metabase:: userID: 1 queryType: MBQL queryHash: da2efd2602ad58c9ccd7d67b9bb5ab99fbbfd39866d2204ba8fcba435aa98d00

// QUERY REMOVED //

 :stacktrace
 ("com.amazon.redshift.dataengine.PGQueryExecutor.executePreparedStatement(Unknown Source)"
  "com.amazon.redshift.dataengine.PGQueryExecutor.execute(Unknown Source)"
  "com.amazon.jdbc.common.SPreparedStatement.executeWithParams(Unknown Source)"
  "com.amazon.jdbc.common.SPreparedStatement.executeQuery(Unknown Source)"
  "com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)"
  "clojure.java.jdbc$execute_query_with_params.invokeStatic(jdbc.clj:1072)"
  "clojure.java.jdbc$execute_query_with_params.invoke(jdbc.clj:1066)"
  "clojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1081)"
  "clojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1075)"
  "clojure.java.jdbc$query.invokeStatic(jdbc.clj:1164)"
  "clojure.java.jdbc$query.invoke(jdbc.clj:1126)"
  "--> driver.sql_jdbc.execute$cancelable_run_query$fn__66651.invoke(execute.clj:182)"
  "driver.sql_jdbc.execute$do_with_ensured_connection.invokeStatic(execute.clj:159)"
  "driver.sql_jdbc.execute$do_with_ensured_connection.invoke(execute.clj:157)"
  "driver.sql_jdbc.execute$cancelable_run_query.invokeStatic(execute.clj:174)"
  "driver.sql_jdbc.execute$cancelable_run_query.invoke(execute.clj:170)"
  "driver.sql_jdbc.execute$run_query.invokeStatic(execute.clj:196)"
  "driver.sql_jdbc.execute$run_query.invoke(execute.clj:192)"
  "driver.sql_jdbc.execute$do_with_auto_commit_disabled.invokeStatic(execute.clj:243)"
  "driver.sql_jdbc.execute$do_with_auto_commit_disabled.invoke(execute.clj:231)"
  "driver.sql_jdbc.execute$do_in_transaction$fn__66672.invoke(execute.clj:248)"
  "driver.sql_jdbc.execute$do_in_transaction.invokeStatic(execute.clj:247)"
  "driver.sql_jdbc.execute$do_in_transaction.invoke(execute.clj:246)"
  "driver.sql_jdbc.execute$run_query_without_timezone.invokeStatic(execute.clj:265)"
  "driver.sql_jdbc.execute$run_query_without_timezone.invoke(execute.clj:264)"
  "driver.sql_jdbc.execute$execute_query$fn__66699.invoke(execute.clj:297)"
  "driver.sql_jdbc.execute$do_with_try_catch.invokeStatic(execute.clj:223)"
  "driver.sql_jdbc.execute$do_with_try_catch.invoke(execute.clj:217)"
  "driver.sql_jdbc.execute$execute_query.invokeStatic(execute.clj:291)"
  "driver.sql_jdbc.execute$execute_query.invoke(execute.clj:285)"
  "driver.sql_jdbc$fn__67318.invokeStatic(sql_jdbc.clj:44)"
  "driver.sql_jdbc$fn__67318.invoke(sql_jdbc.clj:43)"
  "query_processor$fn__44023$execute_query__44028$fn__44029.invoke(query_processor.clj:71)"
  "query_processor$fn__44023$execute_query__44028.invoke(query_processor.clj:65)"
  "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__34284.invoke(mbql_to_native.clj:38)"
  "query_processor.middleware.annotate$result_rows_maps__GT_vectors$fn__36550.invoke(annotate.clj:541)"
  "query_processor.middleware.annotate$add_column_info$fn__36456.invoke(annotate.clj:485)"
  "query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__37491.invoke(cumulative_aggregations.clj:57)"
  "query_processor.middleware.resolve_joins$resolve_joins$fn__41131.invoke(resolve_joins.clj:184)"
  "query_processor.middleware.limit$limit$fn__38092.invoke(limit.clj:19)"
  "query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__43890.invoke(results_metadata.clj:87)"
  "query_processor.middleware.format_rows$format_rows$fn__38080.invoke(format_rows.clj:26)"
  "query_processor.middleware.add_dimension_projections$add_remapping$fn__35043.invoke(add_dimension_projections.clj:234)"
  "query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__35684.invoke(add_source_metadata.clj:107)"
  "query_processor.middleware.resolve_source_table$resolve_source_tables$fn__41181.invoke(resolve_source_table.clj:46)"
  "query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__35531.invoke(add_row_count_and_status.clj:16)"
  "query_processor.middleware.driver_specific$process_query_in_context$fn__37567.invoke(driver_specific.clj:12)"
  "query_processor.middleware.add_settings$add_settings$fn__35554.invoke(add_settings.clj:45)"
  "query_processor.middleware.resolve_driver$resolve_driver$fn__40795.invoke(resolve_driver.clj:22)"
  "query_processor.middleware.bind_effective_timezone$bind_effective_timezone$fn__36881$fn__36882.invoke(bind_effective_timezone.clj:9)"
  "util.date$call_with_effective_timezone.invokeStatic(date.clj:88)"
  "util.date$call_with_effective_timezone.invoke(date.clj:77)"
  "query_processor.middleware.bind_effective_timezone$bind_effective_timezone$fn__36881.invoke(bind_effective_timezone.clj:8)"
  "query_processor.middleware.store$initialize_store$fn__43915$fn__43916.invoke(store.clj:11)"
  "query_processor.store$do_with_store.invokeStatic(store.clj:46)"
  "query_processor.store$do_with_store.invoke(store.clj:40)"
  "query_processor.middleware.store$initialize_store$fn__43915.invoke(store.clj:10)"
  "query_processor.middleware.async$async__GT_sync$fn__34195.invoke(async.clj:23)"
  "query_processor.middleware.async_wait$runnable$fn__36607.invoke(async_wait.clj:89)"),

flamber · November 12, 2019, 2:52pm

Hi @mparsons
Which version of Metabase? Post the Diagnostic Info from Admin > Troubleshooting.
When you say that Metabase crashes - do you mean that it actually shuts down (and perhaps restarted again by a service process) ?
Can you trigger the same crash by visiting the question directly?

mparsons · November 12, 2019, 4:38pm

Diagnostic Info:

  "browser-info": {
    "language": "en-GB",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/605.1.15 (KHTML, like Gecko)",
    "vendor": "Apple Computer, Inc."
  },
  "system-info": {
    "java.runtime.name": "Java(TM) SE Runtime Environment",
    "java.runtime.version": "1.8.0_202-b08",
    "java.vendor": "Oracle Corporation",
    "java.vendor.url": "http://java.oracle.com/",
    "java.version": "1.8.0_202",
    "java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
    "java.vm.version": "25.202-b08",
    "os.name": "Mac OS X",
    "os.version": "10.14.6",
    "user.language": "en",
    "user.timezone": "Europe/London"
  },
  "metabase-info": {
    "databases": [
      "redshift"
    ],
    "hosting-env": "osx",
    "application-database": "h2",
    "run-mode": "prod",
    "version": {
      "tag": "v0.33.5",
      "date": "2019-11-08",
      "branch": "release-0.33.x",
      "hash": "d9d6f72"
    },
    "settings": {
      "report-timezone": null
    }
  }
}```

mparsons · November 12, 2019, 4:39pm

By the error I mean that when the dashboard begins to load it suddenly cuts to the Metabase loading icon and goes back to the home screen.

If I visit the question directly, it doesn’t seem to crash.

Thanks in advance for the help!

flamber · November 12, 2019, 4:51pm

@mparsons
Okay, then it’s not a crash (I guess), but definitely the first time I’ve heard of it throwing you back to the home screen.
Can you create a new dashboard and only add the failing question? Just to see if it is reproduceable or if there’s something configuration in the original dashboard that is causing it.
Can you also check the browser console (I’m not sure how that works on the Mac app, but it’s just a Safari shell)?