我在本地系统中创建了一个表:create table default.test\u distributed(int8)engine=distributed(logs,default,test\u remote)
并在ip为10.121.21.33的远程系统中创建了一个表:create table test\u remote(a int8)engine=log
然后我在本地系统中插入数据:insert into test\ u distributed values(1011)
然后我启动了select查询:selectfrom test\u distributed
并获得以下异常:2017.05.02 18:49:36.155606[14]connectionpoolwithfailover:尝试时连接失败№1,原因:code:210,e.displaytext()=db::netexception:连接被拒绝:(10.121.21.33:9000),e.what()=db::netexception 2017.05.02 18:49:36.155982[14]connectionpoolwithfailover:尝试时连接失败№2,原因:code:210,e.displaytext()=db::netexception:连接被拒绝:(10.121.21.33:9000),e.what()=db::netexception 2017.05.02 18:49:36.156316[14]connectionpoolwithfailover:尝试时连接失败№3,原因:code:210,e.displaytext()=db::netexception:连接被拒绝:(10.121.21.33:9000),e.what()=db::netexception 2017.05.02 18:49:36.162780[4]执行:code:279,e.displaytext()=db::netexception:所有连接尝试均失败。日志:
代码:210,e.displaytext()=db::netexception:拒绝连接:(10.121.21.33:9000),e.what()=db::netexception代码:210,e.displaytext()=db::netexception:拒绝连接:(10.121.21.33:9000),e.what()=db::netexception代码:210,e.displaytext()=db::netexception:拒绝连接:(10.121.21.33:9000),e.what()=db::netexception
,e.what()=db::netexception(来自127.0.0.1:33590)(在query:selectfrom test\u distributed中),堆栈跟踪:
clickhouse服务器(stacktrace::stacktrace()+0x16)[0x17c6e76]
clickhouse服务器(db::exception::exception(std::string const&,int)+0x1f)[0xfdd9ff]
clickhouse server(poolwithfailoverbase::getmany(db::settings const*,poolmode)+0x773)[0x17615f3]
clickhouse server(db::connectionpoolwithfailover::dogetmany(db::settings const*,poolmode)+0x33)[0x17617f3]
clickhouse服务器(db::multiplexedconnections::initfromshard(db::iconnectionpool*)+0x26d)[0x19afcad]
clickhouse server(db::multiplexedconnections::multiplexedconnections(db::iconnectionpool*,db::settings const*,std::shared\u ptr,bool,poolmode)+0x138)[0x19b0a38]
clickhouse服务器(db::remoteblockinputstream::createmultiplexedconnections()+0x3fb)[0x1665e8b]
clickhouse服务器(db::remoteblockinputstream::readprefix()+0x23)[0x166b043]
clickhouse服务器(db::asynchronousblockinputstream::calculate(memorytracker*)+0x60)[0xfe8ea0]
clickhouse服务器(threadpool::worker()+0x141)[0x17d2d91]
clickhouse-server()[0x33d4faf]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x8182)[0x7f8fe38aa182]
/lib/x86_64-linux-gnu/libc.so.6(克隆+0x6d)[0x7f8fe2ec530d]
1条答案
按热度按时间hc8w905p1#
检查本地系统的设置
并检查以下文件/etc/clickhouse server/config.xml for remote\u servers部分
看到了吗https://clickhouse.yandex/reference_en.html#distributed 远程服务器示例配置