Page MenuHomePhabricator
Paste P11657

(An Untitled Masterwork)
ActivePublic

Authored by Marostegui on Jun 25 2020, 7:12 AM.
Tags
None
Referenced Files
F31904801: raw.txt
Jun 25 2020, 7:12 AM
Subscribers
None
./switchover.py --timeout=10 --only-slave-move db1135.eqiad.wmnet db1097.eqiad.wmnet
Starting preflight checks...
* Original read only values are as expected (master: read_only=0, slave: read_only=1)
* The host to fail over is a direct replica of the master
* Replication is up and running between the 2 hosts
* The replication lag is acceptable: 0 (lower than the configured or default timeout)
* The master is not a replica of any other host
Testing if to migrate db1097.eqiad.wmnet:3306/(none)...
Nope
Testing if to migrate db2132.codfw.wmnet:3306/(none)...
Stopped at master position: db1135-bin.003314:832580310, slave position db2132-bin.002163:914327744
Traceback (most recent call last):
File "./switchover.py", line 318, in <module>
main()
File "./switchover.py", line 280, in main
move_replicas_to_new_master(master_replication, slave_replication, timeout)
File "./switchover.py", line 178, in move_replicas_to_new_master
result = replication.move(new_master=slave_replication.connection, start_if_stopped=True)
File "/home/marostegui/git/wmfmariadbpy/wmfmariadbpy/WMFReplication.py", line 397, in move
events = self.connection.execute('SHOW BINLOG EVENTS IN \'{}\''.format(binlog_file))
File "/home/marostegui/git/wmfmariadbpy/wmfmariadbpy/WMFMariaDB.py", line 259, in execute
cursor.execute(command)
File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 170, in execute
result = self._query(query)
File "/usr/lib/python3/dist-packages/pymysql/cursors.py", line 328, in _query
conn.query(q)
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 517, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 732, in _read_query_result
result.read()
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1082, in read
self._read_result_packet(first_packet)
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1152, in _read_result_packet
self._read_rowdata_packet()
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1190, in _read_rowdata_packet
rows.append(self._read_row_from_packet(packet))
File "/usr/lib/python3/dist-packages/pymysql/connections.py", line 1206, in _read_row_from_packet
data = data.decode(encoding)
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xed in position 1313: invalid continuation byte