Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list'
We'll I thought it was working, but now that I'm back on it to test it, when I shut down a mysql daemon, the script crashes!
Here's the trace
Failed to reconnect to the master after 3 attemps.
Failover starting in 'auto' mode...
Traceback (most recent call last):
File "/usr/bin/mysqlfailover", line 375, in <module>
rpl_cmds.auto_failover(opt.interval)
File "/usr/lib/python2.7/dist-packages/mysql/utilities/command/rpl_admin.py", line 740, in a uto_failover
res = self.run_auto_failover(console, failover_mode)
File "/usr/lib/python2.7/dist-packages/mysql/utilities/command/rpl_admin.py", line 943, in r un_auto_failover
res = self.topology.failover(self.candidates, False)
File "/usr/lib/python2.7/dist-packages/mysql/utilities/common/topology.py", line 2107, in fa ilover
new_master_dict = self.find_best_slave(candidates, False, strict)
File "/usr/lib/python2.7/dist-packages/mysql/utilities/common/topology.py", line 2062, in fi nd_best_slave
check_master)
File "/usr/lib/python2.7/dist-packages/mysql/utilities/common/topology.py", line 735, in _ch eck_candidate_eligibility
user, _ = slave.get_rpl_user()
File "/usr/lib/python2.7/dist-packages/mysql/utilities/common/replication.py", line 1584, in get_rpl_user
m_host = self.master_info.get_value("Master_User")
File "/usr/lib/python2.7/dist-packages/mysql/utilities/common/replication.py", line 1230, in get_value
self._check_read(refresh)
File "/usr/lib/python2.7/dist-packages/mysql/utilities/common/replication.py", line 1096, in _check_read
self.read()
File "/usr/lib/python2.7/dist-packages/mysql/utilities/common/replication.py", line 1083, in read
return self._read_master_info_table()
File "/usr/lib/python2.7/dist-packages/mysql/utilities/common/replication.py", line 1168, in _read_master_info_table
self._build_dictionary(rows)
File "/usr/lib/python2.7/dist-packages/mysql/utilities/common/replication.py", line 1104, in _build_dictionary
self.values[_MASTER_INFO_COL] = rows
IndexError: list index out of range