Unable to create a user who was deleted before

[PercUse]

Hi Guys,

We’re running 3 MySQL master-master and had some trouble to create a user who was existing before for some test:

Node1: [1]

mysql> create user ‘web0’@‘localhost’ identified by ‘';
ERROR 1396 (HY000): Operation CREATE USER failed for ‘web0’@‘localhost’
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> create user ‘web0’@‘localhost’ identified by '’;
ERROR 1396 (HY000): Operation CREATE USER failed for ‘web0’@‘localhost’

-------------------- [2]

Node1:
select * from mysql.user where user like ‘%web0%’;
Empty set (0.00 sec)

Node2:
select * from mysql.user where user like ‘%web0%’;
Empty set (0.00 sec)

Node3:
select * from mysql.user where user like ‘%web0%’;
Empty set (0.00 sec)

----------------------- [3]

Node 1:

mysql> create user ‘web0’@‘localhost’ identified by ‘‘’;
ERROR 1396 (HY000): Operation CREATE USER failed for ‘web0’@‘localhost’
mysql> drop user web0@localhost;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> create user ‘web0’@‘localhost’ identified by '’';
Query OK, 0 rows affected (0.00 sec)

---

After dropping a non existing user [2] we was able to create it again [3].

Are you aware about this issue?

Installed packages:

ii percona-toolkit 2.2.15-2 Advanced MySQL and system command-line tools
ii percona-xtrabackup 2.3.2-1.precise Open source backup tool for InnoDB and XtraDB
ii percona-xtradb-cluster-client-5.6 5.6.26-25.12-1.precise Percona XtraDB Cluster database client binaries
ii percona-xtradb-cluster-common-5.6 5.6.26-25.12-1.precise Percona XtraDB Cluster database common files (e.g. /etc/mysql/my.cnf)
ii percona-xtradb-cluster-galera-3.x 3.12.2-1.precise Galera components of Percona XtraDB Cluster
ii percona-xtradb-cluster-server 5.6.15-25.2-645.precise Percona Server database server
ii percona-xtradb-cluster-server-5.6 5.6.26-25.12-1.precise Percona XtraDB Cluster database server binaries

Thanks