Upgrade check error: Missing columns: 'x' ... on server startup

[kssenii]

https://s3.amazonaws.com/clickhouse-test-reports/55252/1a839adec7d89cd13a74b610c318da912174b728/upgrade_check__msan_/clickhouse-server.log

2023.10.07 17:41:18.858741 [ 1611168 ] {} <Error> Application: Code: 47. DB::Exception: Missing columns: 'x' while processing query: 'SELECT x = 1, id, value FROM test_11.view', required columns: 'id' 'value' 'x', maybe you meant: 'id' or 'value': While processing _CAST(dictGet('test_11.dict', 'value', toUInt32(1)) AS col_tmp_alter4730806338858091863, 'String') AS col: default expression and column type are incompatible.: Cannot attach table `test_11`.`table` from metadata file /var/lib/clickhouse/store/d19/d19abf56-6148-45ee-a97b-0e751c186006/table.sql from query ATTACH TABLE test_11.table UUID 'f580853e-c16e-46bb-b47a-751e63df19af' (`col` String MATERIALIZED dictGet('test_11.dict', 'value', toUInt32(1))) ENGINE = MergeTree ORDER BY tuple() SETTINGS index_granularity = 8192. (UNKNOWN_IDENTIFIER), Stack trace (when copying this message, always include the lines below):

0. ./build_docker/./contrib/llvm-project/libcxx/include/exception:134: Poco::Exception::Exception(String const&, int) @ 0x00000000414410e9 in /usr/bin/clickhouse
1. ./build_docker/./src/Common/Exception.cpp:103: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000001f51ddd3 in /usr/bin/clickhouse
2. DB::Exception::Exception(PreformattedMessage&&, int) @ 0x00000000087d099b in /usr/bin/clickhouse
3. ./build_docker/./src/Interpreters/TreeRewriter.cpp:1214: DB::TreeRewriterResult::collectUsedColumns(std::shared_ptr<DB::IAST> const&, bool, bool, bool) @ 0x0000000038b9b53e in /usr/bin/clickhouse
4. ./build_docker/./contrib/llvm-project/libcxx/include/__hash_table:935: DB::TreeRewriter::analyzeSelect(std::shared_ptr<DB::IAST>&, DB::TreeRewriterResult&&, DB::SelectQueryOptions const&, std::vector<DB::TableWithColumnNamesAndTypes, std::allocator<DB::TableWithColumnNamesAndTypes>> const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::TableJoin>) const @ 0x0000000038baae5e in /usr/bin/clickhouse
5. ./build_docker/./src/Interpreters/InterpreterSelectQuery.cpp:171: DB::generateFilterActions(DB::StorageID const&, std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context const> const&, std::shared_ptr<DB::IStorage> const&, std::shared_ptr<DB::StorageSnapshot> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::vector<String, std::allocator<String>>&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000037f9938d in /usr/bin/clickhouse
6. ./build_docker/./src/Interpreters/InterpreterSelectQuery.cpp:0: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>)::$_0::operator()(bool) const @ 0x0000000037fbcc72 in /usr/bin/clickhouse
7. ./build_docker/./src/Interpreters/InterpreterSelectQuery.cpp:0: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, std::optional<DB::Pipe>, std::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&, std::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::shared_ptr<DB::PreparedSets>) @ 0x0000000037faa23b in /usr/bin/clickhouse
8. ./build_docker/./src/Interpreters/InterpreterSelectQuery.cpp:0: DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context> const&, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x0000000037f9df7f in /usr/bin/clickhouse
9. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:303: DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::shared_ptr<DB::IAST> const&, std::vector<String, std::allocator<String>> const&) @ 0x00000000381fe8f9 in /usr/bin/clickhouse
10. ./build_docker/./src/Interpreters/InterpreterSelectWithUnionQuery.cpp:152: DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::vector<String, std::allocator<String>> const&) @ 0x00000000381f93f9 in /usr/bin/clickhouse
11. ./build_docker/./contrib/llvm-project/libcxx/include/vector:434: std::__unique_if<DB::InterpreterSelectWithUnionQuery>::__unique_single std::make_unique[abi:v15000]<DB::InterpreterSelectWithUnionQuery, std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&>(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>&, DB::SelectQueryOptions const&) @ 0x0000000037eb6c75 in /usr/bin/clickhouse
12. ./build_docker/./src/Interpreters/InterpreterFactory.cpp:0: DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, std::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x0000000037eb3550 in /usr/bin/clickhouse
13. ./build_docker/./src/Interpreters/executeQuery.cpp:1034: DB::executeQueryImpl(char const*, char const*, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000038e490f5 in /usr/bin/clickhouse
14. ./build_docker/./src/Interpreters/executeQuery.cpp:1234: DB::executeQuery(String const&, std::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x0000000038e3c81e in /usr/bin/clickhouse
15. ./build_docker/./src/Dictionaries/ClickHouseDictionarySource.cpp:171: DB::ClickHouseDictionarySource::createStreamForQuery(String const&) @ 0x0000000029a310ab in /usr/bin/clickhouse
16. ./build_docker/./src/Dictionaries/ClickHouseDictionarySource.cpp:113: DB::ClickHouseDictionarySource::loadAll() @ 0x0000000029a30e35 in /usr/bin/clickhouse
17. DB::HashedDictionary<(DB::DictionaryKeyType)0, false, false>::loadData() @ 0x0000000029d59b8f in /usr/bin/clickhouse
18. DB::HashedDictionary<(DB::DictionaryKeyType)0, false, false>::HashedDictionary(DB::StorageID const&, DB::DictionaryStructure const&, std::shared_ptr<DB::IDictionarySource>, DB::HashedDictionaryConfiguration const&, std::shared_ptr<DB::Block>) @ 0x0000000029d58c01 in /usr/bin/clickhouse
19. DB::registerDictionaryHashed(DB::DictionaryFactory&)::$_4::operator()(String const&, DB::DictionaryStructure const&, Poco::Util::AbstractConfiguration const&, String const&, std::shared_ptr<DB::IDictionarySource>, DB::DictionaryKeyType, bool) const @ 0x0000000029d55bac in /usr/bin/clickhouse
20. std::unique_ptr<DB::IDictionary, std::default_delete<DB::IDictionary>> std::__function::__policy_invoker<std::unique_ptr<DB::IDictionary, std::default_delete<DB::IDictionary>> (String const&, DB::DictionaryStructure const&, Poco::Util::AbstractConfiguration const&, String const&, std::shared_ptr<DB::IDictionarySource>, std::shared_ptr<DB::Context const>, bool)>::__call_impl<std::__function::__default_alloc_func<DB::registerDictionaryHashed(DB::DictionaryFactory&)::$_0, std::unique_ptr<DB::IDictionary, std::default_delete<DB::IDictionary>> (String const&, DB::DictionaryStructure const&, Poco::Util::AbstractConfiguration const&, String const&, std::shared_ptr<DB::IDictionarySource>, std::shared_ptr<DB::Context const>, bool)>>(std::__function::__policy_storage const*, String const&, DB::DictionaryStructure const&, Poco::Util::AbstractConfiguration const&, String const&, std::shared_ptr<DB::IDictionarySource>&&, std::shared_ptr<DB::Context const>&&, bool) @ 0x0000000029d51bd4 in /usr/bin/clickhouse
21. ./build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:848: std::function<std::unique_ptr<DB::IDictionary, std::default_delete<DB::IDictionary>> (String const&, DB::DictionaryStructure const&, Poco::Util::AbstractConfiguration const&, String const&, std::shared_ptr<DB::IDictionarySource>, std::shared_ptr<DB::Context const>, bool)>::operator()(String const&, DB::DictionaryStructure const&, Poco::Util::AbstractConfiguration const&, String const&, std::shared_ptr<DB::IDictionarySource>, std::shared_ptr<DB::Context const>, bool) const @ 0x0000000033a73c91 in /usr/bin/clickhouse
22. ./build_docker/./src/Dictionaries/DictionaryFactory.cpp:0: DB::DictionaryFactory::create(String const&, Poco::Util::AbstractConfiguration const&, String const&, std::shared_ptr<DB::Context const>, bool) const @ 0x0000000033a70917 in /usr/bin/clickhouse
23. ./build_docker/./src/Interpreters/ExternalDictionariesLoader.cpp:40: DB::ExternalDictionariesLoader::create(String const&, Poco::Util::AbstractConfiguration const&, String const&, String const&) const @ 0x0000000037112aa4 in /usr/bin/clickhouse
24. ./build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:717: std::shared_ptr<DB::IExternalLoadable const> std::__function::__policy_invoker<std::shared_ptr<DB::IExternalLoadable const> (String const&, DB::ExternalLoader::ObjectConfig const&, std::shared_ptr<DB::IExternalLoadable const> const&)>::__call_impl<std::__function::__default_alloc_func<DB::ExternalLoader::ExternalLoader(String const&, Poco::Logger*)::$_0, std::shared_ptr<DB::IExternalLoadable const> (String const&, DB::ExternalLoader::ObjectConfig const&, std::shared_ptr<DB::IExternalLoadable const> const&)>>(std::__function::__policy_storage const*, String const&, DB::ExternalLoader::ObjectConfig const&, std::shared_ptr<DB::IExternalLoadable const> const&) @ 0x000000003711dbe0 in /usr/bin/clickhouse
25. ./build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:0: DB::ExternalLoader::LoadingDispatcher::loadSingleObject(String const&, DB::ExternalLoader::ObjectConfig const&, std::shared_ptr<DB::IExternalLoadable const>) @ 0x000000003713ac85 in /usr/bin/clickhouse
26. ./build_docker/./contrib/llvm-project/libcxx/include/__utility/pair.h:520: DB::ExternalLoader::LoadingDispatcher::doLoading(String const&, unsigned long, bool, unsigned long, bool, std::shared_ptr<DB::ThreadGroup>) @ 0x0000000037131712 in /usr/bin/clickhouse
27. ./build_docker/./contrib/llvm-project/libcxx/include/__functional/invoke.h:0: ThreadFromGlobalPoolImpl<true>::ThreadFromGlobalPoolImpl<void (DB::ExternalLoader::LoadingDispatcher::*)(String const&, unsigned long, bool, unsigned long, bool, std::shared_ptr<DB::ThreadGroup>), DB::ExternalLoader::LoadingDispatcher*, String&, unsigned long&, bool&, unsigned long&, bool, std::shared_ptr<DB::ThreadGroup>>(void (DB::ExternalLoader::LoadingDispatcher::*&&)(String const&, unsigned long, bool, unsigned long, bool, std::shared_ptr<DB::ThreadGroup>), DB::ExternalLoader::LoadingDispatcher*&&, String&, unsigned long&, bool&, unsigned long&, bool&&, std::shared_ptr<DB::ThreadGroup>&&)::'lambda'()::operator()() @ 0x0000000037143d5a in /usr/bin/clickhouse
28. ./build_docker/./contrib/llvm-project/libcxx/include/__functional/function.h:717: void std::__function::__policy_invoker<void ()>::__call_impl<std::__function::__default_alloc_func<ThreadFromGlobalPoolImpl<true>::ThreadFromGlobalPoolImpl<void (DB::ExternalLoader::LoadingDispatcher::*)(String const&, unsigned long, bool, unsigned long, bool, std::shared_ptr<DB::ThreadGroup>), DB::ExternalLoader::LoadingDispatcher*, String&, unsigned long&, bool&, unsigned long&, bool, std::shared_ptr<DB::ThreadGroup>>(void (DB::ExternalLoader::LoadingDispatcher::*&&)(String const&, unsigned long, bool, unsigned long, bool, std::shared_ptr<DB::ThreadGroup>), DB::ExternalLoader::LoadingDispatcher*&&, String&, unsigned long&, bool&, unsigned long&, bool&&, std::shared_ptr<DB::ThreadGroup>&&)::'lambda'(), void ()>>(std::__function::__policy_storage const*) @ 0x000000003714383f in /usr/bin/clickhouse
29. ./build_docker/./base/base/../base/wide_integer_impl.h:809: ThreadPoolImpl<std::thread>::worker(std::__list_iterator<std::thread, void*>) @ 0x000000001f865f0f in /usr/bin/clickhouse
30. ./build_docker/./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:303: void* std::__thread_proxy[abi:v15000]<std::tuple<std::unique_ptr<std::__thread_struct, std::default_delete<std::__thread_struct>>, void ThreadPoolImpl<std::thread>::scheduleImpl<void>(std::function<void ()>, Priority, std::optional<unsigned long>, bool)::'lambda0'()>>(void*) @ 0x000000001f874b8b in /usr/bin/clickhouse
31. ? @ 0x00007f61e2ab3ac3 in ?
 (version 23.10.1.1)