phxsql集群停机后 重启启动phxsql集群 已经设置root的密码无法登陆了

[tihu2016]

[root@linux_server_1 ~]# mysql -uroot -h 192.168.20.60 -P 54321 ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

[tihu2016]

[root@linux_server_1 ~]# mysql -uroot -h 192.168.20.60 -P 54321 -p Enter password: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 [root@linux_server_1 ~]# mysql -uroot -h 192.168.20.60 -P 54321 -p123@xlm Warning: Using a password on the command line interface can be insecure. ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0 [root@linux_server_1 ~]#

带密码登录也是失败的

[wodesuck]

@tihu2016 用 phxbinlogsvr_tools 确认一下是否有 master，master 是否过期。如果 master 状态正常，麻烦看一下 phxsqlproxy 的 log。

[wayde-P]

E0823 17:51:46.481302 2915 phx_glog.cpp:78] UpdateMasterStatus:103 GetMaster success but (172.18.30.102:1503479490) expired E0823 17:51:46.481348 2915 phx_glog.cpp:78] UpdateMasterStatus ret -104 E0823 17:51:46.583690 2915 phx_glog.cpp:78] UpdateMasterStatus:103 GetMaster success but (172.18.30.102:1503479490) expired E0823 17:51:46.583731 2915 phx_glog.cpp:78] UpdateMasterStatus ret -104 E0823 17:51:46.686774 2915 phx_glog.cpp:78] UpdateMasterStatus:103 GetMaster success but (172.18.30.102:1503479490) expired E0823 17:51:46.686810 2915 phx_glog.cpp:78] UpdateMasterStatus ret -104 E0823 17:51:46.789441 2915 phx_glog.cpp:78] UpdateMasterStatus:103 GetMaster success but (172.18.30.102:1503479490) expired E0823 17:51:46.789513 2915 phx_glog.cpp:78] UpdateMasterStatus ret -104 E0823 17:51:46.892834 2915 phx_glog.cpp:78] UpdateMasterStatus:103 GetMaster success but (172.18.30.102:1503479490) expired E0823 17:51:46.892901 2915 phx_glog.cpp:78] UpdateMasterStatus ret -104

[wayde-P]

过期了怎么办呢?

[wodesuck]

master过期看一下各机phxsql相关进程，看看是否有多数派存活，如果多数派存活但master过期，看phxbinlogsvr的log，看一下具体过期原因。