MySQL Forums :: Utilities :: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list'


Advanced Search

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
mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 1369 Aaron Lager 06/21/2016 12:49PM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 524 Chuck Bell 06/23/2016 06:45AM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 598 Aaron Lager 06/28/2016 11:03AM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 600 Aaron Lager 06/29/2016 03:14PM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 462 Chuck Bell 07/06/2016 04:05PM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 486 Aaron Lager 07/06/2016 04:10PM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 473 Aaron Lager 07/06/2016 04:12PM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 458 Chuck Bell 07/11/2016 08:18AM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 417 Chuck Bell 07/11/2016 08:20AM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 423 Aaron Lager 06/29/2016 03:15PM
Re: mysqlfailover 1.6.1 and mysql 5.7.12 ERROR: Query failed. 1054 (42S22): Unknown column 'password' in 'field list' 585 Aaron Lager 06/29/2016 03:18PM


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.