Clickhouse: remote(...) to older server = Not found column comment_expression in block

[filimonov]

Trying to connect from 18.16.1 to 1.1.54362 via remote table function, getting:

Received exception from server (version 18.16.1):
Code: 10. DB::Exception: Received from localhost:9000, ::1. DB::Exception: Not found column comment_expression in block. There are only columns: name, type, default_type, default_expression. 

[mcarbonneaux]

i've the same when try to connect to 18.14.19 from 19.1.6...

Received exception from server (version 19.1.6):
Code: 10. DB::Exception: Received from localhost:9000, 127.0.0.1. DB::Exception: Not found column comment_expression in block. There are only columns: name, type, default_type, default_expression.

i try to copy data from old cluster to new cluster...
i've tryed to do insert from select remote() on the new cluster...

how to do that ?

[filimonov]

Full stacktrace:

Received exception from server (version 19.3.3):
Code: 10. DB::Exception: Received from localhost:9000, ::1. DB::Exception: Not found column comment_expression in block. There are only columns: name, type, default_type, default_expression. Stack trace:

0. clickhouse-server(StackTrace::StackTrace()+0x16) [0x5d95ad6]
1. clickhouse-server(DB::Exception::Exception(std::string const&, int)+0x1f) [0x2ce88af]
2. clickhouse-server(DB::Block::getByName(std::string const&) const+0x9a) [0x4a6526a]
3. clickhouse-server(DB::RemoteBlockInputStream::readImpl()+0x4a3) [0x4aa6cd3]
4. clickhouse-server(DB::IBlockInputStream::read()+0x1f5) [0x4a93c25]
5. clickhouse-server(DB::getStructureOfRemoteTable(DB::Cluster const&, std::string const&, std::string const&, DB::Context const&, std::shared_ptr<DB::IAST> const&)+0xa03) [0x4e0ce63]
6. clickhouse-server(DB::TableFunctionRemote::executeImpl(std::shared_ptr<DB::IAST> const&, DB::Context const&) const+0x676) [0x2e388a6]
7. clickhouse-server(DB::ITableFunction::execute(std::shared_ptr<DB::IAST> const&, DB::Context const&) const+0x3b) [0x4fa36fb]
8. clickhouse-server(DB::Context::executeTableFunction(std::shared_ptr<DB::IAST> const&)+0x3e6) [0x4b666e6]
9. clickhouse-server(DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, DB::Context const&, std::shared_ptr<DB::IBlockInputStream> const&, std::shared_ptr<DB::IStorage> const&, std::vector<std::string, std::allocator<std::string> > const&, DB::QueryProcessingStage::Enum, unsigned long, bool)+0xbfb) [0x4bb760b]
10. clickhouse-server(DB::InterpreterSelectQuery::InterpreterSelectQuery(std::shared_ptr<DB::IAST> const&, DB::Context const&, std::vector<std::string, std::allocator<std::string> > const&, DB::QueryProcessingStage::Enum, unsigned long, bool)+0x42) [0x4bb7fa2]
11. clickhouse-server(DB::InterpreterSelectWithUnionQuery::InterpreterSelectWithUnionQuery(std::shared_ptr<DB::IAST> const&, DB::Context const&, std::vector<std::string, std::allocator<std::string> > const&, DB::QueryProcessingStage::Enum, unsigned long, bool)+0x70f) [0x4bc377f]
12. clickhouse-server(DB::InterpreterFactory::get(std::shared_ptr<DB::IAST>&, DB::Context&, DB::QueryProcessingStage::Enum)+0x1f4) [0x4b9fcd4]
13. clickhouse-server() [0x4cdaa13]
14. clickhouse-server(DB::executeQuery(std::string const&, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool)+0x61) [0x4cdc921]
15. clickhouse-server(DB::TCPHandler::runImpl()+0x45e) [0x2cf4a9e]
16. clickhouse-server(DB::TCPHandler::run()+0x1c) [0x2cf5d8c]
17. clickhouse-server(Poco::Net::TCPServerConnection::start()+0xf) [0x5f8871f]
18. clickhouse-server(Poco::Net::TCPServerDispatcher::run()+0x110) [0x5f88d80]
19. clickhouse-server(Poco::PooledThread::run()+0x77) [0x60704e7]
20. clickhouse-server(Poco::ThreadImpl::runnableEntry(void*)+0x38) [0x606da48]
21. clickhouse-server() [0x65c272f]
22. /lib64/libpthread.so.0(+0x7e25) [0x7f1b1b18be25]
23. /lib64/libc.so.6(clone+0x6d) [0x7f1b1a9af34d]

[perez1987]

+1

[alexey-milovidov]

The fix will be in the next release.