MySQL Bugs: #40860: funcs_1.ndb

Bug #40860	funcs_1.ndb_views fail
Submitted:	19 Nov 2008 17:56	Modified:	25 Feb 20:12
Reporter:	Tomas Ulin
Status:	Duplicate
Category:	Server: Cluster	Severity:	S3 (Non-critical)
Version:	6.2	OS:	Any
Assigned to:		Target Version:
Triage:	Needs Triage: D3 (Medium) / R2 (Low) / E3 (Medium)

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:
.

new testcase, create view fails with out of resouce
E3: for finding out what is it...tomas tried and failed

http://bugs.mysql.com/bug.php?id=39125

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