Server IP : 104.21.38.3 / Your IP : 108.162.226.90 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/r/ |
Upload File : |
RESET MASTER; include/gtid_utils.inc include/gtid_step_reset.inc SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:1'; PREPARE stmt FROM 'CREATE TABLE t1( i INT) engine=INNODB'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:2'; PREPARE stmt FROM 'INSERT INTO t1 VALUES (12)'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:3'; PREPARE stmt FROM 'INSERT INTO t1 SELECT * FROM t1'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:4'; PREPARE stmt FROM 'UPDATE t1 SET i=13 WHERE i=12'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:5'; PREPARE stmt FROM 'DELETE FROM t1'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:6'; PREPARE stmt FROM 'ALTER TABLE t1 ADD COLUMN other_column INT'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:7'; PREPARE stmt FROM 'CREATE INDEX t_index ON t1(i)'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:8'; PREPARE stmt FROM 'DROP INDEX t_index ON t1'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:9'; PREPARE stmt FROM 'RENAME TABLE t1 TO t2'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:10'; PREPARE stmt FROM 'DROP TABLE t2'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:11'; PREPARE stmt FROM 'CREATE TEMPORARY TABLE t1(i INT)'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:12'; PREPARE stmt FROM 'DROP TEMPORARY TABLE t1'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:13'; PREPARE stmt FROM 'CREATE VIEW v1 as SELECT 1'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:14'; PREPARE stmt FROM 'DROP VIEW v1'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:15'; PREPARE stmt FROM 'CREATE USER user1'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:16'; PREPARE stmt FROM 'ALTER USER user1 IDENTIFIED BY \'passwd\''; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:17'; PREPARE stmt FROM 'GRANT ALL ON *.* TO user1'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:18'; PREPARE stmt FROM 'REVOKE ALL PRIVILEGES ON *.* FROM user1'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:19'; PREPARE stmt FROM 'DROP USER user1'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:20'; PREPARE stmt FROM 'CREATE DATABASE db1'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] SET GTID_NEXT = 'AUTOMATIC'; SET SESSION GTID_NEXT='MASTER_UUID:21'; PREPARE stmt FROM 'DROP DATABASE db1'; EXECUTE stmt; include/gtid_step_assert.inc [count=1, only_count=0] include/gtid_utils_end.inc