Bug #58221 mysqladmin --sleep=x --count=x keeps looping
Submitted: 16 Nov 2010 8:56 Modified: 29 Jan 2011 23:05
Reporter: Roel Van de Paar Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.1.52, 5.5.7rc OS:Any
Assigned to: Nirbhay Choubey CPU Architecture:Any
Tags: regression

[16 Nov 2010 8:56] Roel Van de Paar
Description:
mysqladmin -uroot --sleep=10 --count=3 processlist

Keeps looping instead of stopping after 3 turns.

Regression? Ref bug #42639

How to repeat:
mysqladmin -uroot --sleep=10 --count=3 processlist
[15 Dec 2010 10:08] 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/126899

3525 Nirbhay Choubey	2010-12-15
      Bug#58221 : mysqladmin --sleep=x --count=x keeps looping
      
      When mysqldadmin is run with sleep and count options,
      it goes into an infinite loop and keeps executing the
      specified command.
      
      This happened because the statement, responsible for
      decrementing the count value, was missing.
      
      Fixed by adding a statement which will decrement the
      count value for each iteration.
     @ client/mysqladmin.cc
        Bug#58221 : mysqladmin --sleep=x --count=x keeps looping
        
        Added a condition to check and decrement the count
        value stored in nr_iterations per iteration.
     @ mysql-test/r/mysqladmin.result
        Added a testcase for Bug#58221.
     @ mysql-test/t/mysqladmin.test
        Added a testcase for Bug#58221.
[4 Jan 2011 11:28] Marc ALFF
Ok to push
[15 Jan 2011 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/128854

3555 Nirbhay Choubey	2011-01-16
      Bug#58221 : mysqladmin --sleep=x --count=x keeps looping
      
      When mysqldadmin is run with sleep and count options,
      it goes into an infinite loop and keeps executing the
      specified command.
      
      This happened because the statement, responsible for
      decrementing the count value, was missing.
      
      Fixed by adding a statement which will decrement the
      count value for each iteration.
     @ client/mysqladmin.cc
        Bug#58221 : mysqladmin --sleep=x --count=x keeps looping
        
        Added a condition to check and decrement the count
        value stored in nr_iterations per iteration.
     @ mysql-test/r/mysqladmin.result
        Added a testcase for Bug#58221.
     @ mysql-test/t/mysqladmin.test
        Added a testcase for Bug#58221.
[15 Jan 2011 20:39] 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/128855

3253 Nirbhay Choubey	2011-01-16 [merge]
      Merge of fix for bug#58221 from mysql-5.1 -> mysql-5.5.
[16 Jan 2011 3:27] 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/128861

3515 Nirbhay Choubey	2011-01-16 [merge]
      Merge of fix for bug#58221 from mysql-5.5 -> mysql-trunk.
[16 Jan 2011 3:29] Bugs System
Pushed into mysql-5.1 5.1.56 (revid:nirbhay.choubey@sun.com-20110115203408-8sii20wb5owr11rj) (version source revid:nirbhay.choubey@sun.com-20110115203408-8sii20wb5owr11rj) (merge vers: 5.1.56) (pib:24)
[16 Jan 2011 3:30] Bugs System
Pushed into mysql-5.5 5.5.10 (revid:nirbhay.choubey@sun.com-20110115203824-l3dob19149gnecyd) (version source revid:nirbhay.choubey@sun.com-20110115203824-l3dob19149gnecyd) (merge vers: 5.5.10) (pib:24)
[16 Jan 2011 3:31] Bugs System
Pushed into mysql-trunk 5.6.2 (revid:nirbhay.choubey@sun.com-20110116032530-awxs3t5328nmu4vg) (version source revid:nirbhay.choubey@sun.com-20110116032530-awxs3t5328nmu4vg) (merge vers: 5.6.2) (pib:24)
[19 Jan 2011 1:17] Paul DuBois
Noted in 5.1.56, 5.5.10, 5.6.2 changelogs.

When mysqldadmin was run with the --sleep and --count options, it
went into an infinite loop executing the specified command.