Hello team, We are running Otel collector version

v.88.21

locally, we keep getting this error

code: 115, message: Unknown setting database

and this is the error in clickhouse end as well

2024.04.24 11:48:49.423451 [ 49 ] {} <Error> TCPHandler: Code: 115. DB::Exception: Unknown setting database. (UNKNOWN_SETTING), Stack trace (when copying this message, always include the lines below):

0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000bc17148 in /usr/bin/clickhouse
1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x0000000007526170 in /usr/bin/clickhouse
2. DB::BaseSettingsHelpers::throwSettingNotFound(std::basic_string_view<char, std::char_traits<char>>) @ 0x000000000f27b0e8 in /usr/bin/clickhouse
3. DB::BaseSettings<DB::SettingsTraits>::read(DB::ReadBuffer&, DB::SettingsWriteFormat) @ 0x000000000f2cd6c0 in /usr/bin/clickhouse
4. DB::TCPHandler::receiveQuery() @ 0x000000001116bc7c in /usr/bin/clickhouse
5. DB::TCPHandler::receivePacket() @ 0x00000000111640a4 in /usr/bin/clickhouse
6. DB::TCPHandler::runImpl() @ 0x000000001115a18c in /usr/bin/clickhouse
7. DB::TCPHandler::run() @ 0x000000001116ece8 in /usr/bin/clickhouse
8. Poco::Net::TCPServerConnection::start() @ 0x0000000013611fa4 in /usr/bin/clickhouse
9. Poco::Net::TCPServerDispatcher::run() @ 0x0000000013612f18 in /usr/bin/clickhouse
10. Poco::PooledThread::run() @ 0x0000000013732adc in /usr/bin/clickhouse
11. Poco::ThreadImpl::runnableEntry(void*) @ 0x0000000013730f0c in /usr/bin/clickhouse
12. start_thread @ 0x0000000000007624 in /lib/libpthread.so.0
13. ? @ 0x00000000000d162c in /lib/libc.so.6

2024.04.24 11:48:49.424448 [ 49 ] {} <Warning> TCPHandler: Can't skip data packets after query failure.

We are running the otel-collector using this config, also we found that the error originates here this is happening for

clickhousetraces

,

clickhousemetricswrite

,

clickhousemetricswrite/prometheus

but not for

clickhouselogsexporter

The migrator ran without any issues, we verified that.

Please update the connection like this change https://github.com/SigNoz/signoz/pull/4909/files

Got it, thank you!