Metabase Keep getting SQLTransientException when pulling large amount of data

Hello everyone, I am new to Metabase. For some reason, our company starting to use Metabase to visualize our data set and yes Metabase doing a very good job making our life easier. But we meet some challenges when we trying to use Metabase

We have modified the maximum query rows to 5,000,000. Our system spec is 4core 8GB. When every time we trying to open the dataset we meet SQLTransientException. This is the error log.

Appreciate for your help. Thanks

{:database_id 3,
:started_at #t “2020-08-18T02:13:02.464153Z[UTC]”,
:via
[{:status :failed,
:class java.sql.SQLTransientException,
:error “(conn=92803) Query execution was interrupted”,
:stacktrace
[“org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:255)”
“org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:164)”
“org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:258)”
“org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:225)”
“org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:145)”
“org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:159)”
“com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)”
“–> driver.sql_jdbc.execute$fn__72670.invokeStatic(execute.clj:267)”
“driver.sql_jdbc.execute$fn__72670.invoke(execute.clj:265)”
“driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:389)”
“driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)”
“driver.sql_jdbc$fn__72760.invokeStatic(sql_jdbc.clj:49)”
“driver.sql_jdbc$fn__72760.invoke(sql_jdbc.clj:47)”
“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:69)”
“query_processor.context.default$default_runf.invoke(default.clj:67)”
“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__45048.invoke(mbql_to_native.clj:26)”
“query_processor.middleware.check_features$check_features$fn__44350.invoke(check_features.clj:42)”
“query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45213.invoke(optimize_datetime_filters.clj:133)”
“query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__46741.invoke(wrap_value_literals.clj:137)”
“query_processor.middleware.annotate$add_column_info$fn__42325.invoke(annotate.clj:574)”
“query_processor.middleware.permissions$check_query_permissions$fn__44225.invoke(permissions.clj:64)”
“query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__45731.invoke(pre_alias_aggregations.clj:40)”
“query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44423.invoke(cumulative_aggregations.clj:61)”
“query_processor.middleware.resolve_joins$resolve_joins$fn__46263.invoke(resolve_joins.clj:183)”
“query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__37977.invoke(add_implicit_joins.clj:245)”
“query_processor.middleware.limit$limit$fn__45034.invoke(limit.clj:38)”
“query_processor.middleware.format_rows$format_rows$fn__45015.invoke(format_rows.clj:81)”
“query_processor.middleware.desugar$desugar$fn__44489.invoke(desugar.clj:22)”
“query_processor.middleware.binning$update_binning_strategy$fn__42869.invoke(binning.clj:229)”
“query_processor.middleware.resolve_fields$resolve_fields$fn__44031.invoke(resolve_fields.clj:24)”
“query_processor.middleware.add_dimension_projections$add_remapping$fn__37526.invoke(add_dimension_projections.clj:272)”
“query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__37733.invoke(add_implicit_clauses.clj:141)”
“query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__38204.invoke(add_source_metadata.clj:105)”
“query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__45928.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)”
“query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__42510.invoke(auto_bucket_datetimes.clj:125)”
“query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44078.invoke(resolve_source_table.clj:46)”
“query_processor.middleware.parameters$substitute_parameters$fn__45713.invoke(parameters.clj:114)”
“query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44130.invoke(resolve_referenced.clj:80)”
“query_processor.middleware.expand_macros$expand_macros$fn__44745.invoke(expand_macros.clj:158)”
“query_processor.middleware.add_timezone_info$add_timezone_info$fn__38235.invoke(add_timezone_info.clj:15)”
“query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__46625.invoke(splice_params_in_response.clj:32)”
“query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__45939$fn__45943.invoke(resolve_database_and_driver.clj:33)”
“driver$do_with_driver.invokeStatic(driver.clj:61)”
“driver$do_with_driver.invoke(driver.clj:57)”
“query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__45939.invoke(resolve_database_and_driver.clj:27)”
“query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__44963.invoke(fetch_source_query.clj:267)”
“query_processor.middleware.store$initialize_store$fn__46634$fn__46635.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__46634.invoke(store.clj:10)”
“query_processor.middleware.cache$maybe_return_cached_results$fn__43361.invoke(cache.clj:209)”
“query_processor.middleware.validate$validate_query$fn__46643.invoke(validate.clj:10)”
“query_processor.middleware.normalize_query$normalize$fn__45061.invoke(normalize_query.clj:22)”
“query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__38073.invoke(add_rows_truncated.clj:36)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__46610.invoke(results_metadata.clj:147)”
“query_processor.middleware.constraints$add_default_userland_constraints$fn__44366.invoke(constraints.clj:42)”
“query_processor.middleware.process_userland_query$process_userland_query$fn__45802.invoke(process_userland_query.clj:136)”
“query_processor.middleware.catch_exceptions$catch_exceptions$fn__44309.invoke(catch_exceptions.clj:174)”
“query_processor.reducible$async_qp$qp_STAR___21737$thunk__21738.invoke(reducible.clj:101)”
“query_processor.reducible$async_qp$qp_STAR___21737.invoke(reducible.clj:107)”
“query_processor.reducible$sync_qp$qp_STAR___21746$fn__21749.invoke(reducible.clj:133)”
“query_processor.reducible$sync_qp$qp_STAR___21746.invoke(reducible.clj:132)”
“query_processor$process_userland_query.invokeStatic(query_processor.clj:213)”
“query_processor$process_userland_query.doInvoke(query_processor.clj:209)”
“query_processor$fn__46785$process_query_and_save_execution_BANG___46794$fn__46797.invoke(query_processor.clj:225)”
“query_processor$fn__46785$process_query_and_save_execution_BANG___46794.invoke(query_processor.clj:217)”
“query_processor$fn__46829$process_query_and_save_with_max_results_constraints_BANG___46838$fn__46841.invoke(query_processor.clj:237)”
“query_processor$fn__46829$process_query_and_save_with_max_results_constraints_BANG___46838.invoke(query_processor.clj:230)”
“api.dataset$fn__60188$fn__60191.invoke(dataset.clj:54)”
“query_processor.streaming$streaming_response_STAR_$fn__34470$fn__34471.invoke(streaming.clj:73)”
“query_processor.streaming$streaming_response_STAR_$fn__34470.invoke(streaming.clj:72)”
“async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)”
“async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)”
“async.streaming_response$do_f_async$fn__23771.invoke(streaming_response.clj:85)”],
:state “70100”}],
:state “70100”,
:json_query {:database 3, :query {:source-table 7, :limit 1000000}, :type “query”, :parameters [], :middleware {:add-default-userland-constraints? true}},
:native
{:query
“SELECT rc_authtxn.AUTHTXN_ADDITIONAL_AMT AS AUTHTXN_ADDITIONAL_AMT, rc_authtxn.AUTHTXN_APPROVAL_CODE AS AUTHTXN_APPROVAL_CODE, rc_authtxn.AUTHTXN_BILL_NO AS AUTHTXN_BILL_NO, rc_authtxn.AUTHTXN_BUSINESS_DATE AS AUTHTXN_BUSINESS_DATE, rc_authtxn.AUTHTXN_CARD_FIID AS AUTHTXN_CARD_FIID, rc_authtxn.AUTHTXN_CARD_NO AS AUTHTXN_CARD_NO, rc_authtxn.AUTHTXN_CURRENCY_ID AS AUTHTXN_CURRENCY_ID, rc_authtxn.AUTHTXN_EDC_SETTLED_IND AS AUTHTXN_EDC_SETTLED_IND, rc_authtxn.AUTHTXN_EXTRA_FIELD AS AUTHTXN_EXTRA_FIELD, rc_authtxn.AUTHTXN_MCC_ID AS AUTHTXN_MCC_ID, rc_authtxn.AUTHTXN_MCCS_DATA AS AUTHTXN_MCCS_DATA, rc_authtxn.AUTHTXN_MEPS_RECON_IND AS AUTHTXN_MEPS_RECON_IND, rc_authtxn.AUTHTXN_MERCHANT_ID AS AUTHTXN_MERCHANT_ID, rc_authtxn.AUTHTXN_MERCHANT_NAME AS AUTHTXN_MERCHANT_NAME, rc_authtxn.AUTHTXN_MTI AS AUTHTXN_MTI, rc_authtxn.AUTHTXN_NO AS AUTHTXN_NO, rc_authtxn.AUTHTXN_POS_ENTRY_CODE AS AUTHTXN_POS_ENTRY_CODE, rc_authtxn.AUTHTXN_POS_ENTRY_MODE AS AUTHTXN_POS_ENTRY_MODE, rc_authtxn.AUTHTXN_PROC_CODE AS AUTHTXN_PROC_CODE, rc_authtxn.AUTHTXN_REMARKS AS AUTHTXN_REMARKS, rc_authtxn.AUTHTXN_REQUEST_AMT AS AUTHTXN_REQUEST_AMT, rc_authtxn.AUTHTXN_REQUEST_DATETIME AS AUTHTXN_REQUEST_DATETIME, rc_authtxn.AUTHTXN_RESPONSE_CODE AS AUTHTXN_RESPONSE_CODE, rc_authtxn.AUTHTXN_RESPONSE_DATETIME AS AUTHTXN_RESPONSE_DATETIME, rc_authtxn.AUTHTXN_RESPONSE_REASON_CODE AS AUTHTXN_RESPONSE_REASON_CODE, rc_authtxn.AUTHTXN_RETRIEVAL_REFNO AS AUTHTXN_RETRIEVAL_REFNO, rc_authtxn.AUTHTXN_SETTLED_DATE AS AUTHTXN_SETTLED_DATE, rc_authtxn.AUTHTXN_STAN AS AUTHTXN_STAN, rc_authtxn.AUTHTXN_TERMINAL_BATCH_NO AS AUTHTXN_TERMINAL_BATCH_NO, rc_authtxn.AUTHTXN_TERMINAL_ID AS AUTHTXN_TERMINAL_ID, rc_authtxn.AUTHTXN_TERMINAL_INVOICE_NO AS AUTHTXN_TERMINAL_INVOICE_NO, rc_authtxn.AUTHTXN_TERMINAL_OWNER AS AUTHTXN_TERMINAL_OWNER, rc_authtxn.AUTHTXN_TRACK2_DATA AS AUTHTXN_TRACK2_DATA, rc_authtxn.AUTHTXN_TXNTYPE_DESCRIPTION AS AUTHTXN_TXNTYPE_DESCRIPTION, rc_authtxn.AUTHTXN_TXNTYPE_ID AS AUTHTXN_TXNTYPE_ID, rc_authtxn.AUTHTXN_TXNTYPE_IND AS AUTHTXN_TXNTYPE_IND, rc_authtxn.MOD_DATE AS MOD_DATE, rc_authtxn.USER_ID AS USER_ID, rc_authtxn.VERSION AS VERSION FROM rc_authtxn LIMIT 1000000”,
:params nil},
:status :failed,
:class java.sql.SQLTransientException,
:stacktrace
[“org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:255)”
“org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.readNextValue(SelectResultSet.java:379)”
“org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.fetchAllResults(SelectResultSet.java:282)”
“org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.(SelectResultSet.java:144)”
“org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readResultSet(AbstractQueryProtocol.java:1755)”
“org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1474)”
“org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1424)”
“org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:240)”
“org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:216)”
“org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:145)”
“org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:159)”
“com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)”
“–> driver.sql_jdbc.execute$fn__72670.invokeStatic(execute.clj:267)”
“driver.sql_jdbc.execute$fn__72670.invoke(execute.clj:265)”
“driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:389)”
“driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)”
“driver.sql_jdbc$fn__72760.invokeStatic(sql_jdbc.clj:49)”
“driver.sql_jdbc$fn__72760.invoke(sql_jdbc.clj:47)”
“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:69)”
“query_processor.context.default$default_runf.invoke(default.clj:67)”
“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__45048.invoke(mbql_to_native.clj:26)”
“query_processor.middleware.check_features$check_features$fn__44350.invoke(check_features.clj:42)”
“query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45213.invoke(optimize_datetime_filters.clj:133)”
“query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__46741.invoke(wrap_value_literals.clj:137)”
“query_processor.middleware.annotate$add_column_info$fn__42325.invoke(annotate.clj:574)”
“query_processor.middleware.permissions$check_query_permissions$fn__44225.invoke(permissions.clj:64)”
“query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__45731.invoke(pre_alias_aggregations.clj:40)”
“query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44423.invoke(cumulative_aggregations.clj:61)”
“query_processor.middleware.resolve_joins$resolve_joins$fn__46263.invoke(resolve_joins.clj:183)”
“query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__37977.invoke(add_implicit_joins.clj:245)”
“query_processor.middleware.limit$limit$fn__45034.invoke(limit.clj:38)”
“query_processor.middleware.format_rows$format_rows$fn__45015.invoke(format_rows.clj:81)”
“query_processor.middleware.desugar$desugar$fn__44489.invoke(desugar.clj:22)”
“query_processor.middleware.binning$update_binning_strategy$fn__42869.invoke(binning.clj:229)”
“query_processor.middleware.resolve_fields$resolve_fields$fn__44031.invoke(resolve_fields.clj:24)”
“query_processor.middleware.add_dimension_projections$add_remapping$fn__37526.invoke(add_dimension_projections.clj:272)”
“query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__37733.invoke(add_implicit_clauses.clj:141)”
“query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__38204.invoke(add_source_metadata.clj:105)”
“query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__45928.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)”
“query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__42510.invoke(auto_bucket_datetimes.clj:125)”
“query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44078.invoke(resolve_source_table.clj:46)”
“query_processor.middleware.parameters$substitute_parameters$fn__45713.invoke(parameters.clj:114)”
“query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44130.invoke(resolve_referenced.clj:80)”
“query_processor.middleware.expand_macros$expand_macros$fn__44745.invoke(expand_macros.clj:158)”
“query_processor.middleware.add_timezone_info$add_timezone_info$fn__38235.invoke(add_timezone_info.clj:15)”
“query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__46625.invoke(splice_params_in_response.clj:32)”
“query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__45939$fn__45943.invoke(resolve_database_and_driver.clj:33)”
“driver$do_with_driver.invokeStatic(driver.clj:61)”
“driver$do_with_driver.invoke(driver.clj:57)”
“query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__45939.invoke(resolve_database_and_driver.clj:27)”
“query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__44963.invoke(fetch_source_query.clj:267)”
“query_processor.middleware.store$initialize_store$fn__46634$fn__46635.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__46634.invoke(store.clj:10)”
“query_processor.middleware.cache$maybe_return_cached_results$fn__43361.invoke(cache.clj:209)”
“query_processor.middleware.validate$validate_query$fn__46643.invoke(validate.clj:10)”
“query_processor.middleware.normalize_query$normalize$fn__45061.invoke(normalize_query.clj:22)”
“query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__38073.invoke(add_rows_truncated.clj:36)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__46610.invoke(results_metadata.clj:147)”
“query_processor.middleware.constraints$add_default_userland_constraints$fn__44366.invoke(constraints.clj:42)”
“query_processor.middleware.process_userland_query$process_userland_query$fn__45802.invoke(process_userland_query.clj:136)”
“query_processor.middleware.catch_exceptions$catch_exceptions$fn__44309.invoke(catch_exceptions.clj:174)”
“query_processor.reducible$async_qp$qp_STAR___21737$thunk__21738.invoke(reducible.clj:101)”
“query_processor.reducible$async_qp$qp_STAR___21737.invoke(reducible.clj:107)”
“query_processor.reducible$sync_qp$qp_STAR___21746$fn__21749.invoke(reducible.clj:133)”
“query_processor.reducible$sync_qp$qp_STAR___21746.invoke(reducible.clj:132)”
“query_processor$process_userland_query.invokeStatic(query_processor.clj:213)”
“query_processor$process_userland_query.doInvoke(query_processor.clj:209)”
“query_processor$fn__46785$process_query_and_save_execution_BANG___46794$fn__46797.invoke(query_processor.clj:225)”
“query_processor$fn__46785$process_query_and_save_execution_BANG___46794.invoke(query_processor.clj:217)”
“query_processor$fn__46829$process_query_and_save_with_max_results_constraints_BANG___46838$fn__46841.invoke(query_processor.clj:237)”
“query_processor$fn__46829$process_query_and_save_with_max_results_constraints_BANG___46838.invoke(query_processor.clj:230)”
“api.dataset$fn__60188$fn__60191.invoke(dataset.clj:54)”
“query_processor.streaming$streaming_response_STAR_$fn__34470$fn__34471.invoke(streaming.clj:73)”
“query_processor.streaming$streaming_response_STAR_$fn__34470.invoke(streaming.clj:72)”
“async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)”
“async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)”
“async.streaming_response$do_f_async$fn__23771.invoke(streaming_response.clj:85)”],
:context :ad-hoc,
:error “Query execution was interrupted”,
:row_count 0,
:running_time 0,
:preprocessed
{:database 3,
:query
{:source-table 7,
:limit 1000000,
:fields
[[:field-id 175]
[:field-id 143]
[:field-id 159]
[:datetime-field [:field-id 150] :default]
[:field-id 144]
[:field-id 165]
[:field-id 141]
[:field-id 164]
[:field-id 167]
[:field-id 161]
[:field-id 156]
[:field-id 174]
[:field-id 142]
[:field-id 147]
[:field-id 171]
[:field-id 152]
[:field-id 140]
[:field-id 154]
[:field-id 166]
[:field-id 146]
[:field-id 148]
[:datetime-field [:field-id 158] :default]
[:field-id 145]
[:datetime-field [:field-id 155] :default]
[:field-id 153]
[:field-id 176]
[:datetime-field [:field-id 177] :default]
[:field-id 162]
[:field-id 157]
[:field-id 172]
[:field-id 168]
[:field-id 173]
[:field-id 151]
[:field-id 149]
[:field-id 160]
[:field-id 169]
[:datetime-field [:field-id 163] :default]
[:field-id 170]
[:field-id 178]]},
:type :query,
:middleware {:add-default-userland-constraints? true},
:info
{:executed-by 1,
:context :ad-hoc,
:nested? false,
:query-hash [-112, 44, -81, -88, 119, -54, -58, -103, -75, -32, -10, -80, 82, 53, 63, -75, -48, -5, 107, -59, -37, -101, -34, -42, 16, -81, -53, -125, 104, 29, -124, 99]},
:constraints {:max-results 5000000, :max-results-bare-rows 5000000}},
:data {:rows [], :cols []}}

Hi @JinPengTan
The error comes from your database, not Metabase. Check the logs and timeout on your database.