https://signoz.io logo
Join Slack
Powered by
Hi Team, not sure how to enable logging in signoz ...
# general
m
Hi Team, not sure how to enable logging in signoz for the logs: entry in the otel pipeline to work. I get an error that reads in the lines that signoz logs db is not found when I try to query via frontend
The error and the stack trace: 
2023.02.06 18:03:47.498351 [ 275 ] {5f1bfd06-8000-4f43-8a2b-dd30138cc942} <Error> TCPHandler: Code: 81. DB::Exception: Database signoz_logs doesn't exist. (UNKNOWN_DATABASE), Stack trace (when copying this message, always include the lines below):
clickhouse                |
clickhouse                | 0. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool) @ 0xa3ef75a in /usr/bin/clickhouse
frontend                  | 172.18.0.1 - - [06/Feb/2023:18:03:47 +0000] "GET /api/v1/logs/aggregate?timestampStart=1675706324630000000&timestampEnd=1675706624630000000&step=60&q= HTTP/1.1" 500 148 "<http://localhost:3301/logs>" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36 Edg/109.0.1518.78" "-"
clickhouse                | 1. DB::DatabaseCatalog::assertDatabaseExistsUnlocked(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) const @ 0x1493e80d in /usr/bin/clickhouse
clickhouse                | 2. DB::DatabaseCatalog::getDatabase(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) const @ 0x149412c2 in /usr/bin/clickhouse
clickhouse                | 3. DB::Context::resolveStorageID(DB::StorageID, DB::Context::StorageNamespace) const @ 0x148cc8f6 in /usr/bin/clickhouse
clickhouse                | 4. DB::JoinedTables::getLeftTableStorage() @ 0x14ea8e7f in /usr/bin/clickhouse
clickhouse                | 5. DB::InterpreterSelectQuery::InterpreterSelectQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context> const&, std::__1::optional<DB::Pipe>, std::__1::shared_ptr<DB::IStorage> const&, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&, std::__1::shared_ptr<DB::StorageInMemoryMetadata const> const&, std::__1::shared_ptr<DB::PreparedSets>) @ 0x14e21c81 in /usr/bin/clickhouse
clickhouse                | 6. DB::InterpreterSelectWithUnionQuery::buildCurrentChildInterpreter(std::__1::shared_ptr<DB::IAST> const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 0x14e703ec in /usr/bin/clickhouse
clickhouse                | 7. DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::__1::shared_ptr<DB::IAST> const&, std::__1::shared_ptr<DB::Context>, DB::SelectQueryOptions const&, std::__1::vector<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >, std::__1::allocator<std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > > > const&) @ 0x14e6e0ec in /usr/bin/clickhouse
clickhouse                | 8. DB::InterpreterFactory::get(std::__1::shared_ptr<DB::IAST>&, std::__1::shared_ptr<DB::Context>, DB::SelectQueryOptions const&) @ 0x14dd21de in /usr/bin/clickhouse
clickhouse                | 9. ? @ 0x15163b20 in /usr/bin/clickhouse
clickhouse                | 10. DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::shared_ptr<DB::Context>, bool, DB::QueryProcessingStage::Enum) @ 0x151615f7 in /usr/bin/clickhouse
clickhouse                | 11. DB::TCPHandler::runImpl() @ 0x15c5946c in /usr/bin/clickhouse
clickhouse                | 12. DB::TCPHandler::run() @ 0x15c6da79 in /usr/bin/clickhouse
clickhouse                | 13. Poco::Net::TCPServerConnection::start() @ 0x189db793 in /usr/bin/clickhouse
clickhouse                | 14. Poco::Net::TCPServerDispatcher::run() @ 0x189dcaed in /usr/bin/clickhouse
clickhouse                | 15. Poco::PooledThread::run() @ 0x18b9f449 in /usr/bin/clickhouse
clickhouse                | 16. Poco::ThreadImpl::runnableEntry(void*) @ 0x18b9cd02 in /usr/bin/clickhouse
clickhouse                | 17. ? @ 0x7fe8580dc609 in ?
clickhouse                | 18. __clone @ 0x7fe858001133 in ?
5 Views
Open in Slack
PreviousNext
Powered by