Few days ago there's some problem with the electricity that interfere with the server. After we turn it back on, usually data will be automatically sync, but it doesn't work this time around. We tried to manually sync from admin account also doesn't work.
I notice there are 2 types of error in the log. Here it is:
[a233535b-a4c0-49be-a25b-a50174cc8925] 2021-08-31T06:37:19+07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 3,
:started_at (t/zoned-date-time "2021-08-31T06:37:03.958628+07:00[Asia/Jakarta]"),
:state "57014",
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware nil,
:database 3,
:query
{:source-table 96,
:fields
[[:field-id 533]
[:datetime-field [:field-id 535] :default]
[:field-id 534]
[:fk-> [:field-id 537] [:field-id 500]]
[:fk-> [:field-id 532] [:field-id 495]]
[:field-id 536]
[:field-id 530]
[:field-id 538]],
:order-by [[:desc [:field-id 535]]]},
:parameters [{:type "date/all-options", :target ["dimension" ["field-id" 535]], :value "thisday"}],
:async? true,
:cache-ttl nil},
:native nil,
:status :failed,
:class org.postgresql.util.PSQLException,
:stacktrace
["org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2497)"
"org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2233)"
"org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:310)"
"org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:446)"
"org.postgresql.jdbc.PgStatement.execute(PgStatement.java:370)"
"org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:149)"
"org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:108)"
"com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)"
"--> driver.sql_jdbc.execute$fn__70879.invokeStatic(execute.clj:267)"
"driver.sql_jdbc.execute$fn__70879.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__73052.invokeStatic(sql_jdbc.clj:49)"
"driver.sql_jdbc$fn__73052.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__43149.invoke(mbql_to_native.clj:26)"
"query_processor.middleware.check_features$check_features$fn__42463.invoke(check_features.clj:42)"
"query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__43314.invoke(optimize_datetime_filters.clj:133)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__47282.invoke(wrap_value_literals.clj:137)"
"query_processor.middleware.annotate$add_column_info$fn__41084.invoke(annotate.clj:577)"
"query_processor.middleware.permissions$check_query_permissions$fn__42338.invoke(permissions.clj:64)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__43813.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__42536.invoke(cumulative_aggregations.clj:61)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__44345.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39271.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__43135.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__43116.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__42602.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__41628.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__42144.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38807.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__39027.invoke(add_implicit_clauses.clj:147)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39420.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__44010.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__41269.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__42191.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__43795.invoke(parameters.clj:97)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__42243.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__42858.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39451.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47166.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__44021$fn__44025.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__44021.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__43064.invoke(fetch_source_query.clj:243)"
"query_processor.middleware.store$initialize_store$fn__47175$fn__47176.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__47175.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__42120.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47184.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__43162.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39289.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47151.invoke(results_metadata.clj:128)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__42479.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__43884.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__42422.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38090$thunk__38091.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38090$fn__38093.invoke(reducible.clj:106)"],
:context :question,
:error "ERROR: canceling statement due to user request",
:row_count 0,
:running_time 0,
:preprocessed
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:info
{:executed-by 26,
:context :question,
:card-id 27,
:query-hash [71, 48, 106, 90, 90, 18, 97, 110, -67, 40, 104, 14, -73, -71, -41, 126, -46, 124, 67, -88, 63, -35, 65, -61, -46, 30, -40, -126, -83, 76, -58, -83]},
:database 3,
:query
{:source-table 96,
:fields
[[:field-id 533]
[:datetime-field [:field-id 535] :default]
[:field-id 534]
[:joined-field "resellers__via__reseller_id" [:field-id 500]]
[:joined-field "vendors__via__vendor_id" [:field-id 495]]
[:field-id 536]
[:field-id 530]
[:field-id 538]],
:order-by [[:desc [:field-id 535]]],
:filter [:= [:datetime-field [:field-id 535] :day] [:relative-datetime 0 :day]],
:limit 2000,
:joins
[{:strategy :left-join, :source-table 65, :alias "resellers__via__reseller_id", :fk-field-id 537, :condition [:= [:field-id 537] [:joined-field "resellers__via__reseller_id" [:field-id 501]]]}
{:strategy :left-join, :source-table 63, :alias "vendors__via__vendor_id", :fk-field-id 532, :condition [:= [:field-id 532] [:joined-field "vendors__via__vendor_id" [:field-id 496]]]}]},
:async? true},
:data {:rows [], :cols []}}
[a233535b-a4c0-49be-a25b-a50174cc8925] 2021-08-31T06:36:51+07:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 26:
{:native
"SELECT p.id, count(a.product_id)\nFROM products p LEFT JOIN (\n SELECT i.product_id\n FROM inventories i \n WHERE i.status = 'AVAILABLE'\n) a ON a.product_id = p.id \nWHERE exists (select 1 from inventories where product_id = p.id limit 1)\nGROUP BY p.id\nORDER BY p.id"}
ALSO this:
[a233535b-a4c0-49be-a25b-a50174cc8925] 2021-08-31T06:36:51+07:00 DEBUG metabase.middleware.log POST /api/card/13/query 202 [ASYNC: completed] 202.1 ms (5 DB calls) App DB connections: 0/7 Jetty threads: 5/50 (1 idle, 0 queued) (118 total active threads) Queries in flight: 5 (0 queued)
[a233535b-a4c0-49be-a25b-a50174cc8925] 2021-08-31T06:36:51+07:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 3,
:started_at (t/zoned-date-time "2021-08-31T06:36:51.006320+07:00[Asia/Jakarta]"),
:error_type :missing-required-parameter,
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :native,
:middleware nil,
:native
{:template-tags
{"start_date" {:id "6aa23e63-10e6-f904-e0eb-bf66f110d843", :name "start_date", :display-name "Start date", :type :date, :default nil},
"end_date" {:id "30d7109f-ffd2-6424-954e-a65a79b04010", :name "end_date", :display-name "End date", :type :date, :default nil}},
:query
"select loop_date at time zone 'Asia/Jakarta' as "date", products.name as "product name", count(*) as "redeemed count"\nfrom generate_series(\n {{start_date}}::timestamp at time zone 'Asia/Jakarta',\n {{end_date}}::timestamp at time zone 'Asia/Jakarta',\n '1 day'\n) s(loop_date),\ninventories, products\nwhere ((extract(epoch from loop_date))*1000 < redeemed_timestamp or redeemed_timestamp is null) and uploaded_timestamp <= (extract(epoch from loop_date))1000\nand status not in ('DISABLED')\nand inventories.product_id = products.id\ngroup by loop_date, products.name\norder by loop_date, products.name, count() desc"},
:database 3,
:parameters [],
:async? true,
:cache-ttl nil},
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
["--> driver.sql.parameters.substitute$substitute.invokeStatic(substitute.clj:82)"
"driver.sql.parameters.substitute$substitute.invoke(substitute.clj:64)"
"driver.sql$fn__73030.invokeStatic(sql.clj:46)"
"driver.sql$fn__73030.invoke(sql.clj:42)"
"query_processor.middleware.parameters.native$expand_inner.invokeStatic(native.clj:39)"
"query_processor.middleware.parameters.native$expand_inner.invoke(native.clj:30)"
"query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:50)"
"query_processor.middleware.parameters$expand_one.invoke(parameters.clj:41)"
"query_processor.middleware.parameters$expand_all$replace_43758__43759.invoke(parameters.clj:59)"
"mbql.util.match$replace_in_collection$iter__24736__24740$fn__24741.invoke(match.clj:132)"
"mbql.util.match$replace_in_collection.invokeStatic(match.clj:131)"
"mbql.util.match$replace_in_collection.invoke(match.clj:126)"
"query_processor.middleware.parameters$expand_all$replace_43758__43759.invoke(parameters.clj:59)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:59)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
"query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:56)"
"query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
"query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:77)"
"query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:73)"
"query_processor.middleware.parameters$fn__43774$substitute_parameters_STAR___43779$fn__43780.invoke(parameters.clj:82)"
"query_processor.middleware.parameters$fn__43774$substitute_parameters_STAR___43779.invoke(parameters.clj:79)"
"query_processor.middleware.parameters$substitute_parameters$fn__43795.invoke(parameters.clj:97)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__42243.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__42858.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39451.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47166.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__44021$fn__44025.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__44021.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__43064.invoke(fetch_source_query.clj:243)"
"query_processor.middleware.store$initialize_store$fn__47175$fn__47176.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__47175.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__42120.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47184.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__43162.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39289.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47151.invoke(results_metadata.clj:128)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__42479.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__43884.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__42422.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38090$thunk__38091.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38090$fn__38093.invoke(reducible.clj:106)"],
:context :question,
:error "Cannot run the query: missing required parameters: #{"end_date" "start_date"}",
:row_count 0,
:running_time 0,
:ex-data {:type :missing-required-parameter, :missing ("end_date" "start_date")},
:data {:rows [], :cols []}}