clickhouse-odbc icon indicating copy to clipboard operation
clickhouse-odbc copied to clipboard

Published 20 hours ago • verified publisher icon ClickHouse

MacOS | Tableau error for string columns | Communication with the Tableau Protocol Server process was lost

Open vishjosh opened this issue 6 years ago • 18 comments

Screenshot 2019-03-08 at 7 30 15 PM (1)

Built the current master for the CH odbc driver for MacOS successfully and connecting to CH server. (one month old build maybe)

Tableau is able to fetch the tables. We can fetch all the numeric (int/float and datetime) columns with no problems. However, when we trying to fetch a string column we see the above attached error.

Not sure if anybody has seen this error before.

vishjosh avatar Mar 08 '19 23:03 vishjosh

Could you provide more details on what's the error Tableau suggests to copy on screenshot, which ClickHouse server release is used, how exactly you have built the driver?

blinkov avatar Mar 11 '19 06:03 blinkov

What version of driver are you using (ascii or unicode)? It seems to be an issue with non-ASCII data when using non-unicode ODBC driver. We were able to fetch data from unicode string columns with ascii driver though, but it's obviously corrupted. And sometimes error like your's appears.

greenwolf-nsk avatar Mar 11 '19 11:03 greenwolf-nsk

@blinkov The error on Tableau : Unable to complete action Communication with the Tableau Protocol Server process was lost. Error Code: A7AEA709

  • I am using ClickHouse server version 19.3.6.

  • I have built the driver using both unixodbc and libiodbc libraries. I get the same errors.

  • We have used windows driver against the same ClickHouse server. It runs perfectly fine on that

jojjen avatar Mar 12 '19 15:03 jojjen

@greenwolf-nsk I am using the ASCII one. I could not connect with the unicode one. Were you able to connect with the Unicode one?

jojjen avatar Mar 12 '19 15:03 jojjen

Could you provide more details on what's the error Tableau suggests to copy on screenshot, which ClickHouse server release is used, how exactly you have built the driver?

@blinkov jojjen above has given the information

vishjosh avatar Mar 22 '19 21:03 vishjosh

@blinkov @greenwolf-nsk - any idea or pointers?

vishjosh avatar Apr 30 '19 08:04 vishjosh

Can you reproduce this with latest release https://github.com/yandex/clickhouse-odbc/releases/tag/v1.0.0.20190409 ?

blinkov avatar Apr 30 '19 09:04 blinkov

Can you reproduce this with latest release https://github.com/yandex/clickhouse-odbc/releases/tag/v1.0.0.20190409 ?

Ok, we will try and let you know . @jojjen

vishjosh avatar May 01 '19 09:05 vishjosh

I had the same issue with v1.0.0.20190409 release on a mac.

  • Tableau Desktop
  • ANSI driver (the 'w' one wouldn't work)
  • same error code when German letters are present.

The new release (20190523) works with the mac, using the "w" driver. Thanks a lot!

apisarenco avatar May 24 '19 13:05 apisarenco

@vishjosh any news?

blinkov avatar Jun 17 '19 10:06 blinkov

If this is still relevant, please try the latest release (v1.1.1.20191108). Specific fixes were applied there, and the chances are they address this issue.

traceon avatar Nov 13 '19 08:11 traceon

I have encountered this error when loading a decently-large amount of data ~100+ MB, ~300,000 rows.

If I reduce the amount of data, the error no longer occurs. Of course, then I don't have my data.

In my case, this data is sourced from a regular database, NOT a google sheet (I see that there are results online referring to this being related to sourcing data from Google Sheets).

alexgw-afr avatar Nov 27 '19 00:11 alexgw-afr

I also encountered this error when trying to load a fairly large table (~300M rows) into Tableau.

hellais avatar Jun 04 '20 11:06 hellais

Is it reproducible with increased timeout? See odbc driver config docs.

traceon avatar Jun 04 '20 14:06 traceon

Is it reproducible with increased timeout? See odbc driver config docs.

I attempted to set the Timeout value to 3000, but I still get the same error code and message:

Unable to complete action
The filtering operation did not complete successfully because of an unexpected error.
Error Code: A7AEA709
Communication with the Tableau Protocol Server process was lost.

The error is triggered just 4 seconds after I drag one of the columns into the filter section of a sheet (which I believe should be doing a unique count on the column).

hellais avatar Jun 05 '20 12:06 hellais

Could it be that the ClickHouse server terminates the query execution due to memory exhaustion? What are log messages for that query?

traceon avatar Jun 05 '20 14:06 traceon

Getting a same error on Tableau, while looking at Clickhouse logs, get this in error message:

2021.05.21 15:05:46.225153 [ 3384 ] {} <Trace> HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: 192.168.50.36:58749, User-Agent: clickhouse-odbc/1.1.9.20201226 (Darwin-19.6.0), Content Type: , Transfer Encoding: chunked, X-Forwarded-For: (none) 2021.05.21 15:05:46.225327 [ 3384 ] {} <Trace> DynamicQueryHandler: Request URI: /query?default_format=ODBCDriver2&database=lte 2021.05.21 15:05:46.225426 [ 64413 ] {b799addd-0850-4559-8295-506d7fc453eb} <Error> executeQuery: Code: 24, e.displayText() = DB::Exception: Cannot write to ostream at offset 118750: While executing ODBCDriver2BlockOutputFormat (version 21.4.4.30 (official build)) (from 192.168.50.36:58747) (in query: SELECT * FROM ENRICHED_CPER_NG), Stack trace (when copying this message, always include the lines below):

  1. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, int, bool) @ 0x8914f0a in /usr/bin/clickhouse
  2. DB::WriteBufferFromOStream::nextImpl() @ 0x8a10282 in /usr/bin/clickhouse
  3. DB::WriteBufferFromHTTPServerResponse::nextImpl() @ 0x1017db80 in /usr/bin/clickhouse
  4. DB::IOutputFormat::flush() @ 0x101e0fb3 in /usr/bin/clickhouse
  5. DB::IOutputFormat::work() @ 0x101e0f0a in /usr/bin/clickhouse
  6. ? @ 0x101d4c7d in /usr/bin/clickhouse
  7. DB::PipelineExecutor::executeStepImpl(unsigned long, unsigned long, std::__1::atomic*) @ 0x101d1931 in /usr/bin/clickhouse
  8. DB::PipelineExecutor::executeImpl(unsigned long) @ 0x101cf8a6 in /usr/bin/clickhouse
  9. DB::PipelineExecutor::execute(unsigned long) @ 0x101cf5fd in /usr/bin/clickhouse
  10. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, DB::Context&, std::__1::function<void (std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&)>) @ 0xf9a9196 in /usr/bin/clickhouse
  11. DB::HTTPHandler::processQuery(DB::Context&, DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::__1::optionalDB::CurrentThread::QueryScope&) @ 0x100eccd2 in /usr/bin/clickhouse
  12. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x100f033d in /usr/bin/clickhouse
  13. DB::HTTPServerConnection::run() @ 0x101769df in /usr/bin/clickhouse
  14. Poco::Net::TCPServerConnection::start() @ 0x1282790f in /usr/bin/clickhouse
  15. Poco::Net::TCPServerDispatcher::run() @ 0x12829321 in /usr/bin/clickhouse
  16. Poco::PooledThread::run() @ 0x1295fa49 in /usr/bin/clickhouse
  17. Poco::ThreadImpl::runnableEntry(void*) @ 0x1295b8aa in /usr/bin/clickhouse
  18. start_thread @ 0x7ea5 in /usr/lib64/libpthread-2.17.so
  19. __clone @ 0xfe96d in /usr/lib64/libc-2.17.so

2021.05.21 15:05:46.226261 [ 64413 ] {b799addd-0850-4559-8295-506d7fc453eb} <Error> DynamicQueryHandler: Code: 24, e.displayText() = DB::Exception: Cannot write to ostream at offset 118750: While executing ODBCDriver2BlockOutputFormat, Stack trace (when copying this message, always include the lines below):

  1. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, int, bool) @ 0x8914f0a in /usr/bin/clickhouse

  2. DB::WriteBufferFromOStream::nextImpl() @ 0x8a10282 in /usr/bin/clickhouse

  3. DB::WriteBufferFromHTTPServerResponse::nextImpl() @ 0x1017db80 in /usr/bin/clickhouse

  4. DB::IOutputFormat::flush() @ 0x101e0fb3 in /usr/bin/clickhouse

  5. DB::IOutputFormat::work() @ 0x101e0f0a in /usr/bin/clickhouse

  6. ? @ 0x101d4c7d in /usr/bin/clickhouse

  7. DB::PipelineExecutor::executeStepImpl(unsigned long, unsigned long, std::__1::atomic*) @ 0x101d1931 in /usr/bin/clickhouse

  8. DB::PipelineExecutor::executeImpl(unsigned long) @ 0x101cf8a6 in /usr/bin/clickhouse

  9. DB::PipelineExecutor::execute(unsigned long) @ 0x101cf5fd in /usr/bin/clickhouse

  10. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, DB::Context&, std::__1::function<void (std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&)>) @ 0xf9a9196 in /usr/bin/clickhouse

  11. DB::HTTPHandler::processQuery(DB::Context&, DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::__1::optionalDB::CurrentThread::QueryScope&) @ 0x100eccd2 in /usr/bin/clickhouse

  12. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x100f033d in /usr/bin/clickhouse

  13. DB::HTTPServerConnection::run() @ 0x101769df in /usr/bin/clickhouse

  14. Poco::Net::TCPServerConnection::start() @ 0x1282790f in /usr/bin/clickhouse

  15. Poco::Net::TCPServerDispatcher::run() @ 0x12829321 in /usr/bin/clickhouse

  16. Poco::PooledThread::run() @ 0x1295fa49 in /usr/bin/clickhouse

  17. Poco::ThreadImpl::runnableEntry(void*) @ 0x1295b8aa in /usr/bin/clickhouse

  18. start_thread @ 0x7ea5 in /usr/lib64/libpthread-2.17.so

  19. __clone @ 0xfe96d in /usr/lib64/libc-2.17.so (version 21.4.4.30 (official build)) 2021.05.21 15:05:46.226622 [ 64413 ] {b799addd-0850-4559-8295-506d7fc453eb} <Error> DynamicQueryHandler: Cannot send exception to client: Code: 24, e.displayText() = DB::Exception: Cannot write to ostream at offset 59709, Stack trace (when copying this message, always include the lines below):

  20. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, int, bool) @ 0x8914f0a in /usr/bin/clickhouse

  21. DB::WriteBufferFromOStream::nextImpl() @ 0x8a10282 in /usr/bin/clickhouse

  22. DB::WriteBufferFromHTTPServerResponse::nextImpl() @ 0x1017db80 in /usr/bin/clickhouse

  23. DB::HTTPHandler::trySendExceptionToClient(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, int, DB::HTTPServerRequest&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&) @ 0x100efab8 in /usr/bin/clickhouse

  24. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x100f0b38 in /usr/bin/clickhouse

  25. DB::HTTPServerConnection::run() @ 0x101769df in /usr/bin/clickhouse

  26. Poco::Net::TCPServerConnection::start() @ 0x1282790f in /usr/bin/clickhouse

  27. Poco::Net::TCPServerDispatcher::run() @ 0x12829321 in /usr/bin/clickhouse

  28. Poco::PooledThread::run() @ 0x1295fa49 in /usr/bin/clickhouse

  29. Poco::ThreadImpl::runnableEntry(void*) @ 0x1295b8aa in /usr/bin/clickhouse

  30. start_thread @ 0x7ea5 in /usr/lib64/libpthread-2.17.so

  31. __clone @ 0xfe96d in /usr/lib64/libc-2.17.so (version 21.4.4.30 (official build)) 2021.05.21 15:05:46.226681 [ 64413 ] {b799addd-0850-4559-8295-506d7fc453eb} <Debug> MemoryTracker: Peak memory usage (for query): 0.00 B. 2021.05.21 15:05:46.227326 [ 64413 ] {} <Error> ServerErrorHandler: Poco::Exception. Code: 1000, e.code() = 32, e.displayText() = I/O error: Broken pipe, Stack trace (when copying this message, always include the lines below):

  32. Poco::Net::SocketImpl::error(int, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&) @ 0x128202fd in /usr/bin/clickhouse

  33. Poco::Net::SocketImpl::sendBytes(void const*, int, int) @ 0x128219ea in /usr/bin/clickhouse

  34. Poco::Net::StreamSocketImpl::sendBytes(void const*, int, int) @ 0x12826976 in /usr/bin/clickhouse

  35. Poco::Net::HTTPSession::write(char const*, long) @ 0x127f7b53 in /usr/bin/clickhouse

  36. Poco::Net::HTTPChunkedStreamBuf::writeToDevice(char const*, long) @ 0x127e17e5 in /usr/bin/clickhouse

  37. Poco::BasicBufferedStreamBuf<char, std::__1::char_traits, Poco::Net::HTTPBufferAllocator>::sync() @ 0x127e2759 in /usr/bin/clickhouse

  38. Poco::Net::HTTPChunkedIOS::~HTTPChunkedIOS() @ 0x127e1a3c in /usr/bin/clickhouse

  39. Poco::Net::HTTPChunkedOutputStream::~HTTPChunkedOutputStream() @ 0x127e24be in /usr/bin/clickhouse

  40. DB::HTTPServerConnection::run() @ 0x10176b49 in /usr/bin/clickhouse

  41. Poco::Net::TCPServerConnection::start() @ 0x1282790f in /usr/bin/clickhouse

  42. Poco::Net::TCPServerDispatcher::run() @ 0x12829321 in /usr/bin/clickhouse

  43. Poco::PooledThread::run() @ 0x1295fa49 in /usr/bin/clickhouse

  44. Poco::ThreadImpl::runnableEntry(void*) @ 0x1295b8aa in /usr/bin/clickhouse

  45. start_thread @ 0x7ea5 in /usr/lib64/libpthread-2.17.so

  46. __clone @ 0xfe96d in /usr/lib64/libc-2.17.so (version 21.4.4.30 (official build)) 2021.05.21 15:05:46.353245 [ 33501 ] {} <Trace> SystemLog (system.metric_log): Flushing system log, 8 entries to flush 2021.05.21 15:05:46.364241 [ 33501 ] {} <Debug> DiskLocal: Reserving 1.00 MiB on disk default, having unreserved 108.86 GiB.

mirajgodha avatar May 21 '21 15:05 mirajgodha

Getting a same error on Tableau, while looking at Clickhouse logs, get this in error message:

2021.05.21 15:05:46.225153 [ 3384 ] {} HTTPHandler-factory: HTTP Request for HTTPHandler-factory. Method: POST, Address: 192.168.50.36:58749, User-Agent: clickhouse-odbc/1.1.9.20201226 (Darwin-19.6.0), Content Type: , Transfer Encoding: chunked, X-Forwarded-For: (none) 2021.05.21 15:05:46.225327 [ 3384 ] {} DynamicQueryHandler: Request URI: /query?default_format=ODBCDriver2&database=lte 2021.05.21 15:05:46.225426 [ 64413 ] {b799addd-0850-4559-8295-506d7fc453eb} executeQuery: Code: 24, e.displayText() = DB::Exception: Cannot write to ostream at offset 118750: While executing ODBCDriver2BlockOutputFormat (version 21.4.4.30 (official build)) (from 192.168.50.36:58747) (in query: SELECT * FROM ENRICHED_CPER_NG), Stack trace (when copying this message, always include the lines below):

  1. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, int, bool) @ 0x8914f0a in /usr/bin/clickhouse
  2. DB::WriteBufferFromOStream::nextImpl() @ 0x8a10282 in /usr/bin/clickhouse
  3. DB::WriteBufferFromHTTPServerResponse::nextImpl() @ 0x1017db80 in /usr/bin/clickhouse
  4. DB::IOutputFormat::flush() @ 0x101e0fb3 in /usr/bin/clickhouse
  5. DB::IOutputFormat::work() @ 0x101e0f0a in /usr/bin/clickhouse
  6. ? @ 0x101d4c7d in /usr/bin/clickhouse
  7. DB::PipelineExecutor::executeStepImpl(unsigned long, unsigned long, std::__1::atomic*) @ 0x101d1931 in /usr/bin/clickhouse
  8. DB::PipelineExecutor::executeImpl(unsigned long) @ 0x101cf8a6 in /usr/bin/clickhouse
  9. DB::PipelineExecutor::execute(unsigned long) @ 0x101cf5fd in /usr/bin/clickhouse
  10. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, DB::Context&, std::__1::function<void (std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&)>) @ 0xf9a9196 in /usr/bin/clickhouse
  11. DB::HTTPHandler::processQuery(DB::Context&, DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::__1::optionalDB::CurrentThread::QueryScope&) @ 0x100eccd2 in /usr/bin/clickhouse
  12. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x100f033d in /usr/bin/clickhouse
  13. DB::HTTPServerConnection::run() @ 0x101769df in /usr/bin/clickhouse
  14. Poco::Net::TCPServerConnection::start() @ 0x1282790f in /usr/bin/clickhouse
  15. Poco::Net::TCPServerDispatcher::run() @ 0x12829321 in /usr/bin/clickhouse
  16. Poco::PooledThread::run() @ 0x1295fa49 in /usr/bin/clickhouse
  17. Poco::ThreadImpl::runnableEntry(void*) @ 0x1295b8aa in /usr/bin/clickhouse
  18. start_thread @ 0x7ea5 in /usr/lib64/libpthread-2.17.so
  19. __clone @ 0xfe96d in /usr/lib64/libc-2.17.so

2021.05.21 15:05:46.226261 [ 64413 ] {b799addd-0850-4559-8295-506d7fc453eb} DynamicQueryHandler: Code: 24, e.displayText() = DB::Exception: Cannot write to ostream at offset 118750: While executing ODBCDriver2BlockOutputFormat, Stack trace (when copying this message, always include the lines below):

  1. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, int, bool) @ 0x8914f0a in /usr/bin/clickhouse
  2. DB::WriteBufferFromOStream::nextImpl() @ 0x8a10282 in /usr/bin/clickhouse
  3. DB::WriteBufferFromHTTPServerResponse::nextImpl() @ 0x1017db80 in /usr/bin/clickhouse
  4. DB::IOutputFormat::flush() @ 0x101e0fb3 in /usr/bin/clickhouse
  5. DB::IOutputFormat::work() @ 0x101e0f0a in /usr/bin/clickhouse
  6. ? @ 0x101d4c7d in /usr/bin/clickhouse
  7. DB::PipelineExecutor::executeStepImpl(unsigned long, unsigned long, std::__1::atomic*) @ 0x101d1931 in /usr/bin/clickhouse
  8. DB::PipelineExecutor::executeImpl(unsigned long) @ 0x101cf8a6 in /usr/bin/clickhouse
  9. DB::PipelineExecutor::execute(unsigned long) @ 0x101cf5fd in /usr/bin/clickhouse
  10. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, DB::Context&, std::__1::function<void (std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&)>) @ 0xf9a9196 in /usr/bin/clickhouse
  11. DB::HTTPHandler::processQuery(DB::Context&, DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::__1::optionalDB::CurrentThread::QueryScope&) @ 0x100eccd2 in /usr/bin/clickhouse
  12. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x100f033d in /usr/bin/clickhouse
  13. DB::HTTPServerConnection::run() @ 0x101769df in /usr/bin/clickhouse
  14. Poco::Net::TCPServerConnection::start() @ 0x1282790f in /usr/bin/clickhouse
  15. Poco::Net::TCPServerDispatcher::run() @ 0x12829321 in /usr/bin/clickhouse
  16. Poco::PooledThread::run() @ 0x1295fa49 in /usr/bin/clickhouse
  17. Poco::ThreadImpl::runnableEntry(void*) @ 0x1295b8aa in /usr/bin/clickhouse
  18. start_thread @ 0x7ea5 in /usr/lib64/libpthread-2.17.so
  19. __clone @ 0xfe96d in /usr/lib64/libc-2.17.so (version 21.4.4.30 (official build)) 2021.05.21 15:05:46.226622 [ 64413 ] {b799addd-0850-4559-8295-506d7fc453eb} DynamicQueryHandler: Cannot send exception to client: Code: 24, e.displayText() = DB::Exception: Cannot write to ostream at offset 59709, Stack trace (when copying this message, always include the lines below):
  20. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, int, bool) @ 0x8914f0a in /usr/bin/clickhouse
  21. DB::WriteBufferFromOStream::nextImpl() @ 0x8a10282 in /usr/bin/clickhouse
  22. DB::WriteBufferFromHTTPServerResponse::nextImpl() @ 0x1017db80 in /usr/bin/clickhouse
  23. DB::HTTPHandler::trySendExceptionToClient(std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, int, DB::HTTPServerRequest&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&) @ 0x100efab8 in /usr/bin/clickhouse
  24. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0x100f0b38 in /usr/bin/clickhouse
  25. DB::HTTPServerConnection::run() @ 0x101769df in /usr/bin/clickhouse
  26. Poco::Net::TCPServerConnection::start() @ 0x1282790f in /usr/bin/clickhouse
  27. Poco::Net::TCPServerDispatcher::run() @ 0x12829321 in /usr/bin/clickhouse
  28. Poco::PooledThread::run() @ 0x1295fa49 in /usr/bin/clickhouse
  29. Poco::ThreadImpl::runnableEntry(void*) @ 0x1295b8aa in /usr/bin/clickhouse
  30. start_thread @ 0x7ea5 in /usr/lib64/libpthread-2.17.so
  31. __clone @ 0xfe96d in /usr/lib64/libc-2.17.so (version 21.4.4.30 (official build)) 2021.05.21 15:05:46.226681 [ 64413 ] {b799addd-0850-4559-8295-506d7fc453eb} MemoryTracker: Peak memory usage (for query): 0.00 B. 2021.05.21 15:05:46.227326 [ 64413 ] {} ServerErrorHandler: Poco::Exception. Code: 1000, e.code() = 32, e.displayText() = I/O error: Broken pipe, Stack trace (when copying this message, always include the lines below):
  32. Poco::Net::SocketImpl::error(int, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&) @ 0x128202fd in /usr/bin/clickhouse
  33. Poco::Net::SocketImpl::sendBytes(void const*, int, int) @ 0x128219ea in /usr/bin/clickhouse
  34. Poco::Net::StreamSocketImpl::sendBytes(void const*, int, int) @ 0x12826976 in /usr/bin/clickhouse
  35. Poco::Net::HTTPSession::write(char const*, long) @ 0x127f7b53 in /usr/bin/clickhouse
  36. Poco::Net::HTTPChunkedStreamBuf::writeToDevice(char const*, long) @ 0x127e17e5 in /usr/bin/clickhouse
  37. Poco::BasicBufferedStreamBuf<char, std::__1::char_traits, Poco::Net::HTTPBufferAllocator>::sync() @ 0x127e2759 in /usr/bin/clickhouse
  38. Poco::Net::HTTPChunkedIOS::~HTTPChunkedIOS() @ 0x127e1a3c in /usr/bin/clickhouse
  39. Poco::Net::HTTPChunkedOutputStream::~HTTPChunkedOutputStream() @ 0x127e24be in /usr/bin/clickhouse
  40. DB::HTTPServerConnection::run() @ 0x10176b49 in /usr/bin/clickhouse
  41. Poco::Net::TCPServerConnection::start() @ 0x1282790f in /usr/bin/clickhouse
  42. Poco::Net::TCPServerDispatcher::run() @ 0x12829321 in /usr/bin/clickhouse
  43. Poco::PooledThread::run() @ 0x1295fa49 in /usr/bin/clickhouse
  44. Poco::ThreadImpl::runnableEntry(void*) @ 0x1295b8aa in /usr/bin/clickhouse
  45. start_thread @ 0x7ea5 in /usr/lib64/libpthread-2.17.so
  46. __clone @ 0xfe96d in /usr/lib64/libc-2.17.so (version 21.4.4.30 (official build)) 2021.05.21 15:05:46.353245 [ 33501 ] {} SystemLog (system.metric_log): Flushing system log, 8 entries to flush 2021.05.21 15:05:46.364241 [ 33501 ] {} DiskLocal: Reserving 1.00 MiB on disk default, having unreserved 108.86 GiB.

Hi, @mirajgodha have you found a solution? I got exactly the same error as yours during query clickhouse table by odbc to write to tm1 database, but could not find any clue. Any suggestion would be very appreciated!!!

xu-an avatar Apr 25 '22 13:04 xu-an