Server IP : 172.67.216.182 / Your IP : 172.69.165.78 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_binlog/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/have_log_bin.inc --disable_query_log reset master; --enable_query_log --echo ------------------------------------------------- --echo First run using ndb_binlog_index table containing --echo epoch end position information --echo ------------------------------------------------- show create table mysql.ndb_binlog_index; --source suite/ndb_binlog/t/ndb_binlog_index_test_schema_independent.inc --echo ------------------------------------------------ --echo Second run using ndb_binlog_index table without --echo epoch end position information --echo ------------------------------------------------ alter table mysql.ndb_binlog_index drop column next_file; alter table mysql.ndb_binlog_index drop column next_position; reset master; show create table mysql.ndb_binlog_index; --source suite/ndb_binlog/t/ndb_binlog_index_test_schema_independent.inc --echo Now restore original schema reset master; alter table mysql.ndb_binlog_index add column next_position bigint unsigned not null; alter table mysql.ndb_binlog_index add column next_file varchar(255) not null; reset master; --echo -------------------------------------- --echo Quick test of ndb-log-empty-epochs = 1 --echo -------------------------------------- select * from mysql.ndb_binlog_index order by epoch; --source include/show_binlog_events.inc show variables like 'ndb_log_empty_epochs'; set global ndb_log_empty_epochs=1; show variables like 'ndb_log_empty_epochs'; --echo Allow some empty epochs to pass... let $got_some_epochs=0; while(!$got_some_epochs) { let $got_some_epochs=query_get_value(select (count(1) > 10) as num from mysql.ndb_binlog_index, num, 1); --sleep 1 } --echo Show that we have entries in ndb_binlog_index select count(1) > 0 from mysql.ndb_binlog_index; --echo Show that all ndb_binlog_index entries have the same file + position select bi1.epoch, bi1.Position, bi1.File, bi1.next_position, bi1.next_file, bi2.epoch, bi2.Position, bi2.File, bi2.next_position, bi2.next_file from mysql.ndb_binlog_index as bi1, mysql.ndb_binlog_index as bi2 where # Start and Next not same bi1.Position != bi1.next_position OR bi1.File != bi1.next_file OR # All epochs not the same bi1.Position != bi2.Position OR bi1.File != bi2.File; --echo Show that we have no epochs in the Binlog --source include/show_binlog_events.inc --echo Disable set global ndb_log_empty_epochs=0;