MySQL Forums
Forum List  »  Utilities

'Operation CREATE USER failed for 'fabric_server'
Posted by: David Monty
Date: January 22, 2016 07:23AM

Hi,

I am having a difficult time with fabric. I have 2 mysql servers and 1 fabric servers, separate server id's etc. All servers ca access each other.

Why is the below happening?

Here is what is in the fabric log:

[INFO] 1453465533.456707 - XML-RPC-Session-4 - Started XML-RPC-Session.
[WARNING] 1453465784.725603 - Executor-3 - Candidate (fb6b2f9d-c0bf-11e5-ac4f-04019da86e01) cannot become a master due to the following reasons: issues to become a master ({'is_gtid_not_enabled': False, 'is_slave_updates_not_enabled': False, 'is_not_running': False, 'is_binlog_not_enabled': False, 'no_rpl_user': False}), prerequistes as a slave ({}), valid master (True).
[WARNING] 1453465784.818237 - Executor-3 - Error trying to process transactions in the relay log for candidate (<server(uuid=c5c0345b-c101-11e5-a6eb-04019dd77301, address=192.34.56.66:3306, mode=READ_ONLY, status=SECONDARY>): Command (START SLAVE SQL_THREAD, ()) failed accessing (192.34.56.66:3306). 1871 (HY000): Slave failed to initialize master info structure from the repository..
[INFO] 1453465784.880582 - Executor-3 - Master has changed from None to c5c0345b-c101-11e5-a6eb-04019dd77301.


Time-To-Live: 1

uuid is_alive status is_not_running is_not_configured io_not_running sql_not_running io_error sql_error
------------------------------------ -------- --------- -------------- ----------------- -------------- --------------- -------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
c5c0345b-c101-11e5-a6eb-04019dd77301 1 PRIMARY 0 0 0 0 False False
fb6b2f9d-c0bf-11e5-ac4f-04019da86e01 1 SECONDARY 0 0 0 1 False Error 'Operation CREATE USER failed for 'fabric_server'@'%'' on query. Default database: ''. Query: 'CREATE USER 'fabric_server'@'%' IDENTIFIED WITH 'mysql_native_password' AS '*0C21C48C1D8B7C42A8155CC993649AB7478D6102''

issue
-----


root@fabric-forex-do-development-ny-druid-20160122035236:~# mysqlfabric group lookup_servers druid
Fabric UUID: 5ca1ab1e-a007-feed-f00d-cab3fe13249e
Time-To-Live: 1

server_uuid address status mode weight
------------------------------------ ------------------ --------- ---------- ------
c5c0345b-c101-11e5-a6eb-04019dd77301 192.34.56.66:3306 PRIMARY READ_WRITE 1.0
fb6b2f9d-c0bf-11e5-ac4f-04019da86e01 192.34.59.181:3306 SECONDARY READ_ONLY 1.0




[DEFAULT]
prefix = /usr/local
sysconfdir = /usr/local/etc
logdir = /var/log

[storage]
address = 0.0.0.0:3306
user = fabric_store
password = Test101
database = mysql_fabric
auth_plugin = mysql_native_password
connection_timeout = 6
connection_attempts = 6
connection_delay = 1

[servers]
user = fabric_server
password = Test101
backup_user = fabric_backup
backup_password = Test101
restore_user = fabric_restore
restore_password = Test101
unreachable_timeout = 5

[protocol.xmlrpc]
address = 0.0.0.0:32274
threads = 5
user = admin
password = Test101
disable_authentication = no
realm = MySQL Fabric
ssl_ca =
ssl_cert =
ssl_key =

[protocol.mysql]
address = 0.0.0.0:32275
user = admin
password = Test101
disable_authentication = no
ssl_ca =
ssl_cert =
ssl_key =

Options: ReplyQuote


Subject
Views
Written By
Posted
'Operation CREATE USER failed for 'fabric_server'
1813
January 22, 2016 07:23AM


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.