| Server IP : 172.67.216.182 / Your IP : 172.70.188.20 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/binlog/r/ |
Upload File : |
RESET MASTER;
call mtr.add_suppression("REVOKE/GRANT failed while storing table level and column level grants in the privilege tables. An incident event has been written to the binary log which will stop the slaves.");
CREATE TABLE t1(a INT, b INT);
CREATE USER u1@h;
#
# Verify that u1 is added into mysql.user.
#
SELECT user FROM mysql.user WHERE user='u1';
user
u1
GRANT SELECT(a) ON t1 TO u1@h, u2@h;
ERROR 42000: Can't find any matching row in the user table
#
# The SELECT privilege on column a is granted to u1@h,
# which means that GRANT can be failed partially when
# granting an available privilege to both an existent
# user and a non-existent user.
#
SELECT user, column_name, column_priv FROM mysql.columns_priv;
user column_name column_priv
u1 a Select
#
# Verify that the partially failed GRANT statement is not binlogged,
# and it causes to log an incident event with an unique gtid, which
# is saved into @@GLOBAL.GTID_EXECUTED.
#
include/show_binlog_events.inc
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
master-bin.000001 # Incident # # #1 (LOST_EVENTS)
master-bin.000001 # Rotate # # master-bin.000002;pos=POS
include/assert.inc [Generate MASTER_UUID:4 for the incident event and commit it into @@GLOBAL.GTID_EXECUTED]
DROP USER u1@h;
DROP TABLE t1;