MariaDB [(none)]> create user testuser@'%';

Query OK, 0 rows affected (0.002 sec)

MariaDB [(none)]> CREATE ROLE journalist;

Query OK, 0 rows affected (0.002 sec)

MariaDB [(none)]> grant journalist to testuser@'%';

Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> select * from mysql.roles_mapping;

+-----------+----------+-----------------------+--------------+

| Host      | User     | Role                  | Admin_option |

+-----------+----------+-----------------------+--------------+

| localhost | root     | role_workflow_portals | Y            |

| localhost | root     | journalist            | Y            |

| %         | testuser | journalist            | N            |

+-----------+----------+-----------------------+--------------+

3 rows in set (0.001 sec)

MariaDB [(none)]> SET DEFAULT ROLE journalist for testuser@'%';

Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> show slave status\G

*************************** 1. row ***************************

                Slave_IO_State: Waiting for master to send event

                   Master_Host: 192.168.254.14

                   Master_User: repl

                   Master_Port: 3306

                 Connect_Retry: 60

               Master_Log_File: m2-bin.000005

           Read_Master_Log_Pos: 1077

                Relay_Log_File: mariadb-relay-bin.000002

                 Relay_Log_Pos: 1220

         Relay_Master_Log_File: m2-bin.000005

              Slave_IO_Running: Yes

             Slave_SQL_Running: No

               Replicate_Do_DB: 

           Replicate_Ignore_DB: 

            Replicate_Do_Table: 

        Replicate_Ignore_Table: 

       Replicate_Wild_Do_Table: 

   Replicate_Wild_Ignore_Table: mysql.%

                    Last_Errno: 1959

                    Last_Error: Error 'Invalid role specification `journalist`' on query. Default database: ''. Query: 'SET DEFAULT ROLE 'journalist' FOR 'testuser'@'%''

                  Skip_Counter: 0

           Exec_Master_Log_Pos: 924

               Relay_Log_Space: 1684

               Until_Condition: None

                Until_Log_File: 

                 Until_Log_Pos: 0

            Master_SSL_Allowed: No

            Master_SSL_CA_File: 

            Master_SSL_CA_Path: 

               Master_SSL_Cert: 

             Master_SSL_Cipher: 

                Master_SSL_Key: 

         Seconds_Behind_Master: NULL

 Master_SSL_Verify_Server_Cert: No

                 Last_IO_Errno: 0

                 Last_IO_Error: 

                Last_SQL_Errno: 1959

                Last_SQL_Error: Error 'Invalid role specification `journalist`' on query. Default database: ''. Query: 'SET DEFAULT ROLE 'journalist' FOR 'testuser'@'%''

   Replicate_Ignore_Server_Ids: 

              Master_Server_Id: 3

                Master_SSL_Crl: 

            Master_SSL_Crlpath: 

                    Using_Gtid: Slave_Pos

                   Gtid_IO_Pos: 3-3-5,0-3-2

       Replicate_Do_Domain_Ids: 

   Replicate_Ignore_Domain_Ids: 

                 Parallel_Mode: optimistic

                     SQL_Delay: 0

           SQL_Remaining_Delay: NULL

       Slave_SQL_Running_State: 

              Slave_DDL_Groups: 5

Slave_Non_Transactional_Groups: 0

    Slave_Transactional_Groups: 0

source include/master-slave.inc;

call mtr.add_suppression("Slave: Invalid role specification `journalist` Error_code: 1959");

connection master;

SET @@GLOBAL.replicate_wild_ignore_table="mysql.%";

connection slave;

source include/stop_slave.inc;

SET @@GLOBAL.replicate_wild_ignore_table="mysql.%";

source include/start_slave.inc;

connection master;

CREATE ROLE journalist;

CREATE USER testuser@localhost IDENTIFIED by '';

GRANT journalist to testuser@localhost;

SELECT  * from mysql.roles_mapping;

SET DEFAULT ROLE journalist for testuser@localhost;

connection slave;

--let $slave_sql_errno= 1959

--let $slave_timeout=5

source include/wait_for_slave_sql_error.inc;

let $error= query_get_value(SHOW SLAVE STATUS, Last_SQL_Error, 1);

--echo Last_SQL_Error = $error

let $errno= query_get_value(SHOW SLAVE STATUS, Last_SQL_Errno, 1);

--echo Last_SQL_Errno = $errno

let $repl_wild_filter= query_get_value(SHOW SLAVE STATUS, Replicate_Wild_Ignore_Table, 1);

--echo Replicate_Wild_Ignore_Table = $repl_wild_filter

# Clean up

source include/stop_slave_io.inc;

SET @@GLOBAL.replicate_wild_ignore_table="";

RESET SLAVE;

--let $rpl_only_running_threads= 1

connection master;

SET @@GLOBAL.replicate_wild_ignore_table="";

DROP ROLE journalist;

DROP USER testuser@localhost;

--source include/rpl_end.inc