Bug #43309 Test main.innodb can't be run twice
Submitted: 2 Mar 2009 14:21 Modified: 20 Jun 2010 0:38
Reporter: Bernt Marius Johnsen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.0, 5.1 (and possible 6.0) OS:Any
Assigned to: Satya B CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[2 Mar 2009 14:21] Bernt Marius Johnsen
Description:
Test main.innodb can't be run twice. Not verified on 6.0 since main.innodb is disabled due to BUG#41299

On 5.0 it fails like this:

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

innodb                         [ pass ]           3257
innodb                         [ fail ]

--- /export/home/tmp/mysql/5.0-bugteam/mysql-test/r/innodb.result       2009-03-02 12:12:10.000000000 +0300
+++ /export/home/tmp/mysql/5.0-bugteam/mysql-test/r/innodb.reject       2009-03-02 17:13:57.000000000 +0300
@@ -1805,13 +1805,13 @@
 Innodb_page_size       16384
 show status like "Innodb_rows_deleted";
 Variable_name  Value
-Innodb_rows_deleted    73
+Innodb_rows_deleted    162
 show status like "Innodb_rows_inserted";
 Variable_name  Value
-Innodb_rows_inserted   29734
+Innodb_rows_inserted   61029
 show status like "Innodb_rows_updated";
 Variable_name  Value
-Innodb_rows_updated    29532
+Innodb_rows_updated    59085
 show status like "Innodb_row_lock_waits";
 Variable_name  Value
 Innodb_row_lock_waits  0
@@ -1844,7 +1844,7 @@
 innodb_sync_spin_loops 20
 show variables like "innodb_thread_concurrency";
 Variable_name  Value
-innodb_thread_concurrency      8
+innodb_thread_concurrency      16
 set global innodb_thread_concurrency=1001;
 Warnings:
 Warning        1292    Truncated incorrect innodb_thread_concurrency value: '1001'

How to repeat:
./mtr innodb innodb
[27 Mar 2009 9:41] 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/70638

2778 Horst Hunger	2009-03-27
      Fix for Bug#43309: Reason for this bug are some "show status" statements, which accumulate with each test run and will only be resetted with a restart of the server. So, I propose to use weak conditions in the show statements.
[30 Mar 2009 12:46] Vasil Dimov
Fix

Attachment: c4575.diff (application/octet-stream, text), 7.22 KiB.

[30 Mar 2009 12:57] Vasil Dimov
This is related to Bug#41299.
[10 Apr 2009 11:23] Vasil Dimov
This fix cannot be ported to MySQL 5.0 because it does not have the table information_schema.global_status.

Is there any way to assign the output of "show status where variable_name='Innodb_rows_deleted';" to a variable and do arithmetics with it later?
[10 Apr 2009 18:53] Davi Arnaut
Vasil,

Take a look at query_get_value usage within the test suite.
[15 Apr 2009 12:28] 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/72148

2859 Satya B	2009-04-15
      Applying InnoDB snashot 5.1-ss4699, part 2. Fixes BUG#43309
      
      1) BUG#43309 - Test main.innodb can't be run twice
      
      2) Follow up fix for BUG#43309, adds explanatory comments.
      
      Detailed revision comments:
      
      r4575 | vasil | 2009-03-30 15:55:31 +0300 (Mon, 30 Mar 2009) | 8 lines
      branches/5.1:
      
      Fix Bug#43309 Test main.innodb can't be run twice
      
      Make the innodb mysql-test more flexible by inspecting how much a
      variable of interest has changed since the start of the test. Do not
      assume the variables have zero values at the start of the test.
      
      r4659 | vasil | 2009-04-06 15:34:51 +0300 (Mon, 06 Apr 2009) | 6 lines
      branches/5.1:
      
      Followup to r4575 and the fix of Bug#43309 Test main.innodb can't be run twice:
      
      Add an explanatory comment, as suggested by Patrick Crews in the bug report.
      modified:
        mysql-test/r/innodb.result
        mysql-test/t/innodb.test
[20 Apr 2009 6:59] Satya B
Notes to Docs team:
Patch queued to 5.1-bugteam.  NOT yet in 6.0 (5.1-snapshot-ss4699 is null merged into 6.0).
Please return to "Patch approved" after documenting until 6.0 snapshot is available.
[24 Apr 2009 12: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/72778

2732 Satya B	2009-04-24
      Applying InnoDB snashot 5.0-ss4900, part 2. Fixes BUG#43309
      
      1) BUG#43309 - Test main.innodb can't be run twice
      
      Detailed revision comments:
      
      r4701 | vasil | 2009-04-13 17:03:46 +0300 (Mon, 13 Apr 2009) | 6 lines
      branches/5.0:
      
      Fix Bug#43309 Test main.innodb can't be run twice
      
      by making the innodb.test reentrant.
      modified:
        mysql-test/r/innodb.result
        mysql-test/t/innodb.test
[24 Apr 2009 12:15] 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/72782

2870 Satya B	2009-04-24 [merge]
      NULL MERGE of innodb-5.0-ss4900 into 5.1 branch. Note BUG#42279 
      is pushed along with BUG#43309.
      
      Forgot to add BUG#4229 in the first paragraph in the commit 
      message
[5 May 2009 18:53] Bugs System
Pushed into 5.0.82 (revid:davi.arnaut@sun.com-20090505184158-dvmedh8n472y8np5) (version source revid:davi.arnaut@sun.com-20090505184158-dvmedh8n472y8np5) (merge vers: 5.0.82) (pib:6)
[5 May 2009 19:42] Bugs System
Pushed into 5.1.35 (revid:davi.arnaut@sun.com-20090505190206-9xmh7dlc6kom8exp) (version source revid:davi.arnaut@sun.com-20090505190206-9xmh7dlc6kom8exp) (merge vers: 5.1.35) (pib:6)
[6 May 2009 14:10] Bugs System
Pushed into 6.0.12-alpha (revid:svoj@sun.com-20090506125450-yokcmvqf2g7jhujq) (version source revid:satya.bn@sun.com-20090424121640-zg2txzmrfqj20ep0) (merge vers: 6.0.11-alpha) (pib:6)
[8 May 2009 19:42] Paul Dubois
Test case changes. No changelog entry needed.
[15 Jun 2009 8:29] Bugs System
Pushed into 5.1.35-ndb-6.3.26 (revid:jonas@mysql.com-20090615074202-0r5r2jmi83tww6sf) (version source revid:jonas@mysql.com-20090615070837-9pccutgc7repvb4d) (merge vers: 5.1.35-ndb-6.3.26) (pib:6)
[15 Jun 2009 9:08] Bugs System
Pushed into 5.1.35-ndb-7.0.7 (revid:jonas@mysql.com-20090615074335-9hcltksp5cu5fucn) (version source revid:jonas@mysql.com-20090615072714-rmfkvrbbipd9r32c) (merge vers: 5.1.35-ndb-7.0.7) (pib:6)
[15 Jun 2009 9:49] Bugs System
Pushed into 5.1.35-ndb-6.2.19 (revid:jonas@mysql.com-20090615061520-sq7ds4yw299ggugm) (version source revid:jonas@mysql.com-20090615054654-ebgpz7elwu1xj36j) (merge vers: 5.1.35-ndb-6.2.19) (pib:6)
[5 May 2010 15:18] Bugs System
Pushed into 5.1.47 (revid:joro@sun.com-20100505145753-ivlt4hclbrjy8eye) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[6 May 2010 17:55] Paul Dubois
Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug.
Re-closing.
[28 May 2010 5:50] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20100524190136-egaq7e8zgkwb9aqi) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (pib:16)
[28 May 2010 6:19] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100524190941-nuudpx60if25wsvx) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[28 May 2010 6:47] Bugs System
Pushed into 5.5.5-m3 (revid:alik@sun.com-20100524185725-c8k5q7v60i5nix3t) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[29 May 2010 22:51] Paul Dubois
Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug.
Re-closing.
[17 Jun 2010 11:50] Bugs System
Pushed into 5.1.47-ndb-7.0.16 (revid:martin.skold@mysql.com-20100617114014-bva0dy24yyd67697) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 12:28] Bugs System
Pushed into 5.1.47-ndb-6.2.19 (revid:martin.skold@mysql.com-20100617115448-idrbic6gbki37h1c) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 13:16] Bugs System
Pushed into 5.1.47-ndb-6.3.35 (revid:martin.skold@mysql.com-20100617114611-61aqbb52j752y116) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)