JDBC, на клиенте на всякий выкрутил таймауты:
@app5:~$ clickhouse-client -h clkhs.local --verbose --stacktrace --receive_timeout=360000 --idle_connection_timeout=360000 --http_connection_timeout=360000 --http_send_timeout=360000 --http_receive_timeout=360000 --max_execution_time=360000
До этого выполнился запрос на выборку первых 10млн записей успешно, после ни один запрос не проходит с ошибкой Attempt to read after eof
Пример запроса:
>SELECT *
FROM jdbc(ps, ps, `select * from PS.RGS_VIEW_NEW OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY`)
Query id: 7838d900-d364-4db7-aa33-3049da31aa8e
Connecting to clkhs.local:9000 as user default.
Connected to ClickHouse server version 22.7.3 revision 54457.
ClickHouse client version is older than ClickHouse server. It may lack support for new features.
Exception on client:
Code: 32. DB::Exception: Attempt to read after eof: while receiving packet from clkhs.local:9000. (ATTEMPT_TO_READ_AFTER_EOF), Stack trace (when copying this message, always include the lines below):
0. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool) @ 0xb37453a in /usr/bin/clickhouse
1. DB::throwReadAfterEOF() @ 0xb38877b in /usr/bin/clickhouse
2. ? @ 0xb3bdd4b in /usr/bin/clickhouse
3. DB::Connection::receivePacket() @ 0x165bded4 in /usr/bin/clickhouse
4. DB::ClientBase::receiveAndProcessPacket(std::__1::shared_ptr<DB::IAST>, bool) @ 0x16594039 in /usr/bin/clickhouse
5. DB::ClientBase::receiveResult(std::__1::shared_ptr<DB::IAST>) @ 0x16593e40 in /usr/bin/clickhouse
6. DB::ClientBase::processOrdinaryQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::shared_ptr<DB::IAST>) @ 0x165936b2 in /usr/bin/clickhouse
7. DB::ClientBase::processParsedSingleQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::shared_ptr<DB::IAST>, std::__1::optional<bool>, bool) @ 0x16592977 in /usr/bin/clickhouse
8. DB::ClientBase::processTextAsSingleQuery(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) @ 0x1659209d in /usr/bin/clickhouse
9. DB::ClientBase::processQueryText(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) @ 0x165a0b5f in /usr/bin/clickhouse
10. DB::ClientBase::runInteractive() @ 0x165a2201 in /usr/bin/clickhouse
11. DB::Client::main(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&) @ 0xb468108 in /usr/bin/clickhouse
12. Poco::Util::Application::run() @ 0x19ba2446 in /usr/bin/clickhouse
13. mainEntryClickHouseClient(int, char**) @ 0xb475a01 in /usr/bin/clickhouse
14. main @ 0xb36e90a in /usr/bin/clickhouse
15. __libc_start_main @ 0x202e1 in /lib/x86_64-linux-gnu/libc-2.24.so
16. _start @ 0xb1592ae in /usr/bin/clickhouse
На стороне Оракла проблем не вижу - запрос отдается сразу практически. Даже не знаю куда копать.
clickhouse-client какой версии? тоже 22.7 ? нечто похожее тут https://github.com/ClickHouse/ClickHouse/issues/13565 но человек закрыл issue попробуйте до 22.8 обновиться
спасибо, клиент младше - ClickHouse client version 22.3.10.22 (official build). Попробую обновить..
Обсуждают сегодня