| Server IP : 104.21.38.3 / Your IP : 104.23.175.126 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/mysql-test/suite/group_replication/r/ |
Upload File : |
include/group_replication.inc
Warnings:
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection server1]
SET SESSION sql_log_bin=0;
call mtr.add_suppression("Table.*does not have any PRIMARY KEY. This is not compatible with Group Replication");
SET SESSION sql_log_bin=1;
CREATE TABLE t1 (c1 INT UNIQUE KEY) ENGINE=InnoDB;
CREATE TABLE t2 (c1 INT, KEY `c1` (`c1`)) ENGINE=InnoDB;
CREATE TABLE t3 (c1 INT UNIQUE NULL) ENGINE=InnoDB;
include/rpl_sync.inc
#
# Testing all tables that will fail.
#
INSERT INTO t3 VALUES(1);
ERROR HY000: The table does not comply with the requirements by an external plugin.
UPDATE t3 SET c1 = 2;
ERROR HY000: The table does not comply with the requirements by an external plugin.
DELETE FROM t3;
ERROR HY000: The table does not comply with the requirements by an external plugin.
INSERT INTO t2 VALUES(1);
ERROR HY000: The table does not comply with the requirements by an external plugin.
UPDATE t2 SET c1 = 2;
ERROR HY000: The table does not comply with the requirements by an external plugin.
DELETE FROM t2;
ERROR HY000: The table does not comply with the requirements by an external plugin.
INSERT INTO t1 VALUES(1);
ERROR HY000: The table does not comply with the requirements by an external plugin.
UPDATE t1 SET c1 = 2;
ERROR HY000: The table does not comply with the requirements by an external plugin.
DELETE FROM t1;
ERROR HY000: The table does not comply with the requirements by an external plugin.
include/rpl_sync.inc
# Now, lets repeat all the tests with group replication stopped.
include/stop_group_replication.inc
include/stop_group_replication.inc
INSERT INTO t3 VALUES(1);
UPDATE t3 SET c1 = 2;
DELETE FROM t3;
DROP TABLE t3;
INSERT INTO t2 VALUES(1);
UPDATE t2 SET c1 = 2;
DELETE FROM t2;
DROP TABLE t2;
INSERT INTO t1 VALUES(1);
UPDATE t1 SET c1 = 2;
DELETE FROM t1;
DROP TABLE t1;
DROP TABLE t3;
DROP TABLE t2;
DROP TABLE t1;
include/group_replication_end.inc