MySQL Forums
Forum List  »  Utilities

Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list'
Posted by: Aaron Lager
Date: June 29, 2016 03:14PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list'
799
June 29, 2016 03:14PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.