Server IP : 104.21.38.3 / Your IP : 172.68.164.14 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/ndb/t/ |
Upload File : |
# The include statement below is a temp one for tests that are yet to #be ported to run with InnoDB, #but needs to be kept for tests that would need MyISAM in future. --source include/force_myisam_default.inc --source include/have_ndb.inc --source include/not_windows.inc CREATE TABLE t1(a int primary key, b varchar(255), c int) engine=ndb; select * from t1; insert into t1 values (1, "row 1", 2); connect(con1, localhost, root,,); connect(con2, localhost, root,,); connect(con3, localhost, root,,); connection con1; select * from t1; connection con2; select * from t1; connection con3; select * from t1; # Restart cluster nodes "nostart" --exec $NDB_MGM --no-defaults --ndb-connectstring="$NDB_CONNECTSTRING" -e "all restart -n" >> $NDB_TOOLS_OUTPUT # Wait for all nodes to enter "nostart" --exec $NDB_WAITER --no-defaults --ndb-connectstring="$NDB_CONNECTSTRING" --not-started >> $NDB_TOOLS_OUTPUT connection con1; --error 1296 select * from t1; connection con2; --error 1296 select * from t1; # Don't do anything with the third connection #connection con3; # Start cluster nodes again --exec $NDB_MGM --no-defaults --ndb-connectstring="$NDB_CONNECTSTRING" -e "all start" >> $NDB_TOOLS_OUTPUT # Wait for all nodes to enter "started" --exec $NDB_WAITER --no-defaults --ndb-connectstring="$NDB_CONNECTSTRING" >> $NDB_TOOLS_OUTPUT # # Wait until the connection to the # cluster has been restored or timeout occurs # connection default; --disable_result_log --disable_query_log --source include/ndb_not_readonly.inc --enable_result_log --enable_query_log # Run selects to show that the cluster are back connection con1; select a,b,c from t1; connection con2; select * from t1; connection con3; select * from t1; # # Wait until mysqld has connected properly to cluster # --disable_result_log --disable_query_log source include/ndb_not_readonly.inc; --enable_query_log --enable_result_log # Do an insert to see table is writable insert into t1 values (2, "row 1", 37); # cleanup drop table t1; # #Bug #13824846 FRM FILES ARE CREATED FOR MYSQLD, BUT TABLE DOES NOT EXIST IN CLUSTER # connection default; create table t1(a int, b varchar(10), c date) engine=ndb; delimiter //; CREATE TRIGGER trg1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN SET new.c = '1901-01-01 01:01:01'; End // delimiter ;// insert into t1 values (1, "row 1", NULL),(2, "row 2", NULL); select * from t1 order by a; create table t2(a int, b varchar(10), c date) engine=myisam; delimiter //; CREATE TRIGGER trg2 BEFORE UPDATE ON t2 FOR EACH ROW BEGIN SET new.c = '1901-01-01 01:01:01'; End // delimiter ;// # drop the ndb table inside ndb --exec $NDB_DROP_TABLE --no-defaults -d test t1 >> $NDB_TOOLS_OUTPUT # Restart cluster nodes and clear all meta-data --exec $NDB_MGM --no-defaults --ndb-connectstring="$NDB_CONNECTSTRING" -e "all restart" >> $NDB_TOOLS_OUTPUT # Wait for all nodes to enter "started" --exec $NDB_WAITER --no-defaults --ndb-connectstring="$NDB_CONNECTSTRING" >> $NDB_TOOLS_OUTPUT # # Wait until the connection to the # cluster has been restored or timeout occurs # connection default; --disable_result_log --disable_query_log --source include/ndb_not_readonly.inc --enable_result_log --enable_query_log # Create the table again to check there are no conflicts create table t1(a int, b varchar(10), c date) engine=ndb; delimiter //; CREATE TRIGGER trg1 BEFORE UPDATE ON t1 FOR EACH ROW BEGIN SET new.c = '1902-02-02 02:02:02'; End // delimiter ;// insert into t1 values (1, "row 1", NULL),(2, "row 2", NULL); select * from t1 order by a; # Check that only ndb tables have been cleaned away --error ER_TABLE_EXISTS_ERROR create table t2(a int, b varchar(10), c date) engine=myisam; drop table t2; create table t2(a int, b varchar(10), c date) engine=myisam; delimiter //; CREATE TRIGGER trg2 BEFORE UPDATE ON t2 FOR EACH ROW BEGIN SET new.c = '1901-01-01 01:01:01'; End // delimiter ;// # cleanup drop table t1, t2; # Check that NDB tables can't be created in the information_schema database --error ER_DBACCESS_DENIED_ERROR create table information_schema.t1(a int, b varchar(10), c date) engine=ndb;