V2EX = way to explore
V2EX 是一个关于分享和探索的地方
现在注册
已注册用户请  登录
dtgxx
V2EX  ›  问与答

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

  •  
  •   dtgxx · 2021 年 1 月 13 日 · 1055 次点击
    这是一个创建于 1917 天前的主题,其中的信息可能已经有所发展或是发生改变。

    使用 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
    目前尚无回复
    关于   ·   帮助文档   ·   自助推广系统   ·   博客   ·   API   ·   FAQ   ·   Solana   ·   5321 人在线   最高记录 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 31ms · UTC 05:53 · PVG 13:53 · LAX 22:53 · JFK 01:53
    ♥ Do have faith in what you're doing.