| Bug #31245 | Stress test fails on NDB: "Unknown prepared statement handler" | ||
|---|---|---|---|
| Submitted: | 27 Sep 2007 15:17 | Modified: | 1 Feb 2008 15:05 |
| Reporter: | Joerg Bruehe | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Tests: Cluster | Severity: | S3 (Non-critical) |
| Version: | 5.1.22-rc | OS: | Any |
| Assigned to: | Guangbao Ni | CPU Architecture: | Any |
[30 Sep 2007 8:02]
Guangbao Ni
prepare statements error.
1) firstly the following statement defines a stmt_start.
PREPARE stmt_start FROM "SELECT UNIX_TIMESTAMP() INTO @start";
2) When EXECUTE stmt_start, mysql server can't find the stmt_start, so it gives the following error messages:
EXECUTE stmt_start' failed: 1243: Unknown prepared statement handler (stmt_start) given to EXECUTE.
It seems that the all works should be done in mysql server unrelated to specific storage engine, but the error only happens in ndbcluster. very interesting!
[2 Oct 2007 12:23]
Tomas Ulin
connection default; should be added to have_ndb_multi.inc (I believe someone did already and this is not merge yet) T
[30 Nov 2007 2:10]
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/38918 ChangeSet@1.2552, 2007-11-30 09:56:04+08:00, gni@dev3-221.dev.cn.tlan +1 -0 BUG#31245 Stress test fails on NDB:"Unknow prepared statement handler"
[9 Jan 2008 2:36]
Guangbao Ni
pushed into mysql-5.1-ndb-bj
[1 Feb 2008 15:05]
Jon Stephens
Test framework only; no end user changes to document. Closed without further action.
[20 Feb 2008 16:03]
Bugs System
Pushed into 6.0.5-alpha
[20 Feb 2008 16:03]
Bugs System
Pushed into 5.1.24-rc
Description: Found in the builds of release 5.1.22-rc: ===== stress.ddl_ndb [ fail ] Errors are (from /PATH/mysqltest-time) : mysqltest: In included file "./suite/stress/include/ddl1.inc": At line 152: query 'EXECUTE stmt_start' failed: 1243: Unknown prepared statement handler (stmt_start) given to EXECUTE (the last lines may be the most important ones) ===== All other "stress.ddl_*" tests pass, using the same include file ("./suite/stress/include/ddl1.inc"); and this one (for NDB) fails on each platform where it is attempted. How to repeat: Found while running the suite.