Hello.
Sometimes when I refresh a question or it gets refreshed automatically on dashboard, I get this error:
May 25 13:07:59 ERROR metabase.driver.generic-sql.query-processor :: nil
May 25 13:07:59 WARN metabase.query-processor :: {:status :failed,
:class java.lang.Exception,
:error "Communications link failure\n\nThe last packet successfully received from the server was 98,446 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.",
:stacktrace
["driver.generic_sql.query_processor$do_with_try_catch.invokeStatic(query_processor.clj:505)"
"driver.generic_sql.query_processor$do_with_try_catch.invoke(query_processor.clj:497)"
"driver.generic_sql.query_processor$execute_query.invokeStatic(query_processor.clj:555)"
"driver.generic_sql.query_processor$execute_query.invoke(query_processor.clj:551)"
"driver$fn__25845$G__25652__25852.invoke(driver.clj:61)"
"query_processor$execute_query.invokeStatic(query_processor.clj:51)"
"query_processor$execute_query.invoke(query_processor.clj:45)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__30118.invoke(mbql_to_native.clj:30)"
"query_processor.middleware.annotate_and_sort$annotate_and_sort$fn__28510.invoke(annotate_and_sort.clj:41)"
"query_processor.middleware.limit$limit$fn__30073.invoke(limit.clj:15)"
"query_processor.middleware.cumulative_aggregations$cumulative_aggregation$fn__29929.invoke(cumulative_aggregations.clj:58)"
"query_processor.middleware.cumulative_aggregations$cumulative_aggregation$fn__29929.invoke(cumulative_aggregations.clj:58)"
"query_processor.middleware.format_rows$format_rows$fn__30063.invoke(format_rows.clj:26)"
"query_processor.middleware.binning$update_binning_strategy$fn__28589.invoke(binning.clj:172)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__31470.invoke(results_metadata.clj:89)"
"query_processor.middleware.resolve$resolve_middleware$fn__28118.invoke(resolve.clj:424)"
"query_processor.middleware.expand$expand_middleware$fn__29818.invoke(expand.clj:605)"
"query_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__28202.invoke(add_row_count_and_status.clj:14)"
"query_processor.middleware.driver_specific$process_query_in_context$fn__29949.invoke(driver_specific.clj:12)"
"query_processor.middleware.resolve_driver$resolve_driver$fn__31481.invoke(resolve_driver.clj:15)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__28670.invoke(cache.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__29866.invoke(catch_exceptions.clj:58)"
"query_processor$process_query.invokeStatic(query_processor.clj:130)"
"query_processor$process_query.invoke(query_processor.clj:126)"
"query_processor$run_and_save_query_BANG_.invokeStatic(query_processor.clj:243)"
"query_processor$run_and_save_query_BANG_.invoke(query_processor.clj:237)"
"query_processor$fn__31515$process_query_and_save_execution_BANG___31520$fn__31521.invoke(query_processor.clj:283)"
"query_processor$fn__31515$process_query_and_save_execution_BANG___31520.invoke(query_processor.clj:269)"
"query_processor$fn__31539$process_query_and_save_with_max_BANG___31544$fn__31545.invoke(query_processor.clj:304)"
"query_processor$fn__31539$process_query_and_save_with_max_BANG___31544.invoke(query_processor.clj:300)"
"api.dataset$fn__38725$fn__38728$fn__38729.invoke(dataset.clj:50)"
"api.common$fn__20334$invoke_thunk_with_keepalive__20339$fn__20340$fn__20341.invoke(common.clj:400)"],
:query
{:type "query",
:query {:source_table 4},
:parameters [],
:constraints {:max-results 10000, :max-results-bare-rows 2000},
:info
{:executed-by 1,
:context :ad-hoc,
:card-id nil,
:nested? false,
:query-hash [13, -61, -95, -14, -91, 82, -42, 17, -5, 40, 20, -48, -48, -123, 36, 75, -102, -50, 124, 4, 26, -60, -46, 64, -86, -23, 22, -120, -109, 68, 27, 86],
:query-type "MBQL"}},
:expanded-query nil}
May 25 13:07:59 WARN metabase.query-processor :: Query failure: Communications link failure
The last packet successfully received from the server was 98,446 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.
["query_processor$assert_query_status_successful.invokeStatic(query_processor.clj:211)"
"query_processor$assert_query_status_successful.invoke(query_processor.clj:204)"
"query_processor$run_and_save_query_BANG_.invokeStatic(query_processor.clj:244)"
"query_processor$run_and_save_query_BANG_.invoke(query_processor.clj:237)"
"query_processor$fn__31515$process_query_and_save_execution_BANG___31520$fn__31521.invoke(query_processor.clj:283)"
"query_processor$fn__31515$process_query_and_save_execution_BANG___31520.invoke(query_processor.clj:269)"
"query_processor$fn__31539$process_query_and_save_with_max_BANG___31544$fn__31545.invoke(query_processor.clj:304)"
"query_processor$fn__31539$process_query_and_save_with_max_BANG___31544.invoke(query_processor.clj:300)"
"api.dataset$fn__38725$fn__38728$fn__38729.invoke(dataset.clj:50)"
"api.common$fn__20334$invoke_thunk_with_keepalive__20339$fn__20340$fn__20341.invoke(common.clj:400)"]
I suspect some database connection timeout issue, but I’m not sure.
Whole thing happens rather randomly. Sometimes stuff just gets refreshed. Especially when just reloading the web page.
If it’s any help, the source DB is a MySQL DB.