MySQL Bugs: #27401: test sp_notembedded failed during mysql-test-run.pl after initial install

Bug #27401	test sp_notembedded failed during mysql-test-run.pl after initial install
Submitted:	23 Mar 2007 15:35	Modified:	25 Jun 2011 0:44
Reporter:	Doug Gilbert	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: General	Severity:	S3 (Non-critical)
Version:	5.0.37 Community,5.0-bugteam	OS:	Solaris (Solaris 8 SPARC)
Assigned to:		CPU Architecture:	Any

Description:
This test failure, apparently fixed from bug 17756, occurred on 5.0.37 Community:

sp_notembedded                 [ fail ]

Errors are (from /usr2/mysql/mysql/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 243: query 'call bug10100p(255, @var)' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 1436...
(the last lines may be the most important ones)
Result from queries before failure can be found in r/sp_notembedded.log

From bug 17756:

[10 Apr 2006 19:29] Brian Pontz

5.1.9-pre has this test failure as well.

sp_notembedded                 [ fail ]

Errors are (from PATH/mysqltest-time) :
mysqltest: At line NNN: query 'call bug10100p(255, @var)' failed with wrong
errno 2013: 'Lost connection to MySQL server during query', instead of 1436...
(the last lines may be the most important ones)
Result from queries before failure can be found in r/sp_notembedded.log

Killing Possible Leftover Processes

[12 Apr 2006 10:50] Alexander Barkov

The patch looks ok to push.

[8 May 2006 21:26] Paul DuBois

No changelog entry needed.

How to repeat:
run mysql-test-run.pl sp_notimbedded

Thank you for a problem report. Please, send URL for binaries you had used (32-bit or 64-bit, pkgadd or tar.gz format?). Send also the results of

env

for the environment you had used while testing.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Feedback is still needed.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I was able to repeat using the internal pb2 test suite on a sol10 
sparc64 debug_max host:
sp_notembedded                 [ fail ]

mysqltest: At line 247: query 'call bug10100p(255, @var)' failed with wrong errno 2013: 'Lost connection to MySQL server during query', instead of 1436...

The result from queries just before the failure was:
< snip >
create procedure bug10100pc(level int, lim int)
begin
declare lv int;
declare c cursor for select a from t3;
open c;
if level < lim then
select level;
fetch c into lv;
select lv;
update t3 set a=level+lv;
FLUSH TABLES;
call bug10100pc(level+1, lim);
else
select * from t3;
end if;
close c;
end|
set @@max_sp_recursion_depth=255|
set @var=1|
call bug10100p(255, @var)|

More results from queries before failure can be found in /export/home/pb2/test/sb_0-1851090-1274923431.5/mysql-5.0.91-solaris10-sparc-test/mysql-test/var/log/sp_notembedded.log

Stopping All Servers
Restoring snapshot of databases
Saving core
Resuming Tests

Georgi,

thank you for the feedback. Please provide link to PB logs or, at least, name of the host where logs are located.

Thank you for the feedback.

Set to "Verified".

The reason for this bug is the same as for bug#11753919 (formerly known as
45445) and relates to controlling of stack limit size.