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.

相关文章推荐

多个ajax请求的同步异步问题

ajax请求的同步问题

adminLTE 教程

使用前先看一遍文档,妥妥的就会了 adminLTE文档 1、皮肤 引入   在 skin-blue 蓝黑 skin-blue-light 蓝白 skin-yellow 黄黑 sk...

记一次 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock’(2) 排错流程

在linux与unix系统的socket文件是为了建立两个程序之间的连接使用的 , 而在mysql中,当mysql启动成功时,会根据配置文件中设定的路径(如:tmp/mysql.sock),在tmp中...

在启动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)”,情况如图:...

更换mysql数据目录后出现ERROR 2002 (HY000): Can't connect to local MySQL serve

用rpm包安装的MySQL是不会安装/etc/my.cnf文件的, 至于为什么没有这个文件而MySQL却也能正常启动和作用,在点有两个说法, 第一种说法,my.cnf只是MySQL启动时的一个参数...

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

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

连接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...

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
  • 3503

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 1735 (HY000): Leaf Error (10.130.81.139:3307): Unable to connect to leaf @10.130.81.138:3307 w
举报原因:
原因补充:

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