Hi, im just trying to upgrade to SigNoz 0.47 from 0.46.1 and migration is crashing with the followin...
d

Danik Raikhlin

about 1 year ago
Hi, im just trying to upgrade to SigNoz 0.47 from 0.46.1 and migration is crashing with the following error: {"level":"error","timestamp":"2024-06-05T144740.007Z","caller":"migrationmanager/manager.go:81","msg":"Failed to run migrations for migrator","component":"migrationmanager","migrator":"logs","error":"failed to create database, err: code: 159, message: Distributed DDL task /clickhouse/task_queue/ddl/query-0000000195 is not finished on 1 of 1 hosts (0 of them are currently executing the task, 0 are inactive). They are going to execute the query in background. Was waiting for 180.882823243 seconds, which is longer than distributed_ddl_task_timeout","stacktrace":"github.com/SigNoz/signoz-otel-collector/migrationmanager.(*MigrationManager).Migrate\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/migrationmanager/manager.go81\nmain.main\n\t/home/runner/work/signoz otel collector/signoz otel collector/cmd/signozschemamigrator/migrate.go126\nruntime.main\n\t/opt/hostedtoolcache/go/1.21.10/x64/src/runtime/proc.go:267"} {"level":"fatal","timestamp":"2024-06-05T144740.007Z","caller":"signozschemamigrator/migrate.go:128","msg":"Failed to run migrations","component":"migrate cli","error":"failed to create database, err: code: 159, message: Distributed DDL task /clickhouse/task_queue/ddl/query-0000000195 is not finished on 1 of 1 hosts (0 of them are currently executing the task, 0 are inactive). They are going to execute the query in background. Was waiting for 180.882823243 seconds, which is longer than distributed_ddl_task_timeout","stacktrace":"main.main\n\t/home/runner/work/signoz-otel-collector/signoz-otel-collector/cmd/signozschemamigrator/migrate.go128\nruntime.main\n\t/opt/hostedtoolcache/go/1.21.10/x64/src/runtime/proc.go267"}
Hello team, I am trying to get signoz running in Nomad and I am getting the following error when ote...
r

Raphaël Grenier

about 1 year ago
Hello team, I am trying to get signoz running in Nomad and I am getting the following error when otel-collector tries to connect to clickhouse:
2024.04.30 19:33:38.290111 [ 750 ] {} <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) @ 0x000000000c800f1b in /usr/bin/clickhouse
1. DB::Exception::Exception<String>(int, FormatStringHelperImpl<std::type_identity<String>::type>, String&&) @ 0x0000000007219a43 in /usr/bin/clickhouse
2. DB::BaseSettingsHelpers::throwSettingNotFound(std::basic_string_view<char, std::char_traits<char>>) @ 0x000000001051fbab in /usr/bin/clickhouse
3. DB::BaseSettings<DB::SettingsTraits>::read(DB::ReadBuffer&, DB::SettingsWriteFormat) @ 0x000000001057a6e8 in /usr/bin/clickhouse
4. DB::TCPHandler::receiveQuery() @ 0x0000000012930419 in /usr/bin/clickhouse
5. DB::TCPHandler::receivePacket() @ 0x000000001292789b in /usr/bin/clickhouse
6. DB::TCPHandler::runImpl() @ 0x000000001291b4fb in /usr/bin/clickhouse
7. DB::TCPHandler::run() @ 0x0000000012933eb9 in /usr/bin/clickhouse
8. Poco::Net::TCPServerConnection::start() @ 0x00000000153a5a72 in /usr/bin/clickhouse
9. Poco::Net::TCPServerDispatcher::run() @ 0x00000000153a6871 in /usr/bin/clickhouse
10. Poco::PooledThread::run() @ 0x000000001549f047 in /usr/bin/clickhouse
11. Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001549d67d in /usr/bin/clickhouse
12. ? @ 0x00007f46509ea609
13. ? @ 0x00007f465090f353
Any idea on what could be wrong?