Skip to content

Instantly share code, notes, and snippets.

@levonet
Created September 23, 2019 13:01
Show Gist options
  • Save levonet/52209e70921d9d37484f3a5c89b96248 to your computer and use it in GitHub Desktop.
Save levonet/52209e70921d9d37484f3a5c89b96248 to your computer and use it in GitHub Desktop.
Stack trace: Cannot read from istream at offset 0
2019.09.23 12:20:07.897003 [ 91 ] {0e740a52-711e-4f5e-80dc-7c24ec560e53} <Error> executeQuery: Code: 23, e.displayText() = DB::Exception: Cannot read from istream at offset 0 (version 19.14.6.12 (official build)) (from 35.187.69.68:39726) (in query: insert into access_log_lb2a (`date`,`status`,`remote_addr_ip4`,`scheme`,`host`,`request_method`,`uri`,`args`,`server_protocol`,`platform`,`bytes_sent`,`body_bytes_sent`,`msec`,`request_time`,`tcpinfo_rtt`,`arg_utm_source`,`arg_utm_medium`,`arg_utm_campaign`,`arg_utm_term`,`arg_utm_content`,`arg_matchtype`,`arg_adsource`,`arg_admedium`,`arg_adcampaign`,`arg_adterm`,`arg_adcontent`,`arg_admatchtype`,`arg_yclid`,`arg_gclid`,`arg__ga`,`arg_fbclid`,`arg_sub_id`,`arg_from_id`,`arg_to_id`,`arg_on`,`arg_passengers`,`arg_preorder_id`,`arg_order_id`,`arg_payment_id`,`arg_locale`,`arg_query`,`arg_error`,`http_referer`,`http_user_agent`,`http_accept_encoding`,`http_accept_language`,`http_x_real_ip4`,`proxy_add_x_forwarded_for4`,`cookie__ga`,`cookie__gid`,`cookie__ym_uid`,`cookie_locale`,`cookie_ab_tests_json`,`cookie_prev_order`,`cookie_ahoy_visitor`,`pid`) values ), Stack trace:
0. 0x55f36137d160 StackTrace::StackTrace() /usr/bin/clickhouse
1. 0x55f36137cf35 DB::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, int) /usr/bin/clickhouse
2. 0x55f3612464ab ? /usr/bin/clickhouse
3. 0x55f361400992 DB::ConcatReadBuffer::nextImpl() /usr/bin/clickhouse
4. 0x55f361400992 DB::ConcatReadBuffer::nextImpl() /usr/bin/clickhouse
5. 0x55f3613acdf5 void DB::readQuotedStringInto<true, DB::PODArray<unsigned char, 4096ul, Allocator<false, false>, 15ul, 16ul> >(DB::PODArray<unsigned char, 4096ul, Allocator<false, false>, 15ul, 16ul>&, DB::ReadBuffer&) /usr/bin/clickhouse
6. 0x55f364565877 DB::DataTypeString::deserializeTextQuoted(DB::IColumn&, DB::ReadBuffer&, DB::FormatSettings const&) const /usr/bin/clickhouse
7. 0x55f364ad2797 DB::ValuesRowInputFormat::readRow(std::vector<COW<DB::IColumn>::mutable_ptr<DB::IColumn>, std::allocator<COW<DB::IColumn>::mutable_ptr<DB::IColumn> > >&, DB::RowReadExtension&) /usr/bin/clickhouse
8. 0x55f364e6db1d DB::IRowInputFormat::generate() /usr/bin/clickhouse
9. 0x55f364a44e8e DB::ISource::work() /usr/bin/clickhouse
10. 0x55f364a20305 DB::InputStreamFromInputFormat::readImpl() /usr/bin/clickhouse
11. 0x55f3644b6537 DB::IBlockInputStream::read() /usr/bin/clickhouse
12. 0x55f364747bb8 DB::InputStreamFromASTInsertQuery::readImpl() /usr/bin/clickhouse
13. 0x55f3644b6537 DB::IBlockInputStream::read() /usr/bin/clickhouse
14. 0x55f3644d2f8b DB::copyData(DB::IBlockInputStream&, DB::IBlockOutputStream&, std::atomic<bool>*) /usr/bin/clickhouse
15. 0x55f364746bff DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, DB::Context&, std::function<void (std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)>, std::function<void (std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)>) /usr/bin/clickhouse
16. 0x55f3613fde1e DB::HTTPHandler::processQuery(Poco::Net::HTTPServerRequest&, HTMLForm&, Poco::Net::HTTPServerResponse&, DB::HTTPHandler::Output&) /usr/bin/clickhouse
17. 0x55f3614001c9 DB::HTTPHandler::handleRequest(Poco::Net::HTTPServerRequest&, Poco::Net::HTTPServerResponse&) /usr/bin/clickhouse
18. 0x55f365268da9 Poco::Net::HTTPServerConnection::run() /usr/bin/clickhouse
19. 0x55f365263b80 Poco::Net::TCPServerConnection::start() /usr/bin/clickhouse
20. 0x55f36526429d Poco::Net::TCPServerDispatcher::run() /usr/bin/clickhouse
21. 0x55f3668b2b31 Poco::PooledThread::run() /usr/bin/clickhouse
22. 0x55f3668b08dc Poco::ThreadImpl::runnableEntry(void*) /usr/bin/clickhouse
23. 0x55f367026120 ? /usr/bin/clickhouse
24. 0x7f5b741166db start_thread /lib/x86_64-linux-gnu/libpthread-2.27.so
25. 0x7f5b73a3388f clone /lib/x86_64-linux-gnu/libc-2.27.so
2019.09.23 12:20:07.897718 [ 91 ] {0e740a52-711e-4f5e-80dc-7c24ec560e53} <Error> HTTPHandler: Code: 23, e.displayText() = DB::Exception: Cannot read from istream at offset 0, Stack trace:
0. 0x55f36137d160 StackTrace::StackTrace() /usr/bin/clickhouse
1. 0x55f36137cf35 DB::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, int) /usr/bin/clickhouse
2. 0x55f3612464ab ? /usr/bin/clickhouse
3. 0x55f361400992 DB::ConcatReadBuffer::nextImpl() /usr/bin/clickhouse
4. 0x55f361400992 DB::ConcatReadBuffer::nextImpl() /usr/bin/clickhouse
5. 0x55f3613acdf5 void DB::readQuotedStringInto<true, DB::PODArray<unsigned char, 4096ul, Allocator<false, false>, 15ul, 16ul> >(DB::PODArray<unsigned char, 4096ul, Allocator<false, false>, 15ul, 16ul>&, DB::ReadBuffer&) /usr/bin/clickhouse
6. 0x55f364565877 DB::DataTypeString::deserializeTextQuoted(DB::IColumn&, DB::ReadBuffer&, DB::FormatSettings const&) const /usr/bin/clickhouse
7. 0x55f364ad2797 DB::ValuesRowInputFormat::readRow(std::vector<COW<DB::IColumn>::mutable_ptr<DB::IColumn>, std::allocator<COW<DB::IColumn>::mutable_ptr<DB::IColumn> > >&, DB::RowReadExtension&) /usr/bin/clickhouse
8. 0x55f364e6db1d DB::IRowInputFormat::generate() /usr/bin/clickhouse
9. 0x55f364a44e8e DB::ISource::work() /usr/bin/clickhouse
10. 0x55f364a20305 DB::InputStreamFromInputFormat::readImpl() /usr/bin/clickhouse
11. 0x55f3644b6537 DB::IBlockInputStream::read() /usr/bin/clickhouse
12. 0x55f364747bb8 DB::InputStreamFromASTInsertQuery::readImpl() /usr/bin/clickhouse
13. 0x55f3644b6537 DB::IBlockInputStream::read() /usr/bin/clickhouse
14. 0x55f3644d2f8b DB::copyData(DB::IBlockInputStream&, DB::IBlockOutputStream&, std::atomic<bool>*) /usr/bin/clickhouse
15. 0x55f364746bff DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, DB::Context&, std::function<void (std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)>, std::function<void (std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&)>) /usr/bin/clickhouse
16. 0x55f3613fde1e DB::HTTPHandler::processQuery(Poco::Net::HTTPServerRequest&, HTMLForm&, Poco::Net::HTTPServerResponse&, DB::HTTPHandler::Output&) /usr/bin/clickhouse
17. 0x55f3614001c9 DB::HTTPHandler::handleRequest(Poco::Net::HTTPServerRequest&, Poco::Net::HTTPServerResponse&) /usr/bin/clickhouse
18. 0x55f365268da9 Poco::Net::HTTPServerConnection::run() /usr/bin/clickhouse
19. 0x55f365263b80 Poco::Net::TCPServerConnection::start() /usr/bin/clickhouse
20. 0x55f36526429d Poco::Net::TCPServerDispatcher::run() /usr/bin/clickhouse
21. 0x55f3668b2b31 Poco::PooledThread::run() /usr/bin/clickhouse
22. 0x55f3668b08dc Poco::ThreadImpl::runnableEntry(void*) /usr/bin/clickhouse
23. 0x55f367026120 ? /usr/bin/clickhouse
24. 0x7f5b741166db start_thread /lib/x86_64-linux-gnu/libpthread-2.27.so
25. 0x7f5b73a3388f clone /lib/x86_64-linux-gnu/libc-2.27.so
(version 19.14.6.12 (official build))
2019.09.23 12:20:07.898252 [ 91 ] {0e740a52-711e-4f5e-80dc-7c24ec560e53} <Error> HTTPHandler: Cannot send exception to client: Code: 24, e.displayText() = DB::Exception: Cannot write to ostream at offset 236, Stack trace:
0. 0x55f36137d160 StackTrace::StackTrace() /usr/bin/clickhouse
1. 0x55f36137cf35 DB::Exception::Exception(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, int) /usr/bin/clickhouse
2. 0x55f36124773f ? /usr/bin/clickhouse
3. 0x55f365097889 DB::WriteBufferFromHTTPServerResponse::nextImpl() /usr/bin/clickhouse
4. 0x55f3613fb7f6 DB::HTTPHandler::trySendExceptionToClient(std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> > const&, int, Poco::Net::HTTPServerRequest&, Poco::Net::HTTPServerResponse&, DB::HTTPHandler::Output&) /usr/bin/clickhouse
5. 0x55f360f441ba ? /usr/bin/clickhouse
6. 0x55f365268da9 Poco::Net::HTTPServerConnection::run() /usr/bin/clickhouse
7. 0x55f365263b80 Poco::Net::TCPServerConnection::start() /usr/bin/clickhouse
8. 0x55f36526429d Poco::Net::TCPServerDispatcher::run() /usr/bin/clickhouse
9. 0x55f3668b2b31 Poco::PooledThread::run() /usr/bin/clickhouse
10. 0x55f3668b08dc Poco::ThreadImpl::runnableEntry(void*) /usr/bin/clickhouse
11. 0x55f367026120 ? /usr/bin/clickhouse
12. 0x7f5b741166db start_thread /lib/x86_64-linux-gnu/libpthread-2.27.so
13. 0x7f5b73a3388f clone /lib/x86_64-linux-gnu/libc-2.27.so
(version 19.14.6.12 (official build))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment