{:database_id 4,
:started_at #t "2022-02-25T07:38:57.626697Z[UTC]",
:json_query
{:constraints nil,
:type :native,
:middleware
{:js-int-to-string? false,
:ignore-cached-results? true,
:process-viz-settings? true,
:skip-results-metadata? true,
:format-rows? false},
:native
{:template-tags
{"startDate"
{:id "32332ab9-aa20-a00b-c09b-2883105355d9",
:name "startDate",
:display-name "Startdate",
:type :date,
:default "2021-07-01",
:required true},
"endDate"
{:id "dcaad17c-e9ec-6165-4dff-cfeae449a262",
:name "endDate",
:display-name "Enddate",
:type :date,
:required true,
:default "2021-12-31"},
"category"
{:id "de8ceb1c-9734-8401-9b8d-be88eab611e7",
:name "category",
:display-name "Category",
:type :text,
:required true,
:default "All"}},
:query
"[\n{$match: {level: 0}}\n\n{$facet: {\n 'new': [\n {$project: {\n _id: 1,\n name: 'All'\n }}],\n 'old': [\n {$project: {\n _id: 1,\n name: 1\n }}]\n}}\n\n{$project: {\n items: {$concatArrays: ['$new', '$old']}\n}}\n\n{$unwind: '$items'}\n\n{$project: {\n _id: '$items._id',\n name: '$items.name'\n}}\n\n{$match: {name: {{category}}}}\n\n{$lookup: {from: 'sias', localField: '_id', foreignField: 'itemDetail.categories', as: 'siasdata'}}\n{$unwind: '$siasdata'}\n\n{$match: {'siasdata.deleted_at': null}}\n{$match: {$or: [{'siasdata.isResellerShop': false}, {'siasdata.isResellerShop': {$exists: false}}]}}\n\n{$project: {\n categoryName: '$name',\n categories: '$siasdata.itemDetail.categories',\n active: '$siasdata.active',\n itemName: '$siasdata.itemDetail.name',\n parentType: '$siasdata.itemDetail.parentType',\n parent: '$siasdata.itemDetail.parent',\n itemCreated_at: {$add: ['$siasdata.created_at', 19800000]}\n}}\n\n{$match: {$expr: {$and: [{$gte: ['$itemCreated_at', {{startDate}}]},\n {$lt: ['$itemCreated_at', {$add : [{{endDate}} , 86400000]}]}]}}}\n\n{$unwind: '$categories'}\n{$lookup: {from: 'categories', localField: 'categories', foreignField: '_id', as: 'categoriesdata'}}\n{$unwind: {path: '$catgoriesdata', preserveNullAndEmptyArrays: true}}\n\n{$match: {'categoriesdata.level': 2}}\n\n{$project: {\n l1CategoryName: '$categoryName',\n l2CategoryId: '$categoriesdata._id',\n l2CategoryName: '$categoriesdata.name',\n active: 1,\n itemName: 1,\n parentType: 1,\n parent: 1,\n itemCreated_at: 1,\n l2Category: {$zip: {'inputs': ['$categoriesdata._id', '$categoriesdata.name']}}\n}}\n\n{$unwind: '$l2CategoryId'}\n{$unwind: '$l2CategoryName'}\n\n{$group: {\n _id: '$l1CategoryName',\n l2Category: {$push: '$l2Category'},\n totalItemCount: {$sum: 1}\n}}\n\n{$unwind: '$l2Category'}\n{$unwind: '$l2Category'}\n\n{$project: {\n _id: 0\n L0Category: '$_id',\n L2CategoryId: {$arrayElemAt: ['$l2Category', 0]},\n L2Category: {$arrayElemAt: ['$l2Category', 1]},\n totalItemCount: 1\n}}\n\n{$group: {\n _id: '$L2CategoryId',\n L2Category: {$first: '$L2Category'},\n totalItemCount: {$first: '$totalItemCount'},\n itemCount: {$sum: 1}\n}}\n\n{$project: {\n _id: 0,\n l2Category: '$L2Category',\n itemCount: 1,\n itemCountPercentage: {$round: [{$multiply: [{$divide: ['$itemCount', '$totalItemCount']}, 100]}, 2]},\n l2CategoryId: '$_id'\n}}\n\n{$lookup: {from: 'sias', localField: 'l2CategoryId', foreignField: 'itemDetail.categories', as: 'siasdata'}}\n{$unwind: {path: '$siasdata', preserveNullAndEmptyArrays: true}}\n\n{$project: {\n itemCount: 1,\n itemCountPercentage: 1,\n l2CategoryId: 1,\n l2Category: 1,\n itemsId: 1,\n price: {$divide: [{$arrayElemAt: ['$siasdata.meta.bestPrice.sellingPrice', 0]},100]},\n marketplaceActiveItem: {$cond: {if: {$and: [{$eq: ['$siasdata.marketplaceActive', true]}, {$eq: ['$siasdata.shopActive', true]}]},\n then: 1,\n else: 0}},\n shopId: '$siasdata.shop',\n shopActive: {$cond: {if: {$and: [{$eq: ['$siasdata.shopActive', true]}, {$eq: ['$siasdata.deleted_at', null]}]},\n then: '$siasdata.shop',\n else: null}}\n}}\n\n{$group: {\n _id: '$l2CategoryId',\n l2Category: {$first: '$l2Category'},\n itemCount: {$first: '$itemCount'},\n itemCountPercentage: {$first: '$itemCountPercentage'},\n avgPrice: {$avg: '$price'},\n marketplaceActiveItem: {$sum: '$marketplaceActiveItem'},\n shopId: {$addToSet: '$shopId'},\n shopActive: {$addToSet: '$shopActive'}\n}}\n\n{$project: {\n id: 0,\n categoryName: '$l2Category',\n itemCount: 1,\n itemCountPercentage: 1,\n avgPrice: 1,\n marketplaceActiveItem: 1,\n sellerCount: {$size: '$shopId'},\n marketplaceActiveSeller: {$size: {$filter: {input: '$shopActive', as: 'd', cond: {$ne: ['$$d', null]}}}}\n}}\n]",
:collection "categories"},
:database 4,
:parameters nil,
:async? true,
:cache-ttl 141022},
:status :failed,
:class com.mongodb.MongoExecutionTimeoutException,
:stacktrace
["com.mongodb.internal.connection.ProtocolHelper.createSpecialException(ProtocolHelper.java:243)"
"com.mongodb.internal.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:175)"
"com.mongodb.internal.connection.InternalStreamConnection.receiveCommandMessageResponse(InternalStreamConnection.java:299)"
"com.mongodb.internal.connection.InternalStreamConnection.sendAndReceive(InternalStreamConnection.java:255)"
"com.mongodb.internal.connection.UsageTrackingInternalConnection.sendAndReceive(UsageTrackingInternalConnection.java:99)"
"com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection.sendAndReceive(DefaultConnectionPool.java:444)"
"com.mongodb.internal.connection.CommandProtocolImpl.execute(CommandProtocolImpl.java:72)"
"com.mongodb.internal.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:200)"
"com.mongodb.internal.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:269)"
"com.mongodb.internal.connection.DefaultServerConnection.command(DefaultServerConnection.java:131)"
"com.mongodb.internal.connection.DefaultServerConnection.command(DefaultServerConnection.java:123)"
"com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:242)"
"com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:233)"
"com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:136)"
"com.mongodb.operation.AggregateOperationImpl$1.call(AggregateOperationImpl.java:193)"
"com.mongodb.operation.AggregateOperationImpl$1.call(AggregateOperationImpl.java:189)"
"com.mongodb.operation.OperationHelper.withConnectionSource(OperationHelper.java:462)"
"com.mongodb.operation.OperationHelper.withConnection(OperationHelper.java:406)"
"com.mongodb.operation.AggregateOperationImpl.execute(AggregateOperationImpl.java:189)"
"com.mongodb.operation.AggregateOperation.execute(AggregateOperation.java:295)"
"com.mongodb.operation.AggregateOperation.execute(AggregateOperation.java:41)"
"com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:179)"
"com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:161)"
"com.mongodb.DBCollection.aggregate(DBCollection.java:1502)"
"com.mongodb.DBCollection.aggregate(DBCollection.java:1462)"
"com.mongodb.DBCollection.aggregate(DBCollection.java:1447)"
"--> driver.mongo.execute$aggregate.invokeStatic(execute.clj:114)"
"driver.mongo.execute$aggregate.invoke(execute.clj:108)"
"driver.mongo.execute$execute_reducible_query.invokeStatic(execute.clj:163)"
"driver.mongo.execute$execute_reducible_query.invoke(execute.clj:157)"
"driver.mongo$fn__94824$f__93105__auto____94825.invoke(mongo.clj:234)"
"driver.mongo.util$do_with_mongo_connection$fn__93096.invoke(util.clj:218)"
"util.ssh$do_with_ssh_tunnel.invokeStatic(ssh.clj:134)"
"util.ssh$do_with_ssh_tunnel.invoke(ssh.clj:123)"
"driver.mongo.util$do_with_mongo_connection.invokeStatic(util.clj:212)"
"driver.mongo.util$do_with_mongo_connection.invoke(util.clj:207)"
"driver.mongo$fn__94824.invokeStatic(mongo.clj:233)"
"driver.mongo$fn__94824.invoke(mongo.clj:231)"
"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__49660.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__50406.invoke(check_features.clj:42)"
"query_processor.middleware.limit$limit$fn__47989.invoke(limit.clj:37)"
"query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:177)"
"query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:168)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__50789.invoke(cache.clj:203)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__51822.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__51866.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__49717.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__39778.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__44544.invoke(annotate.clj:659)"
"query_processor.middleware.permissions$check_query_permissions$fn__46286.invoke(permissions.clj:108)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__51011.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46682.invoke(cumulative_aggregations.clj:60)"
"query_processor.middleware.visualization_settings$update_viz_settings$fn__46620.invoke(visualization_settings.clj:62)"
"query_processor.middleware.escape_join_aliases$escape_join_aliases_middleware$fn__48037.invoke(escape_join_aliases.clj:67)"
"query_processor.middleware.fix_bad_references$fix_bad_references_middleware$fn__50976.invoke(fix_bad_references.clj:91)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__47567.invoke(resolve_joined_fields.clj:111)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__51592.invoke(resolve_joins.clj:178)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__51134.invoke(add_implicit_joins.clj:193)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__47586.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__51186.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__46954.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__46593.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__39507.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__45928.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__50343.invoke(add_dimension_projections.clj:487)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__50637.invoke(add_implicit_clauses.clj:164)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__47974.invoke(upgrade_field_literals.clj:117)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__47331.invoke(add_source_metadata.clj:125)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__50888.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__48975.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__45909.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__48629.invoke(parameters.clj:109)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__45982.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__52250.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__48409.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__51201.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__50648$fn__50653.invoke(resolve_database_and_driver.clj:35)"
"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__50648.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__46528.invoke(fetch_source_query.clj:286)"
"query_processor.middleware.store$initialize_store$fn__46719$fn__46720.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__46719.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50983.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__50990.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__48355.invoke(add_rows_truncated.clj:35)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG$fn__49646.invoke(results_metadata.clj:78)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__48373.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__50924.invoke(process_userland_query.clj:146)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__51281.invoke(catch_exceptions.clj:169)"
"query_processor.reducible$async_qp$qp_STAR___43280$thunk__43281.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___43280$fn__43283.invoke(reducible.clj:108)"],
:card_id 2139,
:context :csv-download,
:error "Error in $cursor stage :: caused by :: operation exceeded time limit",
:row_count 0,
:running_time 0,
:data {:rows [], :cols []}}