system.stack_trace

包含所有服务器线程的堆栈跟踪. 允许开发人员对服务器状态进行自省.

要分析堆栈帧, 请使用 addressToLine, addressToSymbol and demangle 内省函数.

列信息:

  • thread_name (String) — 线程名称.
  • thread_id (UInt64) — 线程标识符.
  • query_id (String) — 用于获取从query_log 系统表运行的查询的详细信息查询标识符.
  • trace (Array(UInt64)) — 堆栈跟踪 表示存储调用方法的物理地址列表.

示例

启用内省功能:

  1. SET allow_introspection_functions = 1;

从 ClickHouse 目标文件中获取符号:

  1. WITH arrayMap(x -> demangle(addressToSymbol(x)), trace) AS all SELECT thread_name, thread_id, query_id, arrayStringConcat(all, '\n') AS res FROM system.stack_trace LIMIT 1 \G;
  1. Row 1:
  2. ──────
  3. thread_name: clickhouse-serv
  5. thread_id: 686
  6. query_id:  1a11f70b-626d-47c1-b948-f9c7b206395d
  7. res:       sigqueue
  8. DB::StorageSystemStackTrace::fillData(std::__1::vector<COW<DB::IColumn>::mutable_ptr<DB::IColumn>, std::__1::allocator<COW<DB::IColumn>::mutable_ptr<DB::IColumn> > >&, DB::Context const&, DB::SelectQueryInfo const&) const
  9. DB::IStorageSystemOneBlock<DB::StorageSystemStackTrace>::read(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&, DB::SelectQueryInfo const&, DB::Context const&, DB::QueryProcessingStage::Enum, unsigned long, unsigned int)
  10. DB::InterpreterSelectQuery::executeFetchColumns(DB::QueryProcessingStage::Enum, DB::QueryPipeline&, std::__1::shared_ptr<DB::PrewhereInfo> 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&)
  11. DB::InterpreterSelectQuery::executeImpl(DB::QueryPipeline&, std::__1::shared_ptr<DB::IBlockInputStream> const&, std::__1::optional<DB::Pipe>)
  12. DB::InterpreterSelectQuery::execute()
  13. DB::InterpreterSelectWithUnionQuery::execute()
  14. DB::executeQueryImpl(char const*, char const*, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, DB::ReadBuffer*)
  15. DB::executeQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool)
  16. DB::TCPHandler::runImpl()
  17. DB::TCPHandler::run()
  18. Poco::Net::TCPServerConnection::start()
  19. Poco::Net::TCPServerDispatcher::run()
  20. Poco::PooledThread::run()
  21. Poco::ThreadImpl::runnableEntry(void*)
  22. start_thread
  23. __clone

在 ClickHouse 源代码中获取文件名和行号:

  1. WITH arrayMap(x -> addressToLine(x), trace) AS all, arrayFilter(x -> x LIKE '%/dbms/%', all) AS dbms SELECT thread_name, thread_id, query_id, arrayStringConcat(notEmpty(dbms) ? dbms : all, '\n') AS res FROM system.stack_trace LIMIT 1 \G;
  1. Row 1:
  2. ──────
  3. thread_name: clickhouse-serv
  5. thread_id: 686
  6. query_id:  cad353e7-1c29-4b2e-949f-93e597ab7a54
  7. res:       /lib/x86_64-linux-gnu/libc-2.27.so
  8. /build/obj-x86_64-linux-gnu/../src/Storages/System/StorageSystemStackTrace.cpp:182
  9. /build/obj-x86_64-linux-gnu/../contrib/libcxx/include/vector:656
  10. /build/obj-x86_64-linux-gnu/../src/Interpreters/InterpreterSelectQuery.cpp:1338
  11. /build/obj-x86_64-linux-gnu/../src/Interpreters/InterpreterSelectQuery.cpp:751
  12. /build/obj-x86_64-linux-gnu/../contrib/libcxx/include/optional:224
  13. /build/obj-x86_64-linux-gnu/../src/Interpreters/InterpreterSelectWithUnionQuery.cpp:192
  14. /build/obj-x86_64-linux-gnu/../src/Interpreters/executeQuery.cpp:384
  15. /build/obj-x86_64-linux-gnu/../src/Interpreters/executeQuery.cpp:643
  16. /build/obj-x86_64-linux-gnu/../src/Server/TCPHandler.cpp:251
  17. /build/obj-x86_64-linux-gnu/../src/Server/TCPHandler.cpp:1197
  18. /build/obj-x86_64-linux-gnu/../contrib/poco/Net/src/TCPServerConnection.cpp:57
  19. /build/obj-x86_64-linux-gnu/../contrib/libcxx/include/atomic:856
  20. /build/obj-x86_64-linux-gnu/../contrib/poco/Foundation/include/Poco/Mutex_POSIX.h:59
  21. /build/obj-x86_64-linux-gnu/../contrib/poco/Foundation/include/Poco/AutoPtr.h:223
  22. /lib/x86_64-linux-gnu/libpthread-2.27.so
  23. /lib/x86_64-linux-gnu/libc-2.27.so

另请参阅