phxsql
phxsql copied to clipboard
get last send gtid failed, svrid [...] ret -1
三节点部署环境 按照wiki文档部署完成后,查询之类都ok,可以使用 在执行一个LOAD DATA LOCAL INFILE 后,显示连接断开 文件约1G 之后通过python tools/restart.py -p mysql来一个个重启,发现报错如下:
tail -100f /app/data/percona.workspace/log.err 2017-06-28 18:12:06 17222 [Note] get last send gtid failed, svrid [fc97c79f-5a40-11e7-a4b8-005056b331c7] ret -1 2017-06-28 18:12:06 17222 [Note] get last send gtid failed, svrid [fc97c79f-5a40-11e7-a4b8-005056b331c7] ret -1 ..以下重复
tail -100f /app/data/log/phxsqlproxy.ERROR E0628 18:19:19.042315 14701 phx_glog.cpp:78] UpdateMasterStatus:103 GetMaster success but (192.168.2.152:1498640038) expired E0628 18:19:19.042389 14701 phx_glog.cpp:78] UpdateMasterStatus ret -104 ...以下重复
tail -100f /app/data/log/phxbinlogsvr.ERROR E0628 18:22:16.000216 14739 phx_glog.cpp:78] Process check master init fail -2600 E0628 18:22:16.000334 14739 phx_glog.cpp:78] ERR: mysql_real_connect fail, Can't connect to MySQL server on '192.168.2.151' (111) E0628 18:22:16.000375 14739 phx_glog.cpp:78] CheckAdminUser new user root not exist in mysql, wait E0628 18:22:16.000471 14739 phx_glog.cpp:78] ERR: mysql_real_connect fail, Can't connect to MySQL server on '192.168.2.151' (111) E0628 18:22:16.000509 14739 phx_glog.cpp:78] CheckReplicaUser new user replica not exist in mysql, wait
执行mysql登录显示: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0
请问是哪个方面的问题?提供下排查思路? 谢谢.
跟 #120 看起来是同一个问题
请问这个问题解决了么,我用的0.8.5,貌似问题还是在啊,MySQL进程启动了,但是端口没有监听,客户端连不上。日志报错如下 get last send gtid failed, svrid [f27d12c5-a704-11ea-a94b-0800276f2b18] ret -1