{"id":285894,"date":"2021-01-14T18:38:06","date_gmt":"2021-01-14T10:38:06","guid":{"rendered":"http:\/\/4563.org\/?p=285894"},"modified":"2021-01-14T18:38:06","modified_gmt":"2021-01-14T10:38:06","slug":"%e5%a4%a7%e4%bd%ac%e4%bb%ac%e9%ba%bb%e7%83%a6%e8%bf%9b%e6%9d%a5%e7%9c%8b%e4%b8%8b%ef%bc%8c%e5%b8%ae%e5%b8%ae%e5%bf%99%e3%80%82%e3%80%82clickhouse-%e6%8a%a5%e9%94%99%e3%80%82%e3%80%82%e3%80%82","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=285894","title":{"rendered":"\u5927\u4f6c\u4eec\u9ebb\u70e6\u8fdb\u6765\u770b\u4e0b\uff0c\u5e2e\u5e2e\u5fd9\u3002\u3002clickhouse \u62a5\u9519\u3002\u3002\u3002"},"content":{"rendered":"
\n
\n
\n

\u5927\u4f6c\u4eec\u9ebb\u70e6\u8fdb\u6765\u770b\u4e0b\uff0c\u5e2e\u5e2e\u5fd9\u3002\u3002clickhouse \u62a5\u9519\u3002\u3002\u3002 <\/h1>\n

<\/p>\n

\n
\u8cc7\u6df1\u5927\u4f6c : dtgxx <\/span> <\/i> 3<\/span> <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/p>\n

\u4f7f\u7528 clickhouse_driver \u7f16\u5199\u7684\u67e5\u8be2\u4ee3\u7801\uff0c\u6709\u65f6\u5019\u53ef\u4ee5\u6267\u884c\u6210\u529f\uff0c\u67e5\u8be2\u8017\u65f6 4 \u79d2\u5de6\u53f3\uff0c\u6709\u65f6\u5019\u5c31\u62a5\u9519\uff0c\u62a5\u9519\u4e4b\u540e\u53ea\u6709\u91cd\u542f clickhouse \u670d\u52a1\u624d\u53ef\u4ee5\u6062\u590d\u8fd9\u4e2a\u63a5\u53e3\uff08\u62a5\u9519\u7684\u65f6\u5019\uff0c\u5176\u4ed6\u67e5\u8be2\u63a5\u53e3\u4e0d\u53d7\u5f71\u54cd\uff09\u3002\u6211\u6267\u884c\u7684\u8bed\u53e5\u662f\u5f88\u591a sql union all \u5728\u4e00\u8d77\uff0c\u53ef\u80fd\u6709 1000 \u591a\u4e2a union\uff0c\u62a5\u9519\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n

clickhouse_driver.errors.ServerException: Code: 279. DB::Exception: All connection tries failed. Log: <\/p>\n

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))<\/p>\n

: While executing Remote. Stack trace:<\/p>\n

    \n
  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<\/li>\n
  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<\/li>\n
  3. DB::ConnectionPoolWithFailover::getManyChecked(DB::ConnectionTimeouts const&, DB::Settings const*, DB::PoolMode, DB::QualifiedTableName const&) @ 0xe2a96aa in \/usr\/bin\/clickhouse<\/li>\n
  4. ? @ 0xd50a8b4 in \/usr\/bin\/clickhouse<\/li>\n
  5. DB::RemoteQueryExecutor::sendQuery() @ 0xd4ff814 in \/usr\/bin\/clickhouse<\/li>\n
  6. DB::RemoteSource::generate() @ 0xe4c37ac in \/usr\/bin\/clickhouse<\/li>\n
  7. DB::ISource::work() @ 0xe36459a in \/usr\/bin\/clickhouse<\/li>\n
  8. DB::SourceWithProgress::work() @ 0xe4c927a in \/usr\/bin\/clickhouse<\/li>\n
  9. ? @ 0xe39d37c in \/usr\/bin\/clickhouse<\/li>\n
  10. DB::PipelineExecutor::executeStepImpl(unsigned long, unsigned long, std::__1::atomic<bool>*) @ 0xe39a4a7 in \/usr\/bin\/clickhouse<\/li>\n
  11. ? @ 0xe39f455 in \/usr\/bin\/clickhouse<\/li>\n
  12. ThreadPoolImplstd::__1::thread::worker(std::__1::__list_iterator<std::__1::thread, void*>) @ 0x7b7293d in \/usr\/bin\/clickhouse<\/li>\n
  13. ? @ 0x7b76463 in \/usr\/bin\/clickhouse<\/li>\n
  14. start_thread @ 0x7ea5 in \/usr\/lib64\/libpthread-2.17.so<\/li>\n
  15. __clone @ 0xfe8dd in \/usr\/lib64\/libc-2.17.so<\/li>\n<\/ol><\/div>\n
    \u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (0<\/span>) <\/div>\n
    <\/div>\n<\/p><\/div>\n<\/p><\/div>\n
      \n
    • \n","protected":false},"excerpt":{"rendered":"

      \u5927\u4f6c\u4eec\u9ebb\u70e6\u8fdb\u6765\u770b\u4e0b\uff0c\u5e2e\u5e2e\u5fd9\u3002\u3002cl…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/285894"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=285894"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/285894\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=285894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=285894"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=285894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}