Skip to content

Update to 19.13.1.11 causes error Table contains parts with adaptive and non adaptive marks ( and no auto recovery ) #6394

@astudnev

Description

@astudnev

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]

  1. /usr/bin/clickhouse-server(DB::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits, std::allocator > const&, int)+0x25) [0x3c427b5]
  2. /usr/bin/clickhouse-server() [0x39c01c4]
  3. /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]
  4. /usr/bin/clickhouse-server() [0x711d68b]
  5. /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]
  6. /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]
  7. /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]
  8. /usr/bin/clickhouse-server() [0x737c0cd]
  9. /usr/bin/clickhouse-server() [0x737c5ff]
  10. /usr/bin/clickhouse-server(ThreadPoolImpl::worker(std::_List_iterator)+0x1a7) [0x3c74537]
  11. /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]
  12. /usr/bin/clickhouse-server(ThreadPoolImplstd::thread::worker(std::_List_iteratorstd::thread)+0x1a6) [0x3c72046]
  13. /usr/bin/clickhouse-server() [0xba2baa0]
  14. /lib/x86_64-linux-gnu/libpthread.so.0(+0x7494) [0x7fcbb0a4b494]
  15. /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

Metadata

Metadata

Assignees

Labels

backward compatibilitybugConfirmed user-visible misbehaviour in official release

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions