Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 11.8, 10.5(EOL)
-
None
Description
I would expect it to be already filed, but can't find it.
CREATE [OR REPLACE] USER was not a part of the big "Atomic DDL" effort MDEV-17567, so I suppose we can say that it is not atomic by design. The problem is that it breaks replication too easily.
--source include/master-slave.inc
|
CREATE USER u; |
--error ER_PLUGIN_IS_NOT_LOADED
|
CREATE OR REPLACE USER u IDENTIFIED VIA x; |
CREATE USER u; |
SHOW BINLOG EVENTS;
|
|
|
--sync_slave_with_master
|
|
|
--connection master
|
DROP USER u; |
--source include/rpl_end.inc |
Failing CREATE OR REPLACE drops the user without creating a new one (== not atomic), but it also doesn't write DROP in the binary log, so the next successful CREATE fails on the replica.
|
main 6ef1303d6931bcbff6cc4a1d66aad8d9b1aa52e6 |
CREATE OR REPLACE USER u IDENTIFIED VIA x;
|
ERROR HY000: Plugin 'x' is not loaded
|
CREATE USER u;
|
SHOW BINLOG EVENTS;
|
Log_name Pos Event_type Server_id End_log_pos Info
|
master-bin.000001 4 Format_desc 1 256 Server ver: 12.1.0-MariaDB-asan-debug-log, Binlog ver: 4
|
master-bin.000001 256 Gtid_list 1 285 []
|
master-bin.000001 285 Binlog_checkpoint 1 329 master-bin.000001
|
master-bin.000001 329 Gtid 1 371 GTID 0-1-1
|
master-bin.000001 371 Query 1 451 use `test`; CREATE USER u
|
master-bin.000001 451 Gtid 1 493 GTID 0-1-2
|
master-bin.000001 493 Query 1 573 use `test`; CREATE USER u
|
...
|
Last_Errno 1396
|
Last_Error Error 'Operation CREATE USER failed for 'u'@'%'' on query. Default database: 'test'. Query: 'CREATE USER u'
|