From: Frazer Clement Date: December 3 2012 5:31pm Subject: bzr push into mysql-5.1-telco-7.0 branch (frazer.clement:5059 to 5060) List-Archive: http://lists.mysql.com/commits/145428 Message-Id: <201212031731.qB3HVEmB014523@acsmt358.oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 5060 Frazer Clement 2012-12-03 Fix non-deterministic testcase. modified: mysql-test/suite/ndb_rpl/r/ndb_rpl_conflict_epoch_trans.result mysql-test/suite/ndb_rpl/t/ndb_rpl_conflict_epoch_trans.cnf mysql-test/suite/ndb_rpl/t/ndb_rpl_conflict_epoch_trans.test 5059 Pekka Nousiainen 2012-12-03 [merge] merge 6.3->7.0 modified: storage/ndb/test/ndbapi/testUpgrade.cpp storage/ndb/test/run-test/upgrade-tests.txt storage/ndb/test/src/HugoTransactions.cpp === modified file 'mysql-test/suite/ndb_rpl/r/ndb_rpl_conflict_epoch_trans.result' --- a/mysql-test/suite/ndb_rpl/r/ndb_rpl_conflict_epoch_trans.result 2011-09-07 22:50:01 +0000 +++ b/mysql-test/suite/ndb_rpl/r/ndb_rpl_conflict_epoch_trans.result 2012-12-03 17:17:56 +0000 @@ -593,12 +593,12 @@ Larry 50 Newsagent 0 Yacht dealer 50 Exceptions at Primary bank site -select server_id, master_server_id, count, auto_key, from_name, to_name, detail -from test.transactions$EX order by count; -server_id master_server_id count auto_key from_name to_name detail -1 3 1 1 Larry Employee-1 Payment to Employee-1 -1 3 2 2 Larry Employee-2 Payment to Employee-2 -1 3 3 3 Employee-2 Newsagent Buy yacht magazine +select server_id, master_server_id, auto_key, from_name, to_name, detail +from test.transactions$EX order by auto_key, from_name, to_name, detail; +server_id master_server_id auto_key from_name to_name detail +1 3 1 Larry Employee-1 Payment to Employee-1 +1 3 2 Larry Employee-2 Payment to Employee-2 +1 3 3 Employee-2 Newsagent Buy yacht magazine Conflict handling activity at Primary bank site Expect : 1 conflict from slave T1 on Larry's balance === modified file 'mysql-test/suite/ndb_rpl/t/ndb_rpl_conflict_epoch_trans.cnf' --- a/mysql-test/suite/ndb_rpl/t/ndb_rpl_conflict_epoch_trans.cnf 2011-09-28 09:40:14 +0000 +++ b/mysql-test/suite/ndb_rpl/t/ndb_rpl_conflict_epoch_trans.cnf 2012-12-03 17:17:56 +0000 @@ -11,6 +11,9 @@ # Potential infinite loops are broken by both servers # on each cluster having the same server-id +[cluster_config] +MaxNoOfExecutionThreads=8 + [cluster_config.slave] mysqld=, === modified file 'mysql-test/suite/ndb_rpl/t/ndb_rpl_conflict_epoch_trans.test' --- a/mysql-test/suite/ndb_rpl/t/ndb_rpl_conflict_epoch_trans.test 2011-09-07 22:50:01 +0000 +++ b/mysql-test/suite/ndb_rpl/t/ndb_rpl_conflict_epoch_trans.test 2012-12-03 17:17:56 +0000 @@ -477,9 +477,11 @@ select * from test.transactions order by select * from test.balances order by name; --echo Exceptions at Primary bank site - -select server_id, master_server_id, count, auto_key, from_name, to_name, detail - from test.transactions$EX order by count; +# Note count not included here as it's non-deterministic +# (CompletedOperations list order related to actual completion order related to +# universal randomness) +select server_id, master_server_id, auto_key, from_name, to_name, detail + from test.transactions$EX order by auto_key, from_name, to_name, detail; --echo Conflict handling activity at Primary bank site --echo Expect : No bundle (reason: useless for push emails).