main.signal_demo3 and sys_vars.max_sp_recursion_depth_func fail in biuldbot on labrador with Thread stack overrun

Description

http://buildbot.askmonty.org/buildbot/builders/labrador/builds/4205/steps/test/logs/stdio

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 sys_vars.max_sp_recursion_depth_func [ fail ] Test ended at 2014-11-24 15:25:04 CURRENT_TEST: sys_vars.max_sp_recursion_depth_func mysqltest: At line 64: query 'CALL sp_addRecords(0,8)' failed: 1436: Thread stack overrun: 172008 bytes used of a 294912 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack. The result from queries just before the failure was: < snip > ** Connection test_con1 ** SET @@session.max_sp_recursion_depth = 10; SELECT @@session.max_sp_recursion_depth; @@session.max_sp_recursion_depth 10 DROP PROCEDURE IF EXISTS sp_addRecords; CREATE PROCEDURE sp_addRecords (IN var1 INT,IN var2 INT) BEGIN SELECT var1,var2; IF var1 < var2 THEN CALL sp_addRecords(var1+1,var2); SELECT var1,var2; END IF; END // CALL sp_addRecords(0,8);
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 main.signal_demo3 [ fail ] Test ended at 2014-11-24 15:19:00 CURRENT_TEST: main.signal_demo3 mysqltest: At line 107: query 'call proc_1()' failed with wrong errno 1436: 'Thread stack overrun: 172008 bytes used of a 294912 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.', instead of 1644... The result from queries just before the failure was: < snip > resignal sqlstate '45000' set message_text='Oops in proc_7'; call proc_8(); end $$ create procedure proc_8() begin declare exit handler for sqlexception resignal sqlstate '45000' set message_text='Oops in proc_8'; call proc_9(); end $$ create procedure proc_9() begin declare exit handler for sqlexception resignal sqlstate '45000' set message_text='Oops in proc_9'; ## Do something that fails, to see how errors are reported drop table oops_it_is_not_here; end $$ call proc_1();

Environment

None

Status

Assignee

Sergei Golubchik

Reporter

Elena Stepanova

External issue ID

None

External issue ID

None

Components

Fix versions

Affects versions

10.1

Priority

Major
Configure