Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Your question took too long | Set query timeout #15536

Closed
saikatharryc opened this issue Apr 9, 2021 · 4 comments
Closed

Your question took too long | Set query timeout #15536

saikatharryc opened this issue Apr 9, 2021 · 4 comments

Comments

@saikatharryc
Copy link

saikatharryc commented Apr 9, 2021 •
edited

Describe the bug
I'm trying to query from Metabase to a MySQL database (size is a bit big).
while doing that, I'm getting a message like this:

Your question took too long
We didn't get an answer back from your database in time, so we had to stop. You can try again in a minute, or if the problem persists, you can email an admin to let them know.

I have even tried to set SET SESSION MAX_EXECUTION_TIME=9000; and run the same query, it seems like the timeout of 60s does not get change or get affected at all.

any particular configuration i'm missing here for the timeout?

ENV:
MB_JETTY_HOST: 0.0.0.0 │
│ MB_JETTY_PORT: 3000 │
│ MB_DB_TYPE: mysql │
│ MB_DB_HOST: **** │
│ MB_DB_PORT: 3306 │
│ MB_DB_DBNAME: *** │
│ MB_DB_USER: <set to the key 'username' in secret 'production-'> Optional: false │
│ MB_DB_PASS: <set to the key 'password' in secret 'production-'> Optional: false │
│ MB_PASSWORD_COMPLEXITY: normal │
│ MB_PASSWORD_LENGTH: 24 │
│ JAVA_TIMEZONE: Asia/Kolkata │
│ MB_EMOJI_IN_LOGS: true

Logs

[7e4558e4-aa57-49ec-b5d0-294487153f5c] 2021-04-09T08:00:00+05:30 INFO metabase.task.send-pulses Sending scheduled pulses...
[7e4558e4-aa57-49ec-b5d0-294487153f5c] 2021-04-09T08:00:34+05:30 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 2,
 :started_at #t "2021-04-09T07:59:33.293059+05:30[Asia/Kolkata]",
 :via
 [{:status :failed,
   :class clojure.lang.ExceptionInfo,
   :error "Error executing query",
   :stacktrace
   ["--> driver.sql_jdbc.execute$execute_reducible_query$fn__77803.invoke(execute.clj:393)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:390)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:375)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:384)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:375)"
    "driver.sql_jdbc$fn__79239.invokeStatic(sql_jdbc.clj:54)"
    "driver.sql_jdbc$fn__79239.invoke(sql_jdbc.clj:52)"
    "query_processor.context$executef.invokeStatic(context.clj:59)"
    "query_processor.context$executef.invoke(context.clj:48)"
    "query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
    "query_processor.context.default$default_runf.invoke(default.clj:66)"
    "query_processor.context$runf.invokeStatic(context.clj:45)"
    "query_processor.context$runf.invoke(context.clj:39)"
    "query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
    "query_processor.reducible$pivot.invoke(reducible.clj:31)"
    "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__46455.invoke(mbql_to_native.clj:25)"
    "query_processor.middleware.check_features$check_features$fn__45707.invoke(check_features.clj:41)"
    "query_processor.middleware.limit$limit$fn__46441.invoke(limit.clj:37)"
    "query_processor.middleware.cache$maybe_return_cached_results$fn__45171.invoke(cache.clj:211)"
    "query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__46620.invoke(optimize_datetime_filters.clj:133)"
    "query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__44317.invoke(auto_parse_filter_values.clj:43)"
    "query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__40636.invoke(wrap_value_literals.clj:147)"
    "query_processor.middleware.annotate$add_column_info$fn__40499.invoke(annotate.clj:582)"
    "query_processor.middleware.permissions$check_query_permissions$fn__45582.invoke(permissions.clj:75)"
    "query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__47143.invoke(pre_alias_aggregations.clj:40)"
    "query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__45780.invoke(cumulative_aggregations.clj:60)"
    "query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47456.invoke(resolve_joined_fields.clj:94)"
    "query_processor.middleware.resolve_joins$resolve_joins$fn__47761.invoke(resolve_joins.clj:178)"
    "query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__43911.invoke(add_implicit_joins.clj:181)"
    "query_processor.middleware.large_int_id$convert_id_to_string$fn__46416.invoke(large_int_id.clj:44)"
    "query_processor.middleware.format_rows$format_rows$fn__46396.invoke(format_rows.clj:74)"
    "query_processor.middleware.desugar$desugar$fn__45846.invoke(desugar.clj:21)"
    "query_processor.middleware.binning$update_binning_strategy$fn__44677.invoke(binning.clj:228)"
    "query_processor.middleware.resolve_fields$resolve_fields$fn__45389.invoke(resolve_fields.clj:24)"
    "query_processor.middleware.add_dimension_projections$add_remapping$fn__43541.invoke(add_dimension_projections.clj:314)"
    "query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__43772.invoke(add_implicit_clauses.clj:146)"
    "query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48191.invoke(upgrade_field_literals.clj:45)"
    "query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__44064.invoke(add_source_metadata.clj:122)"
    "query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__47340.invoke(reconcile_breakout_and_order_by_bucketing.clj:97)"
    "query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__44264.invoke(auto_bucket_datetimes.clj:139)"
    "query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45436.invoke(resolve_source_table.clj:45)"
    "query_processor.middleware.parameters$substitute_parameters$fn__47125.invoke(parameters.clj:111)"
    "query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45488.invoke(resolve_referenced.clj:79)"
    "query_processor.middleware.expand_macros$expand_macros$fn__46102.invoke(expand_macros.clj:155)"
    "query_processor.middleware.add_timezone_info$add_timezone_info$fn__44073.invoke(add_timezone_info.clj:15)"
    "query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__48127.invoke(splice_params_in_response.clj:32)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47351$fn__47355.invoke(resolve_database_and_driver.clj:31)"
    "driver$do_with_driver.invokeStatic(driver.clj:60)"
    "driver$do_with_driver.invoke(driver.clj:56)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47351.invoke(resolve_database_and_driver.clj:25)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46342.invoke(fetch_source_query.clj:274)"
    "query_processor.middleware.store$initialize_store$fn__48136$fn__48137.invoke(store.clj:11)"
    "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
    "query_processor.store$do_with_store.invoke(store.clj:38)"
    "query_processor.middleware.store$initialize_store$fn__48136.invoke(store.clj:10)"
    "query_processor.middleware.validate$validate_query$fn__48198.invoke(validate.clj:10)"
    "query_processor.middleware.normalize_query$normalize$fn__46468.invoke(normalize_query.clj:22)"
    "query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__43929.invoke(add_rows_truncated.clj:35)"
    "query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__48112.invoke(results_metadata.clj:147)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__45723.invoke(constraints.clj:42)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__47214.invoke(process_userland_query.clj:135)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__45666.invoke(catch_exceptions.clj:173)"
    "query_processor.reducible$async_qp$qp_STAR___37239$thunk__37240.invoke(reducible.clj:103)"
    "query_processor.reducible$async_qp$qp_STAR___37239.invoke(reducible.clj:109)"
    "query_processor.reducible$sync_qp$qp_STAR___37248$fn__37251.invoke(reducible.clj:135)"
    "query_processor.reducible$sync_qp$qp_STAR___37248.invoke(reducible.clj:134)"
    "query_processor$process_userland_query.invokeStatic(query_processor.clj:237)"
    "query_processor$process_userland_query.doInvoke(query_processor.clj:233)"
    "query_processor$fn__48244$process_query_and_save_execution_BANG___48253$fn__48256.invoke(query_processor.clj:249)"
    "query_processor$fn__48244$process_query_and_save_execution_BANG___48253.invoke(query_processor.clj:241)"
    "query_processor$fn__48288$process_query_and_save_with_max_results_constraints_BANG___48297$fn__48300.invoke(query_processor.clj:261)"
    "query_processor$fn__48288$process_query_and_save_with_max_results_constraints_BANG___48297.invoke(query_processor.clj:254)"
    "api.dataset$run_query_async$fn__54437.invoke(dataset.clj:56)"
    "query_processor.streaming$streaming_response_STAR_$fn__54416$fn__54417.invoke(streaming.clj:72)"
    "query_processor.streaming$streaming_response_STAR_$fn__54416.invoke(streaming.clj:71)"
    "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
    "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
    "async.streaming_response$do_f_async$fn__16060.invoke(streaming_response.clj:84)"],
   :error_type :driver,
   :ex-data
   {:sql
    "-- Metabase:: userID: 1 queryType: native queryHash: 52f7cfda5e2c006a691efaa845797aeea364ae46e6505f0f1a4ff37256938485\nSELECT count(distinct userId) AS `count`\nFROM `events`\nWHERE (`events`.`action` = 'OPEN_FIT_FINDER_DIALOG'\n   AND `events`.`timestamp` >= convert_tz('2020-11-27 00:00:00.000', 'US/Pacific', @@session.time_zone) AND date(`events`.`timestamp`) BETWEEN date(date_add(now(6), INTERVAL -90 day)) AND date(now(6)))\n   AND userId IN (SELECT userId\nFROM `events`\nWHERE (`events`.`action` = 'FIND_FIT_VISIBLE'\n   AND `events`.`timestamp` >= convert_tz('2020-11-27 00:00:00.000', 'US/Pacific', @@session.time_zone) AND (lower(`events`.`jdoc`) like '%/job/%') AND date(`events`.`timestamp`) BETWEEN date(date_add(now(6), INTERVAL -90 day)) AND date(now(6))))",
    :params nil,
    :type :driver}}],
 :state "70100",
 :error_type :driver,
 :json_query
 {:type "native",
  :native
  {:query
   "SELECT count(distinct userId) AS `count`\nFROM `events`\nWHERE (`events`.`action` = 'OPEN_FIT_FINDER_DIALOG'\n   AND `events`.`timestamp` >= convert_tz('2020-11-27 00:00:00.000', 'US/Pacific', @@session.time_zone) AND date(`events`.`timestamp`) BETWEEN date(date_add(now(6), INTERVAL -90 day)) AND date(now(6)))\n   AND userId IN (SELECT userId\nFROM `events`\nWHERE (`events`.`action` = 'FIND_FIT_VISIBLE'\n   AND `events`.`timestamp` >= convert_tz('2020-11-27 00:00:00.000', 'US/Pacific', @@session.time_zone) AND (lower(`events`.`jdoc`) like '%/job/%') AND date(`events`.`timestamp`) BETWEEN date(date_add(now(6), INTERVAL -90 day)) AND date(now(6))))",
   :template-tags {}},
  :database 2,
  :parameters [],
  :middleware {:js-int-to-string? true, :add-default-userland-constraints? true}},
 :status :failed,
 :class java.sql.SQLTimeoutException,
 :stacktrace
 ["org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:47)"
  "org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153)"
  "org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:274)"
  "org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:229)"
  "org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)"
  "org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:163)"
  "com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)"
  "--> driver.sql_jdbc.execute$fn__77724.invokeStatic(execute.clj:265)"
  "driver.sql_jdbc.execute$fn__77724.invoke(execute.clj:263)"
  "driver.sql_jdbc.execute$execute_reducible_query$fn__77803.invoke(execute.clj:391)"
  "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:390)"
  "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:375)"
  "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:384)"
  "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:375)"
  "driver.sql_jdbc$fn__79239.invokeStatic(sql_jdbc.clj:54)"
  "driver.sql_jdbc$fn__79239.invoke(sql_jdbc.clj:52)"
  "query_processor.context$executef.invokeStatic(context.clj:59)"
  "query_processor.context$executef.invoke(context.clj:48)"
  "query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
  "query_processor.context.default$default_runf.invoke(default.clj:66)"
  "query_processor.context$runf.invokeStatic(context.clj:45)"
  "query_processor.context$runf.invoke(context.clj:39)"
  "query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
  "query_processor.reducible$pivot.invoke(reducible.clj:31)"
  "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__46455.invoke(mbql_to_native.clj:25)"
  "query_processor.middleware.check_features$check_features$fn__45707.invoke(check_features.clj:41)"
  "query_processor.middleware.limit$limit$fn__46441.invoke(limit.clj:37)"
  "query_processor.middleware.cache$maybe_return_cached_results$fn__45171.invoke(cache.clj:211)"
  "query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__46620.invoke(optimize_datetime_filters.clj:133)"
  "query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__44317.invoke(auto_parse_filter_values.clj:43)"
  "query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__40636.invoke(wrap_value_literals.clj:147)"
  "query_processor.middleware.annotate$add_column_info$fn__40499.invoke(annotate.clj:582)"
  "query_processor.middleware.permissions$check_query_permissions$fn__45582.invoke(permissions.clj:75)"
  "query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__47143.invoke(pre_alias_aggregations.clj:40)"
  "query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__45780.invoke(cumulative_aggregations.clj:60)"
  "query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47456.invoke(resolve_joined_fields.clj:94)"
  "query_processor.middleware.resolve_joins$resolve_joins$fn__47761.invoke(resolve_joins.clj:178)"
  "query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__43911.invoke(add_implicit_joins.clj:181)"
  "query_processor.middleware.large_int_id$convert_id_to_string$fn__46416.invoke(large_int_id.clj:44)"
  "query_processor.middleware.format_rows$format_rows$fn__46396.invoke(format_rows.clj:74)"
  "query_processor.middleware.desugar$desugar$fn__45846.invoke(desugar.clj:21)"
  "query_processor.middleware.binning$update_binning_strategy$fn__44677.invoke(binning.clj:228)"
  "query_processor.middleware.resolve_fields$resolve_fields$fn__45389.invoke(resolve_fields.clj:24)"
  "query_processor.middleware.add_dimension_projections$add_remapping$fn__43541.invoke(add_dimension_projections.clj:314)"
  "query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__43772.invoke(add_implicit_clauses.clj:146)"
  "query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48191.invoke(upgrade_field_literals.clj:45)"
  "query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__44064.invoke(add_source_metadata.clj:122)"
  "query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__47340.invoke(reconcile_breakout_and_order_by_bucketing.clj:97)"
  "query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__44264.invoke(auto_bucket_datetimes.clj:139)"
  "query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45436.invoke(resolve_source_table.clj:45)"
  "query_processor.middleware.parameters$substitute_parameters$fn__47125.invoke(parameters.clj:111)"
  "query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45488.invoke(resolve_referenced.clj:79)"
  "query_processor.middleware.expand_macros$expand_macros$fn__46102.invoke(expand_macros.clj:155)"
  "query_processor.middleware.add_timezone_info$add_timezone_info$fn__44073.invoke(add_timezone_info.clj:15)"
  "query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__48127.invoke(splice_params_in_response.clj:32)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47351$fn__47355.invoke(resolve_database_and_driver.clj:31)"
  "driver$do_with_driver.invokeStatic(driver.clj:60)"
  "driver$do_with_driver.invoke(driver.clj:56)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__47351.invoke(resolve_database_and_driver.clj:25)"
  "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46342.invoke(fetch_source_query.clj:274)"
  "query_processor.middleware.store$initialize_store$fn__48136$fn__48137.invoke(store.clj:11)"
  "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
  "query_processor.store$do_with_store.invoke(store.clj:38)"
  "query_processor.middleware.store$initialize_store$fn__48136.invoke(store.clj:10)"
  "query_processor.middleware.validate$validate_query$fn__48198.invoke(validate.clj:10)"
  "query_processor.middleware.normalize_query$normalize$fn__46468.invoke(normalize_query.clj:22)"
  "query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__43929.invoke(add_rows_truncated.clj:35)"
  "query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__48112.invoke(results_metadata.clj:147)"
  "query_processor.middleware.constraints$add_default_userland_constraints$fn__45723.invoke(constraints.clj:42)"
  "query_processor.middleware.process_userland_query$process_userland_query$fn__47214.invoke(process_userland_query.clj:135)"
  "query_processor.middleware.catch_exceptions$catch_exceptions$fn__45666.invoke(catch_exceptions.clj:173)"
  "query_processor.reducible$async_qp$qp_STAR___37239$thunk__37240.invoke(reducible.clj:103)"
  "query_processor.reducible$async_qp$qp_STAR___37239.invoke(reducible.clj:109)"
  "query_processor.reducible$sync_qp$qp_STAR___37248$fn__37251.invoke(reducible.clj:135)"
  "query_processor.reducible$sync_qp$qp_STAR___37248.invoke(reducible.clj:134)"
  "query_processor$process_userland_query.invokeStatic(query_processor.clj:237)"
  "query_processor$process_userland_query.doInvoke(query_processor.clj:233)"
  "query_processor$fn__48244$process_query_and_save_execution_BANG___48253$fn__48256.invoke(query_processor.clj:249)"
  "query_processor$fn__48244$process_query_and_save_execution_BANG___48253.invoke(query_processor.clj:241)"
  "query_processor$fn__48288$process_query_and_save_with_max_results_constraints_BANG___48297$fn__48300.invoke(query_processor.clj:261)"
  "query_processor$fn__48288$process_query_and_save_with_max_results_constraints_BANG___48297.invoke(query_processor.clj:254)"
  "api.dataset$run_query_async$fn__54437.invoke(dataset.clj:56)"
  "query_processor.streaming$streaming_response_STAR_$fn__54416$fn__54417.invoke(streaming.clj:72)"
  "query_processor.streaming$streaming_response_STAR_$fn__54416.invoke(streaming.clj:71)"
  "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
  "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
  "async.streaming_response$do_f_async$fn__16060.invoke(streaming_response.clj:84)"],
 :context :ad-hoc,
 :error "(conn=4865160) Query execution was interrupted",
 :row_count 0,
 :running_time 0,
 :data {:rows [], :cols []}}

[7e4558e4-aa57-49ec-b5d0-294487153f5c] 2021-04-09T08:00:34+05:30 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: canceled] 1.0 mins (4 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (17 idle, 0 queued) (133 total active threads) Queries in flight: 1 (0 queued)
[7e4558e4-aa57-49ec-b5d0-294487153f5c] 2021-04-09T08:01:23+05:30 INFO metabase.server.middleware.exceptions Request canceled before finishing.

Metabase Diagnostic Info

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 11_0_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.105 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.10+9",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.10",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.10+9",
    "os.name": "Linux",
    "os.version": "4.14.203-156.332.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "Asia/Kolkata"
  },
  "metabase-info": {
    "databases": [
      "mysql",
      "postgres"
    ],
    "hosting-env": "unknown",
    "application-database": "mysql",
    "application-database-details": {
      "database": {
        "name": "MySQL",
        "version": "5.7.12"
      },
      "jdbc-driver": {
        "name": "MariaDB Connector/J",
        "version": "2.6.2"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-04-01",
      "tag": "v0.38.3",
      "branch": "release-x.38.x",
      "hash": "8332830"
    },
    "settings": {
      "report-timezone": "US/Pacific"
    }
  }
}

NOTE: I have tried passing MB_JETTY_ASYNC_RESPONSE_TIMEOUT as ENV var, did not work either.
@Thomassso
Copy link

Related: Timeout configuration discussion

@flamber
Copy link
Contributor

flamber commented Apr 9, 2021 •
edited

Hi @saikatharryc
You likely have a reverse-proxy that closes the connection after 60 seconds - change the timeout on the reverse-proxy.
See #12423 for more details.

@flamber flamber closed this as completed Apr 9, 2021
@saikatharryc
Copy link
Author

Does not work either,
even after putting the idle timeout of the ALB to 4000s from 60s.
It's straightly keeping 60s the query and then timing out and no difference is noticed.

@flamber
Copy link
Contributor

flamber commented Apr 10, 2021

@saikatharryc If your MySQL is configured to stop queries after 60 seconds, then you need to change that on MySQL.
Then try setting this in Admin > Databases > (your MySQL) > Connection String:
sessionVariables=max_execution_time=600000 - remember MySQL uses milliseconds.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@flamber @saikatharryc @Thomassso