Ds-Mode@Alexh1 /data/repos/dozor/config-final.git/0f676af8-e25d-481e-a193-2aaecb2a2eed/clickhouse/conf.d # cat test.xml <?xml version="1.0"?> <yandex> <profiles>

<default>
<joined_subquery_requires_alias>0</joined_subquery_requires_alias>
<any_join_distinct_right_table_keys>1</any_join_distinct_right_table_keys>
</default>
</profiles>
</yandex>
ds-mode@alexh1 /data/repos/dozor/config-final.git/0f676af8-e25d-481e-a193-2aaecb2a2eed/clickhouse/conf.d # cat test2.xml
<yandex>
<merge_tree>
<parts_to_delay_insert>150</parts_to_delay_insert>
<parts_to_throw_insert>600</parts_to_throw_insert>
<max_delay_to_insert>5</max_delay_to_insert>
<enable_mixed_granularity_parts>1</enable_mixed_granularity_parts>
<index_granularity_bytes>10485760</index_granularity_bytes>
</merge_tree>
</yandex>

и что выводится в косноль при sudo -u clickhouse /usr/bin/clickhouse-server --config-file /data/repos/dozor/config-final.git/0f676af8-e25d-481e-a193-2aaecb2a2eed/clickhouse/config.xml

Вот ошибка 020-11-17 20:12:26.857898500 2020.11.17 20:12:26.857276 [ 20051 ] {} <Error> DynamicQueryHandler: Code: 115, e.displayText() = DB::Exception: Unknown setting profile, Stack trace (when copying this message, always include the lines below): 2020-11-17 20:12:26.857903500 2020-11-17 20:12:26.857903500 0. Poco::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0x18ba03d0 in /usr/bin/clickhouse 2020-11-17 20:12:26.857905500 1. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0xe606dad in /usr/bin/clickhouse 2020-11-17 20:12:26.857939500 2. DB::BaseSettingsHelpers::throwSettingNotFound(std::__1::basic_string_view<char, std::__1::char_traits<char> > const&) @ 0x1534fa30 in /usr/bin/clickhouse 2020-11-17 20:12:26.857941500 3. DB::AccessControlManager::CustomSettingsPrefixes::checkSettingNameIsAllowed(std::__1::basic_string_view<char, std::__1::char_traits<char> > const&) const @ 0x15238abc in /usr/bin/clickhouse 2020-11-17 20:12:26.857968500 4. DB::SettingsConstraints::checkImpl(DB::Settings const&, DB::SettingChange&, DB::SettingsConstraints::ReactionOnViolation) const @ 0x152f6074 in /usr/bin/clickhouse 2020-11-17 20:12:26.857992500 5. DB::SettingsConstraints::check(DB::Settings const&, DB::SettingsChanges&) const @ 0x152f675f in /usr/bin/clickhouse 2020-11-17 20:12:26.857993500 6. DB::Context::checkSettingsConstraints(DB::SettingsChanges&) const @ 0x155ef89d in /usr/bin/clickhouse 2020-11-17 20:12:26.857995500 7. DB::HTTPHandler::processQuery(DB::Context&, Poco::Net::HTTPServerRequest&, HTMLForm&, Poco::Net::HTTPServerResponse&, DB::HTTPHandler::Output&) @ 0x16211fef in /usr/bin/clickhouse 2020-11-17 20:12:26.858004500 8. DB::HTTPHandler::handleRequest(Poco::Net::HTTPServerRequest&, Poco::Net::HTTPServerResponse&) @ 0x16215e1b in /usr/bin/clickhouse 2020-11-17 20:12:26.858005500 9. Poco::Net::HTTPServerConnection::run() @ 0x18a80023 in /usr/bin/clickhouse 2020-11-17 20:12:26.858006500 10. Poco::Net::TCPServerConnection::start() @ 0x18abe23b in /usr/bin/clickhouse 2020-11-17 20:12:26.858014500 11. Poco::Net::TCPServerDispatcher::run() @ 0x18abe6cb in /usr/bin/clickhouse 2020-11-17 20:12:26.858015500 12. Poco::PooledThread::run() @ 0x18c3d1a6 in /usr/bin/clickhouse 2020-11-17 20:12:26.858016500 13. Poco::ThreadImpl::runnableEntry(void*) @ 0x18c385a0 in /usr/bin/clickhouse 2020-11-17 20:12:26.858017500 14. start_thread @ 0x7dd5 in /usr/lib64/libpthread-2.17.so 2020-11-17 20:12:26.858018500 15. __clone @ 0xfe02d in /usr/lib64/libc-2.17.so 2020-11-17 20:12:26.858040500 (version 20.8.4.11 (official build))

возьмите config.xml стоковый , может у вас там затесалось что-то?

Ок. попробую