Skip to content

Instantly share code, notes, and snippets.

@masv
Last active August 11, 2017 15:04
Show Gist options
  • Save masv/018cb3b889fdd8be7026e5078779cce1 to your computer and use it in GitHub Desktop.
Save masv/018cb3b889fdd8be7026e5078779cce1 to your computer and use it in GitHub Desktop.
Error 1776 on make-co-master
ubuntu@orc:~$ orchestrator -c make-co-master -i db3 -d db2
2017-08-11 14:59:57 DEBUG Connected to orchestrator backend: orc_server_user:?@tcp(127.0.0.1:3306)/orchestrator?timeout=1s
2017-08-11 14:59:57 DEBUG Orchestrator pool SetMaxOpenConns: 128
2017-08-11 14:59:57 DEBUG Initializing orchestrator
2017-08-11 14:59:57 INFO Connecting to backend: maxConnections: 128, maxIdleConns: 32
2017-08-11 14:59:57 DEBUG Will check whether db3:3306's master (db2:3306) can become its co-master
2017-08-11 14:59:57 INFO Will make db3:3306 co-master of db2:3306
2017-08-11 14:59:57 INFO auditType:begin-maintenance instance:db3:3306 cluster:db2:3306 message:maintenanceToken: 35, owner: ubuntu, reason: make co-master of db2:3306
2017-08-11 14:59:57 INFO auditType:begin-maintenance instance:db2:3306 cluster:db2:3306 message:maintenanceToken: 36, owner: ubuntu, reason: db3:3306 turns into co-master of this
2017-08-11 14:59:57 DEBUG Got credentials from a replica. will now apply
2017-08-11 14:59:57 DEBUG ChangeMasterTo: will attempt changing master credentials on db2:3306
2017-08-11 14:59:57 INFO ChangeMasterTo: Changed master credentials on db2:3306
2017-08-11 14:59:57 DEBUG ChangeMasterTo: will attempt changing master on db2:3306 to db3:3306, mysql-bin.000003:191
2017-08-11 14:59:57 ERROR Error 1776: Parameters MASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be set when MASTER_AUTO_POSITION is active.
2017-08-11 14:59:57 ERROR Error 1776: Parameters MASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be set when MASTER_AUTO_POSITION is active.
2017-08-11 14:59:57 ERROR Error 1776: Parameters MASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be set when MASTER_AUTO_POSITION is active.
2017-08-11 14:59:57 INFO auditType:end-maintenance instance:db2:3306 cluster:db2:3306 message:maintenanceToken: 36
2017-08-11 14:59:57 INFO auditType:end-maintenance instance:db3:3306 cluster:db2:3306 message:maintenanceToken: 35
2017-08-11 14:59:57 FATAL Error 1776: Parameters MASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be set when MASTER_AUTO_POSITION is active.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment