MySQL Bugs: #39125: Result file for test contains a "temporary error", how can this be stable ?

Bug #39125	Result file for test contains a "temporary error", how can this be stable ?
Submitted:	29 Aug 2008 18:31	Modified:	18 May 21:38
Reporter:	Joerg Bruehe
Status:	Verified
Category:	Server: Cluster	Severity:	S3 (Non-critical)
Version:	mysql-5.1-telco-6.3	OS:	Any
Assigned to:	Jørgen Austvik	Target Version:	6.3.19
Tags:	mysql-5.1-telco-6.3.17, disabled
Triage:	Triaged: D3 (Medium) / R6 (Needs Assessment) / E6 (Needs Assessment)

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.

MaxNoOfConcurrentTransactions needs to be increased in mtr and result file needs to be
adopted.

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

Please remove the whole line from disabled.def

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