Bug #41732 rpl_ndb_circular_2ch needs an updated configuration file
Submitted: 24 Dec 2008 11:24 Modified: 4 Mar 2009 7:04
Reporter: Alfranio Tavares Correia Junior Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:6.0-rpl OS:Any
Assigned to: Andrei Elkin CPU Architecture:Any
Tags: 6.0-rpl-green, pushbuild, test failure

[24 Dec 2008 11:24] Alfranio Tavares Correia Junior
Description:
This test case needs an updated configuration file:

rpl_ndb.rpl_ndb_circular_2ch             [ fail ]
        Test ended at 2008-12-23 13:48:06

CURRENT_TEST: rpl_ndb.rpl_ndb_circular_2ch
081223 16:47:59 [Warning] The syntax '--log' is deprecated and will be removed in MySQL 7.0. Please use '--general-log --general-log-file' instead.
081223 16:47:59 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in MySQL 7.0. Please use '--slow-query-log'/'--slow-query-log-file' instead.
081223 16:47:59 [Note] Plugin 'InnoDB' disabled by command line option
081223 16:47:59 [Note] Falcon: unable to open system data files.
081223 16:47:59 [Note] Falcon: creating new system data files.
081223 16:47:59 [Note] NDB: NodeID is 4, management server 'localhost:12501'
081223 16:48:03 [Note] NDB[0]: all storage nodes connected
081223 16:48:03 [Note] Starting MySQL Cluster Binlog Thread
081223 16:48:03 [ERROR] /home/acorreia/tmp/merge/mysql-6.0-rpl/sql/mysqld: unknown variable 'master-host=127.0.0.1'
081223 16:48:03 [ERROR] Aborting

081223 16:48:04 [Note] Stopping Cluster Binlog
081223 16:48:04 [Note] Stopping Cluster Utility thread
081223 16:48:05 [Note] Debug sync points hit:                   1
081223 16:48:05 [Note] Debug sync points executed:              0
081223 16:48:05 [Note] Debug sync points max active per thread: 0
081223 16:48:05 [Note] /home/acorreia/tmp/merge/mysql-6.0-rpl/sql/mysqld: Shutdown complete

Failed to start mysqld.2.slave

How to repeat:
Execute the test case in 6.0-rpl.

Suggested fix:
Update the configuration file and the test case according to the new MTR properties.
[26 Jan 2009 18:00] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/64067

2719 Andrei Elkin	2009-01-26
      Bug #41732 rpl_ndb_circular_2ch needs an updated configuration file
      
      There are two issues: 
      1. 6.0 uses the obsolate master-*** server options;
      2. the test is not deterministic in that although master vs slave consistency is fine,
         two runs of the test can have different results. The reason of the non-determinism
         is the combination of 
         a chosen way to demo results and the ndb_autoincrement_prefetch_sz feature.
      
      Fixed: with changing consistency checks through diff_tables (5.1, 6.0 issue 2); and
         removing the obsolate paramenters from a configuration file in the 6.0 version.
[26 Jan 2009 18:05] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/64068

2793 Andrei Elkin	2009-01-26
      Bug #41732 rpl_ndb_circular_2ch needs an updated configuration file
      
      1. 6.0 uses the obsolate master-*** server options;
      2. the test is not deterministic in that although master vs slave consistency is
      fine,two runs of the test can have different results. The reason of the
      non-determinism is the combination of 
      a chosen way to demo results and the ndb_autoincrement_prefetch_sz feature.
            
      Fixed: with changing consistency checks through diff_tables (changeset for 5.1; and
             removing the obsolate paramenters from a configuration file in the 6.0 version
             (the current changeset).
[29 Jan 2009 14:02] Alfranio Tavares Correia Junior
Please, look at BUG#42396.
[2 Feb 2009 20:31] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/64929

2765 Andrei Elkin	2009-02-02
      Bug #41732 rpl_ndb_circular_2ch needs an updated configuration file
      
      There are two issues: 
            1. 6.0 uses the obsolate master-*** server options;
            2. the test is not deterministic in that although master vs slave consistency is
               fine, two runs of the test can have different results. The reason of the
               non-determinism is the combination of 
               a chosen way to demo results and the ndb_autoincrement_prefetch_sz feature.
      
      The current patch fixes the 2nd issue by putting out results via diff_table macro
      instead of the former run-sensitive method.
      The 1st issue is going to be fixed by a separate patch to 6.0.
[2 Feb 2009 20:35] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/64931

3002 Andrei Elkin	2009-02-02
      Bug #41732 rpl_ndb_circular_2ch needs an updated configuration file
            
      There are two issues: 
            1. 6.0 uses the obsolate master-*** server options;
            2. the test is not deterministic in that although master vs slave consistency is
                     fine, two runs of the test can have different results. The reason of the
                     non-determinism is the combination of 
                     a chosen way to demo results and the ndb_autoincrement_prefetch_sz feature.
            
      The current patch fixes the 1st issue. Notice the test remains disable on the 6.0 tree
      due to Bug #42396.
[2 Feb 2009 21:00] Andrei Elkin
Pushed to 5.1-bt and 6.0-bt parts of the patch in the two last commits on the bug page.
[3 Feb 2009 9:41] Bugs System
Pushed into 5.1.32 (revid:joro@sun.com-20090203090549-gos3v4320vimrzg6) (version source revid:aelkin@mysql.com-20090202203101-rpc9wvdek95qqk5n) (merge vers: 5.1.32) (pib:6)
[4 Feb 2009 11:16] Bugs System
Pushed into 6.0.10-alpha (revid:kostja@sun.com-20090204104420-mw1i2u9lum4bxjo6) (version source revid:aelkin@mysql.com-20090202205045-ibm2u4upsznckdmi) (merge vers: 6.0.10-alpha) (pib:6)
[17 Feb 2009 14:57] Bugs System
Pushed into 5.1.32-ndb-6.3.23 (revid:tomas.ulin@sun.com-20090217131017-6u8qz1edkjfiobef) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)
[17 Feb 2009 16:45] Bugs System
Pushed into 5.1.32-ndb-6.4.3 (revid:tomas.ulin@sun.com-20090217134419-5ha6xg4dpedrbmau) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)
[17 Feb 2009 18:21] Bugs System
Pushed into 5.1.32-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090217134216-5699eq74ws4oxa0j) (version source revid:tomas.ulin@sun.com-20090203064601-uyuzm4mielj3fz76) (merge vers: 5.1.32-ndb-6.2.17) (pib:6)
[4 Mar 2009 7:04] Jon Stephens
Problem with test only, no end-user changes to document. Closed without further action.