| Bug #26887 | main.count_distinct3 fails randomly | ||
|---|---|---|---|
| Submitted: | 6 Mar 2007 17:57 | Modified: | 6 May 2009 14:45 |
| Reporter: | Daniel Fischer | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Tests: Server | Severity: | S7 (Test Cases) |
| Version: | 4.1.23,5.0.37, 6.0-BK | OS: | Any (varying) |
| Assigned to: | Patrick Crews | CPU Architecture: | Any |
| Tags: | pushbuild, reason unknown, sporadic, test failure | ||
[6 Mar 2007 17:57]
Daniel Fischer
[1 Jul 2008 16:12]
Alexander Nozdrin
https://intranet.mysql.com/secure/pushbuild/xref.pl?testname=main.count_distinct3
[16 Dec 2008 13:20]
Sven Sandberg
This xref shows only timeouts in the test: http://tinyurl.com/5lb67d
[10 Apr 2009 0:24]
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/71836 2748 Patrick Crews 2009-04-09 Bug#26887: main.count_distinct3 fails randomly Revised the method of inflating the size of t1 in the test to use OUTFILE / INFILE to speed up the process. My experiments showed an average improvement of 14 seconds off the runtime of the test. Re-recorded the .result file to account for the changes to the test.
[14 Apr 2009 12:35]
Bernt Marius Johnsen
Ok to push.
[16 Apr 2009 12:45]
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/72287 2725 Patrick Crews 2009-04-16 Bug#26887 - main.count_distinct3 fails randomly Made efforts to streamline how we increase the size of our test table. Incorporating review feedback, the run time of the test has been reduced by ~60% While this does not guarantee that the test will not timeout anymore (the cause of the random failures), it does significantly reduce the chances of a timeout occurring.
[16 Apr 2009 14:30]
Sergey Petrunya
Ok to push after review feedback is addressed.
[16 Apr 2009 16:32]
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/72317 2726 Patrick Crews 2009-04-16 Bug#26887 - main.count_distinct3 fails randomly Made efforts to streamline how we increase the size of our test table Incorporating review feedback, the run time of the test has been reduced by ~60% While this does not guarantee that that test will not timeout anymore (the cause of the random failures), it does significantly reduce the chances of this occurring.
[16 Apr 2009 17:48]
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/72327 2726 Patrick Crews 2009-04-16 Bug#26887 - main.count_distinct3 fails randomly Streamlined how we increase the size of our test table. The new method shows run time decreased by ~60%. This is not a guarantee that we will not see test timeouts (the random failures noted in the bug), but it should significantly reduce the chances of this occurring.
[5 May 2009 18:52]
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:39]
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 4:17]
Paul DuBois
Test case changes. No changelog entry needed. Setting report to NDI pending push into 6.0.x.
[6 May 2009 14:11]
Bugs System
Pushed into 6.0.12-alpha (revid:svoj@sun.com-20090506125450-yokcmvqf2g7jhujq) (version source revid:patrick.crews@sun.com-20090416180244-zjjija41wria1o2i) (merge vers: 6.0.11-alpha) (pib:6)
[6 May 2009 14:45]
Paul DuBois
Test case changes. No changelog entry needed.
[15 Jun 2009 8:26]
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:06]
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:46]
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)
