Bug #39125 Result file for test contains a "temporary error", how can this be stable ?
Submitted: 29 Aug 2008 16:31 Modified: 18 May 2009 19:38
Reporter: Joerg Bruehe Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:mysql-5.1-telco-6.3 OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: disabled, mysql-5.1-telco-6.3.17

[29 Aug 2008 16:31] Joerg Bruehe
Description:
This occurred in the build of "cluster 6.3.17" which is based on server 5.1.27.
The dubious contents is present in the general 5.1 tree, not specific to the cluster tree.

See this test failure:

::::::::::::::
funcs_1.ndb_views              [ fail ]

--- /PATH/mysql-test/suite/funcs_1/r/ndb_views.result
+++ /PATH/mysql-test/suite/funcs_1/r/ndb_views.reject
@@ -21567,7 +21567,8 @@
 v28    CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `test1`.`v28` AS selec
t `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test3`.`t1` `tab1` join `test1`.`v27` `tab2` on(((`tab1`.`f1`
 = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`))))      latin1  latin1_swedish_ci
 SELECT CAST(f1 AS SIGNED INTEGER) AS f1,
 CAST(f2 AS CHAR) AS f2 FROM test1.v28;
-ERROR HY000: Got temporary error 4006 'Connect failure - out of connection objects (increase MaxNoOfConcurrentTransactions)' from NDBCLUSTER
+f1     f2
+5      five

 The output of following EXPLAIN is deactivated, because the result
 differs on some platforms
=== end of quote ===

This difference occurred in 32 test runs,
so these 32 runs did not have such a "temporary error" which the result file expects.

Please also see the remark in line 2941 ff of the test file "mysql-test/suite/funcs_1/views/views_master.inc",
and discuss with the Cluster team whether their "6.3" tree differs from main 5.1 in this area.

I see no use in evaluating any different failure symptom of this test as long as the result file is so obviously unreliable.

How to repeat:
Run the test in the cluster tree.

Suggested fix:
Have all developers run the "extra" tests before pushing.
[6 Nov 2008 14:29] Bernd Ocklin
MaxNoOfConcurrentTransactions needs to be increased in mtr and result file needs to be adopted.
[25 Feb 2009 19:26] 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/67604

2884 Jonathan.Miller@sun.com	2009-02-25
      Bug#39125 and Bug#40860 show that the results had been orginally created with a resource issue. This should have been addressed by the creator before check in. Nonetheless, the results now do not contain the error and the test is currently passing for me. Commenting out the entry in disable.def. If problem is seen again, please reopen Bug#39125
      modified:
        mysql-test/suite/funcs_1/t/disabled.def
[26 Feb 2009 9:26] Magnus BlÄudd
Please remove the whole line from disabled.def
[24 Apr 2009 22:47] Jonathan Miller
This shows to be passing in mysql-5.1-telco-6.2, suggest allowing it to run in push-build to see if issues exists there that do not on my test system