Bug #40860 funcs_1.ndb_views fail
Submitted: 19 Nov 2008 16:56 Modified: 25 Feb 2009 19:12
Reporter: Tomas Ulin Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:6.2 OS:Any
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D3 (Medium) / R2 (Low) / E3 (Medium)

[19 Nov 2008 16:56] Tomas Ulin
Description:
funcs_1.ndb_views              [ fail ]

--- /home/tomas/mysql_src/mysql-5.1-telco-6.2-merge/mysql-test/suite/funcs_1/r/ndb_views.result 2008-08-29 15:26:22 +03:00
+++ /home/tomas/mysql_src/mysql-5.1-telco-6.2-merge/mysql-test/suite/funcs_1/r/ndb_views.reject 2008-11-19 18:53:51 +03:00
@@ -21567,7 +21567,8 @@
 v28    CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `test1`.`v28` AS select `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

How to repeat:
.
[20 Nov 2008 13:23] Jonas Oreland
new testcase, create view fails with out of resouce
E3: for finding out what is it...tomas tried and failed
[25 Feb 2009 19:12] Jonathan Miller
http://bugs.mysql.com/bug.php?id=39125
[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