Hey guys, Myself MANJESH H S Iam trying to connec...
# support
m
Hey guys, Myself MANJESH H S Iam trying to connect external clickhouse cluster in place of exciting signoz clickhouse server followed as per given information on the signoz doc iam failed to get a data from exciting signoz clickhouse server to in the clickhouse cluster iam getting error on the signoz logs clickhouse server as in the below format can you suggest to resolve the issue please 2024.01.29 074057.876896 [ 582 ] {} <Error> signoz_metrics.distributed_time_series_v2.DistributedInsertQueue.default: Code: 60. DB:Exception Received from 10.0.34.52:9000. DB:Exception Table signoz_metrics.time_series_v2 does not exist. Maybe you meant signoz_metrics.time_series_v3?. Stack trace: 0. ? @ 0x000000000c7e293b in /usr/bin/clickhouse 1. ? @ 0x00000000072a9e61 in /usr/bin/clickhouse 2. ? @ 0x000000001092f19a in /usr/bin/clickhouse 3. ? @ 0x0000000010c816d6 in /usr/bin/clickhouse 4. ? @ 0x0000000010c8b249 in /usr/bin/clickhouse 5. ? @ 0x0000000011427b2b in /usr/bin/clickhouse 6. ? @ 0x000000001185eb3f in /usr/bin/clickhouse 7. ? @ 0x00000000118588da in /usr/bin/clickhouse 8. ? @ 0x0000000012804629 in /usr/bin/clickhouse 9. ? @ 0x000000001281c279 in /usr/bin/clickhouse 10. ? @ 0x0000000015281d92 in /usr/bin/clickhouse 11. ? @ 0x0000000015282b91 in /usr/bin/clickhouse 12. ? @ 0x0000000015379f47 in /usr/bin/clickhouse 13. ? @ 0x000000001537853c in /usr/bin/clickhouse 14. ? @ 0x00007f32b0c94ac3 15. ? @ 0x00007f32b0d26850 : While sending /var/lib/clickhouse/store/85a/85a1d4d5-1e6f-4c07-bf94-7d07e8da103c/shard2_replica1/630.bin. (UNKNOWN_TABLE), Stack trace (when copying this message, always include the lines below): 0. DB:Exception:Exception(DB:Exception:MessageMasked&&, int, bool) @ 0x000000000c4fd017 in /usr/bin/clickhouse 1. DB::readException(DB::ReadBuffer&, String const&, bool) @ 0x000000000c56361f in /usr/bin/clickhouse 2. DB:Connection:receiveException() const @ 0x000000001213db2a in /usr/bin/clickhouse 3. DB:Connection:receivePacket() @ 0x000000001214658d in /usr/bin/clickhouse 4. DB:RemoteInserter:RemoteInserter(DB::Connection&, DB::ConnectionTimeouts const&, String const&, DB::Settings const&, DB::ClientInfo const&) @ 0x0000000011bc3897 in /usr/bin/clickhouse 5. DB:DistributedAsyncInsertDirectoryQueue:processFile(String&) @ 0x0000000011bbdb9a in /usr/bin/clickhouse 6. DB:DistributedAsyncInsertDirectoryQueue:processFiles() @ 0x0000000011bb6789 in /usr/bin/clickhouse 7. void std: function:__policy_invoker<void ()>: call impl&lt;std function default alloc func&lt;DBDistributedAsyncInsertDirectoryQueue:DistributedAsyncInsertDirectoryQueue(DB::StorageDistributed&, std:shared ptr&lt;DB:IDisk> const&, String const&, std:shared ptr&lt;DB:IConnectionPool>, DB::ActionBlocker&, DB::BackgroundSchedulePool&)::$_0, void ()>>(std: function:__policy_storage const*) @ 0x0000000011bc1038 in /usr/bin/clickhouse 8. DB:BackgroundSchedulePool:threadFunction() @ 0x00000000100892bf in /usr/bin/clickhouse 9. void std: function:__policy_invoker<void ()>: call impl&lt;std function default alloc func&lt;ThreadFromGlobalPoolImpl&lt;false&gt;ThreadFromGlobalPoolImpl&lt;DBBackgroundSchedulePool:BackgroundSchedulePool(unsigned long, StrongTypedef<unsigned long, CurrentMetrics::MetricTag>, StrongTypedef<unsigned long, CurrentMetrics::MetricTag>, char const*)::$_0>(DB:BackgroundSchedulePool:BackgroundSchedulePool(unsigned long, StrongTypedef<unsigned long, CurrentMetrics::MetricTag>, StrongTypedef<unsigned long, CurrentMetrics::MetricTag>, char const*)::$_0&&)::'lambda'(), void ()>>(std: function:__policy_storage const*) @ 0x000000001008a311 in /usr/bin/clickhouse 10. void* std: thread proxy[abiv15000]<std:tuple&lt;stdunique ptr&lt;std:__thread_struct, std:default delete&lt;std:__thread_struct>>, void ThreadPoolImpl<std:thread&gt;:scheduleImpl<void>(std::function<void ()>, Priority, std::optional<unsigned long>, bool)::'lambda0'()>>(void*) @ 0x000000000c5e4053 in /usr/bin/clickhouse 11. ? @ 0x00007fde35c21609 in ? 12. ? @ 0x00007fde35b46133 in ? (version 23.11.1.2711 (official build)) Thanks,
r
Hi Manjesh 🙂 Can you please share the details of your deployment. Are you running SigNoz on docker or on k8s? Specifically, please share the versions/images you are using for the otel collector and schema migrator containers/pods
m
hi raj we have installed signoz using docker standalone type (https://signoz.io/docs/install/docker/) -> we have installed using the install script.. and the versions of otel collector and schema migrator container is 0.88.8.. now the thing is we have set up a existing clickhouse and zookeeper and also we had made the changes in our clickhousecluster.xml and dockercompose.yaml using this url (https://signoz.io/docs/operate/clickhouse/distributed-clickhouse/) but we are not getting logs in our external clickhouse cluster or server.. the error is in the below file. We are strucked on this issue please help me to get rid of this issue. Thanks,