Adding replication slave errno: 1396

Follow

Tobias

• June 14, 2019 07:38

When I want to add a new replication slave to our cluster we get this error:

(ERROR) HOSTNAME1:3306: Query CREATE USER 'rpl_user'@'HOSTNAME2' IDENTIFIED BY xx xxx failed: Operation CREATE USER failed for 'rpl_user'@'HOSTNAME2' (errno: 1396).

It seems that cc creates the user two times, the user is created on HOSTNAME1 correctly at the first time, and then it fails because the user is already created.

Any ideas?

0

• Official comment

  

  Krzysztof Ksiazek

  • June 14, 2019 11:33

  Hi,

   

  Can you please open a ticket with us (support.severalnines.com)? Please provide error report in the ticket (Logs -> Error reports -> Create error report) - we need more data to determine the cause for this issue to show up.

  Thanks,

  Krzysztof

  Comment actions Permalink

Please sign in to leave a comment.