Hello all
I am having some issues with dbt while trying to update from tutor v19.0.5 to v20.0.5, and also updating aspects to tutor-contrib-aspects v3.0.2.
After updating both pip packages, we build the images (openedx, mfe, aspects and aspects-superset) and everything is OK. But when we try to init the platform with tutor local init we receive the following issue:
Installing dbt dependencies
14:23:20 Running with dbt=1.9.10
14:23:21 Installing dbt-labs/codegen
14:23:21 Installed from version 0.13.1
14:23:21 Updated version available: 0.14.0
14:23:21 Installing dbt-labs/dbt_utils
14:23:21 Installed from version 1.3.0
14:23:21 Updated version available: 1.3.3
14:23:21
14:23:21 Updates available for packages: [‘dbt-labs/codegen’, ‘dbt-labs/dbt_utils’]
Update your versions in packages.yml, then run dbt deps
Running run
Insert data script.
Loading: /app/aspects-dbt/state/manifest.json
14:23:24 Running with dbt=1.9.10
14:23:24 Registered adapter: clickhouse=1.9.4
14:23:24 Unable to do partial parsing because saved manifest not found. Starting full parse.
14:23:26 [WARNING]: Configuration paths exist in your dbt_project.yml file which do not apply to any resources.
There are 1 unused configuration paths:
seeds.aspects
14:23:26 Performance info: /app/aspects-dbt/target/perf_info.json
Found /app/aspects-dbt/state/manifest.json so only running modified items and their downstreams
14:23:29 Running with dbt=1.9.10
14:23:29 Registered adapter: clickhouse=1.9.4
14:23:29 [WARNING]: Configuration paths exist in your dbt_project.yml file which do not apply to any resources.
There are 1 unused configuration paths:
seeds.aspects
14:23:29 Found 37 models, 16 data tests, 8 sources, 635 macros, 27 unit tests
14:23:29
14:23:29 Concurrency: 2 threads (target=‘prod’)
14:23:29
14:23:30 1 of 30 START sql materialized_view model event_sink.dim_most_recent_course_blocks [RUN]
14:23:30 2 of 30 START sql materialized_view model event_sink.dim_most_recent_object_tags [RUN]
14:23:30 1 of 30 OK created sql materialized_view model event_sink.dim_most_recent_course_blocks [OK in 0.20s]
14:23:30 3 of 30 START sql materialized_view model event_sink.dim_most_recent_tags .. [RUN]
14:23:30 2 of 30 OK created sql materialized_view model event_sink.dim_most_recent_object_tags [OK in 0.20s]
14:23:30 4 of 30 START sql materialized_view model event_sink.dim_most_recent_taxonomies [RUN]
14:23:30 3 of 30 OK created sql materialized_view model event_sink.dim_most_recent_tags [OK in 0.08s]
14:23:30 4 of 30 OK created sql materialized_view model event_sink.dim_most_recent_taxonomies [OK in 0.08s]
14:23:30 5 of 30 START sql materialized_view model xapi.enrollment_events … [RUN]
14:23:30 6 of 30 START sql materialized_view model xapi.grading_events … [RUN]
14:23:30 5 of 30 OK created sql materialized_view model xapi.enrollment_events … [OK in 0.08s]
14:23:30 7 of 30 START sql materialized_view model xapi.navigation_events … [RUN]
14:23:30 6 of 30 OK created sql materialized_view model xapi.grading_events … [OK in 0.08s]
14:23:30 8 of 30 START sql materialized_view model xapi.problem_events … [RUN]
14:23:30 8 of 30 OK created sql materialized_view model xapi.problem_events … [OK in 0.06s]
14:23:30 9 of 30 START sql materialized_view model xapi.video_playback_events … [RUN]
14:23:30 7 of 30 OK created sql materialized_view model xapi.navigation_events … [OK in 0.08s]
14:23:30 10 of 30 START sql dictionary model reporting.dim_course_block_names … [RUN]
14:23:30 10 of 30 OK created sql dictionary model reporting.dim_course_block_names .. [OK in 0.05s]
14:23:30 11 of 30 START sql dictionary model reporting.dim_most_recent_course_tags .. [RUN]
14:23:30 11 of 30 OK created sql dictionary model reporting.dim_most_recent_course_tags [OK in 0.03s]
14:23:30 12 of 30 START sql materialized_view model reporting.dim_most_recent_enrollment [RUN]
14:23:30 9 of 30 OK created sql materialized_view model xapi.video_playback_events .. [OK in 0.11s]
14:23:30 13 of 30 START sql view model reporting.fact_enrollments … [RUN]
14:23:30 12 of 30 OK created sql materialized_view model reporting.dim_most_recent_enrollment [OK in 0.08s]
14:23:30 14 of 30 START sql materialized_view model reporting.fact_instance_enrollments [RUN]
14:23:30 13 of 30 OK created sql view model reporting.fact_enrollments … [OK in 0.09s]
14:23:30 15 of 30 START sql materialized_view model reporting.dim_learner_most_recent_course_grade [RUN]
14:23:30 14 of 30 OK created sql materialized_view model reporting.fact_instance_enrollments [OK in 0.07s]
14:23:30 16 of 30 START sql materialized_view model reporting.dim_learner_most_recent_course_state [RUN]
14:23:30 15 of 30 OK created sql materialized_view model reporting.dim_learner_most_recent_course_grade [OK in 0.08s]
14:23:30 17 of 30 START sql materialized_view model reporting.dim_learner_last_course_visit [RUN]
14:23:30 16 of 30 OK created sql materialized_view model reporting.dim_learner_most_recent_course_state [OK in 0.07s]
14:23:30 18 of 30 START sql view model reporting.dim_course_blocks … [RUN]
14:23:31 17 of 30 OK created sql materialized_view model reporting.dim_learner_last_course_visit [OK in 0.08s]
14:23:31 19 of 30 START sql materialized_view model reporting.fact_video_segments … [RUN]
14:23:31 18 of 30 OK created sql view model reporting.dim_course_blocks … [OK in 0.11s]
14:23:31 20 of 30 START sql view model reporting.dim_student_status … [RUN]
14:23:31 19 of 30 ERROR creating sql materialized_view model reporting.fact_video_segments [ERROR in 0.14s]
14:23:31 21 of 30 START sql materialized_view model reporting.dim_learner_last_response [RUN]
14:23:31 20 of 30 OK created sql view model reporting.dim_student_status … [OK in 0.14s]
14:23:31 22 of 30 START sql materialized_view model reporting.dim_problem_responses . [RUN]
14:23:31 21 of 30 OK created sql materialized_view model reporting.dim_learner_last_response [OK in 0.12s]
14:23:31 23 of 30 START sql materialized_view model reporting.dim_problem_results … [RUN]
14:23:31 22 of 30 OK created sql materialized_view model reporting.dim_problem_responses [OK in 0.37s]
14:23:31 24 of 30 START sql view model reporting.fact_navigation_completion … [RUN]
14:23:32 24 of 30 OK created sql view model reporting.fact_navigation_completion … [OK in 0.13s]
14:23:32 23 of 30 OK created sql materialized_view model reporting.dim_problem_results [OK in 0.39s]
14:23:32 25 of 30 START sql view model reporting.fact_problem_engagement … [RUN]
14:23:32 26 of 30 SKIP relation reporting.fact_video_engagement … [SKIP]
14:23:32 27 of 30 START sql materialized_view model reporting.dim_problem_coursewide_avg [RUN]
14:23:32 27 of 30 ERROR creating sql materialized_view model reporting.dim_problem_coursewide_avg [ERROR in 0.04s]
14:23:32 28 of 30 START sql materialized_view model reporting.dim_subsection_problem_results [RUN]
14:23:32 25 of 30 OK created sql view model reporting.fact_problem_engagement … [OK in 0.12s]
14:23:32 29 of 30 START sql view model reporting.fact_pageview_engagement … [RUN]
14:23:32 28 of 30 ERROR creating sql materialized_view model reporting.dim_subsection_problem_results [ERROR in 0.08s]
14:23:32 30 of 30 SKIP relation reporting.dim_subsection_performance … [SKIP]
14:23:32 29 of 30 OK created sql view model reporting.fact_pageview_engagement … [OK in 0.06s]
14:23:32
14:23:32 Finished running 2 dictionary models, 22 materialized view models, 6 view models in 0 hours 0 minutes and 2.54 seconds (2.54s).
14:23:32
14:23:32 Completed with 3 errors, 0 partial successes, and 0 warnings:
14:23:32
14:23:32 Database Error in model fact_video_segments (models/video/fact_video_segments.sql)
Code: 47.
DB::Exception: Unknown expression identifier emission_time_long in scope data AS (SELECT event_id, org, course_key, actor_id, emission_time_long, video_position, object_id, video_duration, if(verb_id = ‘https://w3id.org/xapi/video/verbs/played’, ‘start’, ‘end’) AS verb FROM xapi.video_playback_events WHERE verb_id != ‘http://adlnet.gov/expapi/verbs/initialized’). Maybe you meant: [‘emission_time’]. Stack trace:
DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000013596f1f
DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000ca3f80e
DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000ca3f2c0
DB::Exception::Exception<char const*, String&, String, String, String>(int, FormatStringHelperImpl<std::type_identity<char const*>::type, std::type_identity<String&>::type, std::type_identity::type, std::type_identity::type, std::type_identity::type>, char const*&&, String&, String&&, String&&, String&&) @ 0x0000000017618182
DB::QueryAnalyzer::resolveExpressionNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, bool, bool, bool) @ 0x00000000175e3a7f
DB::QueryAnalyzer::resolveExpressionNodeList(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, bool, bool) @ 0x00000000175e0cf4
DB::QueryAnalyzer::resolveProjectionExpressionNodeList(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&) @ 0x0000000017618f27
DB::QueryAnalyzer::resolveQuery(std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x00000000175d7bee
DB::QueryAnalyzer::resolveExpressionNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, bool, bool, bool) @ 0x00000000175e185a
DB::QueryAnalyzer::resolveQueryJoinTreeNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, DB::QueryExpressionsAliasVisitor&) @ 0x000000001761a2d8
DB::QueryAnalyzer::resolveQuery(std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x00000000175d7ba4
DB::QueryAnalyzer::resolveExpressionNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, bool, bool, bool) @ 0x00000000175e185a
DB::QueryAnalyzer::resolveQueryJoinTreeNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, DB::QueryExpressionsAliasVisitor&) @ 0x000000001761a2d8
DB::QueryAnalyzer::resolveQuery(std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x00000000175d7ba4
DB::QueryAnalyzer::resolveExpressionNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, bool, bool, bool) @ 0x00000000175e185a
DB::QueryAnalyzer::resolveQueryJoinTreeNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, DB::QueryExpressionsAliasVisitor&) @ 0x000000001761a2d8
DB::QueryAnalyzer::resolveQuery(std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x00000000175d7ba4
DB::QueryAnalyzer::resolveExpressionNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, bool, bool, bool) @ 0x00000000175e185a
DB::QueryAnalyzer::resolveQueryJoinTreeNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, DB::QueryExpressionsAliasVisitor&) @ 0x000000001761a2d8
DB::QueryAnalyzer::resolveJoin(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, DB::QueryExpressionsAliasVisitor&) @ 0x000000001761bafa
DB::QueryAnalyzer::resolveQueryJoinTreeNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, DB::QueryExpressionsAliasVisitor&) @ 0x0000000017619d78
DB::QueryAnalyzer::resolveQuery(std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x00000000175d7ba4
DB::QueryAnalyzer::resolveExpressionNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, bool, bool, bool) @ 0x00000000175e185a
DB::QueryAnalyzer::resolveQueryJoinTreeNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, DB::QueryExpressionsAliasVisitor&) @ 0x000000001761a2d8
DB::QueryAnalyzer::resolveQuery(std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x00000000175d7ba4
DB::QueryAnalyzer::resolve(std::shared_ptrDB::IQueryTreeNode&, std::shared_ptrDB::IQueryTreeNode const&, std::shared_ptr<DB::Context const>) @ 0x00000000175d5538
DB::QueryAnalysisPass::run(std::shared_ptrDB::IQueryTreeNode&, std::shared_ptr<DB::Context const>) @ 0x00000000175d4b9c
DB::QueryTreePassManager::run(std::shared_ptrDB::IQueryTreeNode) @ 0x000000001763f3f6
DB::buildQueryTreeAndRunPasses(std::shared_ptrDB::IAST const&, DB::SelectQueryOptions const&, std::shared_ptr<DB::Context const> const&, std::shared_ptrDB::IStorage const&) (.llvm.1953922074611898924) @ 0x00000000181a4b8d
DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptrDB::IAST const&, std::shared_ptr<DB::Context const> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator> const&) @ 0x00000000181a2adc
DB::InterpreterSelectQueryAnalyzer::getSampleBlock(std::shared_ptrDB::IAST const&, std::shared_ptr<DB::Context const> const&, DB::SelectQueryOptions const&) @ 0x00000000181a4fe1
DB::InterpreterCreateQuery::getTablePropertiesAndNormalizeCreateQuery(DB::ASTCreateQuery&, DB::LoadingStrictnessLevel) const @ 0x00000000180c6747
14:23:32
14:23:32 Database Error in model dim_problem_coursewide_avg (models/problems/dim_problem_coursewide_avg.sql)
Code: 47.
DB::Exception: Unknown expression identifier problem_link in scope last_response AS (SELECT org, course_key, problem_link, problem_id, actor_id, course_order, graded, multiIf(success, attempts, 0) AS success_attempt, multiIf(NOT success, attempts, 0) AS incorrect_attempt FROM reporting.dim_learner_last_response). Maybe you meant: [‘problem_link’]. Stack trace:
DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000013596f1f
DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000ca3f80e
DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000ca3f2c0
DB::Exception::Exception<char const*, String&, String, String, String>(int, FormatStringHelperImpl<std::type_identity<char const*>::type, std::type_identity<String&>::type, std::type_identity::type, std::type_identity::type, std::type_identity::type>, char const*&&, String&, String&&, String&&, String&&) @ 0x0000000017618182
DB::QueryAnalyzer::resolveExpressionNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, bool, bool, bool) @ 0x00000000175e3a7f
DB::QueryAnalyzer::resolveExpressionNodeList(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, bool, bool) @ 0x00000000175e0cf4
DB::QueryAnalyzer::resolveProjectionExpressionNodeList(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&) @ 0x0000000017618f27
DB::QueryAnalyzer::resolveQuery(std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x00000000175d7bee
DB::QueryAnalyzer::resolveExpressionNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, bool, bool, bool) @ 0x00000000175e185a
DB::QueryAnalyzer::resolveQueryJoinTreeNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, DB::QueryExpressionsAliasVisitor&) @ 0x000000001761a2d8
DB::QueryAnalyzer::resolveJoin(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, DB::QueryExpressionsAliasVisitor&) @ 0x000000001761bafa
DB::QueryAnalyzer::resolveQueryJoinTreeNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, DB::QueryExpressionsAliasVisitor&) @ 0x0000000017619d78
DB::QueryAnalyzer::resolveQuery(std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x00000000175d7ba4
DB::QueryAnalyzer::resolve(std::shared_ptrDB::IQueryTreeNode&, std::shared_ptrDB::IQueryTreeNode const&, std::shared_ptr<DB::Context const>) @ 0x00000000175d5538
DB::QueryAnalysisPass::run(std::shared_ptrDB::IQueryTreeNode&, std::shared_ptr<DB::Context const>) @ 0x00000000175d4b9c
DB::QueryTreePassManager::run(std::shared_ptrDB::IQueryTreeNode) @ 0x000000001763f3f6
DB::buildQueryTreeAndRunPasses(std::shared_ptrDB::IAST const&, DB::SelectQueryOptions const&, std::shared_ptr<DB::Context const> const&, std::shared_ptrDB::IStorage const&) (.llvm.1953922074611898924) @ 0x00000000181a4b8d
DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptrDB::IAST const&, std::shared_ptr<DB::Context const> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator> const&) @ 0x00000000181a2adc
DB::InterpreterSelectQueryAnalyzer::getSampleBlock(std::shared_ptrDB::IAST const&, std::shared_ptr<DB::Context const> const&, DB::SelectQueryOptions const&) @ 0x00000000181a4fe1
DB::InterpreterCreateQuery::getTablePropertiesAndNormalizeCreateQuery(DB::ASTCreateQuery&, DB::LoadingStrictnessLevel) const @ 0x00000000180c6747
DB::InterpreterCreateQuery::createTable(DB::ASTCreateQuery&) @ 0x00000000180cefbf
DB::InterpreterCreateQuery::execute() @ 0x00000000180e55b8
DB::executeQueryImpl(char const*, char const*, std::shared_ptrDB::Context, DB::QueryFlags, DB::QueryProcessingStage::Enum, std::unique_ptr<DB::ReadBuffer, std::default_deleteDB::ReadBuffer>&, std::shared_ptrDB::IAST&, std::shared_ptrDB::ImplicitTransactionControlExecutor) @ 0x00000000185759e0
DB::executeQuery(String const&, std::shared_ptrDB::Context, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x000000001856dc4b
DB::TCPHandler::runImpl() @ 0x0000000019c56510
DB::TCPHandler::run() @ 0x0000000019c78599
Poco::Net::TCPServerConnection::start() @ 0x000000001f1a9cc7
Poco::Net::TCPServerDispatcher::run() @ 0x000000001f1aa159
Poco::PooledThread::run() @ 0x000000001f1707c7
Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001f16ebc1
? @ 0x0000000000094ac3
? @ 0x0000000000125a74
14:23:32
14:23:32 Database Error in model dim_subsection_problem_results (models/problems/dim_subsection_problem_results.sql)
Code: 47.
DB::Exception: Identifier ‘last_response.display_name_with_location’ cannot be resolved from table with name last_response. In scope SELECT last_response.org AS org, last_response.course_key AS course_key, last_response.actor_id AS actor_id, splitByChar(‘@’, subsection_blocks.block_id)[3] AS block_id_short, last_response.problem_id AS problem_id, last_response.success AS success, last_response.scaled_score AS scaled_score, splitByString(’ - ‘, subsection_blocks.display_name_with_location) AS _subsection_with_name, arrayStringConcat(arrayMap(x → leftPad(x, 2, char(917768)), splitByString(’:‘, subsection_with_name[1])), ‘:’) AS subsection_number, concat(subsection_number, ’ - ', subsection_with_name[2]) AS subsection_with_name, substring(regexpExtract(last_response.object_id, '(@problem\+block@[\w\d][^/]*)(\d)?’, 2), 2) AS _problem_id_number, ifNull(nullIf(_problem_id_number, ‘’), ‘1’) AS _problem_id_or_1, splitByString(’ - ‘, last_response.display_name_with_location) AS _problem_with_name, arrayStringConcat(arrayMap(x → leftPad(x, 2, char(917768)), splitByString(’:‘, _problem_with_name[1])), ‘:’) AS _problem_number, concat(problem_number, '’, _problem_id_or_1) AS problem_number, concat(problem_number, ’ - ', _problem_with_name[2]) AS problem_name_location FROM reporting.dim_learner_last_response AS last_response INNER JOIN reporting.dim_course_blocks AS problem_blocks ON (problem_blocks.block_id = last_response.problem_id) AND (last_response.course_key = problem_blocks.course_key) LEFT JOIN reporting.dim_course_blocks AS subsection_blocks ON (problem_blocks.subsection_number = subsection_blocks.hierarchy_location) AND (last_response.org = subsection_blocks.org) AND (last_response.course_key = subsection_blocks.course_key) AND ((subsection_blocks.block_id LIKE ‘%@sequential+block@%’) OR (subsection_blocks.block_id LIKE ‘%@chapter+block@%’)) WHERE last_response.graded. Stack trace:
DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x0000000013596f1f
DB::Exception::Exception(String&&, int, String, bool) @ 0x000000000ca3f80e
DB::Exception::Exception(PreformattedMessage&&, int) @ 0x000000000ca3f2c0
DB::Exception::Exception<String const&, String&, String, String>(int, FormatStringHelperImpl<std::type_identity<String const&>::type, std::type_identity<String&>::type, std::type_identity::type, std::type_identity::type>, String const&, String&, String&&, String&&) @ 0x000000001785aff0
DB::IdentifierResolver::tryResolveIdentifierFromStorage(DB::Identifier const&, std::shared_ptrDB::IQueryTreeNode const&, DB::AnalysisTableExpressionData const&, DB::IdentifierResolveScope&, unsigned long, bool) @ 0x000000001785a81a
DB::IdentifierResolver::tryResolveIdentifierFromTableExpression(DB::IdentifierLookup const&, std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x000000001785b2bc
DB::IdentifierResolver::tryResolveIdentifierFromJoinTreeNode(DB::IdentifierLookup const&, std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x000000001785bd7a
DB::IdentifierResolver::tryResolveIdentifierFromJoin(DB::IdentifierLookup const&, std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x000000001785c282
DB::IdentifierResolver::tryResolveIdentifierFromJoinTreeNode(DB::IdentifierLookup const&, std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x000000001785bda6
DB::IdentifierResolver::tryResolveIdentifierFromJoin(DB::IdentifierLookup const&, std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x000000001785c282
DB::IdentifierResolver::tryResolveIdentifierFromJoinTreeNode(DB::IdentifierLookup const&, std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x000000001785bda6
DB::IdentifierResolver::tryResolveIdentifierFromJoinTree(DB::IdentifierLookup const&, DB::IdentifierResolveScope&) @ 0x000000001786074d
DB::QueryAnalyzer::tryResolveIdentifier(DB::IdentifierLookup const&, DB::IdentifierResolveScope&, DB::IdentifierResolveContext) @ 0x00000000175f4553
DB::QueryAnalyzer::resolveExpressionNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, bool, bool, bool) @ 0x00000000175e1e81
DB::QueryAnalyzer::resolveExpressionNodeList(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, bool, bool) @ 0x00000000175e0cf4
DB::QueryAnalyzer::resolveFunction(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&) @ 0x00000000175fca9b
DB::QueryAnalyzer::resolveExpressionNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, bool, bool, bool) @ 0x00000000175e1920
DB::QueryAnalyzer::resolveExpressionNodeList(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, bool, bool) @ 0x00000000175e0cf4
DB::QueryAnalyzer::resolveProjectionExpressionNodeList(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&) @ 0x0000000017618f27
DB::QueryAnalyzer::resolveQuery(std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x00000000175d7bee
DB::QueryAnalyzer::resolveExpressionNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, bool, bool, bool) @ 0x00000000175e185a
DB::QueryAnalyzer::resolveQueryJoinTreeNode(std::shared_ptrDB::IQueryTreeNode&, DB::IdentifierResolveScope&, DB::QueryExpressionsAliasVisitor&) @ 0x000000001761a2d8
DB::QueryAnalyzer::resolveQuery(std::shared_ptrDB::IQueryTreeNode const&, DB::IdentifierResolveScope&) @ 0x00000000175d7ba4
DB::QueryAnalyzer::resolve(std::shared_ptrDB::IQueryTreeNode&, std::shared_ptrDB::IQueryTreeNode const&, std::shared_ptr<DB::Context const>) @ 0x00000000175d5538
DB::QueryAnalysisPass::run(std::shared_ptrDB::IQueryTreeNode&, std::shared_ptr<DB::Context const>) @ 0x00000000175d4b9c
DB::QueryTreePassManager::run(std::shared_ptrDB::IQueryTreeNode) @ 0x000000001763f3f6
DB::buildQueryTreeAndRunPasses(std::shared_ptrDB::IAST const&, DB::SelectQueryOptions const&, std::shared_ptr<DB::Context const> const&, std::shared_ptrDB::IStorage const&) (.llvm.1953922074611898924) @ 0x00000000181a4b8d
DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptrDB::IAST const&, std::shared_ptr<DB::Context const> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator> const&) @ 0x00000000181a2adc
DB::InterpreterSelectQueryAnalyzer::getSampleBlock(std::shared_ptrDB::IAST const&, std::shared_ptr<DB::Context const> const&, DB::SelectQueryOptions const&) @ 0x00000000181a4fe1
DB::AlterCommand::apply(DB::StorageInMemoryMetadata&, std::shared_ptr<DB::Context const>) const @ 0x0000000018b669c7
DB::AlterCommands::apply(DB::StorageInMemoryMetadata&, std::shared_ptr<DB::Context const>) const @ 0x0000000018b6c8b1
DB::StorageMaterializedView::alter(DB::AlterCommands const&, std::shared_ptr<DB::Context const>, std::unique_lockstd::timed_mutex&) @ 0x0000000018ceabba
compiled code at target/run/aspects/models/problems/dim_subsection_problem_results.sql
14:23:32
14:23:32 Done. PASS=25 WARN=0 ERROR=3 SKIP=2 TOTAL=30
Error: Command failed with status 1: docker compose -f /home/yagouam/manifests-local/env/local/docker-compose.yml -f /home/yagouam/manifests-local/env/local/docker-compose.prod.yml --project-name tutor_local -f /home/yagouam/manifests-local/env/local/docker-compose.jobs.yml run --rm aspects-job sh -e -c #!/usr/bin/env bash
set -e
bash /app/aspects/scripts/alembic.sh upgrade head
bash /app/aspects/scripts/dbt.sh True run
It prevents the command to be completed, and while the platform still runs, there is an error accesing to superset from the LMS as you can see in the following screenshot:
Any help on this topic is pretty much appreciated
Thanks in advance!
Regards