ERROR 1735 (HY000): Leaf Error (10.130.81.139:3307): Unable to connect to leaf @10.130.81.138:3307 w

转载 2016年08月30日 18:42:43

1.确认是否是防火墙的问题,用telnet可测试各个节点之间是否连通,或者用memql-ops memsql-update-config --all --key max_pooled_connections --value 2048 命令修改所有节点的连接池大小,如果修改成功,则代表防火墙没问题

2.如果防火墙没问题,就可能是各个节点的连接池大小的问题


此问题是在国外网站找到解决方案,英语水平有限,大致意思就是上面两点,原文地址:https://knowledgebase.memsql.com/hc/en-us/articles/212165403-Query-Error-Unable-to-connect-Timed-out-reading-from-socket

Query Error: Unable to connect ... Timed out reading from socket

ISSUE

Running a query fails with an error like:

Error 1735: Unable to connect to leaf @1.2.3.4:3306 with user root, using password NO: [2005] Timed out reading from socket after 30 seconds

CAUSE

A MemSQL node is unable to connect to another MemSQL node. This may be because there is no network connectivity (such as a network problem or a firewall blocking connectivity), or because a node is overloaded with connection requests.

RESOLUTION

  • Ensure that all nodes are able to connect to all other nodes on the configured port (default 3306). Make sure there is no firewall blocking connectivity.
    • One way to verify connectivity is to run the MemSQL command FILL CONNECTION POOLS on all MemSQL nodes. If this fails with the same error, then a node is unable to connect to another node.
    • Note that some queries require different amounts of connectivity, e.g. some queries only require aggregator-leaf connections while others require aggregator-leaf as well as leaf-leaf connections. As a result, it is possible for some queries to succeed while others fail with this error.
  • If all nodes are able to connect to all other nodes, the error is likely because your query or queries require opening too many connections at once. Run FILL CONNECTION POOLS on all MemSQL nodes to pre-fill connection pools. If the connection pool size is too small for your workload, adjust the max_pooled_connections configuration variable, which controls the number of pooled connections between each pair of nodes.

举报

相关文章推荐

连接mysql报错:error 2003 (hy000):can't connect to mysql server on 'localhost' (10061)

一、mysql 的bin目录下有个MySQLInstanceConfig.exe,运行就可以进行创建数据库实例,创建实例时也可以生成windows 服务,把服务设置成自动启动就可以了 二、安装在D盘...

总结mysql ERROR 2002 (HY000):Can't connect to..

 总结mysql ERROR 2002 (HY000):Can't connect to.. 今天服务器遇到了一个很熟悉的问题 输入 #mysql -u root -p...

精选:深入理解 Docker 内部原理及网络配置

网络绝对是任何系统的核心,对于容器而言也是如此。Docker 作为目前最火的轻量级容器技术,有很多令人称道的功能,如 Docker 的镜像管理。然而,Docker的网络一直以来都比较薄弱,所以我们有必要深入了解Docker的网络知识,以满足更高的网络需求。

MySQL远程连接ERROR 2003 (HY000):Can't connect to MySQL server on'XXXXX'的问题

地址:http://www.2cto.com/database/201204/127400.html 问题描述:   从一台linux远程连接另一台linux上的MySQL, 出现ERROR...

mysql 解决 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

在使用mysql 时  有时会登录遇到错误  ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) 以下...
  • asjdhs
  • asjdhs
  • 2015-05-31 15:29
  • 1532

mysql 常见问题:ERROR 2003 (HY000) Can't connect to MySQL server on 'localhost' (10061)

有时候莫名其妙的就出现那种错误了T_T,我还要练习SQL呢,而且我已经因为它重新装过一次mysql了,讨厌的10061. 在电脑--管理--服务里查看居然没有mysql 服务。 于是以管理员身份进入命...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket

在安装好了MySQL之后,使用了新的配置文件后,MySQL服务器可以成功启动,但在登陆的时候出现了ERROR 2002 (HY000): Can't connect to local MySQL se...

ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.165' (113)

ERROR 2003 (HY000): Can't connect to MySQL server问题 解决办法总结: 1、确定远程机器的防火墙关闭,或在防火墙允许3306端口号 2、确定数据库允许远...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock

问题描述今天阿里云服务器安装mysql的收,遇到了一个很熟悉的问题 输入#mysql -u root -p ERROR 2002 (HY000): Can't connect to local My...

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (

1、先查看 /etc/rc.d/init.d/mysqld status 看看mysql是否已经启动. 另外看看是不是权限问题. 2、确定你的mysql.sock是不是在那个位置, mysql -u...

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

使用的是redhat 6.4 x64系统 #mysql -u root -p ERROR 2002 (HY000):Can't connect to local MySQL server   ...
返回顶部
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

(最多只允许输入30个字)