-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Update to 19.13.1.11 causes error Table contains parts with adaptive and non adaptive marks ( and no auto recovery ) #6394
Copy link
Copy link
Closed
Labels
backward compatibilitybugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official release
Description
After update server does not start:
019.08.08 08:05:45.337713 [ 1 ] {} Application: DB::Exception: Cannot create table from metadata file /var/lib/clickhouse/metadata/ethereum//transfers_tx_storage.sql, error: DB::Exception: Table contains parts with adaptive and non adaptive marks, but setting enable_mixed_granularity_parts is disabled, stack trace:
0. /usr/bin/clickhouse-server(StackTrace::StackTrace()+0x30) [0x7f58f30]
- /usr/bin/clickhouse-server(DB::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, int)+0x25) [0x3c427b5]
- /usr/bin/clickhouse-server() [0x39c01c4]
- /usr/bin/clickhouse-server(DB::StorageReplicatedMergeTree::StorageReplicatedMergeTree(std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, bool, std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, DB::ColumnsDescription const&, DB::IndicesDescription const&, DB::Context&, std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, std::shared_ptrDB::IAST const&, std::shared_ptrDB::IAST const&, std::shared_ptrDB::IAST const&, std::shared_ptrDB::IAST const&, std::shared_ptrDB::IAST const&, DB::MergeTreeData::MergingParams const&, DB::MergeTreeSettings const&, bool)+0xf79) [0x6fd1f99]
- /usr/bin/clickhouse-server() [0x711d68b]
- /usr/bin/clickhouse-server(std::_Function_handler<std::shared_ptrDB::IStorage (DB::StorageFactory::Arguments const&), std::shared_ptrDB::IStorage (*)(DB::StorageFactory::Arguments const&)>::_M_invoke(std::_Any_data const&, DB::StorageFactory::Arguments const&)+0x25) [0x711f415]
- /usr/bin/clickhouse-server(DB::StorageFactory::get(DB::ASTCreateQuery&, std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, DB::Context&, DB::Context&, DB::ColumnsDescription const&, bool, bool) const+0x28e) [0x6f64e5e]
- /usr/bin/clickhouse-server(DB::createTableFromDefinition(std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, DB::Context&, bool, std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&)+0x2d1) [0x6cd1bc1]
- /usr/bin/clickhouse-server() [0x737c0cd]
- /usr/bin/clickhouse-server() [0x737c5ff]
- /usr/bin/clickhouse-server(ThreadPoolImpl::worker(std::_List_iterator)+0x1a7) [0x3c74537]
- /usr/bin/clickhouse-server(ThreadFromGlobalPool::ThreadFromGlobalPool<ThreadPoolImpl::scheduleImpl(std::function<void ()>, int, std::optional)::{lambda()BaseDaemon: terminate on double SIGINT #3}>(ThreadPoolImpl::scheduleImpl(std::function<void ()>, int, std::optional)::{lambda()BaseDaemon: terminate on double SIGINT #3}&&)::{lambda()Repair subtree2 #1}::operator()() const+0x3e) [0x3c74b1e]
- /usr/bin/clickhouse-server(ThreadPoolImplstd::thread::worker(std::_List_iteratorstd::thread)+0x1a6) [0x3c72046]
- /usr/bin/clickhouse-server() [0xba2baa0]
- /lib/x86_64-linux-gnu/libpthread.so.0(+0x7494) [0x7fcbb0a4b494]
- /lib/x86_64-linux-gnu/libc.so.6(clone+0x3f) [0x7fcbb0285aff]
I resolved it by adding
<enable_mixed_granularity_parts>1</enable_mixed_granularity_parts>
in merge_tree config.xml
But that was not done automatically
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
backward compatibilitybugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official release