未分類
14 1 月 2021

大佬们麻烦进来看下，帮帮忙。。clickhouse 报错。。。

大佬们麻烦进来看下，帮帮忙。。clickhouse 报错。。。

資深大佬 : dtgxx 3

使用 clickhouse_driver 编写的查询代码，有时候可以执行成功，查询耗时 4 秒左右，有时候就报错，报错之后只有重启 clickhouse 服务才可以恢复这个接口（报错的时候，其他查询接口不受影响）。我执行的语句是很多 sql union all 在一起，可能有 1000 多个 union，报错信息如下：

clickhouse_driver.errors.ServerException: Code: 279. DB::Exception: All connection tries failed. Log:

Code: 32, e.displayText() = DB::Exception: Attempt to read after eof (version 20.11.4.13 (official build)) Code: 32, e.displayText() = DB::Exception: Attempt to read after eof (version 20.11.4.13 (official build)) Code: 32, e.displayText() = DB::Exception: Attempt to read after eof (version 20.11.4.13 (official build))

: While executing Remote. Stack trace:

  1. PoolWithFailoverBaseDB::IConnectionPool::getMany(unsigned long, unsigned long, unsigned long, unsigned long, bool, std::__1::function<PoolWithFailoverBaseDB::IConnectionPool::TryResult (DB::IConnectionPool&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >&)> const&, std::__1::function<unsigned long (unsigned long)> const&) @ 0xe2aa967 in /usr/bin/clickhouse
  2. DB::ConnectionPoolWithFailover::getManyImpl(DB::Settings const*, DB::PoolMode, std::__1::function<PoolWithFailoverBaseDB::IConnectionPool::TryResult (DB::IConnectionPool&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> >&)> const&) @ 0xe2a9355 in /usr/bin/clickhouse
  3. DB::ConnectionPoolWithFailover::getManyChecked(DB::ConnectionTimeouts const&, DB::Settings const*, DB::PoolMode, DB::QualifiedTableName const&) @ 0xe2a96aa in /usr/bin/clickhouse
  4. ? @ 0xd50a8b4 in /usr/bin/clickhouse
  5. DB::RemoteQueryExecutor::sendQuery() @ 0xd4ff814 in /usr/bin/clickhouse
  6. DB::RemoteSource::generate() @ 0xe4c37ac in /usr/bin/clickhouse
  7. DB::ISource::work() @ 0xe36459a in /usr/bin/clickhouse
  8. DB::SourceWithProgress::work() @ 0xe4c927a in /usr/bin/clickhouse
  9. ? @ 0xe39d37c in /usr/bin/clickhouse
  10. DB::PipelineExecutor::executeStepImpl(unsigned long, unsigned long, std::__1::atomic<bool>*) @ 0xe39a4a7 in /usr/bin/clickhouse
  11. ? @ 0xe39f455 in /usr/bin/clickhouse
  12. ThreadPoolImplstd::__1::thread::worker(std::__1::__list_iterator<std::__1::thread, void*>) @ 0x7b7293d in /usr/bin/clickhouse
  13. ? @ 0x7b76463 in /usr/bin/clickhouse
  14. start_thread @ 0x7ea5 in /usr/lib64/libpthread-2.17.so
  15. __clone @ 0xfe8dd in /usr/lib64/libc-2.17.so
大佬有話說 (0)